android ช่วยด้วยค่ะ ต้องการแสดงรายการสินค้าจากฐานข้อมูล MySQL มาแสดงเป็น ListView ในหน้าโค้ดไม่แจ้งเออเร่อ แต่ว่าพอรันแล้วมันบอกให้ปิดโปรแกรม เข้าไปหน้านั้นไม่ได้เลย
Code (PHP) session_start();
include("connect_db.php");
connect_db();
$result = mysql_query("SELECT p_id, p_name, p_type, p_price1, p_price2, p_price3, p_sale FROM product ")or die(mysql_error());
$row = mysql_num_rows($result);
echo "[ ";
$i =1;
while(list($p_id,$p_name,$p_type,$p_price1,$p_price2, $p_price3, $p_sale) = mysql_fetch_row($result)){
echo " { ";
echo json_encode("p_id").":";
echo json_encode($p_id);
echo " , ";
echo json_encode("p_name").":";
echo json_encode($p_name);
echo " , ";
echo json_encode("p_type").":";
echo json_encode($p_type);
echo " , ";
echo json_encode("p_price1").":";
echo json_encode($p_price1);
echo " , ";
echo json_encode("p_price2").":";
echo json_encode($p_price2);
echo " , ";
echo json_encode("p_price3").":";
echo json_encode($p_price3);
echo " , ";
echo json_encode("p_sale").":";
echo json_encode($p_sale);
echo "} ";
if($i < $row){
echo " , ";
}
$i++;
}
echo " ] ";
mysql_close();
Code (Java) package com.BT.buytrash;
import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.NameValuePair;
import org.apache.http.client.HttpClient;
import org.apache.http.client.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.impl.client.DefaultHttpClient;
import org.apache.http.message.BasicNameValuePair;
import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;
import android.app.Activity;
import android.os.Bundle;
import android.util.Log;
import android.view.LayoutInflater;
import android.view.Menu;
import android.view.View;
import android.view.ViewGroup;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.BaseAdapter;
import android.widget.EditText;
import android.widget.ImageButton;
import android.widget.ListView;
import android.widget.TextView;
public class price extends Activity{
private EditText search;
private ImageButton type_iron;
private ImageButton type_plastic;
private ImageButton type_paper;
private ImageButton type_kew;
private ImageButton type_loha;
private ImageButton type_fifa;
private ImageButton type_other;
private ListView listview_product;
private ArrayList<String> data_name;
String url = "http://10.0.2.2/BuyTrash/price_product.php";
List<NameValuePair> params = new ArrayList<NameValuePair>();
//String[][] data_listview;
//----------------------------------------------------------------
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.price);
search = (EditText) findViewById(R.id.EditText_search);
type_iron = (ImageButton) findViewById(R.id.Button_type_iron);
type_plastic = (ImageButton) findViewById(R.id.Button_type_plastic);
type_paper = (ImageButton) findViewById(R.id.Button_type_paper);
type_kew = (ImageButton) findViewById(R.id.Button_type_kew);
type_loha = (ImageButton) findViewById(R.id.Button_type_loha);
type_fifa = (ImageButton) findViewById(R.id.Button_type_fifa);
type_other = (ImageButton) findViewById(R.id.Button_type_other);
listview_product = (ListView) findViewById(R.id.listview_price);
params.add(new BasicNameValuePair("keyword", search.getText().toString()));
ArrayList<HashMap<String, String>> re = new ArrayList<HashMap<String, String>>(); ;
re = getHttpPost(url,params);
//data_listview = new String[re.size()][7];
// Adapter
listview_product.setAdapter(new MyAdapter());
// ListView
//data_listview = new ArrayList<String>();
data_name = new ArrayList<String>();
for(int i=0 ; i< re.size() ; i++){
data_name.add(re.get(i).get("p_name").toString());
/* data_listview[i][0] = re.get(i).get("p_id").toString();
data_listview[i][1] = re.get(i).get("p_name").toString();
data_listview[i][2] = re.get(i).get("p_type").toString();
data_listview[i][3] = re.get(i).get("p_price1").toString();
data_listview[i][4] = re.get(i).get("p_price2").toString();
data_listview[i][5] = re.get(i).get("p_price3").toString();
data_listview[i][6] = re.get(i).get("p_sale").toString();
*/
}
}
//-------------------------------------------------------------------------------------
private class MyAdapter extends BaseAdapter{
private Holder holder;
public int getCount() {
return data_name.size();
}
public Object getItem(int position) {
return null;
}
public long getItemId(int position) {
return 0;
}
public View getView(int position, View view, ViewGroup parent) {
if( view == null){
view = LayoutInflater.from(getApplicationContext()).inflate(R.layout.list_price_item, null);
holder = new Holder();
holder.p_name = (TextView) view.findViewById(R.id.product_name);
holder.p_price1 = (TextView) view.findViewById(R.id.price1);
holder.p_price2 = (TextView) view.findViewById(R.id.price2);
holder.p_price3 = (TextView) view.findViewById(R.id.price3);
holder.p_sale = (TextView) view.findViewById(R.id.price_sale);
view.setTag(holder);
}else{
holder = (Holder) view.getTag();
}
holder.p_name.setText(data_name.get(position));
//holder.p_price1.setText(data_listview[position][3]);
//holder.p_price2.setText(data_listview[position][4]);
//holder.p_price3.setText(data_listview[position][5]);
//holder.p_sale.setText(data_listview[position][6]);
return view;
}
private class Holder{ //จะบอกว่า view แต่ละรายการมีอะไรบ้าง
public TextView p_name;
public TextView p_price1;
public TextView p_price2;
public TextView p_price3;
public TextView p_sale;
}
}
//----------------------------------------------------------------------------------------
public ArrayList<HashMap<String, String>> getHttpPost(String url, List<NameValuePair> params) {
ArrayList<HashMap<String, String>> myArrList = new ArrayList<HashMap<String, String>>();
//String[][] re ;
InputStream is = null;
String result = "";
// -------------------------------connect----------------------------------------------------
try {
HttpClient client = new DefaultHttpClient();
HttpPost httpPost = new HttpPost(url);
// -------------------------------set UTF8 --------------------------------------------------
httpPost.setEntity(new UrlEncodedFormEntity(params,"UTF-8"));
HttpResponse response = client.execute(httpPost);
HttpEntity entity = response.getEntity();
is = entity.getContent();
}catch (Exception e) {
Log.e("log_tag", "Error in http connection " + e.toString());
}
// -------------------------------to String --------------------------------------------------
try {
BufferedReader reader = new BufferedReader(new InputStreamReader(is, "iso-8859-11"), 8);
StringBuilder sb = new StringBuilder();
String line = null;
while ((line = reader.readLine()) != null) {
sb.append(line + "\n");
}
is.close();
result = sb.toString();
} catch (Exception e) {
Log.e("log_tag", "Error converting result " + e.toString());
}
// -------------------------------JSON to JAVA --------------------------------------------------
try {
JSONArray jArray = new JSONArray(result);
//re = new String[jArray.length()][7];
HashMap<String, String> map;
for (int i = 0; i < jArray.length(); i++) {
/* JSONObject json_data = jArray.getJSONObject(i);
re[i][0] = json_data.getString("p_id");
re[i][1] = json_data.getString("p_name");
re[i][2] = json_data.getString("p_type");
re[i][3] = json_data.getString("p_price1");
re[i][4] = json_data.getString("p_price2");
re[i][5] = json_data.getString("p_price3");
re[i][6] = json_data.getString("p_sale");
*/
//----------------------------------------------------------
JSONObject json_data = jArray.getJSONObject(i);
map = new HashMap<String, String>();
map.put("p_id",json_data.getString("p_id") );
map.put("p_name", json_data.getString("p_name") );
map.put("p_type", json_data.getString("p_type") );
map.put("p_price1", json_data.getString("p_price1") );
map.put("p_price2", json_data.getString("p_price2") );
map.put("p_price3", json_data.getString("p_price3") );
map.put("p_sale", json_data.getString("p_sale") );
myArrList.add(map);
}
} catch (JSONException e) {
Log.e("log_tag", "Error parsing data " + e.toString());
}
return myArrList;
}
@Override
public boolean onCreateOptionsMenu(Menu menu) {
getMenuInflater().inflate(R.menu.login, menu);
return true;
}
}
Tag Mobile, MySQL, Android, JAVA
Date :
2012-11-10 00:05:09By :
amiamikaView :
1247Reply :
4
ในหน้าโค้ดมันไม่แจ้งเออเร่ออะคะ
Date :
2012-11-18 22:04:54By :
amiamika
ต้องดูที่ LogCat ครับ
Date :
2012-11-19 05:45:36By :
mr.win
Logcat ค่ะ ช่วยด้วยนะคะ ไม่รุ้จะไปแก้ตรงไหนอะคะCode
Date :
2012-11-19 13:57:49By :
amiamika
Server 02
Load balance : Server 02
