function.php 1.5 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061
  1. <?php
  2. require_once "../path.php";
  3. require_once "../public/_pdo.php";
  4. require_once '../public/function.php';
  5. require_once '../ucenter/function.php';
  6. function group_get_name($id)
  7. {
  8. if (isset($id)) {
  9. PDO_Connect("" . _FILE_DB_GROUP_);
  10. $query = "SELECT name FROM group_info WHERE id=?";
  11. $Fetch = PDO_FetchRow($query, array($id));
  12. if ($Fetch) {
  13. return $Fetch["name"];
  14. } else {
  15. return "";
  16. }
  17. } else {
  18. return "";
  19. }
  20. }
  21. class GroupInfo
  22. {
  23. private $dbh;
  24. private $buffer;
  25. public function __construct()
  26. {
  27. $dns = "" . _FILE_DB_GROUP_;
  28. $this->dbh = new PDO($dns, "", "", array(PDO::ATTR_PERSISTENT => true));
  29. $this->dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
  30. $buffer = array();
  31. }
  32. public function getName($id)
  33. {
  34. if (empty($id)) {
  35. return "";
  36. }
  37. if (isset($buffer[$id])) {
  38. return $buffer[$id];
  39. }
  40. if ($this->dbh) {
  41. $query = "SELECT name FROM group_info WHERE id= ? ";
  42. $stmt = $this->dbh->prepare($query);
  43. $stmt->execute(array($id));
  44. $user = $stmt->fetch(PDO::FETCH_ASSOC);
  45. if ($user) {
  46. $buffer[$id] = $user["name"];
  47. return $buffer[$id];
  48. } else {
  49. $buffer[$id] = "";
  50. return $buffer[$id];
  51. }
  52. } else {
  53. $buffer[$id] = "";
  54. return $buffer[$id];
  55. }
  56. }
  57. }