Re: send SMS php coding
Posted: Tue Jul 07, 2015 7:58 am
Not sure what we're looking for exactly. I wouldn't define that function inside a conditional. Are you encountering any specific errors?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
$response = sendSMS('47799', '692px', '447538503276', 'test message', 'test message 1');
var_dump($response);No output at all? That means it's not even executing.ianhaney wrote:that just displays SUCCESS from the MySQL connection
Code: Select all
<?php
function sendSMS($username, $password, $mobnumber, $message, $originator) {
$URL = 'http://api.textmarketer.co.uk/gateway/'."?username=$username&password=$password&option=xml";
$URL .= "&to=$to&message=".urlencode($message).'&orig='.urlencode($originator);
$fp = fopen($URL, 'r');
return fread($fp, 1024);
}
$db = mysqli_connect("" , "", "") or die("Check connection parameters!");
// Optionally skip select_db and use: mysqli_connect(host,user,pass,dbname)
mysqli_select_db($db,"") or die(mysqli_error($db));
if (mysqli_connect_error()) {
die ('Failed to connect to MySQL');
}
// You don't need a success message; it will tell you if it fails.
$sqlCommand = "SELECT
u.id
, name
, mobnumber
, item.description
, renewal_id
, DATE_FORMAT(renewal_date, '%e %M %Y') as datedue
, renewal_date
FROM users u
INNER JOIN renewal USING (id)
INNER JOIN item USING (item_id)
WHERE renewal_date BETWEEN CURDATE() AND CURDATE()+INTERVAL 14 DAY
AND IFNULL(date_notified, '1901-01-01') < CURDATE()-INTERVAL 14 DAY
UNION
SELECT
u.id
, name
, mobnumber
, item.description
, renewal_id
, DATE_FORMAT(renewal_date, '%e %M %Y') as datedue
, renewal_date
FROM users u
INNER JOIN renewal USING (id)
INNER JOIN item USING (item_id)
WHERE renewal_date BETWEEN CURDATE() AND CURDATE()+INTERVAL 7 DAY
AND IFNULL(date_notified, '1901-01-01') < CURDATE()-INTERVAL 7 DAY
ORDER BY id, renewal_date";
$query = mysqli_query($db, $sqlCommand) or die (mysqli_error($db));
//fetch the data from the database
while ($row = mysqli_fetch_array($query)) {
$originator = 'Tax Elephants';
$mobnumber = $row['mobnumber'];
$name = $row['name'];
$message = $name."Name:".$row['name'].$row['description'].$row['datedue'];
$response = sendSMS('username', 'password', $row["mobnumber"], "{$row["description"]} expiry date: {$row["datedue"]}", $originator);
var_dump($response); exit;
}
Code: Select all
<?php
function sendSMS($username, $password, $mobnumber, $message, $originator) {
$URL = 'http://api.textmarketer.co.uk/gateway/'."?username=$username&password=$password&option=xml";
$URL .= "&to=$to&message=".urlencode($message).'&orig='.urlencode($originator);
$fp = fopen($URL, 'r');
return fread($fp, 1024);
}
$response = sendSMS('put', 'real', 'values', 'here', 'please');
var_dump($response);Code: Select all
<?php
function sendSMS($username, $password, $mobnumber, $message, $originator) {
$URL = 'http://api.textmarketer.co.uk/gateway/'."?username=$username&password=$password&option=xml";
$URL .= "&to=$to&message=".urlencode($message).'&orig='.urlencode($originator);
$fp = fopen($URL, 'r');
return fread($fp, 1024);
}
$response = sendSMS('47799', '692px', '447538503276', 'expiry date:', '10th July 2015');
var_dump($response);Code: Select all
$response = sendSMS('47799', '692px', '447538503276', 'expiry date: 10th July 2015', '4420812345678');
var_dump($response);