PHP MySQL introductory tutorial: Create database/table and save data_PHP tutorial

In mysql, if we want to use PHP to create databases and tables, the method is very simple. We can directly use mysql_query() to execute the mysql create table command, CREATE DATABASE database_name.

The details are as follows

In order for PHP to execute the above statement, we must use the mysql_query() function. This function is used to send a query or command to the MySQL connection.

Example

In the example below, we create a database named "my_db":

The code is as follows

Copy code

代码如下	复制代码
$con = mysql_connect("localhost","peter","abc123"); if (!$con)  {  die('Could not connect: ' . mysql_error());  } if (mysql_query("CREATE DATABASE my_db",$con))  {  echo "Database created";  } else  {  echo "Error creating database: " . mysql_error();  } mysql_close($con); ?>

$con = mysql_connect("localhost","peter","abc123"); if (!$con)

{

die('Could not connect: ' . mysql_error());

}

if (mysql_query("CREATE DATABASE my_db",$con))

{

echo "Database created";

}

else

代码如下

复制代码

$con = mysql_connect("localhost","peter","abc123"); if (!$con)  {  die('Could not connect: ' . mysql_error());  } // Create database if (mysql_query("CREATE DATABASE my_db",$con))  {  echo "Database created";  } else  {  echo "Error creating database: " . mysql_error();  } // Create table in my_db database mysql_select_db("my_db", $con); $sql = "CREATE TABLE Persons ( FirstName varchar(15), LastName varchar(15), Age int )"; mysql_query($sql,$con); mysql_close($con); ?>

{

echo "Error creating database: " . mysql_error();

}

mysql_close($con);

?>

Create table

CREATE TABLE is used to create database tables in MySQL.

Example

代码如下	复制代码
$con = mysql_connect("localhost","peter","abc123"); if (!$con)  {  die('Could not connect: ' . mysql_error());  } mysql_select_db("my_db", $con); mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Peter', 'Griffin', '35')"); mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Glenn', 'Quagmire', '33')"); mysql_close($con); ?>

The following example shows how to create a table named "Persons" with three columns. The column names are “FirstName”, “LastName” and “Age”: Insert data into database table You can also specify the columns into which you wish to insert data: INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....) Example In the previous chapter, we created a table named “Persons” with three columns: “Firstname”, “Lastname” and “Age”. We will use the same table in this example. The following example adds two new records to the “Persons” table:

The code is as follows	Copy code
$con = mysql_connect("localhost","peter","abc123"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("my_db", $con); mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Peter', 'Griffin', '35')"); mysql_query("INSERT INTO Persons (FirstName, LastName, Age) VALUES ('Glenn', 'Quagmire', '33')"); mysql_close($con); ?>

-------------------------------------------------- ----------------------------------
Insert data from form into database

Age:

The code is as follows

代码如下	复制代码
Firstname: Lastname: Age:

Copy code

Firstname:

代码如下	复制代码
$con = mysql_connect("localhost","peter","abc123"); if (!$con)  {  die('Could not connect: ' . mysql_error());  } mysql_select_db("my_db", $con); $sql="INSERT INTO Persons (FirstName, LastName, Age) VALUES ('$_POST[firstname]','$_POST[lastname]','$_POST[age]')"; if (!mysql_query($sql,$con))  {  die('Error: ' . mysql_error());  } echo "1 record added"; mysql_close($con) ?>

Lastname:

When the user clicks the submit button in the HTML form in the example above, the form data is sent to “insert.php”. The "insert.php" file connects to the database and retrieves values ​​from the form through the $_POST variable. Then, the mysql_query() function executes the INSERT INTO statement, and a new record is added to the database table. The following is the code of the “insert.php” page:

The code is as follows

Copy code

$con = mysql_connect("localhost","peter","abc123"); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("my_db", $con); $sql="INSERT INTO Persons (FirstName, LastName, Age) VALUES ('$_POST[firstname]','$_POST[lastname]','$_POST[age]')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "1 record added"; mysql_close($con) ?> http://www.bkjia.com/PHPjc/628723.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/628723.htmlTechArticleIn mysql, if we want to use PHP to create databases and tables, the method is very simple, we can directly use mysql_query() Execute the mysql create table command, CREATE DATABASE database_name. ...