Create a MySQL Connection

This PHP program displays example code that demonstrates how to create a connection via a MySQL query.

MySqlCreateConnection.php

<?php
  $sServer = "127.0.0.1";
  $sUser = "root";
  $sPassword = "MyPassword";
  $sDatabase = "school";

  try {
    // 1. MySQL Original
    // Procedure Initialization
    $qMySQL = mysql_connect($sServer, $sUser, $sPassword);
    if ($qMySQL->connect_errno) {
      echo "Failed to connect to MySQL: ".$qMySQL->connect_error;
    }
    $sInfo = mysql_get_host_info($qMySQL);
    echo "1. Original - ".$sInfo."<br/ >";
    // Close the connection
    mysql_close($qMySQL);

    // MySQL Improved Extension (object or procedural initialization)
    // 2. Object Initialization
    $qMySQLi = new mysqli($sServer, $sUser, $sPassword);
    if ($qMySQLi->connect_errno) {
      echo "Failed to connect to MySQL: ".$qMySQLi->connect_error;
    }
    $sInfo = $qMySQLi->host_info;
    echo "2. Improved (object) - ".$sInfo."<br/ >";
    // Close the connection
    $qMySQLi->close();

    // 3. Procedure Initialization
    $qMySQLi = mysqli_connect($sServer, $sUser, $sPassword);
    if ($qMySQLi->connect_errno) {
      echo "Failed to connect to MySQL: ".$qMySQLi->connect_error;
    }
    $sInfo = $qMySQLi->host_info;
    echo "3. Improved (procedure) - ".$sInfo."<br/ >";
    // Close the connection
    $qMySQLi->close();

    // 4. PHP Data Object
    $qPhpDO = new PDO("mysql:host={$sServer};dbname={$sDatabase}", $sUser, $sPassword);
    if ($qPhpDO->connect_errno) {
      echo "Failed to connect to MySQL: ".$qPhpDO->connect_error;
    }
    $sInfo = $qPhpDO->getAttribute(constant("PDO::ATTR_CONNECTION_STATUS"));
    echo "4. PHP Data Object - ".$sInfo."<br/ >";
    // Close the connection
    $qPhpDO = null;

  } catch(Exception $eException) {
    echo "error: ".$eException->getCode()." ".$eException->getMessage();
  }
?>

Output

1. Original - 127.0.0.1 via TCP/IP
2. Improved (object) - 127.0.0.1 via TCP/IP
3. Improved (procedure) - 127.0.0.1 via TCP/IP
4. PHP Data Object - 127.0.0.1 via TCP/IP