Category Archives: php Mysql

PHP & MySQL – Select Database Example PHP uses mysqli_select_db function to select the database on which queries are to be performed. This function takes two parameters and returns TRUE on success or FALSE on failure. Syntax mysqli_select_db ( mysqli $link , string $dbname ) : bool Sr.No. Parameter & Description 1 $link Required – […]

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 […]

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 […]