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];
}
?>
