[dba-Tech] Send SMS From Mobile Into MS Access Or SQL Database

Paul Hartland paul.hartland at googlemail.com
Fri Feb 14 00:57:35 CST 2014


Yeah was afraid of that thank you, will have to look into the additional
costs then, but could still be more cost effective than some other
companies offering a similar service for clients.

Paul


On 14 February 2014 06:08, Peter Brawley <peter.brawley at earthlink.net>wrote:

> On 2014-02-13 10:55 PM, Paul Hartland wrote:
>
>> To all,
>>
>> I am working on a little project, which if works has potential to become
>> quite big.  This however involves a learning curve for me in developing
>> applications for mobile phones but I am sure I can get to grips with this.
>>   The way I see this working is that the user will enter a code and
>> message
>> on the phone application (or even just send it as an SMS which saves me
>> the
>> mobile application piece) and press send and this message will be stored
>> in
>> a MS Access or SQL Database, the part I can't see is how the message will
>> get from the phone application into the database, I can't seem to see a
>> way
>> of avoiding a third party software.  I envisaged the application to send
>> the message as an SMS and appear in an email, where my server side
>> application would scan for new emails, then if found would write some of
>> the contents to the database.
>>
>> Is this possible to achieve without a third party software solution,
>> bearing in mind that the phones sending the SMS could have a variety of
>> providers as in O2, Vodafone, T-Mobile etc etc.
>>
>> Thanks in advance for any help on this.
>>
>
> Once you have an SMS Gateway, you can retrieve messages with PHP and save
> them to a MySQL DB (for example) with standard mysqli API calls. AFAIK
> there's no avoiding the need for the gateway.
>
> PB
>
> ----
>
>>
>>
> _______________________________________________
> dba-Tech mailing list
> dba-Tech at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-tech
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com


More information about the dba-Tech mailing list