How to insert new data using INSERT statement in php

PHP is a popular server-side scripting language that is widely used for web development and dynamic website creation. In PHP, SQL queries are implemented in many different ways, the most commonly used of which is the insert statement, which is used to insert new data into a database table. In this article, we will discuss how to insert new data into the database using INSERT statement in PHP.

1. Connect to the database

Before starting any database operations, we need to connect to the database first. You can connect using the built-in function mysqli_connect() in PHP and some necessary parameters. The following is a sample code to connect to the database:

$servername = "localhost";
$username = "yourusername";
$password = "yourpassword";
$dbname = "yourdatabase";

// Create connection
$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

The above code creates a connection to the database named yourdatabase and terminates the program and outputs an error message if the connection fails.

2. Write INSERT statements

Once we are connected to the database, we can start writing INSERT statements. The INSERT statement has the following syntax:

INSERT INTO table_name (column1, column2, column3, ...)
VALUES (value1, value2, value3, ...);

The first part of the INSERT statement specifies the table name and data column name where data is to be inserted, and the second part is the value to be inserted.

The following is an example of inserting data into the table user:

$sql = "INSERT INTO user (username, password, email)
VALUES ('John Doe', 'johndoe123', 'john@example.com')";

In the above code, we specify the table user to insert data into and the data columns username, password, and email to be inserted. Note that the corresponding data values ​​should be provided in the same order in the VALUES clause.

3. Execute the INSERT statement

Once we have written the INSERT statement, we can use the mysqli_query() function to execute it. The following is an example of executing an INSERT statement:

if (mysqli_query($conn, $sql)) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . mysqli_error($conn);
}

In the above code, the mysqli_query() function is used to execute the INSERT statement and returns a Boolean value to indicate whether the statement was successfully executed. If the execution is successful, we can output a success message.

4. Close the database connection

Finally, after we complete all database operations, we should close the database connection to release resources and prevent potential security holes.

The following is an example of closing a database connection:

mysqli_close($conn);

By using the above steps, we can insert new data into the database using the INSERT statement in PHP. We only need to write SQL statements, execute SQL statements and close the connection to achieve this goal.

The above is the detailed content of How to insert new data using INSERT statement in php. For more information, please follow other related articles on the PHP Chinese website!