public function receiveMessages($text, $phone) { $dbOps = new DBOperations(); $con = new mysqli($dbOps->servername, $dbOps->username, $dbOps->password, $dbOps->dbname); //create the db connection if ($con->connect_error) { die("connection failed: " . $con->connect_error); } else { $validMessages = 0; $invalidMessages = 0; $message = DBOperations::filterMessageDetails($text); if ($message != null) { $validMessages++; DBOperations::sendMessageDetails($message); } else { $invalidMessages++; $query = "INSERT INTO invalid_messages(phone_number, message) VALUES ('" . $phone . "', '" . $text . "')"; if ($con->connect_error) { die("connection failed: " . $con->connect_error); } else { if ($con->query($query) === TRUE) { $returnMessage = "Your request was invalid!"; Communication::sendMessage($returnMessage, $phone); } else { echo "receiveMessages: " . $con->error; echo "<script> alert(\"Message did not sent\") </script>"; } } } $receiveMessages = array("valid" => $validMessages, "invalid" => $invalidMessages); } mysqli_close($con); }
<label id="received_message">Received Message: </label> <textarea name="received_message" rows="4" cols="15"></textarea> <input type="submit" name="dbOps" value="read message"> <br/><br/> <label id="to">to: </label> <input type="text" name="number" maxlength="10"></input><br/> <label id="write_message">Write Message: </label> <textarea name="send_message" rows="4" cols="15"></textarea> <input type="submit" name="send" value="send message"> <br/><br/> <input type="submit" name="receive" value="Read Receive Messages"> </form><br/> </body> </html> <?php include_once 'messageDB.php'; include_once 'communication.php'; if (!empty($_POST['received_message']) && $_POST['dbOps'] == "read message") { $filterMessage = DBOperations::filterMessageDetails($_POST['received_message']); DBOperations::sendMessageDetails($filterMessage); } if (!empty($_POST['number']) && !empty($_POST['send_message']) && $_POST['send'] == "send message") { $mobileNumber = Communication::prepareNumber($_POST['number']); Communication::sendMessage($_POST['send_message'], $mobileNumber); } //DBOperations::receiveMessages("hgsr hjk", "94713535362"); //Supplier request message DBOperations::displayMessageTable(); //DBOperations::receiveTicketMachine("0001 20", "94713535362"); //ticket machine message