PHP ILU INU IMU

Jumat, 20 Desember 2019

PHP Code Cek tabel name dan ALTER

<?php
require_once"config.php";

echo"<hr>";
cekKolom($conn,"baksos");

echo"<hr>";

$sql='select * from tb_admin';
//$result=$conn->query($sql);
$result = mysqli_query($conn,$sql);

$jc=mysqli_num_fields($result);
echo "Ada sebanyak: ".$jc." Kolom";

echo"<hr>";
while ($fieldinfo=mysqli_fetch_field($result)){
printf("Name: %s\n",$fieldinfo->name);
printf("Table: %s\n",$fieldinfo->type);
echo"<hr>";
}

$colObj = mysqli_fetch_field_direct($result,1);
$col = $colObj->name;
echo "<br/>Kolemm ke-1: ".$col;

mysqli_free_result($result);
$conn -> close();

function cekKolom($conn,$NK){
$ada=0;
$sql = "SELECT * from tb_admin";
if ($result = $conn -> query($sql)) {
while ($fieldinfo = $result -> fetch_field()) {
if($NK==$fieldinfo -> name){$ada++;}
}
$result -> free_result();
}
if($ada==0){
$sql="ALTER TABLE `tb_admin` ADD `".$NK."` VARCHAR(30) NOT NULL ";
process($conn,$sql);
}
return $ada;
}
?>

Selasa, 17 Desember 2019

MULTI Marker PHP dan Direction Revisi

<?php

$setjarak=100;
if(isset($_POST["Set"])){
$setjarak=$_POST["jarak"];
}
//AIzaSyBhSg6I2JvHNU_jLqIpvc5MEwc_xi3Ttvg
//AIzaSyCbkraMfyHLJxgO0XMLEWxz6xlLRmQpwYM
?>
<script type="text/javascript" src="//maps.googleapis.com/maps/api/js?key=AIzaSyBhSg6I2JvHNU_jLqIpvc5MEwc_xi3Ttvg"></script>

<script>
var map;

Number.prototype.toRad = function() {
return this * Math.PI / 180;
}

function initialize() {
<?php
$lat0= -6.217003;
$lon0=106.828432;

?>
var lat1=<?php echo $lat0;?>;
var lon1=<?php echo $lon0;?>;

var myLatlng = new google.maps.LatLng(lat1, lon1);
var mapOptions = {
zoom: 10,
center: myLatlng,
mapTypeId: google.maps.MapTypeId.ROADMAP
}
map = new google.maps.Map(document.getElementById("map_canvas"), mapOptions);
var image = 'https://developers.google.com/maps/documentation/javascript/examples/full/images/beachflag.png';
var location0 = new google.maps.LatLng(lat1,lon1);
var marker0 = new google.maps.Marker({
position: location0,
map: map,
icon: image
});
marker0.setTitle("Posisi Anda");
var content0="Kampus STIE Perbanas";
attachSecretMessage(marker0, content0);

// or: new Array();
var arLat= [];
var arLon= [];
var arNama= [];
var arLok= [];
var arJarak= [];
var n=0;
var JM=200000000;
<?php
$sql="select * from `$tbpb`";// where status='Diterima'
$arr=getData($conn,$sql);
$j=0;

if(isset($_POST["Set"])){ ?>
JM= <?php echo $_POST["jarak"];?>
<?php
}
else{
?>
var JM=200000000;
<?php
}

foreach($arr as $d) {
$id_pb=$d["id_pb"];
$id_customer=getCustomer($conn,$d["id_customer"]);
$jam=$d["jam"];
$lat=$d["latitude"];
$long=$d["longitude"];
$status=$d["status"];
$alamat=$d["alamat"];
$gambar=$d["gambar"];
$pesan=$d["pesan"];
$nopol=$d["nopol"];
$jenis_mobil=$d["jenis_mobil"];
?>

var lat2= <?php echo $lat;?>;
var lon2= <?php echo $long;?>;

var R = 6371; // km
//has a problem with the .toRad() method below.
var x1 = lat2-lat1;
var dLat = x1.toRad();
var x2 = lon2-lon1;
var dLon = x2.toRad();
var a = Math.sin(dLat/2) * Math.sin(dLat/2) +
Math.cos(lat1.toRad()) * Math.cos(lat2.toRad()) *
Math.sin(dLon/2) * Math.sin(dLon/2);
var c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1-a));
var d = R * c;

