note 71387 added to function.mysql-query
| From: | babba at nurfuerspam dot de | Date: | Sat, 25 Nov 2006 23:42:16 +0000 |
| Subject: | note 71387 added to function.mysql-query | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-120082@lists.php.net to get a copy of this message | ||
Following function creates a minimal update query by comparing two arrays with old and new values
(phpmyadmin-like). An easy way to use it in your forms is to print out the old values in hidden
fields with name old[$key] and name the visible form fields new[$key]. Feel free to send comments
via mail.
<?php
function getUpdateString($tablename, $whereclause, $old, $new) {
$changedvalues = "";
foreach($old as $key => $oldvalue) {
$newvalue = $new[$key];
if($oldvalue != $newvalue) {
if($changedvalues != "")
$changedvalues .= ", ";
$changedvalues .= "
".$key."=";
if(!is_numeric($newvalue))
$changedvalues .= "'".$newvalue."'";
else
$changedvalues .= $newvalue;
}
}
if($changedvalues == "")
return "";
return "UPDATE ".$tablename. " SET ".$changedvalues." WHERE
".$whereclause;
}
?>
----
Server IP: 212.124.37.9
Probable Submitter: 217.226.206.250
----
Manual Page -- http://www.php.net/manual/en/function.mysql-query.php
Edit -- https://master.php.net/note/edit/71387
Del: integrated -- https://master.php.net/note/delete/71387/integrated
Del: useless -- https://master.php.net/note/delete/71387/useless
Del: bad code -- https://master.php.net/note/delete/71387/bad+code
Del: spam -- https://master.php.net/note/delete/71387/spam
Del: non-english -- https://master.php.net/note/delete/71387/non-english
Del: in docs -- https://master.php.net/note/delete/71387/in+docs
Del: other reasons-- https://master.php.net/note/delete/71387
Reject -- https://master.php.net/note/reject/71387
Search -- https://master.php.net/manage/user-notes.php