PHP использует PDO для создания базы данных MySQL, таблиц и вставки нескольких примеров операций с данными

php
$servername = "localhost";
$username = "username";
$password = "password";
try {
  $conn = new PDO("mysql:host=$servername", $username, $password);
  // Set PDO error mode to exception
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  $sql = "CREATE DATABASE myDBPDO";
  // use exec (), because no result is returned
  $conn->exec($sql);
  Echo "database creation success < br >";
}
catch(PDOException $e)
{
  echo $sql . "
" . $e->getMessage();
}
$conn = null;
?>

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // Using SQL to create data tables
  $sql = "CREATE TABLE MyGuests (
  id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
  firstname VARCHAR(30) NOT NULL,
  lastname VARCHAR(30) NOT NULL,
  email VARCHAR(50),
  reg_date TIMESTAMP
  )";
  // With exec (), no result is returned
  $conn->exec($sql);
  Echo "MyGuests Created Successfully";
}
catch(PDOException $e)
{
  echo $sql . "
" . $e->getMessage();
}
$conn = null;
?>

setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  // Start a business
  $conn->beginTransaction();
  // SQL statement
  $conn->exec("INSERT INTO MyGuests (firstname, lastname, email)
  VALUES ('John', 'Doe', '[email protected]')");
  $conn->exec("INSERT INTO MyGuests (firstname, lastname, email)
  VALUES ('Mary', 'Moe', '[email protected]')");
  $conn->exec("INSERT INTO MyGuests (firstname, lastname, email)
  VALUES ('Julie', 'Dooley', '[email protected]')");
  // Submission transaction
  $conn->commit();
  Echo "successful insertion of new records";
}
catch(PDOException $e)
{
  // Roll back if execution fails
  $conn->rollback();
  echo $sql . "
" . $e->getMessage();
}
$conn = null;
?>