PHP 持久层的简单实现

来源：互联网发布：python 去除重复元素编辑：程序博客网时间：2024/05/08 23:45

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

<?php/* * Filename: config.php * Window - Preferences - PHPeclipse - PHP - Code Templates */// About databasedefine('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);?>

测试成功