<?php if(isset($_POST["Set"])){ ?>
if(d <= JM){
arLat[n]= <?php echo $lat;?>;
arLon[n]= <?php echo $long;?>;
arNama[n]= "<?php echo $id_customer;?>";
arLok[n]= "<?php echo "Hasil cari <=".$_POST["jarak"]." KM : $id_customer #<a href='direction.php?mnu=direction&lat=$lat0&lon=$lon0&id=$id_pb&origin=$id_customer' target='_blank'>Go Direction</a>";?>;"
arJarak[n]=d;
n=n+1;
}//<=
<?php
}//isset
else{
?>
arLat[n]= <?php echo $lat;?>;
arLon[n]= <?php echo $long;?>;
arNama[n]="<?php echo $id_customer;?>";
arLok[n]= "<?php echo "$id_customer #<a href='direction.php?mnu=direction&lat=$lat0&lon=$lon0&id=$id_pb&origin=$id_customer' target='_blank'>Go Direction</a>";?>";
arJarak[n]=d;
n=n+1;
<?php
}//else
}//foreach
?>

for (var i = 0; i < n; i++) {
var location = new google.maps.LatLng(arLat[i],arLon[i]);
var marker = new google.maps.Marker({
position: location,
map: map
});
marker.setTitle(arNama[i]);
var content=arNama[i]+"\n"+arLok[i]+" jarak :"+arJarak[i]+" KM";
attachSecretMessage(marker, content);
}
}

function attachSecretMessage(marker, lokasi) {
var infowindow = new google.maps.InfoWindow({content: lokasi,size: new google.maps.Size(50,50)});
google.maps.event.addListener(marker, 'click', function() {
infowindow.open(map,marker);
});
}

google.maps.event.addDomListener(window, 'load', initialize);
</script>

<body>
<div id="map_canvas" style="width:100%;height:500px;"></div>

<br>

<div align="right">
<form action="" method="post">
Set jarak Minimal <input type="text" name="jarak" id="jarak" value="<?php echo $setjarak;?>">
<input type="submit" value="Set" name="Set">
</form>
</div>

</body>

++++
<?php
require_once"konmysqli.php";

$id=100;
$id_pb="PNB1912004";
$lat0= -6.217003;
$lon0=106.828432;
$origin="Kampus STIE Perbanas";

if(isset($_GET["id"])){
$id_pb=$_GET["id"];
$lat0=$_GET["lat"];
$lon0=$_GET["lon"];
$origin=$_GET["origin"];
}

$sql="select * from `$tbpb` where `id_pb`='$id_pb' ";
$d=getField($conn,$sql);
$id_pb=$d["id_pb"];
$id_customer="";//getCustomer($conn,$d["id_customer"]);
$jam=$d["jam"];
$latitude=$d["latitude"];
$longitude=$d["longitude"];
$status=$d["status"];
$alamat=$d["alamat"];
$keterangan=$d["keterangan"];
$gambar=$d["gambar"];
$gambar0=$d["gambar"];
$pesan=$d["pesan"];
$nopol=$d["nopol"];
$jenis_mobil=$d["jenis_mobil"];

?>
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="initial-scale=1.0, user-scalable=no">
<meta charset="utf-8">
<title>Travel Modes in Directions</title>
<style>
/* Always set the map height explicitly to define the size of the div
* element that contains the map. */
#map {
height: 100%;
}
/* Optional: Makes the sample page fill the window. */
html, body {
height: 100%;
margin: 0;
padding: 0;
}
#floating-panel {
position: absolute;
top: 10px;
left: 25%;
z-index: 5;
background-color: #fff;
padding: 5px;
border: 1px solid #999;
text-align: center;
font-family: 'Roboto','sans-serif';
line-height: 30px;
padding-left: 10px;
}
</style>
</head>
<body>
<div id="floating-panel">
<b>Mode of Travel: </b>
<select id="mode">
<option value="DRIVING">Driving</option>
<option value="WALKING">Walking</option>
<option value="BICYCLING">Bicycling</option>
<option value="TRANSIT">Transit</option>
</select>
</div>
<div id="map"></div>
<script>
function initMap() {
var directionsRenderer = new google.maps.DirectionsRenderer;
var directionsService = new google.maps.DirectionsService;
var map = new google.maps.Map(document.getElementById('map'), {
zoom: 14,
center: {lat: <?php echo $lat0;?>, lng: <?php echo $lon0;?>}
});
directionsRenderer.setMap(map);

calculateAndDisplayRoute(directionsService, directionsRenderer);
document.getElementById('mode').addEventListener('change', function() {
calculateAndDisplayRoute(directionsService, directionsRenderer);
});
}

