How can we create a database using PHP and mysql?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / b.chandrasekaran
using
mysql_db_create("databasename");
we can create new database in php.
Is This Answer Correct ? | 1 Yes | 1 No |
How to create a web form?
What is the use of is_array() and in_array()?
How to know user has read the email-php?
How many functions are there in php?
Write a PHP code to print following number pattern: 123 456 789
What is oops php?
What are the different types of errors in PHP?
How to run the interactive php shell from the command line interface?
How To Get the Uploaded File Information in the Receiving Script?
How to download and install php on windows?
How can I find my php version?
What are the differences between include() and include_once () functions?