PHP 持久层的简单实现

首先定义数据库的相关的信息config.php

<?php
/*
 * Filename: config.php
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */
	// About database
	define('DBHOST', 'localhost'); // 数据库服务器
	define('DBUSER', 'root'); // 登陆用户名
	define('DBPSWD', 'lee'); // 登录密码
	define('DBNAME', 'ygbzj'); // 数据库名称
?>

然后进行数据库连接conn.php

<?php
/*
 * Filename: conn.php
 */
	include_once 'config.php';
	
	function db_conn(){
		$conn = mysqli_connect(DBHOST, DBUSER, DBPSWD,DBNAME);
		if (!$conn) {
			echo "Unable to connect!";
		}
		return $conn;
	}
	function db_colse($conn) {
		mysqli_close($conn);
	}

?>

进行测试

<?php
/*
 * Filename: demo.php
 */
	include_once 'conn.php';
	$con = db_conn();
		$sql = "select * from admin";
		$re = mysqli_query($con,$sql);
		if (mysqli_num_rows($re)>0) {
			echo "=====================";
			$row = mysqli_fetch_row($re);
			echo $row[0];
		}
		db_colse($con);
?>

测试成功