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

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

代码如下

复制代码

Copy code

Related labels：

mysql php keep Getting Started Tutorial create use exist us data database surface

source：php.cn

Previous article：Detailed explanation of a PHP message board example (with source code download)_PHP tutorial Next article：Detailed explanation of get and post examples of PHP form submission data_PHP tutorial

Statement of this Website

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