总结使用PHP作为中间介来实现android链接远程数据库。

使用PHP作为中间介来实现android链接远程数据库,这也是从网上搜集的两种简单的实现方法，差别不大，作为参考。

方法1

PHP代码：

conn.php是连接mysql数据库的。代码如下：

<?php
$dbhost = "localhost:3306";
$dbuser = "root"; //我的用户名
$dbpass = ""; //我的密码
$dbname = "testlogin"; //我的mysql库名
$cn = mysql_connect($dbhost,$dbuser,$dbpass) or die("connect error");
@mysql_select_db($dbname)or die("db error");
mysql_query("set names 'UTF-8'");
?>

<?php
include ("conn.php");//连接数据库
$username=str_replace(" ","",$_POST['name']);//接收客户端发来的username；
$sql="select * from users where name='$username'";
$query=mysql_query($sql);
$rs = mysql_fetch_array($query);

if(is_array($rs)){
if($_POST['pwd']==$rs['password']){
echo "login succeed";
}else{
echo "error";
}
}
?>

class LoginHandler implements Runnable {
@Override
public void run() {
// TODO Auto-generated method stub
//get username and password;
userName = user_name.getText().toString().trim();
password = pass_word.getText().toString().trim();
//连接到服务器的地址，我监听的是8080端口
String connectURL="http://192.168.1.100:8080/text0/com.light.text/login.php/";
//填入用户名密码和连接地址
boolean isLoginSucceed = gotoLogin(userName, password,connectURL);
//判断返回值是否为true，若是的话就跳到主页。
if(isLoginSucceed){
Intent intent = new Intent();
intent.setClass(getApplicationContext(), HomeActivity.class);
startActivity(intent);
proDialog.dismiss();
}else{
proDialog.dismiss();
// Toast.makeText(ClientActivity.this, "登入错误", Toast.LENGTH_LONG).show();
System.out.println("登入错误");
}
}
}

//登入的方法，传入用户密码和连接地址
private boolean gotoLogin(String userName, String password,String connectUrl) {
String result = null; //用来取得返回的String；
boolean isLoginSucceed = false;
//test
System.out.println("username:"+userName);
System.out.println("password:"+password);
//发送post请求
HttpPost httpRequest = new HttpPost(connectUrl);
//Post运作传送变数必须用NameValuePair[]阵列储存
List params = new ArrayList();
params.add(new BasicNameValuePair("name",userName));
params.add(new BasicNameValuePair("pwd",password));
try{
//发出HTTP请求
httpRequest.setEntity(new UrlEncodedFormEntity(params,HTTP.UTF_8));
//取得HTTP response
HttpResponse httpResponse=new DefaultHttpClient().execute(httpRequest);
//若状态码为200则请求成功，取到返回数据
if(httpResponse.getStatusLine().getStatusCode()==200){
//取出字符串
result=EntityUtils.toString(httpResponse.getEntity());
ystem.out.println("result= "+result);
}
}catch(Exception e){
e.printStackTrace();
}
//判断返回的数据是否为php中成功登入是输出的
if(result.equals("login succeed")){
isLoginSucceed = true;
}
return isLoginSucceed;
}
登入成功后会跳到主页：

***********************************************************************************************************************************************************

方法2：

<? php

mysql_connect("host","username","password");

mysql_select_db("PeopleData");

$q=mysql_query("SELECT * FROM people WHERE birthyear>'".$_REQUEST['year']."'");while($e=mysql_fetch_assoc($q))

$output[]=$e;

print(json_encode($output));

mysql_close();

android代码：

package lzu.ConnectMysql;

import java.io.BufferedReader;

import java.io.InputStream;

import java.io.InputStreamReader;

import java.util.ArrayList;

import org.apache.http.HttpEntity;

import org.apache.http.HttpResponse;

import org.apache.http.client.HttpClient;

import org.apache.http.client.entity.UrlEncodedFormEntity;

import org.apache.http.client.methods.HttpPost;

import org.apache.http.impl.client.DefaultHttpClient;

import org.json.JSONArray;

import org.json.JSONException;

import org.json.JSONObject;

import org.apache.http.NameValuePair;

import org.apache.http.message.BasicNameValuePair;

import android.app.Activity;

import android.os.Bundle;

import android.widget.TextView;

public class ConnectMysql extends Activity {

/** Called when the activity is first created. */

private TextView result;

private String content;

@Override

public void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.main);

result = (TextView)findViewById(R.id.content);

content = connecting();

result.setText(content);

//the year data to send

}

public String connecting(){

/*存放http请求得到的结果*/

String result = "";

String ss = null;

/*将要发送的数据封包 */

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

nameValuePairs.add(new BasicNameValuePair("year","1980"));

InputStream is = null;

//http post

try{

/*创建一个HttpClient的一个对象*/

HttpClient httpclient = new DefaultHttpClient();

/*创建一个HttpPost的对象*/

HttpPost httppost = new HttpPost("http://202.201.0.245/test.php");

/*设置请求的数据*/

httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));

/*创建HttpResponse对象*/

HttpResponse response = httpclient.execute(httppost);

/*获取这次回应的消息实体*/

HttpEntity entity = response.getEntity();

/*创建一个指向对象实体的数据流*/

is = entity.getContent();

}catch(Exception e){

System.out.println("Connectiong Error");

}

//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();

System.out.println("get = " + result);

}catch(Exception e){

System.out.println("Error converting to String");

}

//parse json data

try{

/*从字符串result创建一个JSONArray对象*/

JSONArray jArray = new JSONArray(result);

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

JSONObject json_data = jArray.getJSONObject(i);

System.out.println("Success");

System.out.println("result " + json_data.toString());

if( i == 0){

ss = json_data.toString();

}

else{

ss += json_data.toString();

}

catch(JSONException e){

System.out.println("Error parsing json");

}

return ss;

}

更多相关文章

随机推荐

总结 使用PHP作为中间介来实现android链接远程数据库。

更多相关文章

随机推荐

总结使用PHP作为中间介来实现android链接远程数据库。