JQuery Mobile PHP MySQL基于第一页
问题描述:
的第二页基于选择检索数据,所以我不知道如何在标题中正确表达它,但我会在这里完成。我有两个页面,第一个添加了一些列表视图(每个都有值)。我想要的是,当用户点击一个项目,他/她进入第二页,它会向他/她显示一个列表视图(根据他们选择的值检索MySQL数据)。但我的问题是,当我点击第一页中的一个项目时,它在第二页中显示我什么都没有。JQuery Mobile PHP MySQL基于第一页
我已经尝试了几种方法几天,现在它变得令人沮丧!我真的需要帮助。非常感激。
这是我的第一个页面代码:
<?php
session_start();
include "partials/connectDb.php";
if (isset($_POST["goverVal"]))
{
$_SESSION["goverVal"] = $_POST["goverVal"];
}
?>
<div data-role="page" id="homepage">
<!-- HEADER INCLUDE -->
<?php include "partials/header.php"; ?>
<div data-role="main" class="ui-content" align="center">
<h2>Select A Governorate</h2>
<form action="index.php" method="POST">
<ul data-role="listview" id="goverVal" name="goverVal">
<?php
include "partials/connectDb.php";
$sql = "SELECT * FROM governorate_table;";
$run_query = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_array($run_query))
{
$gId = $row['g_id'];
echo "<li data-value='{$gId}'><a href='area_page.php' class='ui-btn'>$gId - $row[name]</a></li>";
}
?>
</ul>
</form>
</div>
<!-- FOOTER INCLUDE -->
<?php include "partials/footer.php"; ?>
</div>
================================ =======================================
这是我第二页的代码:
<?php
session_start();
include "partials/connectDb.php";
$goverChoice = $_SESSION["goverVal"];
?>
<div data-role="page" id="areaPage">
<!-- HEADER INCLUDE -->
<?php include "partials/header.php"; ?>
<div data-role="main" class="ui-content" align="center">
<h2>Select an Area</h2>
<?php
include "partials/connectDb.php";
$q = "SELECT * FROM area_table WHERE governorate = '$goverChoice';";
$run_sql = mysqli_query($conn, $q);
echo "<ul data-role='listview'>";
while ($row = mysqli_fetch_array($run_sql))
{
echo "<li><a href='#'>".$row['area_name']."</a></li>";
}
echo "</ul>";
?>
</div>
<!-- FOOTER INCLUDE -->
<?php include "partials/footer.php"; ?>
</div>
答
没关系。我终于找到了一个合适的解决方案。 这是我用,如果有人遇到同样的问题:
在第一页:
$(document).ready(function(){
$('#goverVal').on("click", "li", function(){
$.ajax("update_session.php",{method:"post", data:{val:$(this).attr("data-value")}});
});
});
而这在一个单独的文件:
<?php
//Another File
session_start();
if (isset($_POST["val"]))
{
$_SESSION["val"] = $_POST["val"];
}
?>
而此行的第二页面在哪里显示数据,顶部:
$goverChoice = $_SESSION["val"];