PHP Create DATABASE data table

PHP Create DATABASE data table

<?php

$con = mysql_connect (' localhost ', ' root ', ' root ');

/************************ creating tables in the database *************************/

if (! $con) {

Die (' Connection Database error: '. mysql_error ());

}

$database = "My_db_name";

$sqlDatabase = ' Create database '. $database;

if (mysql_query ($sqlDatabase, $con))

{

echo "Congratulations, database". $database. " Created successfully! ";

}

Else

{

echo "CREATE database error, error number:". Mysql_errno (). "Error Reason:". mysql_error ();

}

/******************************end***************************************/

/************************ creating tables in the database *************************/

mysql_select_db ("My_db_name", $con);

?

$sqlTable = "CREATE Table My_table_name (

ID int unsigned NOT NULL Auto_increment primary key,

A varchar (20),

b varchar (2),

C varchar (1)) ";

?

if (mysql_query ($sqlTable))

{

echo "Congratulations, data sheet creation succeeded!";

}

Else

{

echo "Create data table error, error number:". Mysql_errno (). "Error Reason:". mysql_error ();

}

/******************************end***************************************/

?

/************************* writing data to a table *********************************/

Guarantee has been implemented:

mysql_connect ("localhost", "username", "passcode");//Connect MySQL

mysql_select_db ("db_name");//Select Database

$sql = "INSERT into My_table_name (A, B) values (' 123 ', ' 45 ')"; '--' can be a variable in single quotation marks

if (mysql_query ($sql))//INSERT data through SQL statement

{

echo "Congratulations, the table writes the data successfully!";

}

/******************************end***************************************/

?

Mysql_close ();

?>

PHP Create DATABASE data table