How to insert array into mysql using PDO and bindParam?

Posted by moomoochoo on Stack Overflow See other posts from Stack Overflow or by moomoochoo
Published on 2012-03-25T05:12:34Z Indexed on 2012/03/25 5:29 UTC
Read the original article Hit count: 244

Filed under:
|

I'm using the following code. The code works, but I want to change it so that it uses bindparam

try {
    $dbh = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password);
$stqid=array();

    for ($i=0; $i<$array_count; $i++){
    $stqid[$i][0]=$lastInsertValue;
    $stqid[$i][1]=$qid[$i][0];
    $stqid[$i][2]=$qid[$i][1];
    }

$values = array();
    foreach ($stqid as $rowValues) {
        foreach ($rowValues as $key => $rowValue) {
        $rowValues[$key] = $rowValues[$key];  
        }

    $values[] = "(" . implode(', ', $rowValues) . ")";
    }

$count = $dbh->exec("INSERT INTO qresults(instance, qid, result) VALUES  ".implode (', ', $values)); 
$dbh = null;
}
catch(PDOException $e){
    echo $e->getMessage();
}

I replaced the following

$count = $dbh->exec("INSERT INTO qresults(instance, qid, result) VALUES  ".implode (', ', $values)); 

with

$sql = "INSERT INTO qresults (instance, qid, result) VALUES (:an_array)";
$stmt = $dbh->prepare($sql);
$stmt->bindParam(':an_array', implode(',', $values),PDO::PARAM_STR);
$stmt->execute();

but the insert doesn't work anymore (I didn't get any error messages though).

QUESTION: What am I doing wrong? How can I rewrite the code to use bindParam?

© Stack Overflow or respective owner

Related posts about multidimensional-array

Related posts about pdo