PHP Database Table Creation using PDO

Create Table Using PHP Data Object(PDO)

PHP Database Table Creation using PDO

Hi Guys In This Tutorial we will Learn how to Create a Table using Php Data Object(PDO).
using the following example we create a table named "test" under "tutorial" database.
create a new file named table.php in htdocs folder and paste the below codes.

Codes for table.php

<?php
$host = "localhost"; //Host Name
$username = "root"; //MySQL Username.if you don't know leave 'root' by Defaults
$password = ""; //MySQL Password if Password Protected .else Leave it Blank
$db_name = "tutorial"; //Database Name

try {
 //Creating Connection between Server and Database
    $conn = new PDO("mysql:host=$host;dbname=$db_name", $username, $password);
    // SET PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // Creating New table using SQL Query
     $sql = "CREATE TABLE test (
   id int(11) NOT NULL AUTO_INCREMENT,
  name varchar(150) NOT NULL,
  email varchar(150) NOT NULL,
  PRIMARY KEY (id)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;";


    //exec() Function because no results are returned
    $conn->exec($sql);
    echo "You have Successfully Created test Table";
    }
catch(PDOException $e)
    {
    echo $sql . "<br>" . $e->getMessage();
    }

$conn = null;
?>

If you Like This article Please Like and Share With Your Friends.
Keep Visiting for More Codes.Thank you.