Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How can we create a database using PHP and mysql?

Answers were Sorted based on User's Feedback



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

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

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

More PHP Interview Questions

Write a program to display a table of any given number?

0 Answers  


which institute provide better PHP trainning in delhi? please tell me how much salary can freshers get ? thanku

5 Answers  


Is empty in php?

0 Answers  


How many types of array are there in php?

0 Answers  


Where is session value stored?

0 Answers  


Tell me what does the scope of variables means?

0 Answers  


What is difference between mysql_fetch_array and mysql_fetch_assoc?

0 Answers  


Describe which programming language does php parallel to?

0 Answers  


How to generate a form?

0 Answers  


Differentiate echo vs. Print statement.

0 Answers  


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?

5 Answers  


Categories