2
0

_pdo.php 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697
  1. <?php
  2. function PDO_Connect($dsn, $user="", $password="")
  3. {
  4. global $PDO;
  5. $PDO = new PDO($dsn,_DB_USERNAME_,_DB_PASSWORD_,array(PDO::ATTR_PERSISTENT=>true));
  6. $PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  7. }
  8. function PDO_FetchOne($query, $params=null)
  9. {
  10. global $PDO;
  11. if (isset($params)) {
  12. $stmt = $PDO->prepare($query);
  13. $stmt->execute($params);
  14. } else {
  15. $stmt = $PDO->query($query);
  16. }
  17. $row = $stmt->fetch(PDO::FETCH_NUM);
  18. if ($row) {
  19. return $row[0];
  20. } else {
  21. return false;
  22. }
  23. }
  24. function PDO_FetchNum($query, $params=null)
  25. {
  26. global $PDO;
  27. if (isset($params)) {
  28. $stmt = $PDO->prepare($query);
  29. $stmt->execute($params);
  30. } else {
  31. $stmt = $PDO->query($query);
  32. }
  33. return PDO::FETCH_NUM;
  34. }
  35. function PDO_FetchRow($query, $params=null)
  36. {
  37. global $PDO;
  38. if (isset($params)) {
  39. $stmt = $PDO->prepare($query);
  40. $stmt->execute($params);
  41. } else {
  42. $stmt = $PDO->query($query);
  43. }
  44. return $stmt->fetch(PDO::FETCH_ASSOC);
  45. }
  46. function PDO_FetchAll($query, $params=null)
  47. {
  48. global $PDO;
  49. if (isset($params)) {
  50. $stmt = $PDO->prepare($query);
  51. $stmt->execute($params);
  52. } else {
  53. $stmt = $PDO->query($query);
  54. }
  55. return $stmt->fetchAll(PDO::FETCH_ASSOC);
  56. }
  57. function PDO_FetchAssoc($query, $params=null)
  58. {
  59. global $PDO;
  60. if (isset($params)) {
  61. $stmt = $PDO->prepare($query);
  62. $stmt->execute($params);
  63. } else {
  64. $stmt = $PDO->query($query);
  65. }
  66. $rows = $stmt->fetchAll(PDO::FETCH_NUM);
  67. $assoc = array();
  68. foreach ($rows as $row) {
  69. $assoc[$row[0]] = $row[1];
  70. }
  71. return $assoc;
  72. }
  73. function PDO_Execute($query, $params=null)
  74. {
  75. global $PDO;
  76. if (isset($params)) {
  77. $stmt = $PDO->prepare($query);
  78. $stmt->execute($params);
  79. return $stmt;
  80. } else {
  81. return $PDO->query($query);
  82. }
  83. }
  84. function PDO_LastInsertId()
  85. {
  86. global $PDO;
  87. return $PDO->lastInsertId();
  88. }
  89. function PDO_ErrorInfo()
  90. {
  91. global $PDO;
  92. return $PDO->errorInfo();
  93. }
  94. ?>