PHP & MySQL – Select Records Example You can use the same SQL SELECT command into a PHP function mysql_query(). This function is used to execute the SQL command and then later another PHP function mysql_fetch_array() can be used to fetch all the selected data. This function returns the row as an associative array, a […]
Author Archives: user
PHP & MySQL – Update Records Example PHP uses mysqli query() or mysql_query() function to update records in 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 update records in a MySQL table. 2 […]
PHP & MySQL – Database Info Example There are a few important commands in MySQL which can be executed either at the MySQL prompt or by using any script like PHP to get various important information about the database server. Sr.No. Command & Description 1 SELECT VERSION( ) Server version string 2 SELECT DATABASE( ) […]