将json对象数组从php传递到android

Question

我尝试通过json对象将一组数据从php传递给android。但我得到了“解析错误:语法错误”.Please帮助我out.thanx

‘

//db详情

$dbhost="localhost";
$dbuser="root";
$dbpass="";
$dbdb="opac";

//连接到数据库

$con=mysql_connect($dbhost, $dbuser, $dbpass) or die("connection error");

//选择数据库

mysql_select_db($dbdb) or die("db selecction error");
$stk=$_POST[‘stock’];

$query=mysql_query("SELECT Title FROM books WHERE Stock>’$stk’”);

    if(!$query)
    {
           die('Could not get data: ' . mysql_error());
    }
    $index=0;
    while($row = mysql_fetch_array($query, MYSQL_ASSOC)) 
    {
           $output[$index]=$row;
           $index++;
    }

    echo json_encode($output);
     mysql_close();
    ?>  

相应的android文件is....with当android文件执行时出现解析错误，它显示“不幸的，已停止”

   public class BooksActivity extends ListActivity {

HttpClient httpclient;
HttpPost httppost;
ArrayList<NameValuePair> namevaluepairs;
HttpResponse httpresponse;
HttpEntity httpentity;
ArrayList<NameValuePair> nameValuePairs;
InputStream is;
String result = "";

@Override
protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);

    StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
    StrictMode.setThreadPolicy(policy);
    setContentView(R.layout.activity_books);
    nameValuePairs = new ArrayList<NameValuePair>();
    nameValuePairs.add(new BasicNameValuePair("stock","5"));

    //httppost
    try{
        httpclient = new DefaultHttpClient();
        httppost = new HttpPost("http://10.0.2.2:80/books.php");
        httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
        httpresponse = httpclient.execute(httppost);
        httpentity = httpresponse.getEntity();
        is = httpentity.getContent();
    }
    catch(Exception e){
           // Log.e("log_tag", "Error in http connection "+e.toString());
        Toast.makeText(getBaseContext(), "http post error"+e, Toast.LENGTH_SHORT ).show();
    }

    //result conversion
    try{
        BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),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 in converting result "+e.toString());
        Toast.makeText(getBaseContext(), "result conversion error"+e, Toast.LENGTH_SHORT ).show();
    }

    //parsing json data

    try{
        String[] returnString = new String[100];
        JSONArray jArray = new JSONArray(result);           
        ListView listView = (ListView) findViewById(R.id.list);
        for(int i=0;i<jArray.length();i++){
                JSONObject json_data = jArray.getJSONObject(i);
                returnString[i] = json_data.getString("Title");              
        }
        ArrayAdapter<String> adapter = new ArrayAdapter<String>(this,
                  android.R.layout.simple_list_item_1, android.R.id.list, returnString);
        listView.setAdapter(adapter);
    }catch(JSONException e){
        //Log.e("log_tag", "Error parsing data "+e.toString());
        Toast.makeText(getBaseContext(), "parsing error"+e, Toast.LENGTH_SHORT ).show();
    }

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

}

Answer 1

你在这里使用了反引号吗？

$stk=$_POST[‘stock’];

它们需要加引号

$stk=$_POST['stock'];

此外，此行还有一个utf-8花式引号

$query=mysql_query("SELECT Title FROM books WHERE Stock>`$stk”);

这应该是一个ascii引用。

$query=mysql_query("SELECT Title FROM books WHERE Stock>$stk");

这些是从博客复制代码时的常见错误;)