Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- require_once 'DBhost.php';
- $response = array();
- if(isset($_GET['apicall'])){
- switch($_GET['apicall']){
- case 'signup':
- if(isTheseParametersAvailable(array('email','password','nama','gambar','skills','nope','alamat'))){
- $email = $_POST['email'];
- $password = md5($_POST['password']);
- $nama = $_POST['nama'];
- $gambar = $_POST['gambar'];
- $skills = $_POST['skills'];
- $nope = $_POST['nope'];
- $alamat = $_POST['alamat'];
- $stmt = $conn->prepare("SELECT email,password,nama,gambar,skills,nope,alamat FROM user WHERE email = ?");
- $stmt->bind_param("s",$email);
- $stmt->execute();
- $stmt->store_result();
- if($stmt->num_rows > 0){
- $response['error'] = true;
- $response['message'] = 'User already registered';
- $stmt->close();
- }else{
- $stmt = $conn->prepare("INSERT INTO user (email, password, nama, gambar, skills, nope, alamat) VALUES (?, ?, ?, ?, ?, ?, ?)");
- $stmt->bind_param("ssssssss", $email, $password, $nama, $skills, $gambar, $nope, $alamat);
- if($stmt->execute()){
- $stmt = $conn->prepare("SELECT id, email, password, nama, gambar, skills, nope, alamat FROM user WHERE email = ?");
- $stmt->bind_param("s",$email);
- $stmt->execute();
- $stmt->bind_result($id,$email,$password,$nama,$gambar,$skills,$nope,$alamat);
- $stmt->fetch();
- $user = array(
- 'id'=>$id,
- 'email'=>$email,
- 'password'=>$password,
- 'nama'=>$nama,
- 'gambar'=>$gambar,
- 'skills'=>$skills,
- 'nope'=>$nope,
- 'alamat'=>$alamat
- );
- $stmt->close();
- $response['error'] = false;
- $response['message'] = 'User registered successfully';
- $response['user'] = $user;
- }
- }
- }else{
- $response['error'] = true;
- $response['message'] = 'required parameters are not available';
- }
- break;
- case 'edit':
- if(isTheseParametersAvailable(array('email','password','nama','gambar','skills','nope','alamat'))){
- $email = $_POST['email'];
- $password = md5($_POST['password']);
- $nama = $_POST['nama'];
- $gambar = $_POST['gambar'];
- $skills = $_POST['skills'];
- $nope = $_POST['nope'];
- $alamat = $_POST['alamat'];
- $stmt = $conn->prepare("SELECT email,password,nama,gambar,skills,nope,alamat FROM user WHERE email=?");
- $stmt->bind_param("s",$email);
- $stmt->execute();
- $stmt->store_result();
- if($stmt->num_rows > 0){
- $stmt = $conn->prepare("UPDATE user SET password=?, nama=?, gambar=?, skills=?, nope=?, alamat=? WHERE email=?");
- $stmt->bind_param("ssssss", $password, $nama, $gambar, $skills, $nope, $alamat);
- if($stmt->execute()){
- $stmt = $conn->prepare("SELECT id, email, password, nama, gambar, skills, nope, alamat FROM user WHERE email=?");
- $stmt->bind_param("s",$email);
- $stmt->execute();
- $stmt->bind_result($id,$email,$password,$nama,$gambar,$skills,$nope,$alamat);
- $stmt->fetch();
- $user = array(
- 'id'=>$id,
- 'email'=>$email,
- 'password'=>$password,
- 'nama'=>$nama,
- 'gambar'=>$gambar,
- 'skills'=>$skills,
- 'nope'=>$nope,
- 'alamat'=>$alamat
- );
- $stmt->close();
- $response['error'] = false;
- $response['message'] = 'User edited successfully';
- $response['user'] = $user;
- }
- }else{
- $response['error'] = true;
- $response['message'] = 'User not found';
- $stmt->close();
- }
- }else{
- $response['error'] = true;
- $response['message'] = 'required parameters are not available';
- }
- break;
- case 'login':
- if(isTheseParametersAvailable(array('email', 'password'))){
- $email = $_POST['email'];
- $password = md5($_POST['password']);
- $stmt = $conn->prepare("SELECT id, email,password FROM user WHERE email = ? AND password = ?");
- $stmt->bind_param("ss",$email, $password);
- $stmt->execute();
- $stmt->store_result();
- if($stmt->num_rows > 0){
- $stmt->bind_result($id, $email,$password);
- $stmt->fetch();
- $user = array(
- 'id'=>$id,
- 'email'=>$email,
- 'password'=>$password
- );
- $response['error'] = false;
- $response['message'] = 'Login successfull';
- $response['user'] = $user;
- }else{
- $response['error'] = false;
- $response['message'] = 'Invalid username or password';
- }
- }
- break;
- case 'edit':
- if(isTheseParametersAvailable(array('email','password'))){
- $email = $_POST['email'];
- $password = md5($_POST['password']);
- $nama = $_POST['nama'];
- $gambar = $_POST['gambar'];
- $nope = $_POST['nope'];
- $alamat = $_POST['alamat'];
- $skills = $_POST['skills'];
- $stmt = $conn->prepare("SELECT email,password FROM user WHERE email=?");
- $stmt->bind_param("s",$email);
- $stmt->execute();
- $stmt->store_result();
- if($stmt->num_rows > 0){
- $stmt = $conn->prepare("UPDATE user SET password=? WHERE email=?");
- $stmt->bind_param("ss", $password, $email);
- if($stmt->execute()){
- $stmt = $conn->prepare("SELECT id, email, password FROM user WHERE email=?");
- $stmt->bind_param("s",$email);
- $stmt->execute();
- $stmt->bind_result($id,$email,$password);
- $stmt->fetch();
- $user = array(
- 'id'=>$id,
- 'email'=>$email,
- 'password'=>$password
- );
- $stmt->close();
- $response['error'] = false;
- $response['message'] = 'User edited successfully';
- $response['user'] = $user;
- }
- }else{
- $response['error'] = true;
- $response['message'] = 'User not found';
- $stmt->close();
- }
- }else{
- $response['error'] = true;
- $response['message'] = 'required parameters are not available';
- }
- break;
- default:
- $response['error'] = true;
- $response['message'] = 'Invalid Operation Called';
- }
- }else{
- $response['error'] = true;
- $response['message'] = 'Invalid API Call';
- }
- echo json_encode($response); //sudah ada ini, sesuai format android di tutorial
- function isTheseParametersAvailable($params){
- foreach($params as $param){
- if(!isset($_POST[$param])){
- return false;
- }
- }
- return true;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement