Latar Jembar

Website ini merupakan sarana untuk mengekspresikan apa yang saya pikirkan daripada ngruntel/nggedibal di otak, jadi lebih baik saya menuangkan disini

PHP Script Simpan Inbox WAGW

PHP Script Simpan Inbox WAGW

Contoh script simpan inbox WAGW menggunakan PHP

Contoh script simpan inbox WAGW menggunakan PHP

<?php
ini_set('default_charset', 'UTF-8');
require_once('../include/database.config.php');

$method = $_SERVER['REQUEST_METHOD'];

if($method == 'GET'){
$from = $_REQUEST['from'];
$tanggal = $_REQUEST['tanggal'];
$pengirim = $_REQUEST['pengirim'];
$pengirim =  str_replace('pkiqf','+',$pengirim);
$pesan = utf8_encode($_REQUEST['pesan']);

$sql = "INSERT INTO jbssms.inbox (UpdatedInDB,ReceivingDateTime,Text,RecipientID,SenderNumber,Coding,Status)
SELECT * FROM (SELECT N'" . $tanggal . " as UpdatedInDB', N'" . $tanggal . " as ReceivingDateTime', N'" . $pesan . "', '" . $from . "', N'" . $pengirim . "', '8bit', '0') AS tmp
WHERE NOT EXISTS (SELECT * FROM jbssms.inbox WHERE Text='" . $pesan . "' AND SenderNumber='" . $pengirim . "' AND ReceivingDateTime='" . $tanggal . "')";

mysql_query($sql);
}
else
{
echo "Method not allowed";
}
?>

Post a Comment