Postingan lainnya
Kelas Premium!
Belajar bikin website dari nol sekarang
Gunakan kupon "lebihcepat" untuk diskon 25%!
Kondisi else if pencarian data
saya punya kode untuk pencarian data menggunakan kondisi else if, masalah nya ketika saya memberikan kondisi else dimana pada saat pencarian data tidak ada, malah else error, siapa tau ada yang tau..
if(isset($_REQUEST['customer']) && $_REQUEST['customer']<>""){
// jika ada kata kunci pencarian (artinya form pencarian disubmit dan tidak kosong)
// pakai ini
$customer=$_REQUEST['customer'];
$reload = "menu2.php?pagination=true&customer=$customer";
$sql = ("select ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice,cp_temp FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id where cp_flag='0' and cp_cid like '%".$customer."%' ");
$result = mssql_query($sql);
}elseif (isset($_REQUEST['material']) && $_REQUEST['material']<>"") {
$material=$_REQUEST['material'];
$reload = "menu2.php?pagination=true&material=$material";
$sql = ("select ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice,cp_temp FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id where cp_flag='0' and cp_mate like '%".$material."%' ");
$result = mssql_query($sql);
}elseif (isset($_REQUEST['collor']) && $_REQUEST['collor']<>"") {
$collor=$_REQUEST['collor'];
$reload = "menu2.php?pagination=true&collor=$collor";
$sql = ("select ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice,cp_temp FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id where cp_flag='0' and cp_hues like '%".$collor."%' ");
$result = mssql_query($sql);
}elseif (isset($_REQUEST['size']) && $_REQUEST['size']<>"") {
$size=$_REQUEST['size'];
$reload = "menu2.php?pagination=true&size=$size";
$sql = ("select ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice,cp_temp FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id where cp_flag='0' and cp_width like '%".$size."%' ");
$result = mssql_query($sql);
}elseif (isset($_REQUEST['model']) && $_REQUEST['model']<>"") {
$model=$_REQUEST['model'];
$reload = "menu2.php?pagination=true&model=$model";
$sql = ("select ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice,cp_temp FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id where cp_flag='0' and cp_mode like '%".$model."%' ");
$result = mssql_query($sql);
}elseif (isset($_REQUEST['grup']) && $_REQUEST['grup']<>"") {
$grup=$_REQUEST['grup'];
$reload = "menu2.php?pagination=true&grup=$grup";
$sql = ("select ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice,cp_temp FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id where cp_flag='0' and ae_area='$grup' ");
$result = mssql_query($sql);
}else{ echo 'data tidak ditemukan';
}else{
// jika tidak ada pencarian pakai ini
$reload = "menu2.php?pagination=true";
$sql = ("SELECT ac_name,au_name,ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id join [appl_unit] on au_id = cp_unit join [appl_cury] on ac_id = cp_cury where cp_flag='0' ");
$result = mssql_query($sql);
}
2 Jawaban:
else-nya satu aja gan, mau yg echo atau yg query akhir
Tanggapan
kalo untuk kaya notif nya gan gimana kalo pas saya cari data tapi data nya kosong jadi ada pesan bahwa data tidak ditemukan
tambah pengecekan lagi aja <pre> <?php if(isset($_REQUEST['customer']) && $_REQUEST['customer']<>""){ // jika ada kata kunci pencarian (artinya form pencarian disubmit dan tidak kosong) // pakai ini $customer=$_REQUEST['customer']; $reload = "menu2.php?pagination=true&customer=$customer"; $sql = ("select ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice,cp_temp FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id where cp_flag='0' and cp_cid like '%".$customer."%' ");
$result = mssql_query($sql);
}elseif (isset($_REQUEST['material']) && $_REQUEST['material']<>"") { $material=$_REQUEST['material']; $reload = "menu2.php?pagination=true&material=$material"; $sql = ("select ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice,cp_temp FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id where cp_flag='0' and cp_mate like '%".$material."%' "); $result = mssql_query($sql); }elseif (isset($_REQUEST['collor']) && $_REQUEST['collor']<>"") { $collor=$_REQUEST['collor']; $reload = "menu2.php?pagination=true&collor=$collor"; $sql = ("select ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice,cp_temp FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id where cp_flag='0' and cp_hues like '%".$collor."%' "); $result = mssql_query($sql); }elseif (isset($_REQUEST['size']) && $_REQUEST['size']<>"") { $size=$_REQUEST['size']; $reload = "menu2.php?pagination=true&size=$size"; $sql = ("select ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice,cp_temp FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id where cp_flag='0' and cp_width like '%".$size."%' "); $result = mssql_query($sql); }elseif (isset($_REQUEST['model']) && $_REQUEST['model']<>"") { $model=$_REQUEST['model']; $reload = "menu2.php?pagination=true&model=$model"; $sql = ("select ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice,cp_temp FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id where cp_flag='0' and cp_mode like '%".$model."%' "); $result = mssql_query($sql);
}elseif (isset($_REQUEST['grup']) && $_REQUEST['grup']<>"") { $grup=$_REQUEST['grup']; $reload = "menu2.php?pagination=true&grup=$grup"; $sql = ("select ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice,cp_temp FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id where cp_flag='0' and ae_area='$grup' "); $result = mssql_query($sql);
}else{ // jika tidak ada pencarian pakai ini
$reload = "menu2.php?pagination=true"; $sql = ("SELECT ac_name,au_name,ci_id,ci_name,cp_cid,cp_mate,cp_hues,cp_width,cp_mode,cp_name,cp_unit,cp_cury,cp_pack,cp_price,cp_date, cp_weight,cp_cprice,cp_uprice FROM [cust_pric] left join [cust_defi] on cd_cid = cp_cid join [appl_empl] on ae_id = cd_sm join [cust_info] on cp_cid = ci_id join [appl_unit] on au_id = cp_unit join [appl_cury] on ac_id = cp_cury where cp_flag='0' "); $result = mssql_query($sql); }
if(mysql_num_rows($result) <= 0) { // cek, apakah ada data atau tidak echo 'data tidak ditemukan'; } ?> </pre>
Tanggapan
gagal gan hehe, tidak terjadi apa apa wkwk
gagal itu seperti apa? apakah datanya sudah bisa tampil?
kalo data nya mah emang sudah muncul, tapi pas saya cari data dengan kata kunci ngasal.. hasil nya gak ada pesan bahwa data tidak ditemukan