Asterisk + create new app + conncet mysql


#1

i make one application in asterisk, there is i make successfully that app.
But in that app i want to get data from MySQL and put some data on it.
So for that i have done with INSERT, UPDATE & DELETE Query.
But i facing issues in SELECT Query.
So please guide me how to fetch data for single row and how’s for multiple rows?


#2

By “create new app” do you mean you wrote a C module for a dialplan application? If so then you’d need to use the MySQL client library to do things, or use the res_odbc support.


#3

By “create new app” do you mean you wrote a C module for a dialplan application?
yes
use the res_odbc support
i use this, for referance but there is not get much for this
If you have any referance then please let me know how to use select query


#4

There is no guide or anything towards using it, the easiest option is to find a module that does what you need to do, look at it, understand what it is doing, and use a similar implementation.


#5

Thanks @jcolp for your reply.
I also use that way also but i didn’t get , so that’s why i posted here.
If any one knows please help me


#6

You might want to join the Asterisk-Dev list and ask your development questions there, I think it’s outside the scope of this forum.

http://lists.digium.com/mailman/listinfo/asterisk-dev