Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Apr 29th, 2012  |  syntax: None  |  size: 1.67 KB  |  hits: 17  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. What's wrong with my PDO syntax? Is it possible to get a clearer error report?
  2. $dbh = new PDO("mysql:host=" . WEBSITE_SERVER . "; dbname=fluenz_website", WEBSITE_LOGIN,   WEBSITE_PW);
  3. $query = $dbh->prepare("INSERT INTO crm_orders (crm_id, order_num, channel) VALUES (:crm_id, :order_num, :channel)");
  4.  
  5. if($query->execute(array(':crm_id'=>$crm_id, ':order_num'=>$order_num, ':channel'=>$channel))){
  6.     echo 'PDO SUCCESS';
  7. }else{
  8.     echo 'PDO FAILURE';
  9. }
  10.        
  11. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  12.        
  13. try {    
  14.     $query->execute(...);
  15. } catch (PDOException $e) {
  16.     echo $e->getMessage();
  17. }
  18.        
  19. try {
  20.     $dbh = new PDO($dsn, $user, $password);
  21.     $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  22. } catch (PDOException $e) {
  23.     echo 'Connection failed: ' . $e->getMessage();
  24. }
  25.  
  26. try {
  27.   $query = $dbh->prepare("INSERT INTO crm_orders (crm_id, order_num, channel) VALUES (:crm_id, :order_num, :channel)");
  28.   $query->execute(array(':crm_id'=>$crm_id, ':order_num'=>$order_num, ':channel'=>$channel))
  29. }
  30. catch (PDOException $e) {
  31.   echo "Query failed: " $e->getMessage();
  32. }
  33.        
  34. $dbh = new PDO("mysql:host=" . WEBSITE_SERVER . "; dbname=fluenz_website", WEBSITE_LOGIN,   WEBSITE_PW);
  35. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  36. $query = $dbh->prepare("INSERT INTO crm_orders (crm_id, order_num, channel) VALUES (:crm_id, :order_num, :channel)");
  37.  
  38.     try {
  39.         if($query->execute(array(':crm_id'=>$crm_id, ':order_num'=>$order_num, ':channel'=>$channel))){
  40.         echo 'PDO SUCCESS';
  41.         }else{
  42.             echo 'PDO FAILURE';
  43.         }
  44.     }
  45.     catch (PDOException $e) {
  46.         echo 'Connection failed: ' . $e->getMessage();
  47.     }