Senin, 29 Maret 2021

PHP Timer Jika Waktu Habis 30 menit

 


$sql="select * from `$tbbooking` where `status`='Booking' order by `id_booking` desc";

$jum=getJum($conn,$sql);

if($jum > 0){

$arr=getData($conn,$sql);

foreach($arr as $d) {

$id_booking=$d["id_booking"];

$tanggal_booking=($d["tanggal_booking"]);

$jam_booking=$d["jam_booking"];

$awal  = strtotime($tanggal_booking.' '.$jam_booking);

$wkt=date("Y-m-d H:i:s");

$akhir = strtotime($wkt);

$diff  = $akhir - $awal;


$jam   = floor($diff / (60 * 60));

$menit = $diff - $jam * (60 * 60);

echo 'Waktu tinggal: ' . $jam .  ' jam, ' . floor( $menit / 60 ) . ' menit<br>';


if($jam>0){

$sql="Update `$tbbooking` set `status` ='Batal' where `id_booking`='$id_booking'";

$up=process($conn,$sql);

$sql="Update `$tbdetail` set `status_main` ='Batal' where `id_booking`='$id_booking'";

$up=process($conn,$sql);

}

else if($menit>30){

$sql="Update `$tbbooking` set `status` ='Batal' where `id_booking`='$id_booking'";

$up=process($conn,$sql);

$sql="Update `$tbdetail` set `status_main` ='Batal' where `id_booking`='$id_booking'";

$up=process($conn,$sql);

}


}

}






function getData($conn,$sql){

$rs=$conn->query($sql);

$rs->data_seek(0);

//$arr = $rs->fetch_all(MYSQLI_ASSOC);

//$arr = $rs->fetch_assoc();

while ($row = $rs->fetch_assoc()) {

     $arr[] = $row;

   }

$rs->free();

return $arr;

}


$hr = date('l', strtotime($tanggal_main));

//$hr=date("l");

$kat="Weekday ";

$hari="Minggu";

if($hr=="Sunday"){$hari="Minggu";$kat="Weekend";}

else if($hr=="Monday"){$hari="Senin";}

else if($hr=="Tuesday"){$hari="Selasa";}

else if($hr=="Wednesday"){$hari="Rabu";}

else if($hr=="Thrusday"){$hari="Kamis";}

else if($hr=="Friday"){$hari="Jumat";}

else if($hr=="Saturday"){$hari="Sabtu";$kat="Weekend";}







Jumat, 05 Maret 2021

Random Unique Array Static

 

<?php

$i=0;

$arN[$i]="Adiarray";

$arB[$i]="Matlab, Pyton, Bahasa R, Android, C++, Statistik";$i++;


$arN[$i]="Nico";

$arB[$i]="PHP Mysql, Desain Grafis, Layout, Photoshop, AuVi Apps";$i++;


$arN[$i]="Heru KZW";

$arB[$i]="Android Studio, Web Desain, CMS, CSS";$i++;


$arN[$i]="Tony Blair";

$arB[$i]="Java, Android, PHP Mysql, Matlab, C#, VBNET";$i++;


$arN[$i]="Rini DA";

$arB[$i]="Adobe Flash, Ms Office, Excell, Animation ";$i++;


$arN[$i]="JLaksamana";

$arB[$i]="Management Project, Pajak, Brevet, Accounting ";$i++;


$arN[$i]="Boy Chandra";

$arB[$i]="Unity 3D, Blender, VR, AR, Gamer Apps";$i++;


$arN[$i]="Poedji";

$arB[$i]="PHP Native, Laravel, Codeigneter, YII2, Database";$i++;


$arN[$i]="Sandri M";

$arB[$i]="Codeigneter, Android, PHP Mysql, Desainer, SEO";$i++;


$max = $i-1;

$done = false;

while(!$done){

    $numbers = range(0, $max);

    shuffle($numbers);

    $done = true;

    foreach($numbers as $key => $val){

        if($key == $val){

            $done = false;

            break;

        }

    }

}

//var_dump($numbers);

?>

<div class="staff-bottom text-center">

<div class="col-md-3 staff-left">

<img src="img/foto_pengajar.jpg" alt="" />

<h4><?php echo $arN[$numbers[0]];?></h4>

<p><?php echo $arB[$numbers[0]];?></p>

</div>

<div class="col-md-3 staff-left">

<img src="img/foto_pengajar.jpg" alt="" />

<h4><?php echo $arN[$numbers[1]];?></h4>

<p><?php echo $arB[$numbers[1]];?></p>

</div>

<div class="col-md-3 staff-left">

<img src="img/foto_pengajar.jpg" alt="" />

<h4><?php echo $arN[$numbers[2]];?></h4>

<p><?php echo $arB[$numbers[2]];?></p>

</div>

<div class="col-md-3 staff-left">

<img src="img/foto_pengajar.jpg" alt="" />

<h4><?php echo $arN[$numbers[3]];?></h4>

<p><?php echo $arB[$numbers[3]];?></p>

</div>

<div class="clearfix"></div>

</div>

</div>

</div>


ATAU

$arr = range(0, 30);
shuffle($arr );
$arr = array_slice($arr ,0,6);
var_dump($arr);

hasilnya:

array(6) { [0]=> int(4) [1]=> int(28) [2]=> int(9) [3]=> int(22) [4]=> int(12) [5]=> int(6) }









Mencari Tanggal Terakhir Suatu Bulan

  $a_date = "$tahun-$bulan-01"; $lastdate= date('t',strtotime($a_date));//Y-m-t <?php require_once"koneksivar.php&...