Super Shared

<?php
//search.php
/*
 * Following code will search idiom based on keywords
 */
 
// array for JSON response
$response = array();
 
// include connect class
require_once __DIR__ . /connect.php;
 
// connecting to db
$db = new DB_CONNECT();

$keyword=$_GET["keyword"];
// get idioms based on keyword
/*
$result = mysql_query("SELECT * FROM a_senarai_e WHERE " .
 "MATCH(entri) AGAINST ($keyword ".
 "IN NATURAL LANGUAGE MODE)") or die(mysql_error());
*/

//using LIKE
$result = mysql_query("SELECT * FROM idiomlist WHERE entry LIKE %$keyword% LIMIT 0, 20") 
or die(mysql_error());
 
// check for empty result
if (mysql_num_rows($result) > 0) {
 // looping through all results
 $response["idioms"] = array();
 
 while ($row = mysql_fetch_array($result)) {
 // temp user array
 $idioms= array();
 $idioms["id"] = $row["id"];
 $idioms["entry"] = $row["entry"];
 $idioms["meaning"] = $row["meaning"];
 
 // push single idiom array into final response array
 array_push($response["idioms"], $idioms);
 }
 // success
 $response["success"] = 1;
 
 // echoing JSON response
 echo json_encode($response);
} else {
 // no products found
 $response["success"] = 0;
 $response["message"] = "No idioms found";
 
 // echo no users JSON
 echo json_encode($response);
}
?>

http://172.16.16.183/idiomjson/search.php?keyword=baik%20budi

{"idioms":[
 {"id":"106",
 "entry":"Baik budi ",
 "meaning":"Bersikap baik dan penyayang (suka menolong). "},
 
 {"id":"3401",
 "entry":"Yang merah saga, yang kurik kundi, yang indah bahasa, yang baik budi. ",
 "meaning":"Rupa yang elok sahaja, tidak disertakan budi bahasa akan tetap menjadi hina di kalangan masyarakat. "}
],"success":1}

<RelativeLayout >="http://schemas.android.com/apk/res/android"
 >="http://schemas.android.com/tools"
 android:layout_width="match_parent"
 android:layout_height="match_parent"
 android:paddingBottom="@dimen/activity_vertical_margin"
 android:paddingLeft="@dimen/activity_horizontal_margin"
 android:paddingRight="@dimen/activity_horizontal_margin"
 android:paddingTop="@dimen/activity_vertical_margin"
 tools:context=".Search" >

 <TableLayout
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:layout_alignParentBottom="true"
 android:layout_alignParentLeft="true"
 android:layout_alignParentRight="true"
 android:layout_alignParentTop="true" >

 <TableRow
 android:id="@+id/tableRow1"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content" >

 <TextView
 android:id="@+id/textView1"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content"
 android:text="Search for Idiom"
 android:textAppearance="?android:attr/textAppearanceLarge" />

 </TableRow>

 <TableRow
 android:id="@+id/tableRow2"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content" >

 <EditText
 android:id="@+id/txtkeyword"
 android:layout_width="0dp"
 android:layout_height="wrap_content"
 android:layout_weight="1"
 android:ems="10" >

 <requestFocus />
 </EditText>

 </TableRow>

 <TableRow
 android:id="@+id/tableRow3"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content" >

 <Button
 android:id="@+id/btnsearch"
 android:layout_width="0dp"
 android:layout_height="wrap_content"
 android:layout_weight="1"
 android:text="Search" />

 </TableRow>

 <TableRow
 android:id="@+id/tableRow4"
 android:layout_width="wrap_content"
 android:layout_height="wrap_content" >
 </TableRow>
 </TableLayout>

</RelativeLayout>

package net.kerul.searchjson;//change this to ur package name

import android.os.Bundle;
import android.app.Activity;
import android.content.Intent;
import android.view.Menu;
import android.view.View;
import android.view.View.OnClickListener;
import android.widget.Button;
import android.widget.EditText;

public class Search extends Activity implements OnClickListener {
 private EditText txtkeyword;
 private Button btnsearch;

