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: 306
        
multidimensional-array
|pdo
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