oslo Posted February 6, 2013 Report Posted February 6, 2013 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; }
sudheerphp Posted February 6, 2013 Report Posted February 6, 2013 what it throws, post fully qualified :blink:Error description :
oslo Posted February 6, 2013 Author Report Posted February 6, 2013 no error and no insert to db! that's the problem cause its no error it doesn't insert the post data
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now