I'm trying to work with \[code\]PDO\[/code\] class on php but I have some trouble to find the right way to handle errors, I've wrote this code:\[code\]<?php// $connection alreay created on a class which works with similar UPDATE statements// I've simply added here trim() and PDO:
ARAM... data type$id = 33;$name = "Mario Bros.";$url = "http://nintendo.com";$country = "jp";try {$sql = "UPDATE table_users SET name = :name, url = :url, country = :country WHERE user_id = :user_id";$statement = $connection->prepare ($sql);$statement->bindParam (':user_id', trim($id), PDO:ARAM_INT);$statement->bindParam (':name', trim($name), PDO:ARAM_STR);$statement->bindParam (':url', trim($url), PDO:ARAM_STR);$statement->bindParam (':country', trim($country), PDO:ARAM_STR, 2);$status = $statement->execute ();} catch (PDOException $e) { print $e->getMessage ();}print $status; // it returns a null value, and no errors are reported?>\[/code\]this portion of code doesn't report errors, but it simply doesn't work, the var \[code\]$status\[/code\] at the bottom, return a null value.can someone help me to find where I'm wrong?
ARAM... data type$id = 33;$name = "Mario Bros.";$url = "http://nintendo.com";$country = "jp";try {$sql = "UPDATE table_users SET name = :name, url = :url, country = :country WHERE user_id = :user_id";$statement = $connection->prepare ($sql);$statement->bindParam (':user_id', trim($id), PDO:ARAM_INT);$statement->bindParam (':name', trim($name), PDO:ARAM_STR);$statement->bindParam (':url', trim($url), PDO:ARAM_STR);$statement->bindParam (':country', trim($country), PDO:ARAM_STR, 2);$status = $statement->execute ();} catch (PDOException $e) { print $e->getMessage ();}print $status; // it returns a null value, and no errors are reported?>\[/code\]this portion of code doesn't report errors, but it simply doesn't work, the var \[code\]$status\[/code\] at the bottom, return a null value.can someone help me to find where I'm wrong?