Delete an array not working with PDO SQL?

Question

it's been 3 hours that i'm trying to delete a row in mysql based on a id ... Seems simple right ?

Taking into consideration that the array might contains several value: $result = Array ( [3] => 4_Couture )

Array ( [3] => 4_Couture )
$sql_delete = "DELETE FROM users_resumes WHERE id_training_key = ? ";
$stmt_delete= $pdo->prepare($sql_delete);
foreach($result as $r) {
            $stmt_delete->execute($r);
    }

This seems to be right no ? error : PDOStatement::execute() expects parameter 1 to be array, string given

Any, any, any clue is very welcome ! thanks a lot from France !

What exactly is $result? Where do you assign a value? $result = Array ( [3] => 4_Couture ) is not valid PHP code — Phil
– Phil, Commented Aug 26, 2020 at 1:38
Alternative approach to current answer $stmt_delete->execute(array($r)); or use ternary and is_array. — user3783243
– user3783243, Commented Aug 26, 2020 at 2:29

Phil · Accepted Answer · 2020-08-26 01:42:49Z

4

Assuming $result is a one-dimensional array like

$result = [ 3 => '4_Couture' ];

That means you're trying to call $stmt->execute() with a single string value where it requires an array.

I suggest you use bindParam instead

$stmt_delete = $pdo->prepare("DELETE FROM users_resumes WHERE id_training_key = ?");
$stmt_delete->bindParam(1, $r);
foreach ($result as $r) {
  $stmt_delete->execute();
}

answered Aug 26, 2020 at 1:42

Phil

166k25 gold badges265 silver badges269 bronze badges

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

1 Comment

Hymed Ghenai Over a year ago

Dude, you've juste make it work ! Indeed the array wasn't multidimensional ! This is why my code wasn't corking ! I've learned a huge one tonight thanks to you !

Collectives™ on Stack Overflow

Delete an array not working with PDO SQL?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related