Advertisement
Guest User

Untitled

a guest
Feb 23rd, 2020
111
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. $dino_iki = date('Y-m-d');
  2. // $dino_iki = "2019-10-11";
  3. $kode_poli = trim($_POST['KDPOLY']);
  4.  
  5. $sql_antrian_cari = "SELECT * FROM no_antrian WHERE kd_poli='$kode_poli' AND date(tgl) ='$dino_iki'";
  6. $q_antrian = mysql_query($sql_antrian_cari) or die(mysql_error());
  7. $num = mysql_num_rows($q_antrian);
  8.  
  9. $idxDaftar = getLastIDXDAFTAR();
  10. if($num > 0){
  11. $urutan = $num+1;
  12. $to_noAntrian = "INSERT INTO no_antrian SET kd_poli='$kode_poli', idxdaftar='$idxDaftar', no_urut='$urutan'";
  13. }else {
  14. $to_noAntrian = "INSERT INTO no_antrian SET kd_poli='$kode_poli', idxdaftar='$idxDaftar', no_urut='1'";
  15. }
  16. $q_antrian_insert = mysql_query($to_noAntrian)or die(mysql_error());
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement