我想与PDO一起使用,但是有一个错误。我研究其他问题,但我不明白:(我的查询和错误是
错误
php致命错误:在/ssd4/muhtesemciftlik/public_html/referans.php上,在第72
上致电in/ssd4/muhtesemciftlik/public_html/referans.php上的非对象上的成员函数rowcount()。
我的查询
<?php
$id=2
$query = $db->query("SELECT ref_urun,ref_tl FROM degerler INNER JOIN kullanicilar ON kullanicilar.ref = degerler.kullanici WHERE kullanicilar.ref = {'$id'}", PDO::FETCH_ASSOC);
if ( $query->rowCount() ) { //kayıt varsa
foreach( $query as $row ){
echo "
<tr>
<th style="width: 10px">#</th>
<th>".$row["kullanici"]."</th>
<th>".$row["ref_urun"]."</th>
<th>".$row["ref_tl"]."</th>
</tr>
";
}
}
?>
更改:
$query = $db->query("SELECT ref_urun,ref_tl FROM degerler INNER JOIN kullanicilar ON kullanicilar.ref = degerler.kullanici WHERE kullanicilar.ref = {'$id'}", PDO::FETCH_ASSOC);
to:
$query = $db->query("SELECT ref_urun,ref_tl FROM degerler INNER JOIN kullanicilar ON kullanicilar.ref = degerler.kullanici WHERE kullanicilar.ref = '{$id}'", PDO::FETCH_ASSOC);