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 |
Is it possible to protect special characters in a query string?
What is nginx and what is it used for?
What is a php session?
Explain what is the main difference between require() and require_once()?
How do you use bcrypt for hashing passwords in php?
What is the difference between pop3 IMAP and MAPI?
Swap two variables value without using third variable in php ?
What is the difference between htmlentities() and htmlspecialchars()?
How can we extract string ?allinterview.com ? from a string ?http://info@allinterview.com? using regular expression of PHP?
What are the different ways to login to a remote server? Explain the means, advantages and disadvantages?
How to find the length of a string?
Is md5() is breakable if yes than how?