How can we create a database using PHP and mysql?

Question Posted / phpwizz

3 Answers
6429 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How can we create a database using PHP and mysql?..

Answer / tina

1.mysql_connect('ip address/localhost','username for
mysql','password');
i.e
$con=mysql_connect('localhost','root','sdsd');
here,$con is a user defined variable.

2.$quer=CREATE DATABASE sampdb;
mysql_query($quer,$con);

Here,$quer is also user defined variable.

if(mysql_query($quer,$con)
{
echo("DATABASE WAS BEEN CREATED");
}
else
echo("NOT CREATED");

Is This Answer Correct ?

6 Yes

0 No

How can we create a database using PHP and mysql?..

Answer / vivek mohan singh

$dbhost = "localhost"; // database hostname
$dbuser = "root"; // database username
$dbpassword = ""; // database password
$dbname = ""; // database name

//database connection
$link=mysql_connect($dbhost,$dbuser,$dbpassword) or die ('I
cannot connect to the database because: ' . mysql_error());
mysql_select_db($dbname ,$link);

Is This Answer Correct ?

6 Yes

5 No

How can we create a database using PHP and mysql?..

Answer / b.chandrasekaran

using
mysql_db_create("databasename");

we can create new database in php.

Is This Answer Correct ?

1 Yes

1 No

Post New Answer