insert multiple rows into mysql db using pdo

Question

I have an array in the following format

Array
(
[0] => Array
    (
        [name] => Product 1
        [weight] => 0.3000
        [Price] => 31.4400
    )

[1] => Array
    (
        [name] => Product 2
        [weight] => 0.2000
        [Price] => 32.4400
    )

)

My pdo sql query is as follows:

$sql = "INSERT INTO products(name,weight,price) VALUES (?,?,?)"; 
$stmt = $conn->prepare($sql); 
foreach ($new_items as $v) {    
    $stmt->execute(array_values($v)); 
}

Receive error:

PHP Notice: Array to string conversion on $stmt->execute(array_values($v));

Update:

Tried this code too provided by @user1978142

// insert to database
foreach($new_items as $key => $value) {
    $stmt = $conn->prepare("INSERT INTO products (name, weight, price) VALUES (:name, :weight, :price)");
    $stmt->bindParam(':name', $value['name']);
    $stmt->bindParam(':weight', $value['weight']);
    $stmt->bindParam(':price', $value['Price']);
    $stmt->execute();
}

Error: Invalid parameter number: number of bound variables does not match number of tokens.

What is wrong with both the above code ?? I am a newbie.

I really do not like it when a computer is obviously lying. You code looks fine. It obviously prepares the query ok. It tries to bind, what are obviously sensible things, and gets confused. Things to check: First, there are implied parameter types: pdo.constants.php. Check that your table definition has simple data column definitions of integer or string. Next, var_dump($key, $value) and check that the array names and values are what you expect. Update your answer with any useful information. — Ryan Vincent
– Ryan Vincent, Commented Jun 18, 2014 at 13:29
@YourCommonSense, i agree completely! I should have made it clearer that it is getting confused rather than telling lies. I treat it as the point to start the process of checking all my assumptions about the situation as i am obviously the one who does not understand the situation. Was meant to be 'tongue in cheek' rather than a serious point. — Ryan Vincent
– Ryan Vincent, Commented Jun 18, 2014 at 13:57

shuttle87 · Accepted Answer · 2014-06-18 12:36:44Z

0

after $stmt = $conn->prepare($sql); add this code:

 $stmt -> bind_param("ssd", $name, $weight,$price);

edited Jun 18, 2014 at 12:36

shuttle87

16.1k12 gold badges80 silver badges107 bronze badges

answered Jun 18, 2014 at 12:15

Silent Coder

545 bronze badges

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

Comments

Your Common Sense · Accepted Answer · 2014-06-18 13:53:25Z

0

For the present data structure your code is all right.

The error indicates that your array has some different structure, at least that array has one more nested level

check your input data.

answered Jun 18, 2014 at 13:53

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

Comments

Martin Tournoij · Accepted Answer · 2014-06-18 12:03:43Z

-1

after prepare stament, first use bind_param, then proceed further.

edited Jun 18, 2014 at 12:03

Martin Tournoij

28k24 gold badges110 silver badges158 bronze badges

answered Jun 18, 2014 at 11:36

amit 1984

3663 silver badges9 bronze badges

1 Comment

user3737431 Over a year ago

foreach($new_items as $key => $value) { $stmt = $dbh->prepare("INSERT INTO products (name, weight, price) VALUES (:name, :weight, :price)"); $stmt->bindParam(':name', $value['name']); $stmt->bindParam(':weight', $value['weight']); $stmt->bindParam(':price', $value['Price']); $stmt->execute(); } .....Not Working ???

Collectives™ on Stack Overflow

insert multiple rows into mysql db using pdo

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related