How to use php dynamically bind variables, php bind variables_PHP tutorial

Usage of php dynamic binding variables, php binding variables

The examples in this article describe the usage of php dynamic binding variables. Share it with everyone for your reference. The details are as follows:

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

I hope this article will be helpful to everyone’s PHP programming design.

http://www.bkjia.com/PHPjc/1017890.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/1017890.htmlTechArticleUsage of php dynamic binding variables, php binding variables This article explains the usage of php dynamic binding variables. Share it with everyone for your reference. The details are as follows: private function bindVars($s...