<?php

error_reporting(0);

// ==== BEGIN / variabel must be adjusted ====

$token = "bot"."812244953:AAE7l_x_WbmDKuNW13VozE6zrMQj0clgtAc";
$proxy = "";
$mysqli_host = "localhost";
$mysqli_user = "root";
$mysqli_pass = "";
$mysqli_dbname = "rikep_provisioning";

// ==== END / variabel must be adjusted ====


$conn = mysqli_connect($mysqli_host, $mysqli_user, $mysqli_pass, $mysqli_dbname);
if(! $conn ) {
  die('Could not connect: ' . mysqli_error());
}

//$db_selected = mysqli_select_db($mysqli_dbname, $conn);
//if (!$db_selected) {
//  die ('Can\'t use foo : ' . mysqli_error() .'<br>');
//}


$updates = file_get_contents("php://input");

$updates = json_decode($updates,true);
$pesan = $updates[message][text];
$chat_id = $updates[message][chat][id];

$pesan = strtoupper($pesan);
if(strpos($pesan,"AFTAR.")>0){
	$datas = explode(".", $pesan);
	$nama = $datas[1];
	$alamat = $datas[2];
	$hp = $datas[3];
	if(mysqli_query($conn,"insert into data_telegram values ('$nama','$alamat','$hp', now())")) {
		$pesan_balik = "Terima kasih Data Anda sudah kami simpan.";
	}
	else $pesan_balik = "Data gagal disimpan silahkan coba lagi";
}
elseif($pesan = "cek") {
	$data = mysqli_query($conn,"select count(*) as jumlah from data_telegram");
	while($d = mysqli_fetch_array($data)){
		$pesan_balik = "Total data minggu ini = ".$d['jumlah']." data";
	}
}else $pesan_balik = "Mohon maaf format yang Anda kirim salah, silahkan kirim ulang dengan Format DAFTAR.NAMA.ALAMAT.NOHP Contoh Daftar.Monster Mahoni.Jalan Anggrek No 1 Jakarta.2308581234567 . Jika ingin cek data, kirim pesan 'cek'";

$url = "https://api.telegram.org/$token/sendMessage?parse_mode=markdown&chat_id=$chat_id&text=$pesan_balik";

$ch = curl_init();

if($proxy==""){
	$optArray = array(
		CURLOPT_URL => $url,
		CURLOPT_RETURNTRANSFER => true,
		CURLOPT_CAINFO => "C:\cacert.pem"
	);
}
else{
	$optArray = array(
		CURLOPT_URL => $url,
		CURLOPT_RETURNTRANSFER => true,
		CURLOPT_PROXY => "$proxy",
		CURLOPT_CAINFO => "C:\cacert.pem"
	);
}

curl_setopt_array($ch, $optArray);
$result = curl_exec($ch);

$err = curl_error($ch);
curl_close($ch);

if($err<>"") echo "Error: $err";
else echo "Pesan Terkirim";

?>