我要用PHP和HTML5写一个网站,用来对一些物流快递单号的记录的新增、修改和删除,请给我编写一下它的代码,谢谢。
由于您没有提供更多的具体细节,我会尽力提供一个简单的示例代码,希望对您有所帮助。
HTML5代码:
<!DOCTYPE html>
<html>
<head>
<title>物流快递单号管理系统</title>
</head>
<body>
<h1>物流快递单号管理系统</h1>
<!-- 显示已有的快递单号记录 -->
<h2>已有记录</h2>
<table>
<tr>
<th>快递单号</th>
<th>发件人</th>
<th>收件人</th>
<th>操作</th>
</tr>
<?php
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database_name");
if (!$conn) {
die("连接数据库失败:" . mysqli_connect_error());
}
// 查询快递单号记录
$sql = "SELECT * FROM express";
$result = mysqli_query($conn, $sql);
// 显示记录
while ($row = mysqli_fetch_assoc($result)) {
echo "<tr>";
echo "<td>" . $row["tracking_number"] . "</td>";
echo "<td>" . $row["sender"] . "</td>";
echo "<td>" . $row["receiver"] . "</td>";
echo "<td><a href='edit.php?id=" . $row["id"] . "'>编辑</a> | <a href='delete.php?id=" . $row["id"] . "'>删除</a></td>";
echo "</tr>";
}
mysqli_close($conn); // 关闭数据库连接
?>
</table>
<!-- 新增快递单号记录 -->
<h2>新增记录</h2>
<form action="add.php" method="post">
<label>快递单号:</label>
<input type="text" name="tracking_number"><br>
<label>发件人:</label>
<input type="text" name="sender"><br>
<label>收件人:</label>
<input type="text" name="receiver"><br>
<input type="submit" value="新增">
</form>
</body>
</html>
PHP代码:
add.php
<?php
// 获取表单数据
$tracking_number = $_POST["tracking_number"];
$sender = $_POST["sender"];
$receiver = $_POST["receiver"];
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database_name");
if (!$conn) {
die("连接数据库失败:" . mysqli_connect_error());
}
// 插入快递单号记录
$sql = "INSERT INTO express (tracking_number, sender, receiver) VALUES ('$tracking_number', '$sender', '$receiver')";
if (mysqli_query($conn, $sql)) {
echo "新增成功!<br>";
echo "<a href='index.php'>返回首页</a>";
} else {
echo "新增失败:" . mysqli_error($conn);
}
mysqli_close($conn); // 关闭数据库连接
?>
edit.php
<?php
// 获取快递单号ID
$id = $_GET["id"];
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database_name");
if (!$conn) {
die("连接数据库失败:" . mysqli_connect_error());
}
// 查询快递单号记录
$sql = "SELECT * FROM express WHERE id = $id";
$result = mysqli_query($conn, $sql);
// 显示表单
if ($row = mysqli_fetch_assoc($result)) {
echo "<form action='update.php?id=" . $row["id"] . "' method='post'>";
echo "<label>快递单号:</label>";
echo "<input type='text' name='tracking_number' value='" . $row["tracking_number"] . "'><br>";
echo "<label>发件人:</label>";
echo "<input type='text' name='sender' value='" . $row["sender"] . "'><br>";
echo "<label>收件人:</label>";
echo "<input type='text' name='receiver' value='" . $row["receiver"] . "'><br>";
echo "<input type='submit' value='保存'>";
echo "</form>";
} else {
echo "未找到记录!";
}
mysqli_close($conn); // 关闭数据库连接
?>
update.php
<?php
// 获取快递单号ID和表单数据
$id = $_GET["id"];
$tracking_number = $_POST["tracking_number"];
$sender = $_POST["sender"];
$receiver = $_POST["receiver"];
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database_name");
if (!$conn) {
die("连接数据库失败:" . mysqli_connect_error());
}
// 更新快递单号记录
$sql = "UPDATE express SET tracking_number='$tracking_number', sender='$sender', receiver='$receiver' WHERE id=$id";
if (mysqli_query($conn, $sql)) {
echo "更新成功!<br>";
echo "<a href='index.php'>返回首页</a>";
} else {
echo "更新失败:" . mysqli_error($conn);
}
mysqli_close($conn); // 关闭数据库连接
?>
delete.php
<?php
// 获取快递单号ID
$id = $_GET["id"];
// 连接数据库
$conn = mysqli_connect("localhost", "username", "password", "database_name");
if (!$conn) {
die("连接数据库失败:" . mysqli_connect_error());
}
// 删除快递单号记录
$sql = "DELETE FROM express WHERE id=$id";
if (mysqli_query($conn, $sql)) {
echo "删除成功!<br>";
echo "<a href='index.php'>返回首页</a>";
} else {
echo "删除失败:" . mysqli_error($conn);
}
mysqli_close($conn); // 关闭数据库连接
?>
请注意替换代码中的数据库连接信息和数据库表名。同时,为了安全起见,建议对表单数据进行验证和过滤,以防止SQL注入等安全问题。
原文地址: http://www.cveoy.top/t/topic/rWo 著作权归作者所有。请勿转载和采集!