Query with parameter

I've looked in provided file example.php and saw this line:
$rows=$db->fetch("SELECT * FROM my_table WHERE col1=?","s","12","Value1");
col1 = ? requires a value, but the parameters provided are 3. What's the meaning of three parameters?
More explanation is really appreciated.

Thanks,
Hadi

Usage:

$db->query($query,$data_types,$lengths,$value);
$db->fetch($query,$data_types,$lengths,$value);


Parameters:

$query: SQL query to be prepared for execution

$data_types: Data types to be binded for execution."s" for string, "i" for integer, "b" for bool.Each character is assigned to a value.No space between characters.For example:
$db->query($query,"sib",$lengths,$value1,$value2,$value3);
"s" is assigned to $value1
"i" is assigned to $value2
"b" is assigned to $value3

$lengths: Lengths to be binded for execution.Each number is assigned to a value.Numbers are separated by ":".For example:
$db->query($query,$data_types,"10:5:12",$value1,$value2,$value3);
10 is assigned to $value1
5 is assigned to $value2
12 is assigned to $value3

$value: Value to be binded for execution.You must pass the same number of values as the data types and lengths.


If you don't need to bind parameters you may use:
$db->fetch($query);




Hope I helped.Let me know if you have more questions.

Hi there,

Nice class, please find my *static* PDO class + examples at http://bit.ly/1n8g16c

keep up, magkako.. check also @ works > DB manager

Thanks for a comprehensive answer and examples,
Didn't get what's the length parameter for?
$db->query($query,$data_types,"10:5:12",$value1,$value2,$value3);

length : 12 for a bool value? what does it mean?

Regards,
Hadi

According to php.net, "Length of the data type. To indicate that a parameter is an OUT parameter from a stored procedure, you must explicitly set the length.".

In my opinion it's not that important, just put any value.BUT still the number of lengths, separated by ":", must be the same as the number of data types and values.

Thanks Pipi!
Nice name :p Congrats on your works.

Thanks man,
Great job.

Hadi

Thank you Hadi! :)