dimanche 1 septembre 2019

how can i fix this filter function till it works?

soo.. i want to make filter function on my website that, he use 3 tables tb_data,tb_peserta, and paket to print out the tables component on yhis page

$keyword = $_POST['keyword'];
                    $query = "SELECT tb_peserta.id_peserta,tb_data.nama,tb_paket.nama_paket,ket,waktu_awal,waktu_akhir FROM tb_peserta,
                    tb_data,tb_paket WHERE tb_peserta.id_number=tb_data.id_number AND tb_peserta.id_paket = tb_paket.id_paket AND status_data_peserta='aktif' AND nama LIKE '%$keyword%' OR nama_paket LIKE '%$keyword%' OR ket LIKE '%$keyword'";

that is the filter query that ive made.. this not showing a data but it show all data, its not work.. so ineed ur help

Aucun commentaire:

Enregistrer un commentaire