This example describes the use of PHP dynamic binding variables. Share to everyone for your reference. Specifically as follows:
?
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 The |
Private function Bindvars ($stmt, $params) {if ( $params!= null) {$types = ';//initial sting with Types foreach ($params as $param) {//for each element, determine type and add if (Is_int ($param)) {$types. = ' i '//integer} elseif (Is_float ($param)) {$types. = ' d ';//double} elseif (Is_ String ($param)) {$types. = ' s ';//string} else {$types. = ' B ';//blob and Unknown}} $bind _names[] = $types; The type string//eg: ' Issss ' for ($i =0; $i <count ($params); $i + +) {//go through incoming param s and added em to array $bind _name = ' bind '. $i; Give them an arbitrary name $ $bind _name = $params [$i]; Add the parameter to the variable variable $bind _names[] = &$ $bind _name; Now associate the variable as a element in an array}//call the function Bind_param witH Dynamic params Call_user_func_array (Array ($stmt, ' Bind_param '), $bind _names); return $stmt; Return the bound statement |
I hope this article will help you with your PHP programming.