SMS functionality to PHP website

Sayfuddin · 10-18-2012, 03:17 PM

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:

<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:

<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

alemcherry · 10-18-2012, 03:35 PM

Insert and Select are basic operations in MySQL and there is no more simple solution. Just make sure that whatever you are reading from database is deleted to avaoid it getting read again.

I am not aware of the gateway you mentioned or its API. Common sense says that the gateway would need your MySQL server, user, pass, database name to read it from your server. However, with most shared hosts, remote MySQL connection are not allowed. So check with your host before proceeding. An HTTP based API would be safer option.

tangoforce · 10-18-2012, 06:51 PM

Quote:

Originally Posted by alemcherry

Insert and Select are basic operations in MySQL and there is no more simple solution. Just make sure that whatever you are reading from database is deleted to avaoid it getting read again.

I am not aware of the gateway you mentioned or its API.

You are now! It's a spammer just like the other thread - also mentioning http://ozekisms.com/. It's someone dressing up an advert as a request for help in both threads.

Quote:

Originally Posted by alemcherry

Common sense says that the gateway would need your MySQL server, user, pass, database name to read it from your server.

No, all the gateway needs is a url to a script on your server / account where you can handle the response / insert it into a DB. Why would you think they need direct access to the database themselves?