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( ) […]
Category Archives: php Mysql
PHP & MySQL – Handling NULL Example You can use the if…else condition to prepare a query based on the NULL value. The following example takes the tutorial_count from outside and then compares it with the value available in the table. Example Copy and paste the following example as mysql_example.php − <html> <head> <title>Handling NULL</title> […]
PHP & MySQL – Quick Guide PHP & MySQL – Overview MySQL works very well in combination of various programming languages like PERL, C, C++, JAVA and PHP. Out of these languages, PHP is the most popular one because of its web application development capabilities. PHP provides various functions to access the MySQL database and […]