Jump to content

Recommended Posts

Posted

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;

 

}

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...