<?php
if ($_POST) {
require_once 'lib/lib-cli.php';
$security = new Security();
$dbase = new dbase();
$number = $security->StringFiltrate($_POST['number']);
$text = $security->StringFiltrate($_POST['text']);
$time = Date('H') . " : " . Date('i') . " : " . Date('s');
if (strlen($number) > 0 && strlen($text) > 0) {
if ($con = $dbase->connect_database()) {
if ($db = $dbase->select_db($con)) {
if ($dbase->query("insert into tews_send_gsm_log(command,receiver,month,day,year,time,marks) values('" . $text . "','" . $number . "','" . Date('m') . "','" . Date('d') . "','" . Date('Y') . "','" . $time . "','saved')")) {
header("location: lgu_control.php");
$dbase->close();
} else {
$dbase->close();
echo "cant save!";
}
} else {
$dbase->close();
echo "cant select/found database";
}
} else {
$dbase->close();
echo "cant connect to server";
}
//die("<script type='text/javascript'> window.location = 'lgu_control.php'; </script>");
} else {
header("location: lgu_control.php?err=no data found!");
}
<?php
require_once '../inc/config.php';
$objDbase = new dbase();
$objMember = new Member();
$members = $objMember->getMembers();
foreach ($members as $member) {
$entity = $objMember->generateURLentity($member['name']);
$sql = "UPDATE `members` SET `entity` = '" . $entity . "' WHERE `id` = " . $member['id'];
$objDbase->query($sql);
}
