How to create MySQL Database and Tables in PHP?

[Orton]

Hi friends,
I have done the programming in PHP to some extent. Now I am working with the database. I am using MySQL for database. I am not having fair knowledge about the using the MySQL in PHP. So I need your help.!! Please tell me how to create MySQL Database and Tables in PHP? Any other information regarding the topic would be grateful.

[kyosang]

A database will contain a variable number of tables of data which are arranged in columns and rows. A MySQL table is completely different than the normal coding that you do. You might feel tough to understand but later on you will do it easily. In MySQL and other database systems, the goal is to store information in an orderly fashion. You can do this by using the tables. Also I would like to suggest you that before you can enter data (rows) into a table, you must first define what kinds of data will be stored (columns).

[Warner]

You can use the following code for creating the table in PHP :

<?php
mysql_connect("localhost", "admin", "1admin") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

mysql_query("CREATE TABLE example(
id INT NOT NULL AUTO_INCREMENT, 
PRIMARY KEY(id),
 name VARCHAR(30), 
 age INT)")
 or die(mysql_error());  

echo "Table Created!";

?>

the above code will design a MySQL query to summon the table from database.

[CodGuru]

Creating the database is also very important. The following example creates a database called my_data :

<?php
$con = mysql_connect("localhost","sunil","xyz123");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

if (mysql_query("CREATE DATABASE my_data",$con))
  {
  echo "Database created";
  }
else
  {
  echo "Error creating database: " . mysql_error();
  }

mysql_close($con);
?>

[Solitario]

You should also know about the primary keys and auto increment fields. You should keep in mind that each table should have a primary key field. To ensure that the primary key field cannot be null, we must add the NOT NULL setting to the field. The following code would help you :

$sql = "CREATE TABLE PersonsDemo 
(
personID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY(personID),
FirstName varchar(15),
LastName varchar(15),
Age int
)";

mysql_query($sql,$con);