php 典型三层架构实现增删改查

<?php /** * 查找用户 */ function findUsers($usersName,$pageNum) { //包含配置文件 include '../config.php'; //构建查询 $query="select * from t_user "; if(isset($usersName)&&!$usersName=='') { $query = $query."where lower(u_name) like '%".$usersName."%' "; } $query = $query."order by u_id desc "; if($pageNum!=null) { $query = $query."limit ".($pageNum-1)*$pageCount.",".$pageCount; } //创建数据库连接 $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password); mysql_select_db($mysql_database); //执行查询 $result=mysql_query($query,$conn); //将返回值放入数组 $array = array(); while($row=mysql_fetch_row($result)) { $array[] = $row; } //释放资源,关闭连接 mysql_free_result($result); mysql_close(); //返回结果 return $array; } /** * 登录 */ function login($usersName,$passWord) { //包含配置文件 include '../config.php'; //构建查询 $query="select * from t_user "; if(isset($usersName)&&!$usersName==''&&isset($passWord)&&!$passWord=='') { $query = $query."where u_name = '".$usersName."' "."and u_password = '".$passWord."' "; } else { return null; } //创建数据库连接 $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password); mysql_select_db($mysql_database); //执行查询 $result=mysql_query($query,$conn); //将返回值放入数组 if($row=mysql_fetch_row($result)) { $array = $row; } else { $array = null; } //释放资源,关闭连接 mysql_free_result($result); mysql_close(); //返回结果 return $array; } /* * 查找页数 */ function findUsersCount($usersName) { //包含配置文件 include '../config.php'; //构建查询 $query="select count(*) from t_user "; if(isset($usersName)&&!$usersName=='') { $query = $query."where lower(u_name) like '%".$usersName."%' "; } //创建数据库连接 $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password); mysql_select_db($mysql_database); //执行查询 $result=mysql_query($query,$conn); //将返回值放入变量 if($row = mysql_fetch_array($result)) { $count = intval($row[0]); if($count%$pageCount > 0 ||$count==0) { return floor($count/$pageCount)+1; } else { return floor($count/$pageCount); } } else { $count = 1; } //释放资源,关闭连接 mysql_free_result($result); mysql_close(); //返回结果 return $count; } /** * 根据id查找用户 */ function findUsersById($id) { //包含配置文件 include '../config.php'; //构建查询 $query="select * from t_user "; if(isset($id)&&!$id=='') { $query = $query."where u_id = '".$id."' "; } else { return null; } //创建数据库连接 $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password); mysql_select_db($mysql_database); //执行查询 $result=mysql_query($query,$conn); //将返回值放入数组 if($row=mysql_fetch_row($result)) { $array = $row; } else { $array = null; } //释放资源,关闭连接 mysql_free_result($result); mysql_close(); //返回结果 return $array; } /* * 添加用户 */ function addUsers($usersName,$passWord) { //包含配置文件 include '../config.php'; //构建查询 $query="insert into t_user (u_name,u_password) values ('".$usersName."','".$passWord."')"; //创建数据库连接 $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password); mysql_select_db($mysql_database); //执行查询 mysql_query($query); //释放资源,关闭连接 mysql_close(); } /* * 编辑用户 */ function editUsers($userId,$usersName,$passWord) { //包含配置文件 include '../config.php'; //构建查询 $query="update t_user set u_name = '".$usersName."',u_password = '".$passWord."' where u_id = '".$userId."' "; //创建数据库连接 $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password); mysql_select_db($mysql_database); //执行查询 mysql_query($query); //释放资源,关闭连接 mysql_close(); } /* * 删除用户 */ function delUsersById($userId) { //包含配置文件 include '../config.php'; //构建查询 $query="delete from t_user where u_id = '".$userId."' "; //创建数据库连接 $conn=mysql_connect($mysql_server_name,$mysql_username,$mysql_password); mysql_select_db($mysql_database); //执行查询 mysql_query($query); //释放资源,关闭连接 mysql_close(); } ?>