使用会话变量进行 SQL 选择

首先检查使用会话变量是否正在获取数据。如果客户 ID 是 varchar，则 where 子句中缺少单个反逗号。

session_start();
$Customer_id = $_SESSION['id'];
Require("dbconnect.php");//works is used on other another page
$sql = "SELECT Job_id FROM Job";
$sql.= " WHERE Job_Customer_id = '$Customer_id'";
$stmt = $dbh->query($sql);
$row = $stmt->fetch(PDO::FETCH_ASSOC);
$Job_id = $row['Job_id'];
echo $Customer_id;//Displays correctly 
echo $Job_id;//Curently dose not display anything 

将$sql.=行更改为：

$sql.= " WHERE Job_Customer_id = '$Customer_id'"

'在$Customer_id.