Minggu, 11 Juli 2021

Mmebuat Array UNIQUE

 



function getUNIX($arRS){

$ar=array();

for($i=1;$i<count($arRS);$i++){//dari 1 krn 0 u jumlah ada

$ar[$i-1]=$arRS[$i];

}

$unique = array();

foreach($ar as $v){

  isset($k[$v]) || ($k[$v]=1) && $unique[] = $v;

  }

$gab="";   

for($i=0;$i<count($unique);$i++){

$gab.=$unique[$i].",";

}

$gab=substr($gab,0,strlen($gab)-1);

return $gab;

}

Minggu, 27 Juni 2021

PHP Cek Usia

 


function cekUsia($tgl){

$awal  = date_create($tgl);

$akhir = date_create(); 

$diff  = date_diff( $awal, $akhir );

return $diff->y;

}

Sabtu, 26 Juni 2021

Read Write SM

 <?php


$token = "1893725977:AAHyteFgCs_A73IyjSBIIXpsADIGANTENG";


$data = [

    'text' => 'halo apa kabar .... here',

    'chat_id' => '1308416385'

];


//file_get_contents("https://api.telegram.org/bot$token/sendMessage?" . http_build_query($data) );




$URI="https://api.telegram.org/bot1893725977:AAHyteFgCs_A73IyjSBIIADIGANTENG/getUpdates?offset=0";

//$ar=file_get_contents($URI );

//var_dump($ar);




//call api

$json = file_get_contents($URI);

//var_dump($json);

$json = json_decode($json,true);

//var_dump($json);

//$lat = $json->message[0]->message_id;

//$lng = $json->message[0]->from->first_name;

//echo "Latitude: " . $lat . ", Longitude: " . $lng;

cetak( $json["ok"]);

cetak( $json["result"][0]["update_id"]);

cetak( $json["result"][0]["message"]["message_id"]);

cetak( $json["result"][0]["message"]["from"]["id"]);

cetak( $json["result"][0]["message"]["from"]["first_name"]);

cetak( $json["result"][0]["message"]["from"]["last_name"]);

cetak( $json["result"][0]["message"]["from"]["language_code"]);

cetak( $json["result"][0]["message"]["chat"]["id"]);

cetak( $json["result"][0]["message"]["chat"]["first_name"]);

cetak( $json["result"][0]["message"]["chat"]["last_name"]);

cetak( $json["result"][0]["message"]["chat"]["type"]);

cetak( $json["result"][0]["message"]["date"]);

cetak( $json["result"][0]["message"]["text"]);




function cetak($v){

    echo"$v<hr>";


}

/*


string(331) "{"ok":true,"result":[{"update_id":42342343423, "message":{"message_id":8,"from":{"id":4324234234234,"is_bot":false,

    "first_name":"adi","last_name":"adiarray",

    "language_code":"en"},

    "chat":{"id":2342343,

        "first_name":"adi","last_name":"adiarray","type":"private"},"date":1624708793,

        "text":"Piye kabare ...masih enak zaman ku to?"}}]}

*/


?>

Senin, 21 Juni 2021

Import Tanggal Dari Excell

 function fromExcelToLinux($excel_time) {
    return ($excel_time-25569)*86400;
}

                $TGL_EXCEL = fromExcelToLinux($mulai_kerja); 
		$mulai_kerja= date("Y-m-d",$TGL_EXCEL);
		$TGL_EXCEL = fromExcelToLinux($tgl_lahir); 
		$tgl_lahir= date("Y-m-d",$TGL_EXCEL);

Senin, 26 April 2021

AJAX DOM RADIO BUTTON


<script type="text/javascript">
var xmlHttp;

function showUp1(str){
xmlHttp=GetXmlHttpObject()
if (xmlHttp==null){
 alert ("Browser tidak support HTTP Request");
 return;
 } 

var url="getUp1.php";

url=url+"?q="+str;

url=url+"&sid="+Math.random();

xmlHttp.onreadystatechange=SC1;

xmlHttp.open("GET",url,true);

xmlHttp.send(null);

}


function SC1() { 

if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){ 

 document.getElementById("txt1").innerHTML=xmlHttp.responseText ;

 } 

}




function showUp2(str1){ 

xmlHttp=GetXmlHttpObject()

if (xmlHttp==null){

 alert ("Browser tidak support HTTP Request");

 return;

 } 

 

//var str2= document.getElementById("poliklinik").value; 

var str2=  findSelection("poliklinik");

 

alert(str1+"#"+str2);

var url="getUp2.php";

url=url+"?t="+str1+"&p="+str2;

url=url+"&sid="+Math.random();

xmlHttp.onreadystatechange=SC2;

xmlHttp.open("GET",url,true);

xmlHttp.send(null);

}


function SC2() { 

if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){ 

 document.getElementById("txt2").innerHTML=xmlHttp.responseText ;

 } 

}


