LV. MySQL Functions

These functions allow you to access MySQL database servers. In order to have these functions available, you must compile php with MySQL support by using the --with-mysql option. If you use this option without specifying the path to MySQL, php will use the built-in MySQL client libraries. Users who run other applications that use MySQL (for example, running php3 and php4 as concurrent apache modules, or auth-mysql) should always specify the path to MySQL: --with-mysql=/path/to/mysql. This will force php to use the client libraries installed by MySQL, avoiding any conflicts.

More information about MySQL can be found at http://www.mysql.com/.

Documentation for MySQL can be found at http://www.mysql.com/documentation/.

This simple example shows how to connect, execute a query, print resulting rows and disconnect from MySQL Database.

Example 1. MySQL extension overview example <?php $link = mysql_connect("mysql_host", "mysql_login", "mysql_password") or die ("Could not connect"); print ("Connected successfully"); mysql_select_db ("my_database") or die ("Could not select database"); $query = "SELECT * FROM my_table"; $result = mysql_query ($query) or die ("Query failed"); // printing HTML result print "<table>\n"; while ($line = mysql_fetch_array($result)) { print "\t<tr>\n"; while(list($col_name, $col_value) = each($line)) { print "\t\t<td>$col_value</td>\n"; } print "\t</tr>\n"; } print "</table>\n"; mysql_close($link); ?>