$member_id=$_GET['id']; // Collecting data from query string
if(!is_numeric($member_id)){ // Checking data it is a number or not
echo "Data Error";
exit;
}
$handler = new PDO('mysql:host=localhost;dbname=manager', 'root', 'jordan31');
$count=$handler->prepare("select * from login, member_workouts where member_workouts.member_id=:member_id");
$count->bindParam(":member_id",$member_id,PDO::PARAM_INT,3);
if($count->execute())
$row = $count->fetch(PDO::FETCH_OBJ);
if( ! $row)
print('No Workouts Found');
else
echo "<tr bgcolor='#f1f1f1'><strong><p>Exercise:</strong> $row->exercise</p>
<strong><p>Weight:</strong> $row->weight</p>
<strong><p>Reps:</strong> $row->reps</p>
<strong><p>Sets:</strong> $row->sets</p>
<strong><p>notes:</strong> $row->notes</p>
<strong><p>Date:</strong> $row->date</p>
<a class='btn btn-success'><i class='fa fa-plus-square m-right-xs'> </i> View All</a>"
?>
尝试为一个人显示 db 中的所有条目,问题是当我尝试时如何绑定连接的表
$count->bindParam(":member_id",$member_workouts.member_id,PDO::PARAM_INT,3);
它不像我期望的那样工作。
基本上,代码应该根据成员的member_id返回成员的所有锻炼,我让它返回数据库的最新条目,但不是全部,它让我难倒了!!我正在努力在谷歌搜索中找到我可以理解的信息。
我对php代码相当陌生,所以我正在学习。 建设性的批评是非常受欢迎的。
如果你
member_workouts
有一些字段是fk来login
pk,请向WHERE
或ON
添加条件。例如 login_id & id,使用如下查询:
SELECT *
FROM login
JOIN member_workouts ON member_workouts.login_id = login.id --it is only example
WHERE member_workouts.member_id=:member_id
无论如何,如果没有连接条件,您将获得行的乘法。
我设法通过抛出一个 while 循环似乎可以解决问题来解决下面的代码。
<?Php
$handler = new PDO('mysql:host=localhost;dbname=manager', 'root', ******);
$count=$handler->prepare("SELECT * FROM member_workouts WHERE member_id=:member_id ORDER BY date DESC");
$count->bindParam(":member_id",$member_id,PDO::PARAM_INT,3);
if($count->execute())
while($row = $count->fetch(PDO::FETCH_OBJ))
if( ! $row)
print('<h4>No Workouts Found</h4>');
else
echo "<tr bgcolor='#f1f1f1'><strong><p>Exercise:</strong> $row->exercise</p>
<strong><p>Weight:</strong> $row->weight</p>
<strong><p>Reps:</strong> $row->reps</p>
<strong><p>Sets:</strong> $row->sets</p>
<strong><p>notes:</strong> $row->notes</p>
<strong><p>Date:</strong> $row->date</p>
<hr>"
?>