phpeveryday.com

For example, make a employees database of one office, personal data table with the field of employees number, employees name, and employees address.

Create a file named create_table.php within www. Enter following code:

<?
//the example of making MySQL database table
//create_table.php
$continued = mysql_connect("localhost","root","admin");
if($continued){
	echo("Connection is succeed");
}else{
	echo("Connection is fail");
}
$make = mysql_create_db("employees");
if($make){
	echo("<br><br>Employees database succeeds in making");
}else{
	echo("<br><br>Employees database fails in making");
}
$order1 = "CREATE TABLE data_employees
	(
		employees_number int(10)AUTO_INCREMENT PRIMARY KEY,
		name char(100),
		address varchar(255)
	)";
$make_table = mysql_db_query("employees",$order1);
if($make_table){
	echo("<br><br>Table data_employees succeeds in making");
}else{
	echo("<br><br>Table data_employees fails in making");
}
?>

Point your browser to http://localhost/create_table.php. May you get like this:

If you see at phpmyadmin, you will get like this: