Asterisk Readout Values From a Database

Asterisk Asterisk Support
1

Hi everyone,

I am attempting to create a simple asterisk dialplan application that reads the values from a MySQL database whenever a user calls a certain extension.

Type[color=#FFFFFF]…[/color]Number

H[color=#FFFFFF]..........[/color]10
S[color=#FFFFFF]..........[/color]60
P[color=#FFFFFF]..........[/color]40 
G[color=#FFFFFF]..........[/color]15

So basically, whenever someone calls, asterisk should readout H 10, S 60, P 40, G 15…
Here’s what I have so far:

[code];Answer call
exten => 123,1,Answer()

;Readout results to caller

;hangup
exten => 123,3,Hangup()[/code]

Any help would be appreciated.

2

asteriskdocs.org/en/3rd_Edit … sk-DB.html

3

Hi David, I am aware of the use of ODBC and the AGI, however I am not sure how I will implement the code. Any further thoughts?

4

If you need to buy consultancy, you should use the Biz and Jobs forum.