手机端API框架流程(学习笔记)

创建一个接口公共类

<?php

#	echo "response";

	$array = array(
		'id' => 1,
		'name' => '王磊磊'
		 );
	// echo json_encode($array);

	 // Response::json(200, "sucess", $array);

	/**
	*  @param integer $code 状态码
	*  @param string $message 提示信息
	*  @param string $data 数据
	*  return string;
	*/
	class Response
	{
		
		public static function json ($code, $message = '', $data = array()) {

			if (!is_numeric($code)) {
				return '';
			}

			$result = array(
				'code' => $code,
				'message' => $message,
				'data' =>$data
			 );
			echo  json_encode($result);
			exit();
		}
	}
复制代码

创建数据库类

<?php

/**
* 
*/
header("Content-Type: text/html;charset=utf-8"); 
class Db
{
	static private $_instance;
	static private $_connectSource;

	private $_dbConfig  = array(
		'host' => '127.0.0.1:3306',
		'user' => 'root',
		'password' => '2535262wll',
		'database' => 'BYSJ'
		 );	

	private function __construct() {

		# code...
	}

	static public function getInstance() {

		if (!self::$_instance instanceof self) {
			self::$_instance = new self;
		}
		return self::$_instance;
	}

	public function connect() {

	// mysql_connect();//连接数据库
	// mysql_connect($this->_dbConfig['', )
		if (!self::$_connectSource) {
			# code...
			self::$_connectSource = mysql_connect($this->_dbConfig['host'], $this->_dbConfig['user'], $this->_dbConfig['password']);

			if (!self::$_connectSource) {
				// echo "  测试失败\r\n";
				die('mysql_error'.mysql_error());
			}

			// mysql_select_db($this->db['database'], self::$_connectSource);
			mysql_query("set name UTF8", self::$_connectSource);
		}
		

		return self::$_connectSource;

	}

}
复制代码

app首页Demo

<?php
	//http://wangleilei.top/api/list.php?page=1&pagesize=12
	require_once('./Response.php');
	require_once('./db.php');

	$page = isset($_GET['page'])?$_GET['page']:1;
	$pagesize = isset($_GET['pagesize'])?$_GET['pagesize']:10;

	// echo $page."And ".$pagesize;
	if (!is_numeric($page) || !is_numeric($pagesize)) {
		# code...
		return Response::json(401,'数据不合法','12');
	}

	$offset = ($page - 1) * $pagesize;

	$sql = "select * from BYSJ.property  limit ".$offset.','.$pagesize;
	$collect = Db::getInstance()->connect();
	// var_dump($collect);
	$result = mysql_query($sql, $collect);
	echo mysql_num_rows($result);
	var_dump($result);
	
复制代码