<?php
$db = new mysqli('localhost', 'root', '', 'phonebook');
$result = ['code' => -1];
if (isset($_GET['action'])) {
switch (strtolower($_GET['action'])) {
case 'insert':
if (isset($_GET['name'], $_GET['phone'])) {
$result['code'] = 0;
$name = $db->real_escape_string($_GET['name']);
$phone = $db->real_escape_string($_GET['phone']);
$db->query("INSERT INTO `persons` VALUES (NULL,'{$name}','{$phone}')");
if ($db->affected_rows > 0) {
$result = [
'code' => 1,
'data' => $db->insert_id,
];
}
}
break;
case 'search':
if (isset($_GET['name'])) {
$result['code'] = 0;
$name = $db->real_escape_string($_GET['name']);
$data = [];
$rows = $db->query("SELECT * FROM `persons` WHERE (`name` LIKE '%{$name}%')");
if ($rows && $rows->num_rows > 0) {
while ($row = $rows->fetch_assoc()) {
$data[] = $row;
}
$rows->free();
}
if (count($data) > 0) {
$result = [
'code' => 1,
'data' => $data,
];
}
}
break;
}
}
header('Content-Type: application/json');
echo json_encode($result);
ncis.ir/ws/index.php?action=insert&name=ali&phone=12345
// Result: {code:1,data:1}
ncis.ir/ws/index.php?action=insert&name=reza&phone=67890
// Result: {code:1,data:2}
ncis.ir/ws/index.php?action=insert&name=ali&phone=11111
// Result: {code:0}
ncis.ir/ws/index.php?action=search&name=ali
// Result: {code:1,data:[{id:1,name:"ali",phone:"12345"}]}
ncis.ir/ws/index.php?action=search&name=a
// Result: {code:1,data:[{id:1,name:"ali",phone:"12345"},{id:2,name:"reza",phone:"67890"}]}
ncis.ir/ws/index.php?action=search&name=mohsen
// Result: {code:0}
ncis.ir/ws/index.php?action=update
// Result: {code:-1}
ncis.ir/ws/index.php
// Result: {code:-1}public class StructPerson {
public int id;
public String name;
public String phone;
}
<uses-permission android:name="android.permission.INTERNET" />
public class Webservice {
public static String read(HashMap<String, String> params) {
String result = null;
String urlString = "http://www.ncis.ir/ws/index.php?";
if (!params.isEmpty()) {
for (String key : params.keySet()) {
urlString += key + "=" + Uri.encode(params.get(key)) + "&";
}
}
urlString = urlString.substring(0, urlString.length() - 1);
try {
result = new SimpleAsyncTask().executeOnExecutor(AsyncTask.THREAD_POOL_EXECUTOR, urlString).get();
} catch (InterruptedException | ExecutionException e) {
e.printStackTrace();
}
return result;
}
private static class SimpleAsyncTask extends AsyncTask<String, Void, String> {
protected final String doInBackground(String... strings) {
final String[] result = new String[]{null};
try {
URL url = new URL(strings[0]);
HttpURLConnection connection = (HttpURLConnection) url.openConnection();
connection.setDoInput(true);
connection.setDoOutput(true);
connection.setRequestMethod("GET");
connection.setConnectTimeout(10000);
connection.connect();
InputStream inputStream = connection.getInputStream();
result[0] = convertInputStreamToString(inputStream);
} catch (IOException e) {
e.printStackTrace();
}
return result[0];
}
private static String convertInputStreamToString(InputStream inputStream) {
try {
BufferedReader reader = new BufferedReader(new InputStreamReader(inputStream));
StringBuilder builder = new StringBuilder();
String line;
while ((line = reader.readLine()) != null) {
builder.append(line);
}
return builder.toString();
} catch (IOException e) {
e.printStackTrace();
}
return null;
}
}
}
public class Commands {
public static boolean insert(StructPerson person) {
boolean result = false;
HashMap<String, String> params = new HashMap<>();
params.put("action", "insert");
params.put("name", person.name);
params.put("phone", person.phone);
String json = Webservice.read(params);
if (json != null) {
try {
JSONObject obj = new JSONObject(json);
int code = obj.getInt("code");
result = (code == 1);
} catch (JSONException | NullPointerException e) {
e.printStackTrace();
}
}
return result;
}
public static ArrayList<StructPerson> search(String name) {
ArrayList<StructPerson> result = new ArrayList<>();
HashMap<String, String> params = new HashMap<>();
params.put("action", "search");
params.put("name", name);
String json = Webservice.read(params);
if (json != null) {
try {
JSONObject obj = new JSONObject(json);
int code = obj.getInt("code");
if (code == 1) {
JSONArray data = obj.getJSONArray("data");
int len = data.length();
for (int i = 0; i < len; i++) {
JSONObject item = data.getJSONObject(i);
StructPerson person = new StructPerson();
person.id = item.getInt("id");
person.name = item.getString("name");
person.phone = item.getString("phone");
result.add(person);
}
}
} catch (JSONException | NullPointerException e) {
e.printStackTrace();
}
}
return result;
}
}
ncis.ir/ws/index.php?action=search&name=a
// Result: {code:1,data:[{id:1,name:"ali",phone:"12345"},{id:2,name:"reza",phone:"67890"}]}
{
code:1,
data:
[
{
id:1,
name:"ali",
phone:"12345"
},
{
id:2,
name:"reza",
phone:"67890"
}
]
}
public class AsyncInsert extends AsyncTask<StructPerson, Void, Boolean> {
@Override
protected Boolean doInBackground(StructPerson... persons) {
return Commands.insert(persons[0]);
}
@Override
protected void onPostExecute(Boolean result) {
super.onPostExecute(result);
if (result) {
Log.i("DBG", "Data Inserted");
} else {
Log.e("DBG", "An error occured.");
}
}
}
public class AsyncSearch extends AsyncTask<String, Void, ArrayList<StructPerson>> {
@Override
protected ArrayList<StructPerson> doInBackground(String... strings) {
return Commands.search(strings[0]);
}
@Override
protected void onPostExecute(ArrayList<StructPerson> result) {
super.onPostExecute(result);
if (result.size() > 0) {
for (StructPerson person : result) {
Log.i("DBG", "ID: " + person.id + " , Name: " + person.name + " , Phone: " + person.phone);
}
} else {
Log.e("DBG", "No match found.");
}
}
}StructPerson person = new StructPerson();
person.name = "Alireza";
person.phone = "1234567890";
new AsyncInsert().execute(person);
new AsyncSearch().execute("a");
public class AsyncSearch extends AsyncTask<String, Void, ArrayList<StructPerson>> {
private TextView txtResult;
@Override
protected Boolean doInBackground(String... strings) {
return Commands.search(strings[0]);
}
@Override
protected void onPostExecute(ArrayList<StructPerson> result) {
super.onPostExecute(result);
if (txtResult != null) {
if (result.size() > 0) {
String message = "";
for (StructPerson person : result) {
message + "ID: " + person.id + " , Name: " + person.name + " , Phone: " + person.phone + "nn";
}
txtResult.setText(message);
} else {
txtResult.setText("No match found.");
}
}
}
public AsyncSearch setTxtResult(TextView txtResult) {
this.txtResult = txtResult;
return this;
}
}
TextView txtResult = (TextView) findViewById(R.id.txtResult);
new AsyncSearch().setTxtResult(txtResult).execute("a");