杭州同城招聘网站 (杭州同城招聘信息)
杭州夜店
04-04
阅读：72
评论：0
connect_error) {die("连接失败: " . $conn->connect_error);}// 接收查询参数$keyword = isset($_GET['keyword']) ? $_GET['keyword'] : "";$category = isset($_GET['category']) ? $_GET['category'] : "all";$location = isset($_GET['location']) ? $_GET['location'] : "all";$experience = isset($_GET['experience']) ? $_GET['experience'] : "all";$education = isset($_GET['education']) ? $_GET['education'] : "all";// 构建查询语句$sql = "SELECT FROM jobs WHERE 1 = 1";if ($keyword != "") {$sql .= " AND (title LIKE '%$keyword%' OR company_name LIKE '%$keyword%' OR location LIKE '%$keyword%')";}if ($category != "all") {$sql .= " AND category = '$category'";}if ($location != "all") {$sql .= " AND location = '$location'";}if ($experience != "all") {$sql .= " AND experience = '$experience'";}if ($education != "all") {$sql .= " AND education = '$education'";}// 执行查询$result = $conn->query($sql);if ($result->num_rows > 0) {// 输出查询结果while($row = $result->fetch_assoc()) {echo "";echo "";echo "";echo "";echo "";echo "";echo "";echo "";}} else {echo "";}// 关闭数据库连接$conn->close();?>
| 职位名称 | 公司名称 | 工作地区 | 工作经验 | 学历要求 | 发布时间 |
|---|---|---|---|---|---|
| " . $row['title'] . " | " . $row['company_name'] . " | " . $row['location'] . " | " . $row['experience'] . " | " . $row['education'] . " | " . $row['publish_time'] . " |
| 没有找到符合条件的职位 | |||||
版权声明
本文仅代表作者观点，不代表杭州桑拿立场。
本文系作者授权发表，未经许可，不得转载。
