How can we create a database using PHP and mysql?

Question Posted / jude jr

4 Answers
5503 Views
Rushmore Consultancy, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

<?php
$link = mysql_connect('localhost', 'mysql_user',
'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}

$sql = 'CREATE DATABASE my_db';
if (mysql_query($sql, $link)) {
echo "Database my_db created successfully\n";
} else {
echo 'Error creating database: ' . mysql_error() . "\n";
}
?>

Is This Answer Correct ?

5 Yes

0 No

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

Answer / ram

mysql_create_db -- Create a MySQL database
syntax: bool mysql_create_db ( string database_name [,
resource link_identifier])
<?php
$con=mysql_connect("localhost","root","");

if(!$con)
{
die("could not connect:".mysql_error());
}
$dbname='CREATE DATABASE prasad';

if(mysql_query($dbname,$con))
{
echo "Database Created successfully";
}
else
{
echo 'error message:' .mysql_error();
}
?>

Is This Answer Correct ?

2 Yes

0 No

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

Answer / sunil kumar

It`s simple than above

<?php
mysql_connect("localhost","root","");//connect to host
$sql_create_db="create database my_db";
if(mysql_query($sql_create_db))
echo"Database is created";
else
echo"Error in creating Database".mysql_error();

?>

Is This Answer Correct ?

2 Yes

0 No

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

Answer / rahul

by using phpmyadmin

Is This Answer Correct ?

2 Yes

4 No

Post New Answer