get.php 1.1 KB

123456789101112131415161718192021222324252627282930313233343536373839
  1. <?php
  2. //查询group 列表
  3. require_once "../path.php";
  4. require_once "../public/_pdo.php";
  5. require_once '../public/function.php';
  6. require_once '../ucenter/function.php';
  7. $output = array();
  8. if(isset($_GET["id"])){
  9. PDO_Connect("sqlite:"._FILE_DB_GROUP_);
  10. $id=$_GET["id"];
  11. $query = "SELECT * FROM group_info WHERE id = ? ";
  12. $Fetch = PDO_FetchRow($query,array($id));
  13. if($Fetch){
  14. $output["info"] = $Fetch;
  15. if($Fetch["parent"]==0 ){
  16. #列出小组
  17. $query = "SELECT * FROM group_info WHERE parent = ? ";
  18. $FetchList = PDO_FetchAll($query,array($id));
  19. $output["children"] = $FetchList;
  20. }
  21. else{
  22. $output["children"] = array();
  23. $query = "SELECT * FROM group_info WHERE id = ? ";
  24. $parent_group = PDO_FetchRow($query,array($Fetch["parent"]));
  25. $output["parent"] = $parent_group;
  26. }
  27. #列出文件
  28. if(isset($_GET["list"]) && $_GET["list"]=="file"){
  29. PDO_Connect("sqlite:"._FILE_DB_FILEINDEX_);
  30. $query = "SELECT * FROM group_share WHERE group_id = ? ";
  31. $fileList = PDO_FetchAll($query,array($id));
  32. $output["file"] = $fileList;
  33. }
  34. }
  35. }
  36. echo json_encode($output, JSON_UNESCAPED_UNICODE);
  37. ?>