```php <?php // 数据库连接 $servername = "localhost"; $username = "username"; $password = "password"; $dbname = "iot_card"; // 创建连接 $conn = new mysqli($servername, $username, $password, $dbname); // 检查连接 if ($conn->connect_error) { die("连接失败: ". $conn->connect_error); } // 表结构创建 $sql = "CREATE TABLE cards ( id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY, unit VARCHAR(50), manufacturer VARCHAR(50), card_count INT(11), status ENUM('待领取', '已领取', '无需处理'), recipient VARCHAR(50), photo VARCHAR(255), serial_number VARCHAR(50) )"; if ($conn->query($sql) === TRUE) { echo "表创建成功"; } else { echo "创建表错误: ". $conn->error; } // 录入功能 if (isset($_POST['submit'])) { $unit = $_POST['unit']; $manufacturer = $_POST['manufacturer']; $card_count = $_POST['card_count']; $status = $_POST['status']; $recipient = $_POST['recipient']; $photo = $_FILES['photo']['name']; // 处理图片上传 $target_dir = "uploads/"; $target_file = $target_dir. basename($_FILES["photo"]["name"]); move_uploaded_file($_FILES["photo"]["tmp_name"], $target_file); $serial_number = uniqid(); $sql = "INSERT INTO cards (unit, manufacturer, card_count, status, recipient, photo, serial_number) VALUES ('$unit', '$manufacturer', $card_count, '$status', '$recipient', '$photo', '$serial_number')"; if ($conn->query($sql) === TRUE) { echo "新记录插入成功"; } else { echo "错误: ". $sql. "<br>". $conn->error; } } // 统计数量 $sql_count_pending = "SELECT COUNT(*) as pending_count FROM cards WHERE status = '待领取'"; $result_pending = $conn->query($sql_count_pending); $row_pending = $result_pending->fetch_assoc(); $pending_count = $row_pending['pending_count']; $sql_count_claimed = "SELECT COUNT(*) as claimed_count FROM cards WHERE status = '已领取'"; $result_claimed = $conn->query($sql_count_claimed); $row_claimed = $result_claimed->fetch_assoc(); $claimed_count = $row_claimed['claimed_count']; $sql_count_no_action = "SELECT COUNT(*) as no_action_count FROM cards WHERE status = '无需处理'"; $result_no_action = $conn->query($sql_count_no_action); $row_no_action = $result_no_action->fetch_assoc(); $no_action_count = $row_no_action['no_action_count']; ?> <!DOCTYPE html> <html> <head> <title>物联卡领用系统</title> </head> <body> <h1>物联卡领用系统</h1> <div> <p>待领取数量: <?php echo $pending_count;?></p> <p>已领取数量: <?php echo $claimed_count;?></p> <p>无需处理数量: <?php echo $no_action_count;?></p> </div> <form action="" method="post" enctype="multipart/form-data"> <label for="unit">单位:</label> <input type="text" name="unit" id="unit"><br> <label for="manufacturer">厂家:</label> <input type="text" name="manufacturer" id="manufacturer"><br> <label for="card_count">卡数量:</label> <input type="number" name="card_count" id="card_count"><br> <label for="status">实时状态:</label> <select name="status" id="status"> <option value="待领取">待领取</option> <option value="已领取">已领取</option> <option value="无需处理">无需处理</option> </select><br> <label for="recipient">领取人:</label> <input type="text" name="recipient" id="recipient"><br> <label for="photo">拍照图片:</label> <input type="file" name="photo" id="photo"><br> <input type="submit" name="submit" value="提交"> </form> </body> </html> <?php $conn->close(); ?> ``` [2025-05-22 11:29:42 | AI问答 | 1115点数解答]