PHP and MySQL
This is an old revision of this page, as edited by Ed Poor (talk | contribs) at 14:21, August 9, 2008. It may differ significantly from current revision.
PHP and MySQL are both free software, and they work together well for making database-backed websites.
Methods for PHP to access MySQL databases all begin with the mysql_ prefix.
The convention is to store a query statement in a variable like $query or $sql.
$query = "select * from employee";
Results by convention are returned to a varible like $result.
$result = mysql_query($query);