Prepared Statement in a Class

dr_freak

Hello,everyone. Newbie here. 🙂

I have learnt that php supports prepare statement like the following:

$query="INSERT INTO books values (?,?,?,?)";
$stmt=$db->prepare($query);
$stmt->bind_param("sssd",$isbn,$author,$title,$price);     <---
$stmt->execute();

The problem lies in the line with an arrow.I have written a class for database operation which accepts field values to accomplish adding record.However,I can't seem to add those field values in this statement via looping.Do you guys know how to work it out?

NuLL_PL_

Use call_user_func_array function.

whisher06

Hi.
You should use ADOdb 🙂
Take care.

whisher06

The link to
download it.
Bye.

dr_freak

Thanks for your reply,NuLL[PL] & whisher06. NuLL[PL],how do I use call_user_func_array?After I read the document in php.net, I still have no clue what's that for.And my problem is,the bind_param seems like refusing me to add a variable everytime via looping.This is very important because this script's parameter will be appended according to user's input.For example,if I input an array with 4 variables,my method will loop 4 times and append these 4 variables to the second parameters of bind_param.It seems hard to do that.

Please give me a clue.

whisher06

Hi.
Let's take a look here
Keep it easy 😃
Take care.