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