Viewing file:  sendsms.php (3.22 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
include('session.php');
?>
<?php
// Get the search variable from URL
$var = @$_GET['ID'] ;
$trimmed = trim($var); //trim whitespace from the stored variable
// rows to return
$limit=1;
// check for an empty string and display a message.
if ($trimmed == "")
{
exit;
}
// check for a search parameter
if (!isset($var))
{
echo "<p>We dont seem to have a search parameter!</p>";
exit;
}
mysql_connect("localhost","anshdiam_user","rb!ans838"); //(host, username, password)
//specify database ** EDIT REQUIRED HERE **
mysql_select_db("anshdiam_sarkmicr_data") or die("Unable to select database"); //select which database we're using
// Build SQL Query
$query = "select * from dd where accountno=\"$trimmed\"
order by id DESC"; // EDIT HERE and specify your table and field names for the SQL query
$numresults=mysql_query($query);
$numrows=mysql_num_rows($numresults);
// If we have no results, offer a google search as an alternative
if ($numrows == 0)
{
echo " Sorry, $trimmed this Number is not found";
}
// next determine if s has been passed to script, if not use 0
if (empty($s)) {
$s=0;
}
// get results
$query .= " limit $s,$limit";
$result = mysql_query($query) or die("Couldn't execute query");
// begin to show results set
$count = 1 + $s ;
// now you can display the results returned
while ($row= mysql_fetch_array($result))
{
$sr=$sr+1;
$acccountno=$row[accountno];
$phoones=$row[phone];
$balance=$row[loanamount];
$cname=$row[cname];
echo "</table>";
$count++ ;
}
$currPage = (($s/$limit) + 1);
//break before paging
echo "";
// next we need to do the links to other results
if ($s>=1) { // bypass PREV link if s is 0
$prevs=($s-$limit);
print "<a href=\"$PHP_SELF?s=$prevs&q=$var\"><<
Prev 10</a> ";
}
// calculate number of pages needing links
$pages=intval($numrows/$limit);
// $pages now contains int of pages needed unless there is a remainder from division
?>
<?php
$users = "ANSHDIAMOND";
$pass = "ansh";
$mob ='91'.$phoones;
// Can come from a database
$msg = "Dear%20$cname%20Your%20Account%20$acccountno%20balance%20is%20$balance%20(ANSH%20DIAMOUND%20GROUP)";
$url = "http://103.10.234.154/vendorsms/pushsms.aspx?user=$users&password=$pass&msisdn=$mob&sid=ANSHNI&msg=$msg&fl=0&gwid=2";
$xml = file_get_contents($url);
$getUrl = "http://103.10.234.154/vendorsms/pushsms.aspx?user=$users&password=$pass&msisdn=$mob&sid=ANSHNI&msg=$msg&fl=0&gwid=2";
$curl = curl_init();
curl_setopt($curl, CURLOPT_URL, $getUrl);
curl_setopt($curl, CURLOPT_HTTPHEADER, array('Accept: application/json'));
curl_setopt($curl, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
curl_setopt($curl, CURLOPT_USERPWD, $user . ":" . $pass);
curl_setopt($curl, CURLOPT_HTTPGET, TRUE);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, 1);
$response = curl_exec($curl);
$httpCode = curl_getinfo($curl, CURLINFO_HTTP_CODE);
$responseBody = json_decode($response);
curl_close($curl);
?>
<table width="500" border="0" cellspacing="1" cellpadding="1">
<td>Message Successfully Send To Client.</td>
<td><form action="">
<input type="button" value="BACK" onClick="window.location.href='ddaccountlist.php';"/>
</form> </td>
<td> </td>
</tr>
</table>
|