Connecting to the database

[David]

Hi There, David here I wonder if its possible to access the database directly in order to feed information to other systems dynamically. this would be a read only access.

Bests,

[Alex Anderson]

Hi David,

This is most easily achieved by using MySQL as FrontlineSMS's database engine. This can be activated via Settings -> Database Settings in FrontlineSMS. You will also need to have access to a MySQL database. If you need more info on how to do this, I'm sure we can help.

Cheers,

Alex

[Gyasi A]

Could you please help me with connecting to a MySQL database.
I am using WAMP 2.2 with the Apache server and want to connect to the localhost sql database

[Anthony Papillion]

Gysai:

What are you wanting to do specifically? Are you just wanting to take the data you receive via text and insert it into the MySQL database and maybe do some processing and queries against the db and send it back via SMS? If so, that is super easy to do via external commands.

You've already got all of the necessary pieces in place with your WAMP environment. Just feed the information to an external PHP or Perl script that will take it as a standard HTTP request, process it like you would any other HTTP request, and then pipe your data back to the user.

If you're just wanting to stick results in the database, that's even easier.

Hope this helps. If you need help, feel free to contact me and I'll do my best.

Anthony

[Gyasi A]

I used the HTTP request method.

Thanks

[madan]

hi sir.

im using flsms external commands and i have doubt in it.i want to send the msg from mobile to flsms which inturn should be stored in my database.how i have to do this.


regards
madan

[Atul Rawat]

Hello Anthony Papillion,

             Sir, plz can you provide me the php script to connect, query & send sms back to user....  i'll be very grateful to you....

E-mail: [e-mail]

Thanks in advance....