In this session of PHP, we will create database and table in MySQL using PHP : You can also create it using PHPMyAdmin.

We will use CREATE DATABASE & CREATE TABLE statements to create database and table in MySQL respectively.

mysql_query() : This send a MySQL query.

Syntax : resource mysql_query ( string query  [, resource link_identifier])

  • query : A SQL query that you want to execute.
  • Link_identifier : It is MySQL connection, it is option and if you don’t specify it, the last link opened by mysql_connect() is assumed.

Example :

<?php

    $user_name = 'root';
    $password = '';
    $hostname = "localhost"; 

    $con = mysql_connect($hostname, $user_name, $password);
   if(! $con )
    {
      die("Could not connect: " . mysql_error());
    }
    echo "Connection successful</br> ";  

    //Create Database
    $query = "CREATE database if not exists Employee";
    $d_query = mysql_query($query , $con);

    If(!$d_query)
    {
                die("Could not create database : " . mysql_error());
    }
         echo "Database Created Successfully </br>";

    //Create table

mysql_select_db('Employee');

$c_query="create table Emp(empId int NOT NULL AUTO_INCREMENT, firstName varchar(30) , lastName varchar(30) , age int , designation varchar(30), salary int, PRIMARY KEY(empId) )";

    $d_query=mysql_query($c_query , $con);
    if(!$d_query)
    {
         die("Could not create table: " . mysql_error());
    }
    else
    {
     echo "Table Created Successfully</br> ";
}

     mysql_close($con) or die ("Error while closing connection");
                   echo " Connection Close successful";

?>

Output :

1