In questo esempio di effettua una ricerca per rilevare la idkey e si aggiorna la città.
<?php
/*
update.php
return nr.record updated
*/
require_once('call_class.php');
$call = new call_class();
//
// search idkey for update
$call->cmd = "
<record>
<stmt>select</stmt>
<field>col_idkey</field>
<Where>col_user=? and col_key=? and col_value=?</Where>
<paramW>User_1</paramW>
<paramW>name</paramW>
<paramW>Tom</paramW>
<OtherCmd>LIMIT 1</OtherCmd>
<ReturnSelect>STRING</ReturnSelect>
<RowHeading>N</RowHeading>
</record>
";
$Res = $call->call_curl();
if ( substr($Res, 0, 4) != "#ERR" ) {
$IdKey = $Res; // return only single data
$call->cmd = "
<record>
<stmt>update</stmt>
<field>col_value</field>
<paramF>New York</paramF>
<Where>col_idkey=? and col_key=?</Where>
<paramW>".$IdKey."</paramW>
<paramW>city</paramW>
</record>
";
$Res = $call->call_curl();
if ( substr($Res, 0, 4) != "#ERR" ) {
echo "- Updated nr. ".$Res." record(s) with idkey=".$IdKey."<br />";
}else{
echo "error in update_1...".$Res;
die;
}
}else{
echo "error in Select...".$Res;
die;
}
?>
Ritorna il nr. di record aggiornati

