Android+PHP简单实现

功能：登陆、注册、查看留言、发布留言

一、数据库设计：

user表：

create table user(
id int primary key auto_increment,
username varchar(16) unique not null,
password varchar(32) not null
);

massage表：

create table massage(
id int primary key auto_increment,
title varchar(32) not null,
content varchar(500) not null,
time datatime,
);

二、PHP代码

链接数据库：

<?php

	error_reporting(0); //屏蔽警告
	mysql_connect("主机名", "用户", "密码") or die(mysql_errno);//链接数据库 
	mysql_select_db("app_renlaibang");//选择数据库
	mysql_query("set names utf8"); //设置编码
	
?>

注册：

<?php

include("conn.php");//引入数据库连接
$response = array();//创建一个数组


if (isset($_POST['username']) && isset($_POST['password'])) { //判断从客户端传来的用户名密码是否为空
    //用户名和密码不为空
    $name = $_POST['username'];
    $password = $_POST['password'];
    $result = mysql_query("INSERT INTO rlb_users(username, password) VALUES('$name', '$password')"); //执行SQL语句，$result接受结果集
    if ($result) { //判断结果集是否为真
        
        $response["state"] = "success"; //为真，赋值状态：$response['state'] 为success
        
        echo json_encode($response); //打包为json数据返回给客户端
    } else {
        
        $response["state"] = "fail";    //<span style="font-family: Arial, Helvetica, sans-serif;">为假，赋值状态：$response[’state'] 为fail</span>
       
        echo json_encode($response); //打包为json数据返回给客户端
    }
} else { //用户名密码为空
    
    $response["state"] = fail;
	$response["error"] = "oooo";
    
    echo json_encode($response);
}
?>

登陆：

<?php

include("conn.php");
$response = array();

if (isset($_POST['username']) && isset($_POST['password'])) {
    
    $name = $_POST['username'];
    $password = $_POST['password'];
    $result = mysql_query("select username password from rlb_users where username='$name' && password='$password'");
    if ($result) {
        
        $response["state"] = "success";
        
        echo json_encode($response);
    } else {
        
        $response["state"] = "fail";        
       
        echo json_encode($response);
    }
} else {
    
    $response["state"] = fail;
    
    echo json_encode($response);
}
?>

发表：

<?php

include("conn.php");
$response = array();


if (isset($_POST['title']) && isset($_POST['content']) && isset($_POST['username'])) {
    
    $title = $_POST['title'];
    $content = $_POST['content'];
    $name = $_POST['username'];
    $result = mysql_query("INSERT INTO rlb_message(title, content, time, username) VALUES('$title', '$content', now(), '$name')");
    if ($result) {
        
        $response["state"] = "success";
        
        echo json_encode($response);
    } else {
        
        $response["state"] = "fail";        
       
        echo json_encode($response);
    }
} else {
    
    $response["state"] = fail;
	$response["error"] = "oooo";
    
    echo json_encode($response);
}
?>

查看：

<?php

include("conn.php");
$response = array();

    $result = mysql_query("select * from rlb_message");
	while($row = mysql_fetch_assoc($result)){
		$arr[] = $row;
	}
	$response = array("liuyans" => $arr);
	echo json_encode($response);

?>