my_channal_get.php 1.4 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. <?php
  2. //获取我的channel 列表,已经废弃
  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_,_DB_USERNAME_,_DB_PASSWORD_);
  10. $id=$_GET["id"];
  11. $query = "SELECT uid as id ,owner_uid as owner, name , summary , status , lang , create_time,modify_time FROM "._TABLE_CHANNEL_." WHERE uid=? ";
  12. $Fetch = PDO_FetchRow($query,array($id));
  13. #TODO获取协作者
  14. /*
  15. if($Fetch){
  16. $user_info = new UserInfo();
  17. $group_info = new GroupInfo();
  18. $query = "SELECT * FROM cooperation WHERE channal_id = ? ";
  19. $coop = PDO_FetchAll($query,array($id));
  20. foreach ($coop as $key => $value) {
  21. # code...
  22. if($value["type"]==0){
  23. $coop[$key]["user_name"] = $user_info->getName($value["user_id"]);
  24. }
  25. else if($value["type"]==1){
  26. $coop[$key]["user_name"] = $group_info->getName($value["user_id"]);
  27. }
  28. }
  29. $Fetch["coop"]=$coop;
  30. }
  31. */
  32. echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
  33. }
  34. else{
  35. PDO_Connect(_FILE_DB_CHANNAL_,_DB_USERNAME_,_DB_PASSWORD_);
  36. $query = "SELECT uid as id ,owner_uid as owner, name , summary , status , lang , create_time,modify_time FROM "._TABLE_CHANNEL_." WHERE owner_uid = ? ";
  37. $Fetch = PDO_FetchAll($query,array($_COOKIE["user_uid"]));
  38. echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
  39. }
  40. ?>