Prepared select query function

Question

I'm trying to write a prepared select query function for my DB-class. I think from the code below you can understand what I want to do but obviously this code doesn't work. How can do it right?

public function preparedSelectQuery($sql, $types){
    if(func_num_args() < 3){
        throw new Exception("Less than 3 args!");
    }
    $stmt = $this->mysqli->stmt_init();
    if (!$stmt->prepare($sql)) {
        throw new Exception("Failed to prepare statement!");
    } else {
        if($stmt->bind_param($types, func_get_args())){
            if($stmt->execute()){
                $result = $stmt->get_result();
                while ($row = $result->fetch_assoc()) {
                    $dataset[] = $row;
                }
                $result->close();
                $stmt->close();
                return $dataset;
            }else{
                throw new Exception("Failed to execute!");
            }
        }else{
            throw new Exception("Failed to bind parameters!");
        }
    }
}

What's the error you're getting? "Just doesn't work" doesn't tell us anything. — mcryan, Jan 20 '14 at 14:27
func_get_args() returns an array which is not valid input for bind_param() — Nouphal.M, Jan 20 '14 at 14:32
BUT - is a valid input for `execute()`. Please see the docs - http://www.php.net/manual/ru/pdostatement.execute.php — t1gor, Jan 20 '14 at 14:50
Yes, mysqli bind_param requires its arguments to be lvalues. See my answer to http://stackoverflow.com/questions/7383335/mysqli-prepare-vs-pdo/7383439#7383439 — Bill Karwin, Jan 20 '14 at 17:24

score 0 · Accepted Answer · answered Jun 19 '15 at 08:29

The answer:

function makeValuesReferenced($arr){
        $refs = array();
        foreach($arr as $key => $value)
            $refs[$key] = &$arr[$key];
        return $refs;

    }
$funcArgs = array_slice(func_get_args(),1);
call_user_func_array(array($stmt, 'bind_param'), makeValuesReferenced($funcArgs));

Prepared select query function

1 Answers1