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 |
What is the purpose of the '.frm' file extension? What do thes file contain?
what is the dirrence in PHP4 & PHP5 . ?
Where php basically used?
Are parent constructors called implicitly inside a class constructor?
What are the advantages of PHP over HTML?
11 Answers Infosys, Torque Infotech,
What is csrf token and why it is required?
How to check your php installation?
How can we define a variable accessible in functions of a php script?
What is the maximum size of a table in mysql?
What is the w3c?
How to download a php script directly in your script page?
3 Answers A1 Technology, Zmanda,
Is it possible to extend the execution time of a php script?