таблица в базе:
mysql> describe mvts_aon ;
+-------------+------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+------------+------+-----+---------+-------+
| number | bigint(13) | NO | PRI | NULL | |
| cnt | int(3) | NO | | NULL | |
| change_time | datetime | NO | | NULL | |
+-------------+------------+------+-----+---------+-------+
Код: Выделить всё
#!/usr//bin/php
<?php
$sql_usr='user';
$sql_pwd='password';
$link = mysql_connect("localhost", "$sql_usr", "$sql_pwd");
mysql_select_db("db",$link);
if (!$link) {
die('Error connect: ' . mysql_error());
}
$sql="select number from mvts_aon limit 1";
$res=mysql_query("$sql") or die("Bad query: ".mysql_error()."($sql)");
$fetch = mysql_fetch_row($res,MYSQL_ASSOC);
$req_update="update mvts_aon set cnt=cnt+1, change_time=now() where number='$fetch[number]'";
mysql_query($req_update) or die("Bad query: ".mysql_error()."($req_update)");
/////////////////////////////////////////////////////////////////////////////////////////////////////////
$client = new SoapClient('https://ip_adress_server/service/?wsdl_v2');
$headers = array();
$headers[] = new SoapHeader('auth','Login','mvts_username'_soap);
$headers[] = new SoapHeader('auth','Password','mvts_password_soap);
$client->__setSoapHeaders($headers);
$obj_id = $client->getObjectId('Equipment', 'Equipment;Equipment');
$filter = array(
'type' => 'cond',
'column' => 'gateway_id',
'operator' => '=',
'value' => '8442'
// 'value' => '9812'
);
$columns=array(
'gateway_id',
'gateway_name',
'src_address_list',
'dst_address',
'out_ani_translate',
'description'
);
echo $client->updateRowset(
$obj_id,
array(
array(
array('name' => 'out_ani_translate', 'value' => ".*/$fetch[number]" ),
array('name' => 'dst_zone', 'value' => "voip" ),
array('name' => 'sip_router_zone', 'value' => "voip" ),
array('name' => 'dst_sip_router_address', 'value' => "1.1.1.1" ),
array('name' => 'dst_address', 'value' => "1.1.1.1" ),
array('name' => 'protocol', 'value' => "0" )
)
),
$filter
);
//echo "\n------------------\n";
//$rowset = $client->selectRowset($obj_id,$filter,'',20,0,$columns);
//$rowset = $client->selectRowset($obj_id,$filter,'',20,0);
//print_r($rowset);
//echo "\n------------------------------------------------------------------------\n";
?>