kalo ini gw post tentang funsi untuk insert dan update pada mysql secara otomatis, agar tanpa harus menuliskan query setiap kali melakukan eksekusi
function inzert($table){
global $DateInsert;
global $DateUpdate;
global $UserInsert;
global $UserUpdate;$pozt = $_POST;
$sql= “select * from “.$table;
while (list($key, $val) = each($pozt)) {
$nf = (fgaCute($key));
$$nf = $val;}
$parameter = $_POST['param'];
$param = $parameter[$table];
$exec = mysql_query($sql);
unset($jk);
$jk = mysql_num_fields($exec);
$luv = 1;
while ($data = mysql_fetch_field($exec))
{$namafield = $data->name;
$xz = fcute($namafield);
$xy = $_POST[$xz];
$fnull = $data->not_null;
$primer = $data->primary_key;
$unik = $data->unique_key;
$otomatis = $data->Unsigned;
$tipekolom = $data->type;
if($primer && $xy) { $update = 1 ; $_POST[fcute($nama)] = $xy ; }
if($primer) { $pkey = $namafield.”=’”.$xy.”‘”; $pkeyins = $namafield; }
if ($luv == $jk) { $koma = “” ; } else {$koma = “,” ;}if ($xy){
if(! $primer){
$upd .= ” “.$namafield.”=’”.$xy.”‘”.$koma; }
$ins .= $namafield.$koma;
$insval .= “‘”.$xy.”‘”.$koma; }
$luv ++;
}
unset($luv); unset($pozt);
if ($update) {
$upd .= $pkey;
$upd .= “,UserUpdate=’”.$UserUpdate.”‘,DateUpdate=’”.$DateUpdate.”‘”;
$upins = “UPDATE “.$table.” SET “.$upd.” WHERE (”.$pkey.”) ;”;
} else {
$ins .= “UserInsert,UserUpdate,DateInsert,DateUpdate,”;
$insval .= “‘”.$UserInsert.”‘,’”.$UserUpdate.”‘,’”.$DateInsert.”‘,’”.$DateUpdate.”‘,”;
$xy = ambilpkey($table,$param);
$_POST['nsp'] = $xy;
$_POST[fcute($pkeyins)] = $xy;
if ($xy) {
$ins .= $pkeyins; $insval .= “‘”.$xy.”‘”; }
$upins = “insert into “.$table.” (”.$ins.”) values (”.$insval.”)”;}
$exec = mysql_query($upins);
//lompat($_GET['p']);
return $upins;
}