function calculateAndDisplayRoute(directionsService, directionsRenderer) {
var selectedMode = document.getElementById('mode').value;
directionsService.route({
origin: {lat: <?php echo $lat0;?>, lng: <?php echo $lon0;?>}, // Haight.
destination: {lat: <?php echo $latitude;?>, lng: <?php echo $longitude;?>}, // Ocean Beach.
// Note that Javascript allows us to access the constant
// using square brackets and a string value as its
// "property."
travelMode: google.maps.TravelMode[selectedMode]
}, function(response, status) {
if (status == 'OK') {
directionsRenderer.setDirections(response);
} else {
window.alert('Directions request failed due to ' + status);
}
});
}

google.maps.event.addDomListener(window, 'load', initMap);
</script>
<script async defer
src="https://maps.googleapis.com/maps/api/js?key=AIzaSyBhSg6I2JvHNU_jLqIpvc5MEwc_xi3Ttvg&callback=initMap">
</script>
</body>
</html>

<?php
function process($conn,$sql){
$s=false;
$conn->autocommit(FALSE);
try {
$rs = $conn->query($sql);
if($rs){
$conn->commit();
$last_inserted_id = $conn->insert_id;
$affected_rows = $conn->affected_rows;
$s=true;
}
}
catch (Exception $e) {
echo 'fail: ' . $e->getMessage();
$conn->rollback();
}
$conn->autocommit(TRUE);
return $s;
}

function getJum($conn,$sql){
$rs=$conn->query($sql);
$jum= $rs->num_rows;
$rs->free();
return $jum;
}

function getField($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$d= $rs->fetch_assoc();
$rs->free();
return $d;
}

function getData($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$arr = $rs->fetch_all(MYSQLI_ASSOC);
//foreach($arr as $row) {
// echo $row['nama_kelas'] . '*<br>';
//}

$rs->free();
return $arr;
}

?>

Kamis, 12 Desember 2019

PHP MAP MULTI MARKER DAN DIRECTION

Generate dahulu apikey:
https://console.cloud.google.com/apis/credentials/key/80ecde3a-5abc-4c54-af65-45d6446701a9?project=trusty-gradient-251202

Buat Kode sbb:

<?php
require_once"konmysqli.php";

$setjarak=100;
if(isset($_POST["Set"])){
$setjarak=$_POST["jarak"];
}
//AIzaSyBhSg6I2JvHNU_jLqIpvc5MEwc_xi3Ttvg

//AIzaSyCbkraMfyHLJxgO0XMLEWxz6xlLRmQpwYM
?>
<script type="text/javascript" src="//maps.googleapis.com/maps/api/js?key=AIzaSyBhSg6I2JvHNU_jLqIpvc5MEwc_xi3Ttvg&sensor=true"></script>
<script>
var map;

Number.prototype.toRad = function() {
return this * Math.PI / 180;
}

function initialize() {
var lat1=-6.353019;
var lon1=106.833086;

var myLatlng = new google.maps.LatLng(lat1, lon1);
var mapOptions = {
zoom: 10,
center: myLatlng,
mapTypeId: google.maps.MapTypeId.ROADMAP
}
map = new google.maps.Map(document.getElementById("map_canvas"), mapOptions);
var image = 'https://developers.google.com/maps/documentation/javascript/examples/full/images/beachflag.png';
var location0 = new google.maps.LatLng(lat1,lon1);
var marker0 = new google.maps.Marker({
position: location0,
map: map,
icon: image
});
marker0.setTitle("Posisi Anda");
var content0="Jl. RS Fatmawati, Pangkalan Jati, Cilandak, Kota Jakarta Selatan, Daerah Khusus Ibukota Jakarta 16514";
attachSecretMessage(marker0, content0);

// or: new Array();
var arLat= [];
var arLon= [];
var arNama= [];
var arLok= [];
var arJarak= [];
var n=0;
var JM=200000;
<?php
$sql="select * from `tb_restoran`";
$arr=getData($conn,$sql);
$j=0;

if(isset($_POST["Set"])){ ?>
JM= <?php echo $_POST["jarak"];?>
<?php
}
else{
?>
var JM=200000;
<?php
}

foreach($arr as $d) {
$kd_sem=$d["id_restoran"];
$id_restoran0=$d["id_restoran"];
$nama_restoran=$d["nama_restoran"];
$alamat=$d["alamat"];
$telepon=$d["telepon"];

$lat=$d["latitude"];
$long=$d["longitude"];
$gambar=$d["gambar"];
?>

var lat2= <?php echo $lat;?>;
var lon2= <?php echo $long;?>;

var R = 6371; // km
//has a problem with the .toRad() method below.
var x1 = lat2-lat1;
var dLat = x1.toRad();
var x2 = lon2-lon1;
var dLon = x2.toRad();
var a = Math.sin(dLat/2) * Math.sin(dLat/2) +
Math.cos(lat1.toRad()) * Math.cos(lat2.toRad()) *
Math.sin(dLon/2) * Math.sin(dLon/2);
var c = 2 * Math.atan2(Math.sqrt(a), Math.sqrt(1-a));
var d = R * c;

<?php if(isset($_POST["Set"])){ ?>
if(d <= JM){
arLat[n]= <?php echo $lat;?>;
arLon[n]= <?php echo $long;?>;
arNama[n]= "<?php echo $nama_restoran;?>";
arLok[n]= "<?php echo "Hasil cari <=".$_POST["jarak"]."KM : $nama_restoran $alamat #<a href='index.php?mnu=direction&x=$lat&y=$long'>Go Direction</a>";?>";
arJarak[n]=d;
n=n+1;
}//<=

<?php
}//isset
else{
?>
arLat[n]= <?php echo $lat;?>;
arLon[n]= <?php echo $long;?>;
arNama[n]= "<?php echo $nama_restoran;?>";
arLok[n]= "<?php echo "Hasil Semua Data : $nama_restoran $alamat #<a href='index.php?mnu=direction&x=$lat&y=$long'>Go Direction</a>";?>";
arJarak[n]=d;
n=n+1;
<?php
}//else
}//foreach
?>

for (var i = 0; i < n; i++) {
var location = new google.maps.LatLng(arLat[i],arLon[i]);
var marker = new google.maps.Marker({
position: location,
map: map
});
marker.setTitle(arNama[i]);
var content=arNama[i]+"\n"+arLok[i]+" jarak :"+arJarak[i]+" KM";
attachSecretMessage(marker, content);
}
}

function attachSecretMessage(marker, lokasi) {
var infowindow = new google.maps.InfoWindow({content: lokasi,size: new google.maps.Size(50,50)});
google.maps.event.addListener(marker, 'click', function() {
infowindow.open(map,marker);
});
}

google.maps.event.addDomListener(window, 'load', initialize);
</script>

<body>
<div id="map_canvas" style="width:100%;height:500px;"></div>

<br>

<div align="right">
<form action="" method="post">
Set jarak <input type="text" name="jarak" id="jarak" value="<?php echo $setjarak;?>">
<input type="submit" value="Set" name="Set">
</form>
</div>

</body>

<?php
function process($conn,$sql){
$s=false;
$conn->autocommit(FALSE);
try {
$rs = $conn->query($sql);
if($rs){
$conn->commit();
$last_inserted_id = $conn->insert_id;
$affected_rows = $conn->affected_rows;
$s=true;
}
}
catch (Exception $e) {
echo 'fail: ' . $e->getMessage();
$conn->rollback();
}
$conn->autocommit(TRUE);
return $s;
}

function getJum($conn,$sql){
$rs=$conn->query($sql);
$jum= $rs->num_rows;
$rs->free();
return $jum;
}

function getField($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$d= $rs->fetch_assoc();
$rs->free();
return $d;
}

function getData($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$arr = $rs->fetch_all(MYSQLI_ASSOC);
//foreach($arr as $row) {
// echo $row['nama_kelas'] . '*<br>';
//}

$rs->free();
return $arr;
}

?>
HASILNYA:

Untuk direction gunakan kode sbb:

OK Mudah yaaaa

Senin, 09 Desember 2019

PDF 2 WORD

<?php
require 'pdfcrowd.php';

$client = new \Pdfcrowd\HtmlToPdfClient("sahrulrasyid", "360c2654be6b37707a1c512bdcb39db8");
$pdf = $client->convertUrl("https://en.wikipedia.org/wiki/Main_Page");
?>

DOWNLOAD LIB

Sabtu, 30 November 2019

CACAH WAKTU

<?php
$tanggal_wafat="2018-06-03";
$ar=explode("-",$tanggal_wafat);
$thn=$ar[0];
$bln=$ar[1];
$now=date("Y");
$nowb=date("m");

$sel=$now-$thn;
$lop=$sel;

//--------------------------
$awal=12-$bln;
if($sel==0){$lop=$awal;}
else{$lop=$awal+(12*$sel);}
//-----------------------
$inc=0;
$thntagihan=$thn;
$blntagihan=$bln-1;
echo"TGL Wavat: $tanggal_wafat s/d Bulan $nowb tahun $now =$lop Bulan<br>";
for($i=0;$i<=$lop;$i++){
$blntagihan=$blntagihan+1;
if($blntagihan>12){
$inc=0;
$blntagihan=1;
$thntagihan=$thntagihan+1;
}

echo"$inc $blntagihan $thntagihan<br>";
$inc++;
}

?>

Kamis, 14 November 2019

PHP JSON Telegram

Baca Telegram pesan terakhir:

<?php

$url="https://api.telegram.org/bot937760588:AAEUJ78wN4PXsqiPGHws1z1POA-_TcG4P_0A/getUpdates";
$json = file_get_contents($url);
echo $json;

echo"<hr>";
$json = json_decode($json, true);
$jum=count($json['result'])-1;
echo $jum;
$last=$json['result'][$jum]['message']['text'];
echo $last;//var_dump($json['result'][2]['message']['text']);

?>

Kirim pesan:

echo $TOKEN ="937760588:AAEUJ78wN4PXsqiPGHws1z1POA-_TcG4P_0A";
$chatid ="874965587"; //me
$method = "sendMessage";
$url = "https://api.telegram.org/bot" . $TOKEN . "/". $method;
$post = [
'chat_id' => $chatid,
'parse_mode' => 'HTML', // aktifkan ini jika ingin menggunakan format type HTML, bisa juga diganti menjadi Markdown
'text' => $pesan
];
$header = [
"X-Requested-With: XMLHttpRequest",
"User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.84 Safari/537.36"
];

$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
curl_setopt($ch, CURLOPT_POSTFIELDS, $post );
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
$datas = curl_exec($ch);
$error = curl_error($ch);
$status = curl_getinfo($ch, CURLINFO_HTTP_CODE);
curl_close($ch);
$debug['text'] = $pesan;
$debug['code'] = $status;
$debug['status'] = $error;
$debug['respon'] = json_decode($datas, true);

Hasil baca= {"ok":true,"result":[{"update_id":590513901,
"message":{"message_id":1,"from":{"id":874965587,"is_bot":false,"first_name":"Riadi","last_name":"Marta Dinata"},"chat":{"id":874965587,"first_name":"Riadi","last_name":"Marta Dinata","type":"private"},"date":1573714779,"text":"/start","entities":[{"offset":0,"length":6,"type":"bot_command"}]}},{"update_id":590513902,
"message":{"message_id":3,"from":{"id":874965587,"is_bot":false,"first_name":"Riadi","last_name":"Marta Dinata","language_code":"en"},"chat":{"id":874965587,"first_name":"Riadi","last_name":"Marta Dinata","type":"private"},"date":1573715943,"text":"/start","entities":[{"offset":0,"length":6,"type":"bot_command"}]}},{"update_id":590513903,
"message":{"message_id":13,"from":{"id":874965587,"is_bot":false,"first_name":"Riadi","last_name":"Marta Dinata","language_code":"en"},"chat":{"id":874965587,"first_name":"Riadi","last_name":"Marta Dinata","type":"private"},"date":1573733191,"text":"halo apa kabar"}}]}

LAST:

<?php
session_start();
//error_reporting(0);

require_once"konmysqli.php";

date_default_timezone_set("Asia/Jakarta");
echo WKT(date("Y-m-d"))." # ".date("H:i:s")."<hr>";

$sqlv="select * from `$tbpengguna` where `status`='Aktif'";
$arrv=getData($conn,$sqlv);
foreach($arrv as $dv) {
$id_pengguna=$dv["id_pengguna"];
$nama_pengguna=$dv["nama_pengguna"];
$nama=$nama_pengguna;
$email=$dv["email"];
$telephone=$dv["telephone"];
$TOKEN=$dv["key"];
$chatid=$dv["id_bot"];
$id_bot=$dv["id_bot"];

if(strlen($TOKEN)>15){
$sql="select * from `$tbalarm` where id_bot='$id_bot' and `status_alarm`='Proses' order by `id_alarm` asc";
$jum=getJum($conn,$sql);
if($jum > 0){
$arr=getData($conn,$sql);
foreach($arr as $d) {
$id_alarm=$d["id_alarm"];
$stanggal_alarm=($d["tanggal_alarm"]);

$tanggal_alarm=$d["tanggal_alarm"];
$jam_alarm=$d["jam_alarm"];

$pesan_alarm=$d["pesan_alarm"];
$status_alarm=$d["status_alarm"];
$keterangan_alarm=$d["keterangan_alarm"];

$sel=cekAlarm($tanggal_alarm,$jam_alarm);
echo"$nama=$sel: $pesan_alarm#$stanggal_alarm $jam_alarm<br>";

if($sel==0){
$pesan="Yth $nama_pengguna :$pesan_alarm";
kirim($TOKEN,$chatid,$pesan);
$sql2="Update `$tbalarm` set `status_alarm`='Selesai' where `id_alarm`='$id_alarm'";
$up2=process($conn,$sql2);

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

$ar=explode(":",$jam_alarm);
$J0=$ar[0];
$M0=$ar[1];
$M0=$M0+10;

if($M0>=60){
$J0=$J0+1;
$M0=00;
}

$jam_alarm="$J0:$M0:00";

if($keterangan_alarm=="-"|| $keterangan_alarm==""){
$sql3=" INSERT INTO `$tbalarm` (
`id_alarm` ,
`id_bot` ,
`tanggal` ,
`jam` ,
`tanggal_alarm` ,
`jam_alarm` ,
`pesan_alarm` ,
`status_alarm`,
`keterangan_alarm`
) VALUES (
'',
'$id_bot',
'$tanggal',
'$jam',
'$tanggal_alarm',
'$jam_alarm',
'$pesan_alarm (Reupload)',
'Proses',
'Reupload'
)";

$simpan=process($conn,$sql3);

}//if -
}

}//foreach
}//jum
//=====================================================CEK ADA REQUEST\\\

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

$url="https://api.telegram.org/bot".$TOKEN."/getUpdates";
//echo $url."<hr>";
$json = file_get_contents($url);
//echo $json."<hr>";

$json = json_decode($json, true);
$jumx=count($json['result'])-1;
if($jumx>=0){
$datetele=$json['result'][$jumx]['message']['date'];
$pesantele=$json['result'][$jumx]['message']['text'];
$pesantele=strtolower($pesantele);
echo "Pesan Telegram=".$pesantele."<hr>";
if($pesantele=="request" || $pesantele=="cek" ||$pesantele=="today"){

$sqln="select * from `$tbrequest` where id_bot='$id_bot' and `date`='$datetele' order by `id_request` desc";
$ada2=getJum($conn,$sqln);
if($ada2<1){
//simpan
$sqlm=" INSERT INTO `$tbrequest` (
`id_request` ,
`tanggal` ,
`jam` ,
`id_bot` ,
`pesan` ,`date` ,
`status` ,
`keterangan`
) VALUES (
'',
'$tanggal',
'$jam',
'$id_bot',
'$pesantele','$datetele',
'Selesai',
'Request Via Telegram'
)";
$simpan=process($conn,$sqlm);

//***
/*
$gab="<strong>Alarm Hari ini:</strong><ol>";
$sqlb="select * from `$tbalarm` where id_bot='$id_bot' and `tanggal_alarm`='".date("Y-m-d")."' order by `id_alarm` asc";
$arrb=getData($conn,$sqlb);
foreach($arrb as $db) {
$tanggal_alarm=WKT($db["tanggal_alarm"]);
$jam_alarm=$db["jam_alarm"];
$pesan_alarm=$db["pesan_alarm"];
$status_alarm=$db["status_alarm"];
$gab.="<li>$pesan_alarm ($status_alarm:$jam_alarm)</li>";
}
$gab.="</ol>";
echo $gab;
*/

$gab="Alarm Hari ini:";
$sqlb="select * from `$tbalarm` where id_bot='$id_bot' and `tanggal_alarm`='".date("Y-m-d")."' order by `id_alarm` asc";
$arrb=getData($conn,$sqlb);
foreach($arrb as $db) {
$tanggal_alarm=WKT($db["tanggal_alarm"]);
$jam_alarm=$db["jam_alarm"];
$pesan_alarm=$db["pesan_alarm"];
$status_alarm=$db["status_alarm"];
$gab.="$pesan_alarm ($status_alarm:$jam_alarm), ";
}
$gab.="";
echo $gab;

kirim($TOKEN,$chatid,$gab);
//***

}//ada2
}//if request

}//jumx

