updating mysql with pdo

See more:

PHP

MySQL

I have a database with table users. I need to update the table.

The code below works where 'send' is a user name in the row user_name

Code:

$query_new_user_update = $pdo->prepare("UPDATE users set user_balance = :user_balance where user_name = 'send'");

However I need 'send' to be a variable like below

$user = 'send';

However code below does not work.

Code:

$pdo = new PDO('mysql:host='. $host .';dbname='.$db_test, $db_username, $db_password);
        

$query_new_user_update = $pdo->prepare("UPDATE users set user_balance = :user_balance where user_name = :user");
$query_new_user_update->bindValue(1,':user_balance', $ubalance, PDO::PARAM_STR);
$query_new_user_update->bindValue(2,':user', $user, PDO::PARAM_STR);
$query_new_user_update->execute();