搭建校园失物管理系统PHP源码教程
// 失物发布 <?php if(isset($_POST['submit_lost_item'])) { $item_name = $_POST['item_name']; $description = $_POST['description']; // 将失物信息插入失物信息表中 $stmt = $pdo->prepare("INSERT INTO lost_items (item_name, description, user_id) VALUES (:item_name, :description, :user_id)"); $stmt->bindParam(':item_name', $item_name); $stmt->bindParam(':description', $description); $stmt->bindParam(':user_id', $_SESSION['user_id']); if($stmt->execute()) { echo "失物发布成功"; } else { echo "失物发布失败"; } } ?> // 失物查询 <?php $stmt = $pdo->prepare("SELECT * FROM lost_items WHERE user_id = :user_id"); $stmt->bindParam(':user_id', $_SESSION['user_id']); $stmt->execute(); $lost_items = $stmt->fetchAll(); foreach($lost_items as $item) { echo $item['item_name'] . ": " . $item['description'] . "<br>"; } ?>
登录后复制
上一篇:python全局变量如何定义
-
基因剪辑技术的专利现状及原因解析2024-06-14
-
神仙级剪辑技术:这些软件你不能错过2024-06-29
-
学会剪辑视频的5个关键步骤2024-06-24
-
深入了解PyCharm:快速删除项目的方法2024-05-16
-
学会这几种技巧,你也能成为视频剪辑大师2024-07-04