[root@kvm3 ~]# vim /var/www/html/createtbl.php [root@kvm3 ~]# cat /var/www/html/createtbl.php <?php $dbhost = 'localhost:3306'; $dbuser = 'root'; $dbpass = '123qwe'; $conn = mysqli_connect($dbhost, $dbuser, $dbpass) or die(mysqli_connect_error().PHP_EOL); echo 'Connected successfully'.PHP_EOL; $sql = "CREATE TABLE tblphp( ". "id INT NOT NULL AUTO_INCREMENT, ". "title VARCHAR(100) NOT NULL, ". "author VARCHAR(40) NOT NULL, ". "submission_date DATE, ". "PRIMARY KEY ( id )); "; mysqli_select_db( $conn, 'dywphp' ) or die('Error: '.mysqli_error($conn).PHP_EOL); mysqli_query( $conn, $sql ) or die('Error: '.mysqli_error($conn).PHP_EOL); echo "Table tblphp created successfully\n"; mysqli_close($conn); ?>
[root@kvm3 ~]# curl -s http://127.0.0.1/createtbl.php Connected successfully Error: Unknown database 'dywphp'
[root@kvm3 ~]# curl -s http://127.0.0.1/createdb.php Connected successfully Database dywphp created successfully
[root@kvm3 ~]# curl -s http://127.0.0.1/createtbl.php Connected successfully Table tblphp created successfully
[root@kvm3 ~]# curl -s http://127.0.0.1/createtbl.php Connected successfully Error: Table 'tblphp' already exists
[root@kvm3 ~]# mysql -uroot -p123qwe -e "use dywphp; show tables;" +------------------+ | Tables_in_dywphp | +------------------+ | tblphp | +------------------+