event.php

<?php


$ghost = 'xx.xx.xx.xx';
$guser = 'xxxxxxxx';
$gpwd = 'xxxxxxx';
$gdbname = 'xxxxxxxx';

$db = mysql_connect($ghost, $guser, $gpwd) or die("Could not connect: " . mysql_error());
mysql_select_db ($gdbname, $db) or die (mysql_error($db));

function bridge_events($ecode, $data, $server, $port){
                print_r($data);
                $datanow = Date('Y-m-d H-i-s');

                $bridgeState = $data["Bridgestate"];
                $callerId = $data["CallerID1"];
                $calleeId = $data["CallerID2"];
                /*if($bridgeState == "Link"){
                        $sql = "SELECT *
                                FROM `max_taxi_inccall`
                                WHERE `status` = 0
                                AND `caller_phone_num`
                                LIKE '8951995897'
                                ORDER BY `max_taxi_inccall`.`id` DESC
                                LIMIT 1";
                        $sqlresult =    mysql_query($sql) or die(mysql_error());
                        $row = mysql_fetch_array($sqlresult);
                        $callerPhoneNum = $row['caller_phone_num'];
                        $id = $row["id"];
                        echo $callerPhoneNum."\n";

                        $sql =  "UPDATE `max_taxi_inccall`
                                SET `sip_conn_oper` = '$calleeId'
                                WHERE '$callerId' = '$callerPhoneNum'
                                AND `id` = $id";
                        echo $sql;
                        $result = mysql_query($sql);
                }*/
}

function dump_events($ecode,$data,$server,$port) {
                //print_r($data);
                                                                                                                                                      1,1           Top

/*INSERT INTO `test`.`max_taxi_inccall`
                                ( `id` , `date_call`, `sip_conn_oper`, `caller_phone_num` , `sip_system_id`)
                                VALUES ( NULL , '2014-07-25 15:22:07', '300', 0, 'SIP/300-00004e80' );PHP Notice:  Undefined
*/


                $CallerIDNum = $data["CallerIDNum"];
//              $CallerIDNum = str_replace('99810','', $CallerIDNum);
                $Channel        =       $data['Channel'];
                echo $sql =     "INSERT INTO `test`.`max_taxi_inccall`
                                ( `id` , `date_call`, `sip_conn_oper`, `caller_phone_num` , `sip_system_id`)
                                VALUES ( NULL , '$datenow', '$CallerIDNum', 0, '$Channel' );";
                if( ($CallerIDNum!= "") AND (strlen($CallerIDNum)>3) )
                        $res = mysql_query($sql);
                print($res);
}

function hangup_handler($ecode, $data, $server, $port){
                //print_r($data);
                $datanow = Date('Y-m-d H:i:s');
                $sipID = $data["Channel"];

                echo $sql =     "UPDATE `test`.`max_taxi_inccall`
                                SET `status` = '1'
                                WHERE `sip_id` = '$sipID'
                                AND
                                `status` = '0'";
                $res = mysql_query($sql);
                 if(mysql_error()){
                        print "Success!!!\n";
                }else
                        print(mysql_error());
                print($res);


}

         include('phpagi/phpagi.php');

        $manager = new AGI_AsteriskManager();

        $manager->connect("127.0.0.1:5038", "newmax", "newmaxpassword");

        $manager->add_event_handler('newchannel','dump_events');
        //$manager->add_event_handler('hangup',                 'hangup_handler');
        //$manager->add_event_handler('bridge',                 'bridge_events');
        $manager->wait_response();
        $manager->disconnect();
?>