asterisk 操作mysql

[globals]
DBCurrentHost=localhost
DBuser=root
DBpass=passw0rd
DBname=asterisk

[sip]
exten => _X.,1,Set(CALLERID(num)=58837999)
exten => _X.,n,MySql(connect connid ${DBCurrentHost} ${DBuser} ${DBpass} ${DBname})    ;连接mysql 操作
exten => _X.,n,set(ID=12)
exten => _X.,n,MySql(query resultid ${connid} insert   into  jd  set  id=14\, name =\'ppp\') ; //进行查询  
exten => _X.,n,MySql(query resultidr ${connid} select name from jd where id=${ID}) ; //进行查询  
exten => _X.,n,MySql(Fetch foundrow ${resultidr} name)              ;//读取
exten => _X.,n,MySql(clear ${resultidr})  ;//清除什么什么东东  
exten => _X.,n,MySql(disconnect ${connid}) ; //关闭连接 
exten => _X.,n,noop(${name})
exten => _X.,n,Queue(sipqueue,t,,,150)
exten => _X.,n,hangup

exten => 3000,1,SetMusicOnHold(default)
exten => 3000,n,WaitMusicOnHold(20)

转载于:https://www.cnblogs.com/5dteam/articles/2059943.html