Warning: mysqli_stmt::bind_param() [mysqli-stmt.bind-param]

[cypher86]

that's ok 'cos that foreach is 1 instruction lenght and is just for debugging the $params array.

[cypher86]

i found this http://www.phpfreaks.com/forums/index.php?topic=269812.0.

 

unfortunately now the problem is:

Warning: call_user_func_array() expects parameter 2 to be array, integer given in ......

 

any help on this?

[cypher86]

attention  please i've finally work it out.

 

while (list($chiave,$val) = each($_POST)){
		if($val!=""){
			$fragments[] = $chiave." = ?";
			//echo $chiave;
			if($chiave=="ritiro" or $chiave=="data")
				$params[] = normalToDbDate($val);
			else
				$params[] = $val;
			if($chiave=="legale")
				$type[]='i';
			else
				$type[]='s';
		}
	}

	$prova=implode("",$type);
	foreach($params as $param)
		echo "<p>".$param."</p>";
	//echo "val(".count($params).")-->".implode(',',$params);
	//echo "type(".strlen($prova).")-->".implode("",$type);
	$sql = $db->prepare(".................. AND ".implode(" AND ", $fragments));
	array_unshift($params,$prova);
	//print_r($params);
	$tmp = array();
        foreach($params as $key => $value) $tmp[$key] = &$params[$key];

	print_r($tmp);
       	call_user_func_array( array( $sql, 'bind_param' ),$tmp);
	//$sql->bind_param($prova,$params);
	$sql->execute();