How to access SQL server database from an phonegap android app?
Connecting android to server using PHP is best way ...
First use name value pair
public void registerUser(String email, String password, String mobile) { // Building Parameters List<NameValuePair> params = new ArrayList<NameValuePair>(); params.add(new BasicNameValuePair("tag", register_tag)); params.add(new BasicNameValuePair("keyemail", email)); params.add(new BasicNameValuePair("keypassword", password)); params.add(new BasicNameValuePair("keymobile", mobile)); // getting JSON Object JsonParser.makeHttpRequest(registerURL,params);}
Use JSON to send the data
public JSONObject makeHttpRequest(String url, List<NameValuePair> params) { // Making HTTP request try { // request method is POST // defaultHttpClient DefaultHttpClient httpClient = new DefaultHttpClient(); HttpPost httpPost = new HttpPost(url); httpPost.setEntity(new UrlEncodedFormEntity(params)); HttpResponse httpResponse = httpClient.execute(httpPost); HttpEntity httpEntity = httpResponse.getEntity(); is = httpEntity.getContent(); } catch (UnsupportedEncodingException e) { e.printStackTrace(); } catch (ClientProtocolException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } 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(); json = sb.toString(); } catch (Exception e) { Log.e("Buffer Error", "Error converting result " + e.toString()); } // try parse the string to a JSON object try { jObj = new JSONObject(json); Log.d("Parser", "IN try parse the string to a JSON object"); } catch (JSONException e) { Log.e("JSON Parser", "Error parsing data " + e.toString()); } // return JSON String return jObj;}
PHP code will get this value and use further
// include db connect class require_once dirname(__FILE__).'/db_connect.php'; // connecting to db $db = new DB_CONNECT(); $response = array(); $email = $_POST['keyemail']; $password= $_POST['keypassword']; $phone=$_POST['keymobile']; $tag=$_POST['tag'];$result=mysql_query("INSERT INTO TableName (register_email,password,mobile) VALUES('$email','$password', '$phone')");if ($result) { // successfully updated $response["success"] = 1; $response["message"] = "Data Inserted Successfully."; // echoing JSON response echo json_encode($response);} else { $response["error_msg"]="Error In Insertion";}
?>