2
0

my_channal_get.php 1.1 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. <?php
  2. //查询term字典
  3. require_once "../config.php";
  4. require_once "../public/_pdo.php";
  5. require_once '../public/function.php';
  6. require_once '../ucenter/function.php';
  7. require_once '../group/function.php';
  8. if(isset($_GET["id"])){
  9. PDO_Connect(""._FILE_DB_CHANNAL_);
  10. $id=$_GET["id"];
  11. $query = "SELECT * FROM channal WHERE id = ? ";
  12. $Fetch = PDO_FetchRow($query,array($id));
  13. #获取协作者
  14. if($Fetch){
  15. $user_info = new UserInfo();
  16. $group_info = new GroupInfo();
  17. $query = "SELECT * FROM cooperation WHERE channal_id = ? ";
  18. $coop = PDO_FetchAll($query,array($id));
  19. foreach ($coop as $key => $value) {
  20. # code...
  21. if($value["type"]==0){
  22. $coop[$key]["user_name"] = $user_info->getName($value["user_id"]);
  23. }
  24. else if($value["type"]==1){
  25. $coop[$key]["user_name"] = $group_info->getName($value["user_id"]);
  26. }
  27. }
  28. $Fetch["coop"]=$coop;
  29. }
  30. echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
  31. }
  32. else{
  33. PDO_Connect(""._FILE_DB_CHANNAL_);
  34. $query = "SELECT * FROM channal WHERE owner = ? ";
  35. $Fetch = PDO_FetchAll($query,array($_COOKIE["userid"]));
  36. echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
  37. }
  38. ?>