Skip to content

jovemfelix/phpdatabase

BranchesTags
 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
README.md
README.md
 
 
dbtest.php
dbtest.php
 
 
index.php
index.php
 
 
phpinfo.php
phpinfo.php
 
 

Repository files navigation

Deploy MYSQL

oc new-app mysql MYSQL_USER=user MYSQL_PASSWORD=pass MYSQL_DATABASE=testdb -l db=mysql

Deploy php application and link with MYSQL

oc new-app https://github.com/jovemfelix/phpdatabase MYSQL_SERVICE_HOST=mysql MYSQL_USER=user MYSQL_PASSWORD=pass MYSQL_DATABASE=testdb -l app=php5db
oc new-app --docker-image="registry.access.redhat.com/rhscl/php-71-rhel7:latest" https://github.com/jovemfelix/phpdatabase MYSQL_SERVICE_HOST=mysql MYSQL_USER=user MYSQL_PASSWORD=pass MYSQL_DATABASE=testdb --name=testphp71db
oc new-app --docker-image="registry.access.redhat.com/rhscl/php-72-rhel7:latest" https://github.com/jovemfelix/phpdatabase MYSQL_SERVICE_HOST=mysql MYSQL_USER=user MYSQL_PASSWORD=pass MYSQL_DATABASE=testdb --name=testphp72db

Expose php app

oc expose svc phpdatabase

Test MYSQL

mysql -u ${MYSQL_USER} -p${MYSQL_PASSWORD} -h ${MYSQL_SERVICE_HOST} -P ${MYSQL_SERVICE_PORT} ${MYSQL_DATABASE} 
show tables
CREATE TABLE IF NOT EXISTS tasks (
    task_id INT AUTO_INCREMENT,
    title VARCHAR(255) NOT NULL,
    start_date DATE,
    due_date DATE,
    status TINYINT NOT NULL,
    priority TINYINT NOT NULL,
    description TEXT,
    PRIMARY KEY (task_id)
)  ENGINE=INNODB;

Reference

About

No description, website, or topics provided.

Resources

Readme
Activity

Stars

0 stars

Watchers

1 watching

Forks

0 forks
Report repository

Releases

No releases published

Packages

 
 
 

Contributors

Languages

  • PHP 100.0%