Create and Drop MYSQL Database using PHP

As a Web developer, I usually perform mysql database operations from phpmyadmin or use GUI tool like SQLYOG, HeidiSQL or MYSQL Workbench. But it doesn’t mean that the only way to create and drop database is phpmyadmin or any GUI tool.

You can perform any mysql operation using PHP. If you follow wdb24.com regularly you noticed that I normally add “create database” statement in my tutorials. I do this because I don’t want to create any confusion in my readers mind.

Create and Drop MYSQL Database using PHP

MYSQL Create Database:


<?php 
	$host = "localhost";
	$user = "root";
	$password = "";
	$db = "demo";
	
	$conn = mysqli_connect("localhost","root","");
	if (!$conn) 
	{
		die("Connection Error : " . mysqli_connect_error());
	}

	
	$createDatabase = "create database my_blog";
	$result = mysqli_query($conn, $createDatabase);
	
	if($result)
	{
		echo "Database created successfully";
	}
	else
	{
		echo "Unable to create database ".mysqli_error($conn);
	}
?>

<?php

$host = "localhost";

$user = "root";

$password = "";

$db = "demo";

$conn = mysqli_connect("localhost","root","");

if (!$conn)

{

die("Connection Error : " . mysqli_connect_error());

}

$createDatabase = "create database my_blog";

$result = mysqli_query($conn, $createDatabase);

if($result)

{

echo "Database created successfully";

}

else

{

echo "Unable to create database ".mysqli_error($conn);

}

MYSQL Drop Database:


<?php 
	
	$host = "localhost";
	$user = "root";
	$password = "";
	
	$conn = mysqli_connect("localhost","root","");
	if (!$conn) 
	{
		die("Connection Error : " . mysqli_connect_error());
	}

	
	$createDatabase = "drop database my_blog";
	$result = mysqli_query($conn, $createDatabase);
	
	if($result)
	{
		echo "Database created successfully";
	}
	else
	{
		echo "Unable to create database ".mysqli_error($conn);
	}
?>

<?php

$host = "localhost";

$user = "root";

$password = "";

$conn = mysqli_connect("localhost","root","");

if (!$conn)

{

die("Connection Error : " . mysqli_connect_error());

}

$createDatabase = "drop database my_blog";

$result = mysqli_query($conn, $createDatabase);

if($result)

{

echo "Database created successfully";

}

else

{

echo "Unable to create database ".mysqli_error($conn);

}

Create and Drop MYSQL Database using PHP

Create and Drop MYSQL Database using PHP

MYSQL Create Database:

MYSQL Drop Database:

More from WDB24.com

Published by Ahsan Zameer

Leave a Reply Cancel reply