58同城招聘附近招工 (58同城招聘 招聘网)

附近工作

connect_error) {die("连接失败: " . $conn->connect_error);}// 准备查询语句$sql = "SELECT FROM jobs WHERE location LIKE ? AND title LIKE ?";// 准备语句$stmt = $conn->prepare($sql);// 绑定参数$location = "%" . $_GET['location'] . "%";$keywords = "%" . $_GET['keywords'] . "%";$stmt->bind_param("ss", $location, $keywords);// 执行查询$stmt->execute();// 获取结果$result = $stmt->get_result();// 输出结果while ($row = $result->fetch_assoc()) {echo "
• ";echo "

  " . $row['title'] . "

  ";echo "

  " . $row['description'] . "

  ";echo "

  " . $row['location'] . "

  ";echo "

  " . $row['salary'] . "

  ";echo "
";}// 关闭语句和连接$stmt->close();$conn->close();?>