[RESOLVED] Binding input parameters

[scialom]

Hello,

I try to create a generic binding mysqli function.

My code is:

$pre_sql = "insert into tbl_jobs (job_name,status) values (?,?)";
$string_type = 'si';
$data = "$p_title,1";
$db->pre_sql($pre_sql,$string_type,$data);

function pre_sql($Query_string,$string_type,$data){
	 $this->connect();


 $this->stmt = mysqli_stmt_init($this->Link_ID);
if (mysqli_stmt_prepare($this->stmt,$Query_string)){
	mysqli_stmt_bind_param($this->stmt,$string_type,$data);
	mysqli_stmt_execute($this->stmt);
}
   }

the problem is that mysqli_stmt_bind_param is expected 2 vars, but I don't know how many I will send.

Is there a way to get around it?

Thanks!

[Weedpacket]

If you passed an array of (type, data) pairs to pre_sql() instead of just type and one data variable, then you could loop through the array and bind them all.

Or you could just pass (query_string, type, data, type, data, type, ....) and use func_get_args() to make an array out of that.

Or you could not execute the statement in this method, but do it later.

[scialom]

Hi,

Thanks for your answer.
I think what I want to do is to send an array to pre_sql() and then loop through the array. But I don't know the syntax to bind them all...

of do you mean to do something like this:

for ($i=0;$i<count($data);$i++){
      mysqli_stmt_bind_param($this->stmt,$string_type[$i],$data[$i]));
}

???

[Weedpacket]

Pretty much, although I'd more likely have the types and data in the same array (much harder to end up with mismatched types/data that way)....

array(
    array('type'=>'s', 'data'=>'foo'),
    array('type'=>'i', 'data'=>42),
    array('type'=>'s', 'data'=>'bar'),
);

foreach($parameters as $parameter)
{
   mysqli_stmt_bind_param($this->stmt, $parameter['type'], $parameter['data']);
}

[scialom]

thanks - that works perfect 🙂