0

Hello everyone,

I am trying to connect my android application to MYSQL database. I have used the following:

MYSQL already created database test (accessed via xampp using localhost/phpmyadmin)
Created a table named as student in the database test consisting of Name and Roll No columns and 2 records.
A user on the database with credentials username: rubeea password 123

Then I created a php script as follows:

<?php

mysql_connect("localhost","rubeea","123");//change server name  //pass username according your settings

mysql_select_db("test");// also chang the Mysql database name

$sql1=mysql_query("select * from student");

if (!$sql1) {

echo "Could not successfully run query ($sql) from DB: " . mysql_error();

exit;

}

while($row=mysql_fetch_assoc($sql1))

$output[]=$row;



echo json_encode($output);// this will print the output in json

mysql_close();

?>

When I run this php file from my browser through localhost/mysqlchk.php. It shows me the correct data in the json format in the browser.

Then I wrote the android app as:

MainActivity:

import android.os.AsyncTask;
import android.os.Bundle;
import android.annotation.SuppressLint;
import android.app.Activity;
import android.util.Log;
import android.view.Menu;
import android.view.View;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;

import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.concurrent.ExecutionException;

import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.client.HttpClient;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.impl.client.DefaultHttpClient;
import org.json.JSONArray;
import org.json.JSONObject;

import net.sourceforge.jtds.jdbc.*;


@SuppressLint("NewApi")
public class MainActivity extends Activity {

     private EditText usernameField,passwordField;
     private TextView status,role,method;


    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
          status = (TextView)findViewById(R.id.textView6);
          role = (TextView)findViewById(R.id.textView7);
          method = (TextView)findViewById(R.id.textView9);   
    }

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

    public void login(View view){
          method.setText("Get Method");
          new SigninActivity(this,status,role,0).execute("abc","123");

       }
     }

SigninActivity:

package com.example.sqlserverexample;

import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import java.net.URI;
import java.net.URL;
import java.net.URLConnection;
import java.net.URLEncoder;

import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.client.HttpClient;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.impl.client.DefaultHttpClient;
import org.json.JSONArray;
import org.json.JSONObject;

import android.content.Context;
import android.os.AsyncTask;
import android.util.Log;
import android.widget.TextView;
import android.widget.Toast;

public class SigninActivity  extends AsyncTask<String,Void,String>{

   private TextView statusField,roleField;
   private Context context;
   private int byGetOrPost = 0; 
   //flag 0 means get and 1 means post.(By default it is get.)
   public SigninActivity(Context context,TextView statusField,
   TextView roleField,int flag) {
      this.context = context;
      this.statusField = statusField;
      this.roleField = roleField;
      byGetOrPost = flag;
   }

   protected void onPreExecute(){

   }
   @Override
   protected String doInBackground(String... arg0) {
       String result="";

      if(byGetOrPost == 0){ //means by Get Method

          try{

              String link = "http://192.168.1.2:80/mysqlchk.php";
              URL url = new URL(link);
              HttpClient client = new DefaultHttpClient();
              HttpGet request = new HttpGet();
              request.setURI(new URI(link));
              HttpResponse response = client.execute(request);
              BufferedReader in = new BufferedReader
             (new InputStreamReader(response.getEntity().getContent()));

             StringBuffer sb = new StringBuffer("");
             String line="";
             while ((line = in.readLine()) != null) {
                sb.append(line+"\n");
                //break;
              }
              in.close();
              result= sb.toString();
        }catch(Exception e){
           return new String("Exception: " + e.getMessage());
        }
          return result;
      }
     }
   @Override
   protected void onPostExecute(String result){
      this.statusField.setText("result"+"\t"+result);
      this.roleField.setText("ck");
       try {

              String s = "";

              JSONArray jArray = new JSONArray(result);

              for(int i=0; i<jArray.length();i++){

              JSONObject json = jArray.getJSONObject(i);

              s = s +"Name : "+json.getString("Name")+" "+json.getString("Roll");  }

              this.roleField.setText(s);

              } catch (Exception e) {

              // TODO: handle exception

              Log.e("log_tag", "Error Parsing Data "+e.toString());

              }


   }
}

Where 192.168.1.2:80 is the ip of my machine connected to wifi network. Now, when I try to run this application on my android device (Nokia X) with xampp server on (MYSQL and Apache running on it), it shows the message
Exception: Connection refused to http:\192.168.1.2:80.... when printed in postExecute method.

I don't know why it is showing this error. Please help!!

2
Contributors
1
Reply
15
Views
3 Years
Discussion Span
Last Post by hericles
0

Firewall? What happens if you try to connect to that address via the browser on the phone (or a test html page in the same location)?
If you can hit a test page (or not) then you can start to narrow down what the cause might be.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.