001.<?php
002.header("Content-type:application/json; charset=UTF-8");
003.header("Cache-Control: no-store, no-cache, must-revalidate");
004.header("Cache-Control: post-check=0, pre-check=0", false);
005.require_once("inc/dbconnect.php");
006.
007.
008.if(isset($_POST['action']) && $_POST['action']=="list"){
009.
010.
011. $per_page = 3;
012.
013.
014. $total = 0;
015. $start_page = 0;
016. $cur_page = 1;
017. $chk_page = 0;
018.
019.
020. $sql = "
021. SELECT * FROM tbl_members WHERE 1
022. ";
023.
024.
025. $result = $mysqli->query($sql);
026. if($result && $result->num_rows > 0){
027. $total = $result->num_rows;
028. }
029.
030. if(isset($_POST['page']) && $_POST['page']>0){
031.
032. $chk_page = $_POST['page'];
033. $cur_page = $_POST['page']+1;
034. $start_page = $_POST['page']*$per_page;
035. }
036. $sql.="
037. LIMIT ".$start_page.",".$per_page."
038. ";
039. $i=0;
040. $result = $mysqli->query($sql);
041. if($result && $result->num_rows > 0){
042. while($row = $result->fetch_assoc()){
043. $i++;
044.
045.
046. $json_data['data'][] = array(
047. "item_id" => ($chk_page*$per_page)+$i,
048. "mem_id" => $row['member_id'],
049. "mem_user" => $row['member_username'],
050. "mem_pass" => $row['member_password'],
051. "mem_fullname" => $row['member_fullname'],
052. "mem_type" => $row['member_type']
053. );
054. }
055.
056. if($result->num_rows > 0){
057. $json_data['curpage'] = $cur_page;
058. $json_data['perpage'] = $per_page;
059. $json_data['total'] = $total;
060. $json_data['allpage'] = ceil($total/$per_page);
061. }
062. }
063.
064.}
065.
066.
067.
068.
069.
070.
071.if(isset($_POST['action']) && $_POST['action']=="item"){
072.
073. if(isset($_POST['chk_user_id']) && $_POST['chk_user_id']!=""){
074. $sql = "
075. SELECT * FROM tbl_members WHERE member_id='".$_POST['chk_user_id']."'
076. ";
077. $result = $mysqli->query($sql);
078. if($result && $result->num_rows > 0){
079. $row = $result->fetch_assoc();
080. $json_data['data'][] = array(
081. "mem_id" => $row['member_id'],
082. "mem_user" => $row['member_username'],
083. "mem_pass" => $row['member_password'],
084. "mem_fullname" => $row['member_fullname'],
085. "mem_type" => $row['member_type']
086. );
087. }
088. }
089.
090.
091.}
092.
093.
094.
095.
096.
097.
098.if(isset($_POST['action']) && $_POST['action']=="delete"){
099. $_error_msg = null;
100. $_success_msg = null;
101. if(isset($_POST['del_user_id']) && $_POST['del_user_id']!=""){
102. $sql = "
103. DELETE FROM tbl_members WHERE member_id='".$_POST['del_user_id']."'
104. ";
105. $result = $mysqli->query($sql);
106. if($result && $mysqli->affected_rows>0){
107. $_success_msg = "Delete user data successful!";
108. }else{
109. $_error_msg = "Eror, please try again!";
110. }
111. }else{
112. $_error_msg = "Eror, please try again!";
113. }
114. $json_data[]=array(
115. "success" => $_success_msg,
116. "error" => $_error_msg
117. );
118.
119.}
120.
121.
122.
123.
124.
125.
126.if(isset($_POST['action']) && $_POST['action']=="edit"){
127. $_error_msg = null;
128. $_success_msg = null;
129.
130. if(isset($_POST['userid']) && $_POST['userid']!=""){
131. $sql = "
132. UPDATE tbl_members SET
133. member_username='".$_POST['username']."',
134. member_password='".$_POST['password']."',
135. member_fullname='".$_POST['fullname']."',
136. member_type='".$_POST['usertype']."'
137. WHERE member_id=".$_POST['userid']."
138. ";
139. $result = $mysqli->query($sql);
140. if($result){
141. if($mysqli->affected_rows>0){
142. $_success_msg = "Change user data successful!";
143. }else{
144. $_success_msg = "Update user successful!";
145. }
146. }else{
147. $_error_msg = "Eror, please try again!";
148. }
149. }
150. $json_data[]=array(
151. "success" => $_success_msg,
152. "error" => $_error_msg
153. );
154.
155.}
156.
157.
158.
159.
160.
161.
162.if(isset($_POST['action']) && $_POST['action']=="add"){
163. $_error_msg = null;
164. $_success_msg = null;
165.
166. $sql = "
167. INSERT INTO tbl_members SET
168. member_username='".$_POST['username']."',
169. member_password='".$_POST['password']."',
170. member_fullname='".$_POST['fullname']."',
171. member_type='".$_POST['usertype']."'
172. ";
173. $result = $mysqli->query($sql);
174. if($result && $mysqli->affected_rows>0){
175. $insert_userID = $mysqli->insert_id;
176. $_success_msg = "Add new user successful!";
177. }else{
178. $_error_msg = "Eror, please try again!";
179. }
180. $json_data[]=array(
181. "success" => $_success_msg,
182. "error" => $_error_msg
183. );
184.
185.}
186.
187.
188.
189.
190.if(isset($json_data)){
191. $json= json_encode($json_data);
192. if(isset($_GET['callback']) && $_GET['callback']!=""){
193. echo $_GET['callback']."(".$json.");";
194. }else{
195. echo $json;
196. }
197.}
