asterisk 操作mysql DAILPLAN
[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})
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)
发表评论