 @Override
 protected void onCreate(Bundle savedInstanceState) {
 super.onCreate(savedInstanceState);
 setContentView(R.layout.activity_search);
 
 //link to UI
 txtkeyword=(EditText)findViewById(R.id.txtkeyword);
 btnsearch=(Button)findViewById(R.id.btnsearch);
 btnsearch.setOnClickListener(this);
 }
 @Override
 public void onClick(View v) {
 if(v.getId()==R.id.btnsearch){
 Intent searchIntent = new Intent(this, Search.class);
 //send the keyword to the next screen
 searchIntent.putExtra("key",txtkeyword.getText().toString());
 //call the screen for listing
 startActivity(searchIntent);
 }
 
 }

 @Override
 public boolean onCreateOptionsMenu(Menu menu) {
 // Inflate the menu; this adds items to the action bar if it is present.
 getMenuInflater().inflate(R.menu.search, menu);
 return true;
 }

}

<RelativeLayout >="http://schemas.android.com/apk/res/android"
 >="http://schemas.android.com/tools"
 android:layout_width="match_parent"
 android:layout_height="match_parent"
 android:paddingBottom="@dimen/activity_vertical_margin"
 android:paddingLeft="@dimen/activity_horizontal_margin"
 android:paddingRight="@dimen/activity_horizontal_margin"
 android:paddingTop="@dimen/activity_vertical_margin"
 tools:context=".ListResult" >

 <!-- Main ListView
 Always give id value as list(@android:id/list)
 -->
 <ListView
 android:id="@android:id/list"
 android:layout_width="fill_parent"
 android:layout_height="wrap_content"/>

</RelativeLayout>

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout >="http://schemas.android.com/apk/res/android"
 android:layout_width="fill_parent"
 android:layout_height="wrap_content"
 android:orientation="vertical" >
 
 <!-- Idioms id will be HIDDEN - used to pass to other activity -->
 <TextView
 android:id="@+id/id"
 android:layout_width="fill_parent"
 android:layout_height="wrap_content"
 android:visibility="gone" />
 
 <!-- Entry data display -->
 <TextView
 android:id="@+id/entry"
 android:layout_width="fill_parent"
 android:layout_height="wrap_content"
 android:textSize="17dip"
 android:textStyle="bold" />
 <!-- the Meaning data display -->
 <TextView
 android:id="@+id/meaning"
 android:layout_width="fill_parent"
 android:layout_height="wrap_content"
 android:textSize="14dip" />
 
</LinearLayout>

package net.kerul.searchjson;//change to your package name

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
 
import org.apache.http.NameValuePair;
import org.apache.http.message.BasicNameValuePair;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;
 
import android.app.ListActivity;
import android.app.ProgressDialog;
import android.content.Intent;
import android.os.AsyncTask;
import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.AdapterView;
import android.widget.AdapterView.OnItemClickListener;
import android.widget.ListAdapter;
import android.widget.ListView;
import android.widget.SimpleAdapter;
import android.widget.TextView;
import android.widget.Toast;
 
public class ListResult extends ListActivity {
 
 // Progress Dialog
 private ProgressDialog pDialog;
 
 // Creating JSON Parser object
 JSONParser jParser = new JSONParser();
 
 ArrayList<HashMap<String, String>> idiomsList;
 
 // url to get the idiom list
 private static String url_search = "http://172.16.16.183/idiomjson/search.php";
 
 // JSON Node names
 private static final String TAG_SUCCESS = "success";
 private static final String TAG_IDIOMS = "idioms";
 private static final String TAG_ID = "id";
 private static final String TAG_ENTRY = "entry";
 private static final String TAG_MEANING = "meaning";
 
 // products JSONArray
 JSONArray idioms = null;
 //search key value
 public String searchkey;
 
 @Override
 public void onCreate(Bundle savedInstanceState) {
 super.onCreate(savedInstanceState);
 setContentView(R.layout.activity_list_result);
 Intent myIntent = getIntent(); 
 // gets the arguments from previously created intent
 searchkey = myIntent.getStringExtra("keyword");
 
 // Hashmap for ListView
 idiomsList = new ArrayList<HashMap<String, String>>();
 
 // Loading idioms in Background Thread
Go to link Download






Posted by



Unknown




at

8:36 AM















Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest




Labels:
android,
database,
json,
on,
online,
operation,
search