How can we create a database using PHP and mysql?
Answers were Sorted based on User's Feedback
Answer / lt
<?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 |
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 |
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 |
Write a program to display a table of any given number?
which institute provide better PHP trainning in delhi? please tell me how much salary can freshers get ? thanku
Is empty in php?
How many types of array are there in php?
Where is session value stored?
Tell me what does the scope of variables means?
What is difference between mysql_fetch_array and mysql_fetch_assoc?
Describe which programming language does php parallel to?
How to generate a form?
Differentiate echo vs. Print statement.
How can we know the number of days between two given dates using PHP?
8 Answers AZTEC, HCL, Navsoft,
which function used to get the file name in php?