PHP & MySQL – Create Database Example PHP uses mysqli query() or mysql_query() function to create or delete a MySQL database. This function takes two parameters and returns TRUE on success or FALSE on failure. Syntax $mysqli->query($sql,$resultmode) Sr.No. Parameter & Description 1 $sql Required – SQL query to create a MySQL database. 2 $resultmode Optional […]

PHP & MySQL – Connect Database Example PHP provides mysqli contruct or mysqli_connect() function to open a database connection. This function takes six parameters and returns a MySQL link identifier on success or FALSE on failure. Syntax $mysqli = new mysqli($host, $username, $passwd, $dbName, $port, $socket); Sr.No. Parameter & Description 1 $host Optional − The […]

PHP & MySQL – Drop Table Example PHP uses mysqli query() or mysql_query() function to drop a MySQL table. This function takes two parameters and returns TRUE on success or FALSE on failure. Syntax $mysqli->query($sql,$resultmode) Sr.No. Parameter & Description 1 $sql Required – SQL query to drop a table. 2 $resultmode Optional – Either the […]