Run MySQL query from Asterisk Dialplan and get values

[MySQL]
exten => 1234,1,Answer()
exten => 1234,n,NoOp(${CALLERID(num)})
exten => 1234,n,Read(caller,,10)
exten => 1234,n,Set(CID=${CALLERID(num)})
exten => 1234,n,NoOp(${caller})
exten => 1234,n,Set(userCID=${caller})
exten => 1234,n,MYSQL(Connect connid YOUR_IP username pwd Database_name)
exten => 1234,n,MYSQL(Query resultid ${connid} select * from customer where caller='${userCID}')
exten => 1234,n,MYSQL(Fetch fetchid ${resultid} id name)
exten => 1234,n,SayAlpha(${name})
exten => 1234,n,Saydigits(${id})
exten => 1234,n,MYSQL(Clear ${resultid})
exten => 1234,n,MYSQL(Disconnect ${connid})
exten => 1234,n,Playback(vm-goodbye)

Tested on Asterisk 11.22

Comments

Popular posts from this blog