Grow your CSS skills. Land your dream job.

Binding array values to variables

  • # February 3, 2011 at 8:40 am

    Hi I am adapting Jeffery Ways Mysql class to accept multiple where statements however I have got stuck on the final hurdle.
    It is when I try to do the bind_results() and I pass in the parameter types and the parameters. Here is that part of the code:

    if ($this->_where)
    $values = array_values($this->_where);

    $str = "'";
    $str .= implode('', '', $values);
    $str .= "'";
    // echo $str;
    $count = count($this->_where);

    foreach($this->_where as $key => $value){
    $key = $value;
    }
    $user = 'matt25';
    $pass = '6722853cacc4a9649dc75abc852f23c35b1f75cb';

    $stmt->bind_param($this->_paramTypeList, $user, $pass);
    }

    It works how it is by setting the parameters as variables, but that obviously isn’t practical. as you can see I also tried to make a string with the values from the array which brought up the error:
    Warning: mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of elements in type definition string doesn’t match number of bind variables in C:wampwwwtrick_tipsadminincludesMysqlDb.php on line 260,

    the same as when I try to put the array into there.

    So I need some way of setting each value in the array as a variable to then put into the function, or another Idea that I have completely missed.

    Any help would be much appreciated.

    Cheers,
    Matt

    # September 11, 2012 at 8:24 pm

    I’ve got a similar problem. =/

    # September 11, 2012 at 9:40 pm

    What is the value of `$this->_paramTypeList` if you output before the binding happens?

    echo ‘

    ';
    print_r($this->_paramTypeList);
    echo '

    ‘;
    exit;

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.

*May or may not contain any actual "CSS" or "Tricks".