News:

Want to get involved in developing SMF, then why not lend a hand on our github!

Main Menu

Menampilkan Topik berdasarkan board/category di php

Started by bendol212, October 05, 2014, 11:33:08 AM

Previous topic - Next topic

bendol212

permisi gan....ane pengen menampilkan topik di php tp berdasarkan id board...
atau WHERE id boards...??

ane coba buat secara langsung, ga pake ssi.php karena ane belum pahamnya...

setelah ane coba langsung bisa sih...tp kurang fleksible
$result = $db->query("SELECT * FROM smf_boards WHERE name='One Piece'");
while($data = $result->fetch_assoc()) {
$id_board = $data['id_board'];
$results = $db->query("SELECT * FROM smf_messages WHERE id_board='$id_board'");
if($results){
while($row = $results->fetch_assoc()) {
echo $data['name'].' - <a href="../smf/index.php?topic='.$row['id_topic'].'">'.$row['subject'].$row['id_board'].'</a><br/>';
}
}
}


kode nya akan menampilkan topik/semua topik berdasarkan boards (ane ga tau namanya/ category kali yak.. 8)) "One Piece"...

tp kayaknya lebih mudah kalau pake ssi, kalau manual spt ini kan harus menghubungkan dulu halaman ke database nya....

ada yg bisa bantu?? suwun tQ

ryo12345


Advertisement: