gd.php 1.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091
  1. <?php
  2. class gd_m extends Model
  3. {
  4. function __construct()
  5. {
  6. parent::Model();
  7. }
  8. function gd_m()
  9. {
  10. $this->__construct();
  11. }
  12. function get_list()
  13. {
  14. $sql = "SELECT * FROM ".$this->db->prefix."gd ORDER BY taxis ASC,id DESC";
  15. return $this->db->get_all($sql);
  16. }
  17. function get_one($id)
  18. {
  19. $sql = "SELECT * FROM ".$this->db->prefix."gd WHERE id='".$id."'";
  20. return $this->db->get_one($sql);
  21. }
  22. //存储信息
  23. function save($data,$id=0)
  24. {
  25. if($id)
  26. {
  27. $this->db->update_array($data,"gd",array("id"=>$id));
  28. return $id;
  29. }
  30. else
  31. {
  32. $insert_id = $this->db->insert_array($data,"gd");
  33. return $insert_id;
  34. }
  35. }
  36. //
  37. function chk_sign($sign="")
  38. {
  39. if(!$sign)
  40. {
  41. return false;
  42. }
  43. $sql = "SELECT * FROM ".$this->db->prefix."gd WHERE pictype='".$sign."'";
  44. if($this->db->get_one($sql))
  45. {
  46. return false;
  47. }
  48. else
  49. {
  50. return true;
  51. }
  52. }
  53. //删除操作
  54. function del($id)
  55. {
  56. if(!$id)
  57. {
  58. return false;
  59. }
  60. $sql = "DELETE FROM ".$this->db->prefix."gd WHERE id='".$id."'";
  61. return $this->db->query($sql);
  62. }
  63. function gd_list($code="")
  64. {
  65. if(!$code)
  66. {
  67. return false;
  68. }
  69. $sql = "SELECT * FROM ".$this->db->prefix."upfiles_gd WHERE gdtype='".$code."'";
  70. return $this->db->get_all($sql);
  71. }
  72. function gd_del($code="")
  73. {
  74. if(!$code)
  75. {
  76. return false;
  77. }
  78. $sql = "DELETE FROM ".$this->db->prefix."upfiles_gd WHERE gdtype='".$code."'";
  79. return $this->db->query($sql);
  80. }
  81. }
  82. ?>