你可以简单地
JOIN
你的两张桌子
uid
将两个查询合并为一个。注意,您没有正确使用准备好的语句,应该在
然后使用
bind_param
附加值:
$stmt = $conn->prepare('SELECT u.fname,u.lname,u.gender,u.city,u.state,p.bio
FROM users u
JOIN profile p ON p.uid = u.uid
WHERE u.uid=?');
$stmt->bind_param('s', $_POST['info']);
$stmt->execute();
$stmt->bind_result($fname,$lname,$gender,$city,$state,$bio);
while($stmt->fetch()) {
$output=array(
'fname' => $fname,
'lname' => $lname,
'gender' => $gender,
'city' => $city,
'state' => $state,
'bio' => $bio
);
}
profile
桌子,你应该用
LEFT JOIN
而不是
.