snipplrCallback({"id":27966,"title":"class-db","source":"
  1. class<\/span> Db {<\/span><\/div><\/li>
  2.  <\/div><\/li>
  3. \tprivate<\/span> $_conf<\/span> =<\/span> false<\/span>;<\/span><\/div><\/li>
  4.  <\/div><\/li>
  5. \tpublic<\/span> function<\/span> __construct(<\/span>)<\/span> {<\/span><\/div><\/li>
  6. \t\t$this<\/span>-><\/span>parseConf<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>
  7. \t\t$this<\/span>-><\/span>dbConnect<\/span>(<\/span>)<\/span>;<\/span><\/div><\/li>
  8. \t}<\/span><\/div><\/li>
  9.  <\/div><\/li>
  10. \tprivate<\/span> function<\/span> parseConf(<\/span>)<\/span> {<\/span><\/div><\/li>
  11. \t\t$this<\/span>-><\/span>_conf =<\/span> parse_ini_file<\/span><\/a>(<\/span>"crunksauce.ini"<\/span>,<\/span> true<\/span>)<\/span>;<\/span><\/div><\/li>
  12. \t}<\/span><\/div><\/li>
  13.  <\/div><\/li>
  14. \tprivate<\/span> function<\/span> dbConnect(<\/span>)<\/span> {<\/span><\/div><\/li>
  15. \t\tif<\/span> (<\/span>!<\/span>isset<\/span><\/a>(<\/span>$this<\/span>-><\/span>_conf[<\/span>'database'<\/span>]<\/span>)<\/span>)<\/span> {<\/span><\/div><\/li>
  16. \t\t\techo<\/span> 'no db details found'<\/span>;<\/span><\/div><\/li>
  17. \t\t\texit<\/span><\/a>;<\/span><\/div><\/li>
  18. \t\t}<\/span><\/div><\/li>
  19. \t\telse<\/span> {<\/span><\/div><\/li>
  20. \t\t\t$db<\/span> =<\/span> $this<\/span>-><\/span>_conf[<\/span>'database'<\/span>]<\/span>;<\/span><\/div><\/li>
  21. \t\t\t$con<\/span> =<\/span> mysql_connect<\/span><\/a>(<\/span>$db<\/span>[<\/span>'host'<\/span>]<\/span>,<\/span> $db<\/span>[<\/span>'user'<\/span>]<\/span>,<\/span> $db<\/span>[<\/span>'pass'<\/span>]<\/span>)<\/span> <\/div><\/li>
  22. \t\t\tor die<\/span><\/a>(<\/span>"connect fail"<\/span>)<\/span>;<\/span><\/div><\/li>
  23. \t\t\tmysql_select_db<\/span><\/a>(<\/span>$db<\/span>[<\/span>'dbname'<\/span>]<\/span>,<\/span> $con<\/span>)<\/span> <\/div><\/li>
  24. \t\t\tor die<\/span><\/a>(<\/span>"db select fail"<\/span>)<\/span>;<\/span><\/div><\/li>
  25. \t\t}<\/span><\/div><\/li>
  26. \t}<\/span><\/div><\/li>
  27.  <\/div><\/li>
  28. \tprivate<\/span> function<\/span> quote(<\/span>$str<\/span>=<\/span>''<\/span>)<\/span> {<\/span><\/div><\/li>
  29. \t\treturn<\/span> str_replace<\/span><\/a>(<\/span>"'"<\/span>,<\/span> "\\'"<\/span>,<\/span> $str<\/span>)<\/span>;<\/span><\/div><\/li>
  30. \t}<\/span><\/div><\/li>
  31.  <\/div><\/li>
  32. \tprivate<\/span> function<\/span> query(<\/span>$query<\/span>=<\/span>false<\/span>)<\/span> {<\/span><\/div><\/li>
  33. \t\treturn<\/span> $query<\/span> ? @<\/span>mysql_query<\/span><\/a>(<\/span>$query<\/span>)<\/span> :<\/span> false<\/span>;<\/span><\/div><\/li>
  34. \t}<\/span><\/div><\/li>
  35.  <\/div><\/li>
  36. \t\/\/ public functions<\/span><\/div><\/li>
  37.  <\/div><\/li>
  38. \tpublic<\/span> function<\/span> result(<\/span>$query<\/span>=<\/span>false<\/span>)<\/span> {<\/span><\/div><\/li>
  39. \t\treturn<\/span> $query<\/span> ? @<\/span>mysql_fetch_assoc<\/span><\/a>(<\/span>$this<\/span>-><\/span>query<\/span>(<\/span>$query<\/span>)<\/span>)<\/span> :<\/span> false<\/span>;<\/span><\/div><\/li>
  40. \t}<\/span><\/div><\/li>
  41.  <\/div><\/li>
  42. \tpublic<\/span> function<\/span> results(<\/span>$query<\/span>=<\/span>false<\/span>)<\/span> {<\/span><\/div><\/li>
  43. \t\t$ar<\/span> =<\/span> false<\/span>;<\/span><\/div><\/li>
  44. \t\tif<\/span> (<\/span>$query<\/span>)<\/span> {<\/span><\/div><\/li>
  45. \t\t\t$res<\/span> =<\/span> $this<\/span>-><\/span>query<\/span>(<\/span>$query<\/span>)<\/span>;<\/span><\/div><\/li>
  46. \t\t\tif<\/span> (<\/span>$res<\/span>)<\/span> {<\/span><\/div><\/li>
  47. \t\t\t\t$ar<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span><\/div><\/li>
  48. \t\t\t\twhile<\/span> (<\/span>$r<\/span> =<\/span> mysql_fetch_assoc<\/span><\/a>(<\/span>$res<\/span>)<\/span>)<\/span> {<\/span><\/div><\/li>
  49. \t\t\t\t\t$ar<\/span>[<\/span>]<\/span> =<\/span> $r<\/span>;<\/span><\/div><\/li>
  50. \t\t\t\t}<\/span><\/div><\/li>
  51. \t\t\t}<\/span><\/div><\/li>
  52. \t\t}<\/span><\/div><\/li>
  53. \t\treturn<\/span> $ar<\/span>;<\/span><\/div><\/li>
  54. \t}<\/span><\/div><\/li>
  55.  <\/div><\/li>
  56. \tpublic<\/span> function<\/span> insert(<\/span>$tbl<\/span>=<\/span>false<\/span>,<\/span> $data<\/span>=<\/span>array<\/span><\/a>(<\/span>)<\/span>)<\/span> {<\/span><\/div><\/li>
  57. \t\tif<\/span> (<\/span>$tbl<\/span> &&<\/span> count<\/span><\/a>(<\/span>$data<\/span>)<\/span> ><\/span> 0<\/span>)<\/span> {<\/span><\/div><\/li>
  58. \t\t\tforeach<\/span> (<\/span>$data<\/span> as<\/span> $key<\/span> =><\/span> $d<\/span>)<\/span> {<\/span><\/div><\/li>
  59. \t\t\t\tif<\/span> (<\/span>!<\/span>is_numeric<\/span><\/a>(<\/span>$d<\/span>)<\/span>)<\/span> {<\/span><\/div><\/li>
  60. \t\t\t\t\t$data<\/span>[<\/span>$key<\/span>]<\/span> =<\/span> "'"<\/span> .<\/span> $this<\/span>-><\/span>quote<\/span>(<\/span>$d<\/span>)<\/span> .<\/span> "'"<\/span>;<\/span><\/div><\/li>
  61. \t\t\t\t}<\/span><\/div><\/li>
  62. \t\t\t}<\/span><\/div><\/li>
  63. \t\t\t$query<\/span> =<\/span> "INSERT INTO "<\/span> .<\/span> $tbl<\/span> .<\/span> " <\/span><\/div><\/li>
  64. \t\t\t("<\/span> .<\/span> implode<\/span><\/a>(<\/span>", "<\/span>,<\/span> array_keys<\/span><\/a>(<\/span>$data<\/span>)<\/span>)<\/span> .<\/span> ") <\/span><\/div><\/li>
  65. \t\t\tVALUES ("<\/span> .<\/span> implode<\/span><\/a>(<\/span>", "<\/span>,<\/span> $data<\/span>)<\/span> .<\/span> ")"<\/span>;<\/span><\/div><\/li>
  66. \t\t\treturn<\/span> $this<\/span>-><\/span>query<\/span>(<\/span>$query<\/span>)<\/span> ? mysql_insert_id<\/span><\/a>(<\/span>)<\/span> :<\/span> false<\/span>;<\/span><\/div><\/li>
  67. \t\t}<\/span><\/div><\/li>
  68. \t\telse<\/span> {<\/span> return<\/span> false<\/span>;<\/span> }<\/span><\/div><\/li>
  69. \t}<\/span>\t<\/div><\/li>
  70.  <\/div><\/li>
  71. \tpublic<\/span> function<\/span> update(<\/span>$tbl<\/span>=<\/span>false<\/span>,<\/span> $where<\/span>=<\/span>false<\/span>,<\/span> $data<\/span>=<\/span>array<\/span><\/a>(<\/span>)<\/span>)<\/span> {<\/span><\/div><\/li>
  72. \t\tif<\/span> (<\/span>$tbl<\/span> &&<\/span> $where<\/span> &&<\/span> count<\/span><\/a>(<\/span>$data<\/span>)<\/span> ><\/span> 0<\/span>)<\/span> {<\/span><\/div><\/li>
  73. \t\t\t$set<\/span> =<\/span> array<\/span><\/a>(<\/span>)<\/span>;<\/span><\/div><\/li>
  74. \t\t\tforeach<\/span> (<\/span>$data<\/span> as<\/span> $key<\/span> =><\/span> $d<\/span>)<\/span> {<\/span><\/div><\/li>
  75. \t\t\t\t$line<\/span> =<\/span> $key<\/span> .<\/span> "="<\/span>;<\/span> <\/div><\/li>
  76. \t\t\t\t$line<\/span> .=<\/span> !<\/span>is_numeric<\/span><\/a>(<\/span>$d<\/span>)<\/span> ? "'"<\/span> .<\/span> $this<\/span>-><\/span>quote<\/span>(<\/span>$d<\/span>)<\/span> .<\/span> "'"<\/span> :<\/span> $d<\/span>;<\/span>\t<\/div><\/li>
  77. \t\t\t\t$set<\/span>[<\/span>]<\/span> =<\/span> $line<\/span>;<\/span>\t\t<\/div><\/li>
  78. \t\t\t}<\/span><\/div><\/li>
  79. \t\t\t$query<\/span> =<\/span> "UPDATE "<\/span> .<\/span> $tbl<\/span> .<\/span> " <\/span><\/div><\/li>
  80. \t\t\tSET "<\/span> .<\/span> implode<\/span><\/a>(<\/span>", "<\/span>,<\/span> $set<\/span>)<\/span> .<\/span> " <\/span><\/div><\/li>
  81. \t\t\tWHERE "<\/span> .<\/span> $where<\/span>;<\/span><\/div><\/li>
  82. \t\t\treturn<\/span> $this<\/span>-><\/span>query<\/span>(<\/span>$query<\/span>)<\/span>;<\/span><\/div><\/li>
  83. \t\t}<\/span><\/div><\/li>
  84. \t\telse<\/span> {<\/span> return<\/span> false<\/span>;<\/span> }<\/span><\/div><\/li>
  85. \t}<\/span><\/div><\/li>
  86.  <\/div><\/li>
  87. \tpublic<\/span> function<\/span> delete(<\/span>$tbl<\/span>=<\/span>false<\/span>,<\/span> $where<\/span>=<\/span>false<\/span>)<\/span> {<\/span><\/div><\/li>
  88. \t\tif<\/span> (<\/span>$tbl<\/span> &&<\/span> $where<\/span>)<\/span> {<\/span> <\/div><\/li>
  89. \t\t\treturn<\/span> $this<\/span>-><\/span>query<\/span>(<\/span>"DELETE FROM "<\/span> .<\/span> $tbl<\/span> .<\/span> " WHERE "<\/span> .<\/span> $where<\/span>)<\/span>;<\/span><\/div><\/li>
  90. \t\t}<\/span><\/div><\/li>
  91. \t\telse<\/span> {<\/span> return<\/span> false<\/span>;<\/span> }<\/span><\/div><\/li>
  92. \t}<\/span><\/div><\/li>
  93.  <\/div><\/li>
  94. \tpublic<\/span> function<\/span> debug(<\/span>$a<\/span>)<\/span> {<\/span><\/div><\/li>
  95. \t\techo<\/span> "<pre>"<\/span>;<\/span><\/div><\/li>
  96. \t\tprint_r<\/span><\/a>(<\/span>$a<\/span>)<\/span>;<\/span><\/div><\/li>
  97. \t\techo<\/span> "<\/pre>"<\/span>;<\/span><\/div><\/li>
  98. \t}<\/span><\/div><\/li>
  99.  <\/div><\/li>
  100. }<\/span><\/div><\/li><\/ol><\/pre>","link":"https:\/\/snipplr.com\/view\/27966\/class-db"});