PHP
·
发表于 5年以前
·
阅读量:8301
本文实例讲述了php动态绑定变量的用法。分享给大家供大家参考。具体如下:
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;
//first param needed is the type string
// eg: 'issss'
for ($i=0; $i<count($params);$i++) {
//go through incoming params 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 an 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
希望本文所述对大家的php程序设计有所帮助。