PHP uses PDO to create MySQL databases tables and insert multiple data operation examples

This article illustrates how PHP uses PDO to create MySQL databases, tables and insert multiple pieces of data. Share it for your reference, as follows:

Create an MySQL database:

<?php
$servername = "localhost";
$username = "username";
$password = "password";
try {
  $conn = new PDO("mysql:host=$servername", $username, $password);
  //  Settings  PDO  The error pattern is exception 
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  $sql = "CREATE DATABASE myDBPDO";
  //  Use  exec()  Because no results are returned 
  $conn->exec($sql);
  echo " Database created successfully <br>";
}
catch(PDOException $e)
{
  echo $sql . "<br>" . $e->getMessage();
}
$conn = null;
?>

Create an MySQL table:

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDBPDO";
try {
  $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  //  Settings  PDO  Error mode for throwing exceptions 
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  //  Use  sql  Create a data table 
  $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
  )";
  //  Use  exec()  No result returned 
  $conn->exec($sql);
  echo " Data table  MyGuests  Successful creation ";
}
catch(PDOException $e)
{
  echo $sql . "<br>" . $e->getMessage();
}
$conn = null;
?>

Insert multiple pieces of data into MySQL:

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDBPDO";
try {
  $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
  // set the PDO error mode to exception
  $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  //  Start a transaction 
  $conn->beginTransaction();
  // SQL  Statement 
  $conn->exec("INSERT INTO MyGuests (firstname, lastname, email)
  VALUES ('John', 'Doe', 'john@example.com')");
  $conn->exec("INSERT INTO MyGuests (firstname, lastname, email)
  VALUES ('Mary', 'Moe', 'mary@example.com')");
  $conn->exec("INSERT INTO MyGuests (firstname, lastname, email)
  VALUES ('Julie', 'Dooley', 'julie@example.com')");
  //  Commit transaction 
  $conn->commit();
  echo " New record inserted successfully ";
}
catch(PDOException $e)
{
  //  If the execution fails to roll back 
  $conn->rollback();
  echo $sql . "<br>" . $e->getMessage();
}
$conn = null;
?>

For more readers interested in PHP related contents, please check the topics on this site: "Summary of PHP Database Operation Skills Based on pdo", "Summary of php+mysqli Database Programming Skills", "Introduction to php Object-Oriented Programming", "Summary of php String (string) Usage", "Introduction to php+mysql Database Operation Skills" and "Summary of php Common Database Operation Skills"

I hope this article is helpful to everyone's PHP programming.