package WebServicePHP.java;

import android.app.Activity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import java.io.InputStream;
import java.io.BufferedInputStream;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;
//import org.apache.http.HttpConnection;
//import javax.microedition.io.Connector;


public class MainActivity extends Activity
{
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState)
    {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
       
        final EditText txtConsulta = (EditText) findViewById(R.id.txtConsulta);
        final EditText txtResultado = (EditText) findViewById(R.id.txtResultado);
       
        txtConsulta.setText("SELECT login, senha, id_fotografo FROM fot_login_fotografos");
       
        final Button btnOK = (Button) findViewById(R.id.btnOK);
        btnOK.setOnClickListener(new View.OnClickListener() {
            public void onClick(View v) {
               
                txtResultado.setText("Inicio ...");
                               
                try {
                   
                    StringBuffer sb = null;
                    InputStream is = null;
                    URL url = new URL("http://xxxxxxxxxxxx.com.br/WebServicePHP/consulta.php?sql=" + txtConsulta.getText().toString().replace(" ", "~") + "");
                    HttpURLConnection urlConnection = (HttpURLConnection) url.openConnection();
                    is = urlConnection.getInputStream();
                    InputStream in = new BufferedInputStream(is);
                    //readStream(in);
                   
                    BufferedReader reader = new BufferedReader(new InputStreamReader(is));
                    String line = null;
                    while ((line = reader.readLine()) != null) {
                        txtResultado.setText(line.replace("~", " "));
                    }
                   
                    urlConnection.disconnect();
                }
                catch (Exception e){
                    txtResultado.setText(e.getMessage());
                }
                               
             }
        });
       
    }
       
}

<?php

    $sql = $_GET['sql'];
   

    //echo "->" . " " . $sql ;
   
    //$sql = "select * from fot_login_fotografos";
    $sql = str_replace("~"," ", $sql);
    $aux_1 = explode("from", $sql);
    $colunas = str_replace("select", "", $aux_1[0]);
    $colunas = str_replace(" ", "", $colunas);
    $colunas_aux = split(',', $colunas);
    $qtd_colunas = count($colunas_aux);
   
    //echo $colunas;
   

    $con = mysql_connect("IP_DO_SERVIDOR_DO_MYSQL","USUARIO","SENHA");
    if (!$con)
    {
        die('Could not connect: ' . mysql_error());
    }
    mysql_select_db("NOME_DO_BANCO", $con);
       
    $result = mysql_query($sql);
    $encontrado = "";
       
    while($row = mysql_fetch_array($result))
    {
        $aux = 0;
        while ($aux < $qtd_colunas)
        {
            echo $row[$aux] . "|";
            $aux = $aux + 1;
        }
        echo ";";
    }
    mysql_close($con);
?>