| 1234567891011121314151617181920212223242526272829303132333435363738394041424344 |
- <?php
- //查询term字典
- require_once "../path.php";
- require_once "../public/_pdo.php";
- require_once '../public/function.php';
- require_once '../ucenter/function.php';
- require_once '../group/function.php';
- if(isset($_GET["id"])){
- PDO_Connect(""._FILE_DB_CHANNAL_);
- $id=$_GET["id"];
- $query = "SELECT * FROM channal WHERE id = ? ";
- $Fetch = PDO_FetchRow($query,array($id));
- #获取协作者
- if($Fetch){
- $user_info = new UserInfo();
- $group_info = new GroupInfo();
- $query = "SELECT * FROM cooperation WHERE channal_id = ? ";
- $coop = PDO_FetchAll($query,array($id));
- foreach ($coop as $key => $value) {
- # code...
- if($value["type"]==0){
- $coop[$key]["user_name"] = $user_info->getName($value["user_id"]);
- }
- else if($value["type"]==1){
- $coop[$key]["user_name"] = $group_info->getName($value["user_id"]);
- }
- }
- $Fetch["coop"]=$coop;
- }
- echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
- }
- else{
- PDO_Connect(""._FILE_DB_CHANNAL_);
- $query = "SELECT * FROM channal WHERE owner = ? ";
- $Fetch = PDO_FetchAll($query,array($_COOKIE["user_uid"]));
- echo json_encode($Fetch, JSON_UNESCAPED_UNICODE);
- }
- ?>
|