rubin2008

 Profile Answers by rubin2008 Questions by rubin2008

• Jan 14th, 2010

 

Mysql database can be created using php by executing CREATE DATABASE query using mysql_query() function in php

Tejanshu

 Profile Answers by Tejanshu 

• Mar 8th, 2010

 

 mysql_query("CREATE DATABASE databasename", connector) is the answer. Where mysql_query() is the PHP function that uses the CREATE DATABASE mysql command.

Here is a small code snippet. I have marked the PhP line to create a database in bold.

<?php

$db_connect = mysql_connect("hostname","user","password");
if (!$db_connect)

  {
  die('Could not connect: ' . mysql_error());
  }

if (mysql_query("CREATE DATABASE my_db",$db_connect))
  {
  echo "Database created successfully";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }

mysql_close($db_connect);
?>