Hasil Pencarian Data
$qtes=0;
if ($carinip=='' and $carinama=='')
{
$qtes=1;
}
if ($qtes==0)
{
if ($carinip!='' or $carinama!='')
{
include "callkoneksi.php";
if ($carinip=='' and $carinama!='')
{
$rtes='111111';
$panggil = "select * FROM dtdaerah WHERE vnama like '%$carinama%' and vnama!='' and keterangan='' order by vnama";
}
else
if ($carinama=='' and $carinip!='')
{
$rtes='2222222';
$panggil = "select * FROM dtdaerah WHERE (nipa='$carinipr' and nipa!='') or (nipb='$carinip' and nipb!='') and keterangan='' order by vnama";
}
else
{
$rtes='333333';
$panggil = "select * FROM dtdaerah WHERE (nipa='$carinipr' and nipa!='') or (nipb='$carinip' and nipb!='') or (vnama like '%$carinama%' and vnama!='') and keterangan='' order by vnama";
}
}
$sql = mysqli_query($conn, $panggil);
$num_rows = mysqli_num_rows($sql);
while ($p=mysqli_fetch_array($sql))
{
$nama=$p['vnama'];
$tempat=$p['vtempat'];
$lahir=$p['vlahir'];
$cabang=$p['cabang'];
$kerja =$p['temp_kerja'];
$nipb = $p['nipb'];
$nipa = $p['nipa'];
$dddaerah=$p['daerah'];
if ($nipb!='')
{
echo "$nama
$tempat, $lahir
Cabang $cabang
$kerja
$dddaerah
";
}
else
{
echo "$nama
$tempat, $lahir
Cabang $cabang
$kerja
$dddaerah
";
}
}
}
?>