i get problem with 'insert' in this function. logically, i think its ok but....
function iInsert($list_tbl=array(), $postData = array()){
$res = count($list_tbl);
for($i=0; $i<$res; $i++){
$q = "DESC $list_table[$i] ";
$q = mysql_query($q);
$getFields = array();
while ($field = mysql_fetch_array($q)){
$getFields[sizeof($getFields)] = $field['Field'];
}
$fields = "";
$values = "";
if (sizeof($getFields) > 0){
foreach($getFields as $k){
if (isset($postData[$k])){
$postData[$k] = htmlspecialchars($postData[$k]);
$fields .= "`$k`, ";
$values .= "'$postData[$k]', ";
}
}
$fields = substr($fields, 0, strlen($fields) - 2);
$values = substr($values, 0, strlen($values) - 2);
//$insert = "INSERT INTO $table ($fields) VALUES ($values)";
$q1=" INSERT INTO ($list_table[$i]) ($fields) VALUES ('$values')";
if (mysql_query($q1)){
return true;
}else{
echo mysql_error();
return false;
}
}else{
return false;
}
}
return true;
}