Home Answers Viewqa PHP How can we create a database using PHP and mysql?

 
 


brijesh
How can we create a database using PHP and mysql?
1 Answer(s)      2 years and 6 months ago
Posted in : PHP

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 Pages:

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.