Posts tagged sms

Equipment Room SMS Rental System

In the first step of many, I have a basic SMS rental system functioning. To test the system text the following to 41-411: itper checkout A1534 This follows the syntax required by the TextMarks.com service of using the 41411 shortcode for their system, followed by my registered keyword “itper” followed by an internal keyword (either “checkout” or “return” and finally the serial number identifying the equipment you are checking out.

How does this work?

The TextMarks.com service allows a text sent by anyone with the above syntax to ping a custom PHP page I’ve coded. The custom page records the sender’s phone number, text message, and timestamps the record as well. Then the script can recognize whether or not you’ve entered “checkout” or “return” and it sends a confirmation back to the sender.

How to make it better?

I’m going to continue developing this system to improve my PHP and mySQL skills. As a result of texting the “checkout” or “return” commands I would like a record in a separate database table to keep track of who has each piece of equipment checked out, as well as when it is due back. The due back date should then be sent with the confirmation after a ITP student checks out a piece of equipment.

ITP-centric SMS-based Application

Charged with creating an SMS-based system to benefit the ITP community, I would have to suggest an SMS-enabled check-in/check-out system for equipment room rentals. Too many times a single person working the ER is overwhelmed by an onslaught of fellow ITP’ers. This system would reduce the ER-worker’s job to retrieving the items from the shelves. Then, the student checking out the item would send an SMS text to a defined short code with the item’s identification number in the body of the text. The text would hit the ER system and know what student checked out what item. Additionally, the system could then SMS back with a confirmation and the “due back” date.