由于您没有提供更多的具体细节,我会尽力提供一个简单的示例代码,希望对您有所帮助。

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注入等安全问题。

我要用PHP和HTML5写一个网站,用来对一些物流快递单号的记录的新增、修改和删除,请给我编写一下它的代码,谢谢。

原文地址: http://www.cveoy.top/t/topic/rWo 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录