Connecting to MySQL

@mysql_connect('localhost', 'user', 'password')

Two MySQL extensions for PHP are available. The older one, ext/mysql, was used for PHP 4 and older versions; the newer one, ext/mysqli (the i officially stands for improved, and unofficially for incompatiblebut that's cynical), comes with PHP 5 but requires MySQL 4.1 or higher. However, PHP 5 also supports the old extension. Both extensions are covered in this chapter.

Connecting to MySQL

  if ($db = @mysql_connect('localhost', 'user',
    'password')) {
    mysql_select_db('hoshmand', $db);
    echo 'Connected to the database.';
  } else {
    echo 'Connection failed.';

To use the extensions, you might have to enable them. Under PHP 4, ext/mysql is automatically activated. Under PHP 5, you have to use extension=php_mysql.dll and also have to copy libmysql.dll to where PHP can find it. If you compile PHP yourself, use the switch with-mysql=/path/to/mysql for older MySQL versions and ext/mysql.

Now connecting to the database is easy: Just call mysql_connect(), providing the server, username, and password. You then get a handle that can be used for mysql_select_db() or to choose a database on the server. Finally, mysql_close() closes the connection to the data source.