PHP : update

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