johnmahugu

php - PDO helper functions

Jun 25th, 2015
400
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.90 KB | None | 0 0
  1. <?php
  2. // PDO helper functions.
  3.  
  4.  
  5. function PDO_Connect($dsn, $user="", $password="")
  6. {
  7.     global $PDO;
  8.     $PDO = new PDO($dsn, $user, $password);
  9.     $PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  10. }
  11. function PDO_FetchOne($query, $params=null)
  12. {
  13.     global $PDO;
  14.     if (isset($params)) {
  15.         $stmt = $PDO->prepare($query);
  16.         $stmt->execute($params);
  17.     } else {
  18.         $stmt = $PDO->query($query);
  19.     }
  20.     $row = $stmt->fetch(PDO::FETCH_NUM);
  21.     if ($row) {
  22.         return $row[0];
  23.     } else {
  24.         return false;
  25.     }
  26. }
  27. function PDO_FetchRow($query, $params=null)
  28. {
  29.     global $PDO;
  30.     if (isset($params)) {
  31.         $stmt = $PDO->prepare($query);
  32.         $stmt->execute($params);
  33.     } else {
  34.         $stmt = $PDO->query($query);
  35.     }
  36.     return $stmt->fetch(PDO::FETCH_ASSOC);
  37. }
  38. function PDO_FetchAll($query, $params=null)
  39. {
  40.     global $PDO;
  41.     if (isset($params)) {
  42.         $stmt = $PDO->prepare($query);
  43.         $stmt->execute($params);
  44.     } else {
  45.         $stmt = $PDO->query($query);
  46.     }
  47.     return $stmt->fetchAll(PDO::FETCH_ASSOC);
  48. }
  49. function PDO_FetchAssoc($query, $params=null)
  50. {
  51.     global $PDO;
  52.     if (isset($params)) {
  53.         $stmt = $PDO->prepare($query);
  54.         $stmt->execute($params);
  55.     } else {
  56.         $stmt = $PDO->query($query);
  57.     }
  58.     $rows = $stmt->fetchAll(PDO::FETCH_NUM);
  59.     $assoc = array();
  60.     foreach ($rows as $row) {
  61.         $assoc[$row[0]] = $row[1];
  62.     }
  63.     return $assoc;
  64. }
  65. function PDO_Execute($query, $params=null)
  66. {
  67.     global $PDO;
  68.     if (isset($params)) {
  69.         $stmt = $PDO->prepare($query);
  70.         $stmt->execute($params);
  71.         return $stmt;
  72.     } else {
  73.         return $PDO->query($query);
  74.     }
  75. }
  76. function PDO_LastInsertId()
  77. {
  78.     global $PDO;
  79.     return $PDO->lastInsertId();
  80. }
  81. function PDO_ErrorInfo()
  82. {
  83.     global $PDO;
  84.     return $PDO->errorInfo();
  85. }
  86.  
  87. ?>
Advertisement
Add Comment
Please, Sign In to add comment