Jump to content

Warning: mysql_fetch_array() expects parameter


Bhima

Recommended Posts

I have problem at

 

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\big\operator\pemesanan.php on line 53

 

<?php

$qdatapesan = mysql_query("SELECT member.id_member,member.nama_depan,pemesanan.nama_menu,pemesanan.tanggal,pemesanan.jam,pemesanan.harga FROM menu, pemesanan, member WHERE menu.id_menu = pemesanan.id_menu AND member.id_member = pemesanan.id_member ORDER BY pemesanan.jam");
while($datapesan=mysql_fetch_array($qdatapesan))
{//print_r ($datapesan);
 ?>
 
where the error ? please help

Hi.

 

mysql_ functions are deprecated and will be removed relatively soon.  Convert to PDO instead:

 

$pdo = new PDO("mysql:host=localhost;dbname=$dabaseName", $dbUsername, $dbPassword);

$sql = <<<SQL
SELECT member.id_member, member.nama_depan, pemesanan.nama_menu, 
    pemesanan.tanggal, pemesanan.jam, pemesanan.harga 
FROM menu, pemesanan, member 
WHERE menu.id_menu = pemesanan.id_menu 
    AND member.id_member = pemesanan.id_member 
ORDER BY pemesanan.jam
SQL;

$stmt = $pdo->prepare($sql);
$stmt->execute();

while($datapesan = $stmt->fetch())
{
    print_r ($datapesan);
}
 

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.