没有错误：数据没有从Android中插入PHP MySql

Question

数据没有从android中的MySql中插入没有错误的代码，我已经使用AsyncThread定义了它们 - doInBackground和onPostExecute..Its显示了我所拥有的东西在Json对象中定义如果未插入数据，请在其他条件中尝试Catch方法'Sorry Try Again'。

InputStream is = null; 
String res = null; 
String line = null; 
int code; 

的onClick代码

  AsyncTaskRunner runner = new AsyncTaskRunner(); 
      runner.execute(); 

      question = addque.getText().toString(); 
      choice1 = addc1.getText().toString(); 
      choice2 = addc2.getText().toString(); 
      choice3 = addc3.getText().toString(); 
      answer = addanswer.getText().toString(); 
      Explanation = addexplan.getText().toString(); 

AsyncTaskRunner类

private class AsyncTaskRunner extends AsyncTask<String, String, String> { 
    @Override 
    protected String doInBackground(String... arg0) { 
     // TODO Auto-generated method stub 

     ArrayList<NameValuePair> nameValuePairs = new 
ArrayList<NameValuePair>(); 

     nameValuePairs.add(new BasicNameValuePair("question", question)); 
     nameValuePairs.add(new BasicNameValuePair("choice1", choice1)); 
     nameValuePairs.add(new BasicNameValuePair("choice2", choice2)); 
     nameValuePairs.add(new BasicNameValuePair("choice3", choice3)); 
     nameValuePairs.add(new BasicNameValuePair("answer", answer)); 
     nameValuePairs.add(new BasicNameValuePair("Explanation", 
Explanation)); 

     try { 
      HttpClient httpclient = new DefaultHttpClient(); 
      HttpPost httppost = new 
HttpPost("http://192.168.43.4/insert/insert.php"); 
      httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs)); 
      HttpResponse response = httpclient.execute(httppost); 
      HttpEntity entity = response.getEntity(); 
      is = entity.getContent(); 
      Log.e("pass 1", "connection success "); 
     } catch (Exception e) { 
      Log.e("Fail 1", e.toString()); 

     } 

     try { 
      BufferedReader reader = new BufferedReader(
        new InputStreamReader(is, "iso-8859-1"), 8); 
      StringBuilder sb = new StringBuilder(); 
      while ((line = reader.readLine()) != null) { 
       sb.append(line + "\n"); 
      } 
      is.close(); 
      res = sb.toString(); 
      Log.e("pass 2", "connection success "); 
     } catch (Exception e) { 
      Log.e("Fail 2", e.toString()); 
     } 

     return null; 
    } 

    @Override 
    protected void onPostExecute(String result) { 
     // TODO Auto-generated method stub 
     super.onPostExecute(result); 

     try 
     { 
       JSONObject json_data; 
       json_data = new JSONObject(res); 
       code = json_data.getInt("code"); 

       if(code==1) 
       { 
      Toast.makeText(getActivity(), "Inserted Successfully", 
       Toast.LENGTH_SHORT).show(); 
       } 
       else 
       { 
      Toast.makeText(getActivity(), "Sorry, Try Again", 
       Toast.LENGTH_LONG).show(); 
       } 
     } 
     catch(Exception e) 
     { 
       Log.e("Fail 3", e.toString()); 
     } 
     } 

    } 

PHP代码

<?php 
$host='localhost'; 
$uname='root'; 
$pwd=''; 
$db="quizDB"; 

$con = mysql_connect($host,$uname,$pwd) or die("connection failed"); 
mysql_select_db($db,$con) or die("db selection failed"); 

$question=$_REQUEST['question']; 
$choice1=$_REQUEST['choice1']; 
$choice2=$_REQUEST['choice2']; 
$choice3=$_REQUEST['choice3']; 
$answer=$_REQUEST['answer']; 
$Explanation=$_REQUEST['Explanation']; 

$flag['code']=0; 

if($r=mysql_query("insert into quizquestion values('$question','$choice1', 
$choice2, '$choice3', '$answer', '$Explanation') ",$con)) 
{ 
    $flag['code']=1; 
    echo"hi"; 
} 

print(json_encode($flag)); 
mysql_close($con); 
?> 

纠正我，如果我错了。

Answer 1

首先获取要插入的所有字符串，然后调用AsyncTask。可能是这个解决方案。

question = addque.getText().toString(); 
    choice1 = addc1.getText().toString(); 
    choice2 = addc2.getText().toString(); 
    choice3 = addc3.getText().toString(); 
    answer = addanswer.getText().toString(); 
    Explanation = addexplan.getText().toString(); 

    AsyncTaskRunner runner = new AsyncTaskRunner(); 
    runner.execute(); 

并且也改变这2条线。通过UTF-8 UrlEncodeFormEntity

UrlEncodedFormEntity formEntity = new UrlEncodedFormEntity(nameValuePairs, "UTF-8"); 
    httppost.setEntity(formEntity); 

编辑

我想你忘记添加到concatination $选择2，并改变这样的查询。传递第一个fieldName，然后传递值。

$sql = "INSERT INTO MyGuests (fieldName1, fieldName2, fieldName3,fieldName4,fieldName5,fieldName6) 
VALUES ('$question','$choice1','$choice2', '$choice3', '$answer', '$Explanation')"; 

if (mysqli_query($conn, $sql)) { 
    echo "New record created successfully"; 
    $flag['code']=1; 
    echo"hi"; 
} else { 
    echo "Error: " . $sql . "<br>" . mysqli_error($conn); 
}