Create a CRUD application using PHP and MySQL

With the development of the Internet, Web applications have become a necessity in our daily life and work. With the help of PHP and MySQL, we can easily create a web-based application that allows users to add, delete, modify and view data. This article will introduce how to use PHP and MySQL to create a simple CRUD application.

1. Create database and tables

First, we need to create a database and a related table. Open PHPMyAdmin or other MySQL management tools, create a new database, name it "crud", and set the character set to "utf8mb4_general_ci".

Next, we need to create a table to store our data. Let's assume we want to create a simple user management system with the following fields: id, username, email address, and password. We can use the following SQL statement to create this table:

CREATE TABLE users (
id int(11) NOT NULL AUTO_INCREMENT,
username varchar(50) NOT NULL,
email varchar(100) NOT NULL,
password varchar(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

2. Connect to the database

Now, we have After creating the database and tables, we need to connect to the database. In PHP, we can use mysqli or PDO extension to implement database connection. Here we will use the mysqli extension. Here is sample code to connect to the database:

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "crud";

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

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connection successful";
?> ;

3. Display data

Now that we are connected to the database, we can start writing code to display the data. The following is sample code to display user data:

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

if ($result->num_rows > 0) {
// Output data
while($row = $result->fetch_assoc()) {

echo "id: " . $row["id"]. " - 用户名: " . $row["username"]. " - 邮箱地址: " . $row["email"]. "<br>";

}
} else {
echo "0 result";
}
$conn->close();
?>

4. Add data

Now that we know how to display data, we can write code to add data. Here is sample code to add user data:

if ($_SERVER["REQUEST_METHOD"] == "POST") {
$username = $_POST["username" ];
$email = $_POST["email"];
$password = $_POST["password"];

$sql = "INSERT INTO users (username, email, password) VALUES ('$username', '$email', '$password')";

if ($conn->query($sql) === TRUE) {

echo "新记录添加成功";

} else {

echo "错误: " . $sql . "<br>" . $conn->error;

}

$conn->close();
}
?>

5. Update data

Now that we know how to add data, we can write code to update the data. Here is sample code to update user data:

if ($_SERVER["REQUEST_METHOD"] == "POST") {
$id = $_POST["id" ];
$username = $_POST["username"];
$email = $_POST["email"];
$password = $_POST["password"];

$sql = "UPDATE users SET username='$username', email='$email', password='$password' WHERE id=$id";

if ($conn->query($ sql) === TRUE) {

echo "记录更新成功";

} else {

echo "错误: " . $sql . "<br>" . $conn->error;

}

$conn->close();
}
?> ;

6. Delete data

Finally, we need to know how to delete data. Here is sample code to delete user data:

if ($_SERVER["REQUEST_METHOD"] == "POST") {
$id = $_POST["id" ];

$sql = "DELETE FROM users WHERE id=$id";

if ($conn->query($sql) === TRUE) {

echo "记录删除成功";

} else {

echo "错误: " . $sql . "<br>" . $conn->error;

}

$conn->close();
}
?>

We already know how to create A basic CRUD application. Of course, this is just a simple example. In practical applications, we need to carry out more functional expansion and implementation according to actual needs.

The above is the detailed content of Create a CRUD application using PHP and MySQL. For more information, please follow other related articles on the PHP Chinese website!