sql update不会更改DB中的数据

Question

I made a simple update query using PDO in PHP :

$pdos = connect_db(); 
$pdos->beginTransaction();
try {
    $query = "UPDATE `myo`.`question` SET `intitule` = 'Question azeerrr' WHERE `question`.`id` = 1"; 
    $pdo = $pdos->prepare($query);
    $pdo->execute();
    return $pdo->rowCount();
catch (Exception $e) { print_r ($e); exit (); }

Which doesnt seem to work (the data is not changed in the database) even though i get no error message and even receive "1" from rowCount() meaning the update was successful.

And also, if i copy and paste this query in PHPmyadmin and run it, it works and the row is modified,

Could it be something about rights to execute an UPDATE from my website and not beeing the same as when you are logged into PHPmyadmin?

EDIT : FIXED : thanks for you help : PDO::commit(); was needed to close my PDO::beginTransaction();

Answer 1

As you begin a transaction with $pdos->beginTransaction(); I'm pretty sure that you need commit it using $pdos->commit();

See the documentation for more information.