Postingan lainnya
Buku Ini Koding!
Baru!
Buku ini akan jadi teman perjalanan kamu belajar sampai dapat kerjaan di dunia programming!
Select Multiple DISTINCT di PHP PDO?
Salam kenal bang, bang maaf mau tanya w baru belajar php dan kseulitan untuk nampilin data pakai fungsi DISTINCT, jadi di kode ini pengennya kaya pesan whatsapp gitu, jika user_security => ada di id_send atau id_receiver, di tampilkan hanya sekali,
<?php try {
$show_index = "SELECT DISTINCT IF (id_send = '$user_security', id_receiver, id_send) AS id_send
FROM dUfA1_message WHERE '$user_security' IN (id_receiver, id_send) ORDER BY id DESC";
$show_index1 = $pdo->prepare($show_index);
$show_index1 ->execute(); }
catch (PDOException $exception) {
echo "ada kesalahan pada query : ".$exception->getMessage();
}
while ($data_message = $show_index1->fetch(PDO::FETCH_ASSOC)) {
$security = $data_message['security'];
$id_send = $data_message['id_send'];
$id_receiver = $data_message['id_receiver'];
$message = $data_message['security'];
$message_dcreate = $data_message['dcreate'];
$message_date = get_time_ago(strtotime("$message_dcreate"));
if ($user_security == $id_send) {$sc_master = $id_receiver;}
else {$sc_master = $id_send;}
echo "
<div class='section margintop15'>
<div class='container'>
<div class='col-12'>
<div class='row'>
<div class='col-9 paddingleft0 margintop5'>
<div>
<b>$sc_master</b>
<span class='float-right text-secondary font9'>$message_date</span>
</div>
<div class='font10'>
$message
</div>
</div>
</div>
</div>
</div>
</div>
";}?>
Mohon bantuannya bang
0
Belum ada Jawaban. Jadi yang pertama Jawaban
Login untuk ikut Jawaban