Creation of Database & Table Through PHP

Introduction

Hi guys. In this article we are going to understand the MySQL database with PHP. A database is an organized collection of data for one or more purposes, usually in digital form. A database holds one or multiple tables.

Creation of database

Here in this section we will use the Create database statement to create the database.

Syntax

CREATE DATABASE database_name

Now we will focus on the creation of a database with PHP script. When using PHP to execute the statement above we must use the mysql_query() function. This function is used to send a query or command to a MySQL connection.

PHP script for creating database:

<html>
<body bgcolor="Lightgreen">
<center>
<h3> Creating a database <h3>
<hr>
<?php
$con = mysql_connect("localhost","root","");
$db="Mike";
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
if (mysql_query("CREATE DATABASE $db",$con))
{
echo "Database created : $db";
}
else
{
echo "Error creating database: " . mysql_error();
}
mysql_close($con);
?>
</center>
</body>
</html>

Save it as abcd.php.

Output

To run the code, Open the XAMPP server and start the services like Apache and MySQL. Open the browser type: http://localhost/yourfoldername/abcd.php

Once your database has been created, and if you hit the same URL again, the output will look as in the following:

Creation of Table

Here in this section we will create the table in a particular database. MySQL provides a variety of table types with varying levels of functionality. The CREATE TABLE statement is used to create a table in MySQL.

Syntax

CREATE TABLE table_name
(
column_name1 data_type,
column_name2 data_type
)

Now we will focus on the creation of a table with a particular database with PHP script. The CREATE TABLE statement to the mysql_query() function to execute the command.

PHP script for creating database table:

<html>
<body bgcolor="Lightgreen">
<center>
<h3> Creating a database table <h3>
<hr>
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
// Create database
if (mysql_query("CREATE DATABASE dwij",$con))
{
echo "dwij Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
// Create table
mysql_select_db("dwij", $con);
$sql = "CREATE TABLE PBL
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";
// Execute query
mysql_query($sql,$con);
echo "PBL table created";
mysql_close($con);
?>
</center>
</body>
</html>

Save it as abcd.php.

Output

To run the code, Open the XAMPP server and start the services like Apache and MySQL. Open the browser type: http://localhost/yourfoldername/abcd.php

Conclusion : With the help of the script shwn above we can execute each SQL statement of MySQL with a PHP script.

Thanks !