# Execute MS SQL stored procedure upon DTMF selection, PHPAGI

**URL:** <https://community.asterisk.org/t/execute-ms-sql-stored-procedure-upon-dtmf-selection-phpagi/46741>\
**Category:** Asterisk Support\
**Created:** [July 24, 2014, 1:10pm UTC](https://community.asterisk.org/t/execute-ms-sql-stored-procedure-upon-dtmf-selection-phpagi/46741 "2014-07-24T13:10:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![jeet](https://avatars.discourse-cdn.com/v4/letter/j/ad7895/32.png) [@jeet](https://community.asterisk.org/u/jeet)\
**Post date:** [July 24, 2014, 1:10pm UTC](https://community.asterisk.org/t/execute-ms-sql-stored-procedure-upon-dtmf-selection-phpagi/46741/1 "2014-07-24T13:10:55Z")

</div>

Hi,

This is my 3rd attempt here at this forum, hope someone finds this reasonable 😄

I am trying to run a stored procedure from ms sql server after user dtmf tone in PHPAGI, however it seems that the SP is never triggered. Any ideas or suggestions would be highly appreciated. Thanks

Required:

```auto
$press1 = $agi->get_data('please-select-menu',300, 1);
$press1dtmf = $press1['result'];
if ($press1dtmf=="1"){
//run ms sql stored procedure;  
$agi->stream_file('thank-you');
$agi->hangup();
}
```

Tried & Not Working Method:

```auto
$press1 = $agi->get_data('please-select-menu',300, 1);
$press1dtmf = $press1['result'];
if ($press1dtmf=="1"){
$sql_statement = mssql_init("sp_name '$value1' ,'$value2', '$value3'", $conn);
$result=mssql_execute($sql_statement);
mssql_free_statement($sql_statement);
$agi->stream_file('thank-you');
$agi->hangup();
}
```

---

<div class="post-metadata">

**Author:** ![jeet](https://avatars.discourse-cdn.com/v4/letter/j/ad7895/32.png) [@jeet](https://community.asterisk.org/u/jeet)\
**Post date:** [July 30, 2014, 11:59am UTC](https://community.asterisk.org/t/execute-ms-sql-stored-procedure-upon-dtmf-selection-phpagi/46741/2 "2014-07-30T11:59:07Z")

</div>

added `mssql_free_result($result);` to the code and everything worked out. just thought of posting the ans, so that it might help someone in future.

---

<div class="post-metadata">

**Author:** ![s.khan](https://avatars.discourse-cdn.com/v4/letter/s/db5fbb/32.png) [@s.khan](https://community.asterisk.org/u/s.khan)\
**Post date:** [July 30, 2014, 1:36pm UTC](https://community.asterisk.org/t/execute-ms-sql-stored-procedure-upon-dtmf-selection-phpagi/46741/3 "2014-07-30T13:36:22Z")

</div>

Thanks jeet,

i appreciate it

sohaib khan