Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    New to the CF scene
    Join Date
    Oct 2012
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    SMS functionality to PHP website

    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

  • #2
    New Coder
    Join Date
    Apr 2010
    Posts
    55
    Thanks
    0
    Thanked 4 Times in 4 Posts
    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.
    Hosting Reviews and Discounts: Bluehost Coupon and Hostmonster Coupon

  • #3
    Senior Coder
    Join Date
    Feb 2011
    Location
    Your Monitor
    Posts
    4,091
    Thanks
    51
    Thanked 506 Times in 493 Posts
    Quote Originally Posted by alemcherry View Post
    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 View Post
    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?
    My helpful sig is on vacation trying to loose some weight. It got a bit fat and caused a few problems but it will be back at some point!


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •