thanks Sarwar Erfan for your answer,but can you tell me how i write
the script and where i put it ??
i tried to write a php script
<?php
$myServer = "98.130.0.21";
$myUser = "********";
$myPass = "******";
$myDB = "######";
//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
or die("Couldn't connect to SQL Server on $myServer");
//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
or die("Couldn't open database $myDB");
//declare the SQL statement that will query the database
$query = "SELECT Id_Famille, Id_filiale, Designation ";
$query .= "FROM T_Article ";
while($e=mssql_fetch_assoc($query))
$output[]=$e;
print(json_encode($output));
//close the connection
mssql_close($dbhandle);
?>
and i put my scipt in my pc c:/
in my application i write this :
String result = "";
ArrayList<NameValuePair> nameValuePairs = new
ArrayList<NameValuePair>();
InputStream is = null;
//http post
try{
HttpClient httpclient = new DefaultHttpClient();
HttpPost httppost = new HttpPost("http://10.0.2.2/
getAllArticle.php");
HttpResponse response = httpclient.execute(httppost);
HttpEntity entity = response.getEntity();
is = entity.getContent();
}catch(Exception e){
Log.e("log_tag", "Error in http connection
"+e.toString());
}
//convert response to string
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 converting result
"+e.toString());
}
//parse json data
try{
JSONArray jArray = new JSONArray(result);
for(int i=0;i<jArray.length();i++){
JSONObject json_data = jArray.getJSONObject(i);
Log.i("log_tag","id_famille:
"+json_data.getString("Id_Famille")+
", id_filiale:
"+json_data.getString("Id_filiale")+
", designation:
"+json_data.getString("Designation ")
);
}
}
catch(JSONException e){
Log.e("log_tag", "Error parsing data "+e.toString());
}
}
but this code don't work
08-18 11:09:51.281: ERROR/log_tag(299): Error in http connection
org.apache.http.NoHttpResponseException: The target server failed to
respond
08-18 11:09:51.281: ERROR/log_tag(299): Error converting result
java.lang.NullPointerException
08-18 11:09:51.311: ERROR/log_tag(299): Error parsing data
org.json.JSONException: End of input at character 0 of
could you please help me to fix it or did you have another way to do
this?
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
