CRUD是指应用程序中常见的4种操作：创建(Create)、读取(Read)、更新(Update)和删除(Delete)。简单的CRUD应用程序可以用来演示如何使用基本的Web开发技术来实现这些操作。
1. 创建数据库
2. 创建表格
3. 连接数据库
4. 创建页面
5. 实现CRUD操作
CREATE DATABASE database_name;CREATE TABLE table_name (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";
// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);
// 检查连接
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
echo "连接成功";
?>可以使用HTML、CSS和JavaScript创建页面。
使用PHP实现CRUD操作。以下是一个简单的示例：
<?php
$sql = "INSERT INTO table_name (name, email) VALUES ('John Doe', 'john@example.com')";
if ($conn->query($sql) === TRUE) {
echo "新记录插入成功";
} else {
echo "Error: " . $sql . "
" . $conn->error;
}
$conn->close();
?><?php
$sql = "SELECT id, name, email FROM table_name";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// 输出数据
while($row = $result->fetch_assoc()) {
echo "id: " . $row["id"]. " - Name: " . $row["name"]. " - Email: " . $row["email"]. "<br>";
}
} else {
echo "0 结果";
}
$conn->close();
?><?php
$sql = "UPDATE table_name SET name='Jane Doe' WHERE id=1";
if ($conn->query($sql) === TRUE) {
echo "记录更新成功";
} else {
echo "Error updating record: " . $conn->error;
}
$conn->close();
?><?php
$sql = "DELETE FROM table_name WHERE id=1";
if ($conn->query($sql) === TRUE) {
echo "记录删除成功";
} else {
echo "Error deleting record: " . $conn->error;
}
$conn->close();
?>