Send SMS from MySQL (part 4/4)
Send Test Message

This is the last video in this video series which shows how to connect Ozeki SMS Gateway and MySQL database server for SMS messaging. See how to insert a simple row into the proper table, so Ozeki SMS Gateway can automatically send SMS messages to mobile phones.

Video content
1. Insert message into database
2. Send test message

Video 1 - How to insert a simple row into the proper table (Video tutorial)

Look at the upcoming screenshots to thoroughly examine the final stage, which is SMS sending. You can start the whole process by INSERT-ing the SMS into the database.

open database user
Figure 1 - Open Database user

insert message to the database table
Figure 2 - Insert message to the database table

INSERT message record (example): 
USE ozeki
INSERT INTO ozekimessageout (receiver,msg,status) values ("+44111223465","Hello world","Send");
GO
Figure 3 - Copy INSERT statement

the database users sent folder shows that your message has been sent
Figure 4 - The Database User's sent folder shows that your message has been sent by Ozeki SMS Gateway

More information