Home >
Article > Backend Development > PHP MySQL introductory tutorial: Create database/table and save data_PHP tutorial
PHP MySQL introductory tutorial: Create database/table and save data_PHP tutorial
WBOYOriginal
2016-07-13 17:16:001030browse
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":
$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
The code is as follows
代码如下
复制代码
Copy code
Age:
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. ...
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
