empty data in databsae when add it

[Abdulaziiz]

hello

i wrote method that get the array variable and record it in the database
this is the code

$db->connect(); 
$category = new Category(); 
$data=array();
$data['name'] = $_POST['name'];
$data['desc'] = $_POST['desc'];
$data['parentid'] = $_POST['parentid'];
$result = $category->addCategory($data);
$db->close();
/////
function  addCategory($data)
   {
   global $db;
   $data['name']= mysql_real_escape_string(trim($data['name']));
   $data['desc']= mysql_real_escape_string(trim($data['desc']));
   $data['parentid']= mysql_real_escape_string(trim($data['parentid']));
   $result = $db->query_insert("category", $data);
   return $result;
   }

the problem is when i add category no value has been added in database it's add but empty

so any idea please to fixed it

[NogDog]

I'd start by verifying that the $data array has the expected values (var_dump(), perhaps). If not, then work backwards from there to figure out why. If $data looks OK, then we'll probably have to see the query_insert() method.

[Abdulaziiz]

function query_insert($table, $data) {
	$q="INSERT INTO `".$this->pre.$table."` ";
	$v=''; $n='';

foreach($data as $key=>$val) {
	$n.="`$key`, ";
	if(strtolower($val)=='null') $v.="NULL, ";
	elseif(strtolower($val)=='now()') $v.="NOW(), ";
	else $v.= "'".$this->escape($val)."', ";
}

$q .= "(". rtrim($n, ', ') .") VALUES (". rtrim($v, ', ') .");";

if($this->query($q)){
	//$this->free_result();
	return mysql_insert_id();
}
else return false;

}

this is the function of query_insert

[Weedpacket]

And does $data look okay?