How to insert combined array into mysql table using PDO statements

Question

I have a combined array of the type [key] => value and want to insert it into mysql table using PDO prepared statement. My code is as shown below:

$a = array('avocado', 'apple', 'banana');
$b = array('green', 'red', 'yellow');

$c = array_combine($a, $b);

print_r($c);



$stmt = $pdo->prepare("INSERT INTO fruits (name, color) VALUES (?,?)");
try {
    $pdo->beginTransaction();
    foreach ($c as $row)
    {
        $stmt->execute($row);
    }
    $pdo->commit();
}catch (Exception $e){
    $pdo->rollback();
    throw $e;
}


However, when I execute the statement, I get an error code:

Warning: PDOStatement::execute() expects parameter 1 to be array, string given in C:\xampp\htdocs\mysites\PDOmysql_tutorial\pdoInsert.php on line 19.  Could I get a little help to correct my code or a comment if I am using the right approach.  Thanks

Elanochecer · Accepted Answer · 2019-03-27 12:10:55Z

1

You are just sending the value of the array to the execute function. Send the key and the value in an array:

$a = array('avocado', 'apple', 'banana');
$b = array('green', 'red', 'yellow');

$c = array_combine($a, $b);

print_r($c);



$stmt = $pdo->prepare("INSERT INTO fruits (name, color) VALUES (?,?)");
try {
    $pdo->beginTransaction();
    foreach ($c as $name => $color)
    {
        $stmt->execute( [ $name, $color ] );
    }
    $pdo->commit();
}catch (Exception $e){
    $pdo->rollback();
    throw $e;
}

edited Mar 27, 2019 at 12:10

answered Mar 27, 2019 at 12:09

Elanochecer

6204 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Elanochecer Over a year ago

I was on it @O.Jones

Edugra17 · Accepted Answer · 2019-03-28 09:06:26Z

0

Without combining arrays:

$a = array('avocado', 'apple', 'banana');
$b = array('green', 'red', 'yellow');

$stmt = $stmt->prepare("INSERT INTO fruits (name, color) VALUES (?,?)");

$fruit = "";
$color = "";

$stmt->bindParam(1, $fruit);
$stmt->bindParam(2, $color);

$count = count($a);
$x = 0;
while($count > $x){
    $fruit = $a[$x];
    $color = $b[$x];
    $stmt->execute();
    //echo $fruit . ": " . $color . "<br>";
    $x++;
}

answered Mar 28, 2019 at 9:06

Edugra17

12 bronze badges

1 Comment

Muhammad Khan Over a year ago

Thanks for the help

Collectives™ on Stack Overflow

How to insert combined array into mysql table using PDO statements

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related