How to use PHP to connect to Alibaba Cloud Database RDS to implement data addition, deletion, modification and query operations

How to use PHP to connect to Alibaba Cloud Database RDS to implement data addition, deletion, modification and query operations

Alibaba Cloud Database RDS (Relational Database Service) is a stable, reliable, and elastically scalable relational database service. Using PHP to connect to the RDS database, we can easily implement data addition, deletion, modification and query operations.

Before we start, we need to complete the following steps:

1. Create an Alibaba Cloud RDS instance: Log in to the Alibaba Cloud Management Console, select RDS, and follow the prompts to create an RDS instance. .
2. Create database and tables: Create the database and tables we need in the RDS instance.
3. Create PHP project: Create a PHP project in the local environment.

Below, we will introduce in detail how to use PHP to connect to Alibaba Cloud RDS to implement data addition, deletion, modification and query operations.

1. Connect to the database

First, we need to use PHP code to connect to the Alibaba Cloud RDS database. In the PHP project, create a database connection with the following code:

<?php

$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} else {
    echo "Connected successfully";
}

?>

Copy the above code into a php file, changing your_username, your_password and Replace your_database with your actual database username, password, and database name. Then run the file. If the connection to the database is successful, "Connected successfully" will be output.

2. Data addition operation

Next, we will demonstrate how to use PHP to insert a new piece of data into the Alibaba Cloud RDS database. Add the following code to your php file:

<?php

$sql = "INSERT INTO your_table (column1, column2) VALUES ('value1', 'value2')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();

?>

Replace your_table with the actual table name and column1 and column2 with the actual The table field names, value1 and value2 are replaced with the actual data to be inserted. Run the file. If the data is successfully inserted, "New record created successfully" will be output.

3. Data deletion operation

If you want to delete a certain piece of data in the Alibaba Cloud RDS database, you can use PHP code to perform the deletion operation. Add the following code to your php file:

<?php

$sql = "DELETE FROM your_table WHERE id = 1";

if ($conn->query($sql) === TRUE) {
    echo "Record deleted successfully";
} else {
    echo "Error deleting record: " . $conn->error;
}

$conn->close();

?>

Replace your_table with the actual table name and id with the actual primary key field, 1Replace with the primary key value of the data to be deleted. Run this file. If the data is successfully deleted, "Record deleted successfully" will be output.

4. Data modification operation

If you want to modify a piece of data in the Alibaba Cloud RDS database, you can use PHP code to perform the update operation. Add the following code to your php file:

<?php

$sql = "UPDATE your_table SET column1 = 'new_value1', column2 = 'new_value2' WHERE id = 1";

if ($conn->query($sql) === TRUE) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . $conn->error;
}

$conn->close();

?>

Replace your_table with your actual table name and column1 and column2 with Actual field names that need to be updated, new_value1 and new_value2 are replaced with the actual values ​​that need to be updated, id is replaced with the actual primary key field, 1 Replace with the primary key value of the data to be updated. Run this file. If the data is successfully updated, "Record updated successfully" will be output.

5. Data query operation

Finally, we will demonstrate how to use PHP to query data from the Alibaba Cloud RDS database and display the results. Add the following code to your php file:

<?php

$sql = "SELECT * FROM your_table";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"] . " - Column1: " . $row["column1"] . " - Column2: " . $row["column2"] . "<br>";
    }
} else {
    echo "0 results";
}

$conn->close();

?>

Replace your_table with the actual table name. Running this file will output the query results.

Through the above steps, we have learned how to use PHP to connect to Alibaba Cloud Database RDS to implement data addition, deletion, modification and query operations. Now you can flexibly use this knowledge to complete more complex database operations based on actual needs.

The above is the detailed content of How to use PHP to connect to Alibaba Cloud Database RDS to implement data addition, deletion, modification and query operations. For more information, please follow other related articles on the PHP Chinese website!