function findSelection(field) {

    var test = document.myForm.poliklinik;

    var sizes = test;


        for (i=0; i < sizes.length; i++) {

            if (sizes[i].checked==true) {   

            return sizes[i].value;

        }

    }

}


function showUp3(str){ 

xmlHttp=GetXmlHttpObject()

if (xmlHttp==null){

 alert ("Browser tidak support HTTP Request");

 return;

 } 

var url="getUp3.php";

url=url+"?q="+str;

url=url+"&sid="+Math.random();

xmlHttp.onreadystatechange=SC3;

xmlHttp.open("GET",url,true);

xmlHttp.send(null);

}


function SC3() { 

if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete"){ 

 document.getElementById("txt3").innerHTML=xmlHttp.responseText ;

 } 

}



function GetXmlHttpObject(){

var xmlHttp=null;

try{xmlHttp=new XMLHttpRequest();}

catch (e){

try{xmlHttp=new ActiveXObject("Msxml2.XMLHTTP");}

  catch (e){xmlHttp=new ActiveXObject("Microsoft.XMLHTTP");}

 }

return xmlHttp;

}

</script>


****************************


 


<form action="" name="myForm" method="post" enctype="multipart/form-data">

<input type="text" name="nomor_rm" id="nomor_rm" value="" placeholder="Nomor Rekammendis"  title="Nomor Rekammendis" onChange="showUp1(this.value)">

++++++++++++++++++++++++++++++++++

<input type="radio" name="poliklinik" id="poliklinik"  checked="checked" value="POLI UMUM"/>POLI UMUM

<input type="radio" name="poliklinik" id="poliklinik" value="POLI GIGI" />POLI GIGI

<input type="date" name="tanggal_kunjungan"  class="form-control form-control-user" id="tanggal_kunjungan" value="" placeholder="Tanggal Kunjungan"  title="Tanggal Kunjungan" onChange="showUp2(this.value)">

</form>



getUp1.php

<?php

require_once"konmysqli.php";


$nomor_rm=$_GET["q"];

if(strlen($nomor_rm)>5){

$sql="select * from `$tbpasien` where `nomor_rm`='$nomor_rm'";

$d=getFieldM($conn,$sql);

$id_pasien=$d["id_pasien"];

$nama_pasien=$d["nama_pasien"];

$no_identitas=$d["no_identitas"];

$tanggal_lahir=$d["tanggal_lahir"];

$jenis_kelamin=$d["jenis_kelamin"];

$alamat=$d["alamat"];

$email=$d["email"];

$telepon=$d["telepon"];

$username=$d["username"];

$password=$d["password"];

$nomor_rm=$d["nomor_rm"];

$asuransi=$d["asuransi"];

$awal  = date_create($tanggal_lahir);

$akhir = date_create(); 

$diff  = date_diff( $awal, $akhir );


$usia=$diff->y ;


echo "<b>$nama_pasien (NIK $no_identitas)</b><br>Alamat: $alamat, Telp $telepon |$jenis_kelamin #$usia Thn";

}

?>

###############################

getUp2.php

<?php

require_once"konmysqli.php";


$tanggal=$_GET["t"];

$poliklinik=$_GET["p"];

$id_jadwal="";


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

$hari="Minggu";

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

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

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

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

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

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

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


?>


<select class="form-control" name="id_jadwal" onChange="showUp3(this.value)">

<option disabled>Pilih Jadwal <?php echo  $poliklinik;?> + <?php echo  $hari;?></option>

<?php

$s="select * from `tb_jadwal` where `poliklinik`='$poliklinik' and `hari`='$hari' order by `jam` asc";

$q=getDataM($conn,$s);

foreach($q as $d){

$id_jadwal0=$d["id_jadwal"];

$jam=$d["jam"];

$poliklinik=$d["poliklinik"];

$hari=$d["hari"];

$dokter=$d["dokter"];

echo"<option value='$id_jadwal0' ";if($id_jadwal0==$id_jadwal){echo"selected";} echo">$poliklinik $dokter |$hari $jam </option>";

}

?>

</select>

######################################

getUp3.php

<?php

require_once"konmysqli.php";


$id_jadwal=$_GET["q"];

$tanggal_kunjungan=$_GET["t"];

$tgl=WKTM($tanggal_kunjungan);

$sql="select `nomor_antrian` from `$tbkunjungan` where `id_jadwal`='$id_jadwal' and `tanggal_kunjungan`='$tanggal_kunjungan' order by `id_kunjungan` desc";

$ada=getJumM($conn,$sql);

if($ada>0){

$d=getFieldM($conn,$sql);

$nomor_antrian=$d["nomor_antrian"]+1;

}

else{

$nomor_antrian=1;

}

echo "<b><i>Nomor Antrian Anda Untuk $tgl : </i><h2><font color='blue'>No. $nomor_antrian</font></h2></b>";

?>






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









Sweet Alert

Download library weetalert.min.js, letakkan dalam satu folder sejajar index !  https://drive.google.com/drive/folders/1uXhLjQv998HlVhtzObOPC...