Why PDO insert Query executed two times ?

I am inserting using this code

////////////////

$action_name = "بحث"; $action_doer_id = $_SESSION['user_id'];

$query = "INSERT INTO transactions (transaction_name, transaction_user_id, transaction_notes) VALUES ('$action_name', $action_doer_id, '$notes')";
$stmt = $pdo->query($query);
$stmt->execute();

//////////////

the result is two records added in database why ? ( note ) but there is a query before it should i call it query2 instead of query and stmt2 instead of stmt

Nakov

6 years ago

Best Answer

Level 73

Do you maybe make the request twice? add a dump() above these lines and check if your request is being repeated.

And which PDO class are you using? I tried with PDOConnection and there is no execute() method in it. Wanted to check if the query() method also executes the query.

programators

6 years ago

Level 17

beside the fact of sql injection - you are running script twice. pass $query into execute method .

https://www.php.net/manual/en/pdostatement.execute.php

Please or to participate in this conversation.