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);
}

avatar Obbytokun
@Obbytokun

186 Kontribusi 16 Poin

Diperbarui 5 tahun yang lalu

Tanggapan

errornya apa ya gan?

ini gan error nya

2 Jawaban:

else-nya satu aja gan, mau yg echo atau yg query akhir

avatar dianarifr
@dianarifr

642 Kontribusi 316 Poin

Dipost 5 tahun yang lalu

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> &lt;?php if(isset($_REQUEST['customer']) && $_REQUEST['customer']&lt;&gt;""){ // 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']&lt;&gt;"") { $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']&lt;&gt;"") { $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']&lt;&gt;"") { $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']&lt;&gt;"") { $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']&lt;&gt;"") { $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) &lt;= 0) { // cek, apakah ada data atau tidak echo 'data tidak ditemukan'; } ?&gt; </pre>

avatar dianarifr
@dianarifr

642 Kontribusi 316 Poin

Dipost 5 tahun yang lalu

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

Login untuk ikut Jawaban