Example PHP Code
Please feel free to copy this code and use it as you please. You can also download the appropriate files here:
Create MySQL Database to store the data
MySQL Class - Manages the connection and actions on the database
Inbound Action - Script which is actioned
Inbound View - View inbound SMS
//include the database handling class
include("mysqlclass.php");
//Assign POSTED variables
$destination = $_POST['gwNumber'];
$originator = $_POST['originator'];
$message = $_POST['message'];
$smsTime = $_POST['smsTime'];
$timeZone = $_POST['timeZone'];
$network = $_POST['network'];
$id = $_POST['id'];
$status = $_POST['status'];
//Create a new instance of the mysql class and write data to database
$mysql = New mysql(0);
$sql = "
INSERT INTO
inbound
(varOriginator, varDestination, varMessage, dtTime, varUnixTime, varUDH, intId)
VALUES
('$originator', '$destination', '$message', '$time', '$unixTime', '$udh', '$id')";
$mysql->query($sql);