//========================================================
}//>15
} //penggunaaktif

function kirim($TOKEN,$chatid,$pesan){
$method = "sendMessage";
$url = "https://api.telegram.org/bot" . $TOKEN . "/". $method;
//echo $url;
$post = [
'chat_id' => $chatid,
'parse_mode' => 'HTML',
'text' => $pesan
];
$header = [
"X-Requested-With: XMLHttpRequest",
"User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.84 Safari/537.36"
];

$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $url);
curl_setopt($ch, CURLOPT_HTTPHEADER, $header);
curl_setopt($ch, CURLOPT_POSTFIELDS, $post );
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
$datas = curl_exec($ch);
$error = curl_error($ch);
$status = curl_getinfo($ch, CURLINFO_HTTP_CODE);
curl_close($ch);
$debug['text'] = $pesan;
$debug['code'] = $status;
$debug['status'] = $error;
$debug['respon'] = json_decode($datas, true);
return 1;
}

function cekAlarm($tanggal,$jam){
date_default_timezone_set("Asia/Jakarta");
$tg=date("Y-m-d");
$J1=date("H");
$M1=date("i");

$kon=1;
if($tg==$tanggal){
$ar=explode(":",$jam);
$J0=$ar[0];
$M0=$ar[1];
if($J1>$J0){
$kon=0;
}
elseif($J1==$J0 && $M1>=$M0){
$kon=0;
}
}//if sama tanggal

return $kon;//"$J1>=$J0 && $M1>=$M0=".$kon;
}

function getEXP($tanggal,$jam){
$awal = date_create($tanggal ." ".$jam);
$akhir = date_create(); // waktu sekarang
$diff = date_diff( $awal, $akhir );

$jummenit=$diff->i;
$jumjam=$diff->h;
$kon=0;
if($jummenit>0){
$kon=1;
}
return $jumjam."-".$jummenit;
}

?>

<?php function RP($rupiah){return number_format($rupiah,"2",",",".");}?>
<?php
function WKT($sekarang){
$tanggal = substr($sekarang,8,2)+0;
$bulan = substr($sekarang,5,2);
$tahun = substr($sekarang,0,4);

$judul_bln=array(1=> "Januari", "Februari", "Maret", "April", "Mei","Juni", "Juli", "Agustus", "September","Oktober", "November", "Desember");
$wk=$tanggal." ".$judul_bln[(int)$bulan]." ".$tahun;
return $wk;
}
?>
<?php
function WKTP($sekarang){
$tanggal = substr($sekarang,8,2)+0;
$bulan = substr($sekarang,5,2);
$tahun = substr($sekarang,2,2);

$judul_bln=array(1=> "Jan", "Feb", "Mar", "Apr", "Mei","Jun", "Jul", "Agu", "Sep","Okt", "Nov", "Des");
$wk=$tanggal." ".$judul_bln[(int)$bulan]."'".$tahun;
return $wk;
}
?>
<?php
function BAL($tanggal){
$arr=explode(" ",$tanggal);
if($arr[1]=="Januari"||$arr[1]=="January"){$bul="01";}
else if($arr[1]=="Februari"||$arr[1]=="February"){$bul="02";}
else if($arr[1]=="Maret"||$arr[1]=="March"){$bul="03";}
else if($arr[1]=="April"){$bul="04";}
else if($arr[1]=="Mei"||$arr[1]=="May"){$bul="05";}
else if($arr[1]=="Juni"||$arr[1]=="June"){$bul="06";}
else if($arr[1]=="Juli"||$arr[1]=="July"){$bul="07";}
else if($arr[1]=="Agustus"||$arr[1]=="August"){$bul="08";}
else if($arr[1]=="September"){$bul="09";}
else if($arr[1]=="Oktober"||$arr[1]=="October"){$bul="10";}
else if($arr[1]=="November"){$bul="11";}
else if($arr[1]=="Nopember"){$bul="11";}
else if($arr[1]=="Desember"||$arr[1]=="December"){$bul="12";}
return "$arr[2]-$bul-$arr[0]";
}
?>

<?php
function BALP($tanggal){
$arr=split(" ",$tanggal);
if($arr[1]=="Jan"){$bul="01";}
else if($arr[1]=="Feb"){$bul="02";}
else if($arr[1]=="Mar"){$bul="03";}
else if($arr[1]=="Apr"){$bul="04";}
else if($arr[1]=="Mei"){$bul="05";}
else if($arr[1]=="Jun"){$bul="06";}
else if($arr[1]=="Jul"){$bul="07";}
else if($arr[1]=="Agu"){$bul="08";}
else if($arr[1]=="Sep"){$bul="09";}
else if($arr[1]=="Okt"){$bul="10";}
else if($arr[1]=="Nov"){$bul="11";}
else if($arr[1]=="Nop"){$bul="11";}
else if($arr[1]=="Des"){$bul="12";}
return "$arr[2]-$bul-$arr[0]";
}
?>

<?php
function process($conn,$sql){
$s=false;
$conn->autocommit(FALSE);
try {
$rs = $conn->query($sql);
if($rs){
$conn->commit();
$last_inserted_id = $conn->insert_id;
$affected_rows = $conn->affected_rows;
$s=true;
}
}
catch (Exception $e) {
echo 'fail: ' . $e->getMessage();
$conn->rollback();
}
$conn->autocommit(TRUE);
return $s;
}

function getJum($conn,$sql){

$rs=$conn->query($sql);
$jum= $rs->num_rows;
$rs->free();
return $jum;
}

function getField($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$d= $rs->fetch_assoc();
$rs->free();
return $d;
}

function getData2($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
//$arr = $rs->fetch_all(MYSQLI_ASSOC);
//$arr = mysqli_fetch_all($rs, MYSQLI_ASSOC);
$arr=$rs->fetch_assoc();
$rs->free();
return $arr;
}

/*
$arr=getData($conn,$sql);
$rs=$conn->query($sql);
while ($d = $rs->fetch_assoc()) {
//foreach($arr as $d) {

$arr=getData($conn,$sql2);
foreach($arr as $d) {
$id_request=$d["id_request"];

*/

function getData($conn,$sql){
$rs=$conn->query($sql);
$rs->data_seek(0);
$arr = $rs->fetch_all(MYSQLI_ASSOC);
//foreach($arr as $row) {
// echo $row['nama_kelas'] . '*<br>';
//}

$rs->free();
return $arr;
}
function getBot($conn,$kode){
$field="nama_pengguna";
$sql="SELECT `$field` FROM `tb_pengguna` where `id_bot`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assoc();
$rs->free();
return $row[$field];
}
function getAdmin($conn,$kode){
$field="username";
$sql="SELECT `$field` FROM `tb_admin` where `kode_admin`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assoc();
$rs->free();
return $row[$field];
}

function getPengguna($conn,$kode){
$field="nama_pengguna";
$sql="SELECT `$field` FROM `tb_pengguna` where `id_pengguna`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assoc();
$rs->free();
return $kode." - ". $row[$field];
}
function getRequest($conn,$kode){
$field="tanggal";
$sql="SELECT `$field` FROM `tb_request` where `id_request`='$kode'";
$rs=$conn->query($sql);
$rs->data_seek(0);
$row = $rs->fetch_assoc();
$rs->free();
return $kode." - ". $row[$field];
}
?>

Rabu, 13 November 2019

getData idwebhost000