function getActiveSubscriber($msisdn) { $data = R::find('users', 'mobile_number = :num', array('num' => appendCountryCode($msisdn))); return $data; }
$connect = mysql_connect($server, $username, $password); $database = mysql_select_db($database); $group = 10; $today = strtotime(date('d-M-Y')); $now = strtotime(date('d-m-Y H:i')); //$subscribers = R::getAll('select mobile_number from users where subscription_period >= :today and group_id = :group', array(':today' => $today, ':group' => 10)); //$tip = R::find('tip', ' schedule_time = :date', array('date' => $date)); $query2 = "select * from tip where schedule_time <= '" . $now . "' and processed != 1"; $result2 = mysql_query($query2) or die(mysql_error()); //$tip = mysql_fetch_array($result2); //var_dump($tip[2]); exit; while ($tip = mysql_fetch_array($result2)) { $query = "select * from subscription where expire_date >= '" . $today . "' and category_id = '" . $tip['category_id'] . "'"; $result = mysql_query($query) or die(mysql_error()); while ($subscribers = mysql_fetch_array($result)) { echo appendCountryCode($subscribers['user_phone']); echo '<br/>'; echo $tip['gist']; echo '<br/>'; //smsSender(appendCountryCode($subscribers['user_phone']), $tip['gist']); } $query3 = "update tip set processed = 1 where id = '" . $tip['id'] . "'"; $result3 = mysql_query($query3) or die(mysql_error()); } //echo $count; function checkDestination($number) { $first = substr($number, 0, 1); if ($first == '+') { return $number; } else {
#$database = 'm_health'; #local $server = 'localhost'; $username = '******'; $password = '******'; $database = 'mhealth'; $connect = mysql_connect($server, $username, $password); $database = mysql_select_db($database); $now = date("Y-m-d h:i:s"); //echo $now; $sql = "SELECT * FROM medication m join users u where m.users_id = u.id and m.end_date < '{$now}'"; $result = mysql_query($sql) or die(mysql_error()); while ($data = mysql_fetch_array($result)) { $msg = ""; //smsSender(appendCountryCode($data['mobile_number']), $msg); echo appendCountryCode($data['mobile_number']) . "<br>"; } function smsSender($dnrr, $msg) { $id = "m_health"; $pw = "WKYoDDoCV"; # ensure that you use the approved password on v2nmobile. $url = "http://v2nportal.com/sms/gateway/httpsend.php?U=" . urlencode($id) . "&P=" . urlencode($pw) . "&D=" . urlencode($dnrr) . "&S=" . urlencode("+35123") . "&M=" . urlencode($msg) . "&T=1"; /* invocation of URL */ if ($f = @fopen($url, "r")) { $answer = fgets($f, 255); //echo "<br>answer=$answer"; # remove this if you like return $answer; } else { return "gateway cannot be opened at the moment"; //return false;