Page 1 of 1

SMS functionality to PHP website

Posted: Wed Oct 17, 2012 8:09 am
by Sayfuddin
Hi! I want to create a PHP site with added SMS functionality (dating services site). I was suggested a gateway to use as the engine (google: ozekisms.com/index.php?owpn=422). I will use Mysql database to puit the records in it.

As the documentation mentions PHP website can send SMS messages by simply placing records into a mysql database table called ozekimessageout. So I can create HTML form, that the visitors of the website will fill in. When the form is submitted I am able to create record in the ozekimessagout database table using an SQL INSERT statement. See example:

Code: Select all

<HTML>
<BODY>

<H1> Send an SMS </H1>

<?php
$phonenum = $_GET['phonenum'];
$messagetext = $_GET['messagetext'];

if ($phonenum<>'') {

  $conn = mysql_connect("localhost", 'ozeki', 'abc123');
  if (!$conn) {
    die('Could not connect to database ' . mysql_error());
  }

  mysql_select_db('ozekisms');
  $sql = "INSERT INTO ozekimessageout (receiver,msg,status) ".
         "VALUES ('$phonenum','$messagetext','send')";
  mysql_query($sql);
  mysql_close($conn);

  echo "The message has been submitted for sending <br><br>";
}
?>

<FORM action=send.php METHOD=GET>
  Mobil phone number:
  <INPUT TYPE="TEXT" SIZE="16" NAME="phonenum" VALUE="+44777888999">
  <br>
  <TEXTAREA NAME="messagetext" ROWS=5 COLS=40>Hello world</TEXTAREA>
  <br>
  <INPUT TYPE=SUBMIT VALUE=SEND>
</FORM>

</BODY>
</HTML>
To receive SMS messages all Ihave to do is select the records from the ozekimessagin database table. This can be done by issuing a simple SQL SELECT statement.

Code: Select all

<HTML>
<BODY>

<H1>List incoming messages</H1>

<?php
  $conn = mysql_connect("localhost", 'ozeki', 'abc123');
  mysql_select_db('ozekisms');
  $sql = "SELECT sender,senttime,msg FROM ozekimessagein ORDER BY senttime desc";
  $res = mysql_query($sql);
  $cn = mysql_num_rows($res);

  for ($x=0;$x<$cn;$x++) {
     list ($sender,$senttime,$msg) = mysql_fetch_row($res);
     echo "<li>$senttime, <b>$sender</b>, $msg";
  }

  mysql_close($conn);
?>

</BODY>
</HTML>
Maybe you can get some useful idea from this description and if you have better solutions to insert or select records into Mysql database, please share with me.

TX
Boris