-
Notifications
You must be signed in to change notification settings - Fork 0
/
user.php
149 lines (132 loc) · 4.18 KB
/
user.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
<?php
include './utils.php';
$sql_con = new mysqli('localhost:3306','root','1994woaini');
if(!$sql_con){
die(json_encode(array('code' => -3,'msg' => '服务器无法连接数据库')));
}
$sql_con->select_db('yuewen');
$method = $_POST['method'];
switch ($method){
case 'register':
register();
break;
case 'login':
login();
break;
case 'getusertoken':
getIMToken();
break;
case 'usericon':
userIcon();
break;
default:
die(toJsonString(-4,'未知method'));
break;
}
function login(){
global $sql_con;
$name = $_POST['name'];
$password = $_POST['password'];
$result = $sql_con->query("select uid,uname,uicon from userinfo where uname = '$name' and upassword = '$password'");
if(!$result){
die(toJsonString(-5,'用户名或密码错误'));
}
if($result->num_rows===0){
die(toJsonString(-5,'用户名或密码错误'));
}
$id_result = $result->fetch_assoc();
if($id_result!=null){
die(toJsonString(0,'登录成功',array($id_result)));
}
}
function register(){
global $sql_con;
$name = $_POST['name'];
$password = $_POST['password'];
$icon = isset($_POST['icon'])?$_POST['icon']:null;
$nameexit = $sql_con->query("select uid from userinfo where uname = '$name'");
if($nameexit->num_rows>0){
die(toJsonString(-2,'昵称已被占用'));
}
$insertResult = $sql_con->query("insert into userinfo (uid,uname,upassword,uicon)
values (0,'$name','$password','$icon')");
if($insertResult){
//query语句返回结果为true或false或者一个结果集
die(toJsonString(0,'注册成功'));
}else{
die(toJsonString(-1,'插入数据库失败'));
}
}
/*
* 上传用户头像,插入用户数据失败要删除图片。
* 更换头像要删除原来的图片。
* 判断是否是初次上传。
* 数据中存储的图片链接最终转换为本地相对路径。
*/
function userIcon(){
global $sql_con;
$id = $_POST['uid'];
$url =$_POST['url'];//判断资源类型以及是否已经存储到images目录下。
// if(!($local_path = getLocalPath($url))){
// die(toJsonString(-7,'更换头像失败'));
$result = $sql_con->query("update userinfo set uicon = '$url' where uid = '$id'");
if(!$result){
die(toJsonString(-4,'更换头像失败'));
}else{
$result1 = $sql_con->query("select uicon from userinfo WHERE uid = $id");
$iconA = $result1->fetch_assoc();
$data = array();
$data[] = $iconA;
die(toJsonString(0,'更换头像成功',$data));
}
// };
// if(!$sql_con){
// unlink($local_path);
// die($array = toJsonString(-6,'更换头像失败'));
// }
//
// $sql_con->select_db("yuewen");
// $select_result = $sql_con->query("select uicon from userinfo where uid = '$id'");
// if(!$select_result){
// unlink($local_path);
// die(toJsonString(-2,'更换头像失败'));
// }else{
// $arr_result = $select_result->fetch_assoc();
//
//
//
//
// if($arr_result['icon']!=null){//不是初次上传。
// if(!unlink($arr_result['icon'])){//删除旧头像。
// //服务器保存日志,有一个残余文件。
// }
// }
// }
}
function getUserInfo(){
}
function getIMToken(){
include './RongCloudAPI/rongcloud.php';
$appKey = 'bmdehs6pbic6s';
$appSecret = 'Po5tLJyjbtdyln';
$jsonPath = "jsonsource/";
$RongCloud = new RongCloud($appKey,$appSecret);
$default_proatait = 'http://www.jf258.com/uploads/2014-08-17/175941870.jpg';
global $sql_con;
$uid = isset($_POST['uid'])?$_POST['uid']:false;
if(!$uid){
die(toJsonString(-10,'缺少用户名'));
}
else{
$uid = (int)$uid;
}
$query_result = $sql_con->query("select * from userinfo where uid = '$uid'");
if(!$query_result||$query_result->num_rows<1){
die(toJsonString(-2,'用户不存在'));
}
$userinfo = $query_result->fetch_assoc();
// 获取 Token 方法
$result = $RongCloud->user()->getToken($userinfo['uid'],$userinfo['uname'],$default_proatait);
print_r($result);
}
?>