list.php 739 B

123456789101112131415161718192021222324
  1. <?php
  2. //查询group 列表
  3. require_once "../config.php";
  4. require_once "../public/_pdo.php";
  5. require_once '../public/function.php';
  6. require_once '../ucenter/function.php';
  7. //列出 我j参与的群组
  8. PDO_Connect(_FILE_DB_GROUP_);
  9. $query = "SELECT group_name,group_id,power FROM "._TABLE_GROUP_MEMBER_." WHERE level = 0 and user_id=?";
  10. $Fetch = PDO_FetchAll($query, array($_COOKIE["user_uid"]));
  11. foreach ($Fetch as $key => $value) {
  12. # code...
  13. $query = "SELECT name FROM "._TABLE_GROUP_INFO_." WHERE uid=?";
  14. $groupInfo = PDO_FetchRow($query, array($value["group_id"]));
  15. if($groupInfo){
  16. $Fetch[$key]["group_name"]=$groupInfo["name"];
  17. }
  18. else{
  19. $Fetch[$key]["group_name"]="";
  20. }
  21. }
  22. echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);