Penjelasan
Skrip PHP berikut menghasilpak bagian-bagian untuk merespons postingan dari form per field untuk tabel yang aktif.
ftype: integer,int,tinyint,bit,varchar, dan lain-lain.
fldname, diambil dari kata ‘field name’: ‘nama mahasiswa, dan lain-lain.
ctrname, diambil dari kata ‘control name’: nama kontrol, dalam skrip ini disepaakti nama kontrol adalah nama field yang dihilangkan spasinya.
Kode Skrip PHP
function sql_unit($ftype,$fldname,$ctrname){
switch($ftype){
case "tinyint"Â Â Â : $sql .= " `".$fldname."` = ".$_POST[$ctrname]; break;
case "smallint" : $sql .= " `".$fldname."` = ".$_POST[$ctrname]; break;
case "mediumint": $sql .= " `".$fldname."` = ".$_POST[$ctrname]; break;
case "int"Â Â Â Â Â Â : $sql .= " `".$fldname."` = ".$_POST[$ctrname]; break;
case "integer"Â : $sql .= " `".$fldname."` = ".$_POST[$ctrname]; break;
case "bigint"Â Â : $sql .= " `".$fldname."` = ".$_POST[$ctrname]; break;
case "real"Â Â Â Â Â Â : $sql .= " `".$fldname."` = ".$_POST[$ctrname]; break;
case "double"Â Â Â : $sql .= " `".$fldname."` = ".$_POST[$ctrname]; break;
case "float"Â Â Â : $sql .= " `".$fldname."` = ".$_POST[$ctrname]; break;
case "decimal"Â Â Â : $sql .= " `".$fldname."` = ".$_POST[$ctrname]; break;
case "numeric"Â Â Â : $sql .= " `".$fldname."` = ".$_POST[$ctrname]; break;
case "date"Â Â Â Â Â Â : $sql .= " `".$fldname."` = '".$_POST[$ctrname]."'"; break;
case "time"Â Â Â Â Â Â : $sql .= " `".$fldname."` = '".$_POST[$ctrname]."'"; break;
case "timestamp": $sql .= " `".$fldname."` = '".$_POST[$ctrname]."'"; break;
case "datetime"Â Â Â : $sql .= " `".$fldname."` = '".$_POST[$ctrname]."'"; break;
case "year"Â Â Â Â Â Â : $sql .= " `".$fldname."` = ".$_POST[$ctrname]; break;
case "char"Â Â Â Â Â Â : $sql .= " `".$fldname."` = '".$_POST[$ctrname]."'"; break;
case "varchar"Â Â Â : $sql .= " `".$fldname."` = '".$_POST[$ctrname]."'"; break;
case "tinyblob"Â Â Â : $sql .= " `".$fldname."` = ".$_POST[$ctrname]; break;
case "mediumblob": $sql .=Â " `".$fldname."` = ".$_POST[$ctrname]; break;
case "blob"Â Â Â Â Â Â : $sql .=Â " `".$fldname."` = ".$_POST[$ctrname]; break;
case "longblob"Â Â Â :Â $sql .=Â " `".$fldname."` = ".$_POST[$ctrname]; break;
case "tinytext"Â Â Â :Â $sql .=Â " `".$fldname."` = '".$_POST[$ctrname]."'"; break;
case "text"Â Â Â Â Â Â : $sql .=Â " `".$fldname."` = '".$_POST[$ctrname]."'"; break;
case "mediumtext":Â $sql .=Â " `".$fldname."` = '".$_POST[$ctrname]."'";Â break;
case "longtext"Â Â Â :Â $sql .=Â " `".$fldname."` = '".$_POST[$ctrname]."'"; break;
case "set"Â Â Â Â Â Â :Â $sql .=Â " `".$fldname."` = ".$_POST[$ctrname]; break;
}
return $sql;
}
