CODEWITHSUNDEEP
phpmysqlsqlpdo
Ahmad Irfandi
Ahmad Irfandi

Reputation: 11

Fetching query in PHP PDO

I have this php code,

$result = $Db->query("SELECT DISTINCT matkul_mahasiswa.nim, matkul_mahasiswa.kode_matkul, 
                      nilai.nim, nilai.kode_matkul, nilai.nilai, nilai.kode_ta, nilai.status_nl
                      FROM matkul_mahasiswa 
                      JOIN nilai
                        ON matkul_mahasiswa.nim = nilai.nim AND matkul_mahasiswa.kode_matkul = nilai.kode_matkul
                     WHERE nilai.kode_matkul = '$kdmk' AND nilai.status_nl = '1' AND nilai.kode_ta = '$kdta'");

then I tried to fetch it with PDO, and echo the result

$data = $result->fetch(PDO::FETCH_ASSOC);

echo $data['nim']; 
echo $data['nilai'];

but nothing, nothing show up. I tried the query on phpmyadmin, and it works fine

So, what's wrong ? what do I miss here ?

thanks b4.

Upvotes: 0

Views: 68

Answers (1)

Perfect Square
Perfect Square

Reputation: 1438

Try this one (I changed a bit your approach and added prepared statements cause you are just asking for SQL injection).

$stmt= $Db->prepare("SELECT DISTINCT matkul_mahasiswa.nim AS matkul_mahasiswa_nim, matkul_mahasiswa.kode_matkul, nilai.kode_matkul, nilai.nilai, nilai.kode_ta, nilai.status_nl FROM matkul_mahasiswa JOIN nilai ON matkul_mahasiswa.nim = nilai.nim AND matkul_mahasiswa.kode_matkul = nilai.kode_matkul WHERE nilai.kode_matkul = :kdmk AND nilai.status_nl = '1' AND nilai.kode_ta = :kdta");
$stmt->bindValue(':kdmk', $kdmk);    
$stmt->bindValue(':kdta', $kdta);
$stmt->execute();

while($row = $stmt->fetch()) 
{
    $out[] = $row;
}

return $out;

Upvotes: 2

Related Questions