How can we create a database using PHP and mysql?

How can we create a database using PHP and mysql?

View Answers

November 15, 2010 at 4:00 PM

Hi everyone,

Using mysqlcreatedb($databaseName) we can create Mysql database.

Example :

<?php
$connection = mysql_connect("localhost","root","root");
if (!$connection)
  {
  die('Could not connect: ' . mysql_error());
  }

if (mysql_query("CREATE DATABASE database_name",$connection))
  {
  echo "Database created";
  }
else
  {
  echo "Error in creating database: " . mysql_error();
  }

mysql_close($connection);
?>

Thanks









Related Tutorials/Questions & Answers:
Advertisements