💕💕作者：计算机源码社
💕💕个人简介：本人 八年开发经验，擅长Java、Python、PHP、.NET、Node.js、Android、微信小程序、爬虫、大数据、机器学习等，大家有这一块的问题可以一起交流！
💕💕学习资料、程序开发、技术解答、文档报告
💕💕如需要源码，可以扫取文章下方二维码联系咨询
💕💕Java项目
💕💕微信小程序项目
💕💕Android项目
💕💕Python项目
💕💕PHP项目
💕💕ASP.NET项目
💕💕Node.js项目
💕💕选题推荐
项目实战|在线租房管理系统php房屋出租系统 房屋租赁系统
1、研究背景
随着城市化进程的加快和人们生活水平的提高，房屋租赁市场需求日益增加。传统的房屋租赁方式依赖于线下中介和广告，存在信息不对称、效率低下等问题。特别是在快速发展的都市环境中，租客和房东的需求不断变化，这些传统方式难以适应新时代对房屋租赁服务的高效、便捷需求。因此，开发一个集成化的房屋租赁系统成为必要的选择。该系统旨在整合房屋信息发布、预约看房、合同签订等环节，提高信息透明度和操作效率，以应对市场需求的变化和用户期望的提升。
2、研究目的和意义
房屋租赁系统的开发旨在解决传统租赁方式中的各种痛点，通过互联网技术提供一个高效、便捷、安全的租赁平台。系统通过线上平台将用户、房东、管理员三方连接起来，实现房源信息的快速发布与更新、预约看房的便捷管理、租房费用的在线支付、合同的电子化签署等功能。通过这些功能，系统不仅简化了租赁流程，还提高了各方的互动效率，减少了信息流转中的错误与遗漏，满足了现代用户对高效、透明的租赁服务的需求。
房屋租赁系统的开发不仅提升了租赁市场的运作效率，还促进了房地产信息化的进程。对于用户而言，系统提供了一个一站式服务平台，方便他们快速找到符合需求的房源，并完成租赁过程中的各项操作。对于房东而言，系统帮助他们更有效地管理房源信息和租赁事务，减少了中介费用和管理成本。对于管理员而言，系统提供了全面的管理功能，包括用户、房东、房源信息的管理及统计报表生成，大大提升了工作效率。综上所述，该系统的开发具有重要的市场应用价值和社会意义，有助于推动租赁市场的现代化和信息化进程。
3、系统研究内容
系统需求分析与功能设计
研究将首先深入分析房屋租赁市场的需求，探讨现有系统的不足之处，并明确系统应实现的核心功能。通过与用户、房东和管理员的访谈和调研，确定系统的功能模块，如房源信息发布、预约看房、在线支付、合同签署等。功能设计包括用户界面的设计、系统架构的构建、数据库的设计等，确保系统能够满足用户在房屋租赁过程中的各种需求，并提供良好的用户体验。
系统架构与技术选型
研究将探讨系统的总体架构设计，包括前端和后端的技术选型。前端技术将关注用户体验的优化，选择合适的开发框架和工具，以实现高效的页面渲染和交互体验。后端技术则包括服务器的选择、数据库的设计与管理、系统的安全性与性能优化等。系统架构将兼顾可扩展性和可维护性，以支持未来的功能扩展和技术升级。
系统实施与测试
在系统的实施阶段，研究将包括系统的开发、部署和测试。开发阶段将按照设计文档实现各项功能，并进行单元测试和集成测试，确保系统的各个模块能够协同工作。部署阶段将关注系统的上线和运行环境配置，确保系统的稳定性和安全性。测试阶段包括功能测试、性能测试和用户测试，确保系统在实际使用中能够稳定运行，并满足用户需求。
数据管理与分析
研究还将重点关注系统中的数据管理和分析功能。包括房源信息、租房记录、合同信息等数据的存储、查询和管理。数据分析功能将帮助管理员生成统计报表，了解房屋租赁市场的动态，优化系统功能和服务。通过数据挖掘和分析，系统能够提供更具针对性的服务和改进建议，提高租赁业务的运营效率。
用户体验与系统优化
最后，研究将关注用户体验的提升和系统的持续优化。通过用户反馈和使用数据的分析，识别系统中存在的问题和用户的痛点。根据反馈进行系统优化和功能改进，提升用户满意度和系统的整体性能。定期更新系统，加入新功能和技术，确保系统能够适应市场变化和用户需求的变化。
4、系统页面设计
如需要源码，可以扫取文章下方二维码联系咨询
5、参考文献
[1]闫银娟.基于SSM的房屋租赁系统的设计与实现[J].电脑知识与技术,2022,18(33):38-41.DOI:10.14004/j.cnki.ckt.2022.2092.
[2]林永民,史孟君,陈琳.构建房屋租赁信息生态圈中区块链技术应用研究[J].价格理论与实践,2020,(10):56-59.DOI:10.19851/j.cnki.cn11-1010/f.2020.10.433.
[3]陈湘瑾,孙瑜鸿,祖子帅,等.基于JSP开发技术的信息化房屋租赁系统[J].科学技术创新,2021,(09):106-107.
[4]李瑞娥,沈文枫,杨宇华,等.基于区块链的房屋租赁分配系统设计与实现[J].软件导刊,2019,18(10):111-116.
[5]张基.基于Android平台的房屋租赁管理系统的设计[J].老字号品牌营销,2019,(07):70-71.
[6]武海龙,李国平.基于SpringBoot的房屋租赁系统设计[J].电脑与信息技术,2019,27(03):76-78.DOI:10.19414/j.cnki.1005-1228.2019.03.022.
[7]朱园园,邵雯娟,黄志远.基于Scrapy的房屋租赁信息搜索系统设计与实现[J].电脑与电信,2019,(06):14-19.DOI:10.15966/j.cnki.dnydx.2019.06.005.
[8]侯天峰,庞浩.集成路线规划的房屋租赁系统的设计与实现[J].电脑知识与技术,2016,12(15):91-93.DOI:10.14004/j.cnki.ckt.2016.2044.
[9]马杰.基于PHP的房屋租赁系统[J].河南科技,2016,(11):26-27.
[10]李宇婷.沈阳地区房屋出租信息系统设计与开发[J].电脑知识与技术,2015,11(33):60-62.DOI:10.14004/j.cnki.ckt.2015.3261.
[11]方义.关于房屋租赁管理系统的设计与开发问题研究[J].科技展望,2015,25(06):3-4.
[12]贾峰.基于J2EE框架的房屋租赁系统开发[J].软件导刊,2012,11(05):88-89.
[13]李宁.基于PHP的房屋租赁管理系统[J].电脑知识与技术,2010,6(22):6153-6154.
[14]宁凡,厉星星.网上房屋租赁系统的设计与开发[J].信息化研究,2010,36(02):62-64.
[15]魏培嫌,魏培李.房屋出租管理系统的设计与实现[J].电脑知识与技术,2009,5(04):787-791.
[16]任小艳.基于UML建模的房屋租赁管理系统分析[J].焦作师范高等专科学校学报,2005,(01):56-59.
[17]何渝,李国华.基于GIS房屋租赁系统的研究与实现[J].计算机工程与应用,2004,(20):230-232.
6、核心代码
<?php
session_start();
class FangwuzulinController extends CommonController {
public function __construct()
{
header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Methods: POST, GET, OPTIONS, PUT, DELETE");
header('Access-Control-Allow-Headers:Origin,Content-Type,Accept,token,X-Requested-With,device');
}
public $columData = [
'id','addtime'
,'fangwumingcheng'
,'fangwuleixing'
,'fangwutupian'
,'fangchanzheng'
,'chengshi'
,'weizhi'
,'chaoxiang'
,'louceng'
,'zhuangtai'
,'sheshi'
,'zujin'
,'xiangqing'
,'fangdongzhanghao'
,'fangdongxingming'
,'lianxidianhua'
,'sfsh'
,'shhf'
,'clicknum'
,'storeupnum'
];
/**
* 分页，列表
* get
*/
public function page(){
$token = $this->token();
$tokens = json_decode(base64_decode($token),true);
if (!isset($tokens['id']) || empty($tokens['id'])) exit(json_encode(['code'=>401,'msg'=>"你还没有登录。"]));
$userid = $tokens['id'];
$where = " where 1 ";//查询条件
$orwhere = '';
if($tokens['tablename'] == 'fangdong') {
$where .= " and `fangdongzhanghao` = '".$tokens['username']."' ";
}
$page = isset($_REQUEST['page'])?$_REQUEST['page']:"1";
$limt = isset($_REQUEST['limit'])?$_REQUEST['limit']:"10";
$sort = isset($_REQUEST['sort'])?$_REQUEST['sort']:"id";
$order = isset($_REQUEST['order'])?$_REQUEST['order']:"asc";
foreach ($_REQUEST as $k => $val){
if(in_array($k, $this->columData)){
if ($val != ''){
$where.= " and ".$k." like '".$val."'";
}
}
}
$base = json_decode(base64_decode($token),true);
if ($base['isAdmin']!=1 || ($base['isAdmin']==1 && $base['tablename'] != "users")){
$md5 = md5($userid."+10086");
$colum = "fangdongzhanghao";
$columData = $base['columData'];
if (isset($_SESSION[$md5]) && in_array($colum, $columData)){
if($base['tablename'] == 'fangdong'){
$orsign = false;
if(!$orsign) {
$where .= " and `fangdongzhanghao` = '".$_SESSION[$md5]."'";
}
}
}
}
$sql = "select * from `fangwuzulin` ".$where;
$count = table_sql($sql);
if ($count->num_rows < 1){
$numberCount = 0;
}else{
$numberCount = $count->num_rows;
}
$page_count = ceil($numberCount/$limt);//页数
$startCount = ($page-1)*$limt;
$where .= empty($orwhere) ? '' : "and (".$orwhere.")";
$lists = "select * from `fangwuzulin` ".$where." order by ".$sort." ".$order." limit ".$startCount.",".$limt;
$result = table_sql($lists);
$arrayData = array();
if ($result->num_rows > 0) {
while ($datas = $result->fetch_assoc()){
array_push($arrayData,$datas);
}
}
exit(json_encode([
'code'=>0,
'data' => [
"total" => $numberCount,
"pageSize" => $limt,
"totalPage" => $page_count,
"currPage" => $page,
"list" => $arrayData
]
]));
}
/**
* 分页，列表list
* get
*/
public function lists(){
$sql = "select * from `fangwuzulin`";
$result = table_sql($sql);
$arrayData = array();
if ($result->num_rows > 0) {
while ($datas = $result->fetch_assoc()){
array_push($arrayData,$datas);
}
}
exit(json_encode([
'code'=>0,
'data' =>$arrayData
]));
}
/**
* 分页，列表list
* get
*/
public function list(){
$page = isset($_REQUEST['page'])?$_REQUEST['page']:"1";
$limt = isset($_REQUEST['limit'])?$_REQUEST['limit']:"10";
$sort = isset($_REQUEST['sort'])?$_REQUEST['sort']:"id";
$order = isset($_REQUEST['order'])?$_REQUEST['order']:"asc";
$refid = isset($_REQUEST['refid']) ? $_REQUEST['refid'] : "0";
$where = " where 1 ";//查询条件
if(isset($_REQUEST['goodid'])) {
$where .= " and goodid = ".$_REQUEST['goodid']." ";
}
$sorts = explode(",", $sort);
$orders = explode(",", $order);
$sortorders = "";
foreach ($sorts as $index => $value) {
if($index == count($sorts)-1){
$sortorders =$sortorders.$value." ".$orders[$index];
}else{
$sortorders =$sortorders.$value." ".$orders[$index].",";
}
}
foreach ($_REQUEST as $k => $val){
if(in_array($k, $this->columData)){
$where.= " and ".$k." like '".$val."'";
}
}
$sql = "select * from `fangwuzulin`".$where;
$count = table_sql($sql);
if ($count->num_rows < 1){
$numberCount = 0;
}else{
$numberCount = $count->num_rows;
}
$page_count = ceil($numberCount/$limt);//页数
$startCount = ($page-1)*$limt;
$lists = "select * from `fangwuzulin` ".$where." order by ".$sortorders." limit ".$startCount.",".$limt;
$result = table_sql($lists);
$arrayData = array();
if ($result->num_rows > 0) {
while ($datas = $result->fetch_assoc()){
array_push($arrayData,$datas);
}
}
exit(json_encode([
'code'=>0,
'data' => [
"total" => $numberCount,
"pageSize" => $limt,
"totalPage" => $page_count,
"currPage" => $page,
"list" => $arrayData
]
]));
}
/**
* 新增数据接口
* post
*/
public function save(){
$token = $this->token();
$tokens = json_decode(base64_decode($token),true);
if (!isset($tokens['id']) || empty($tokens['id'])) exit(json_encode(['code'=>401,'msg'=>"你还没有登录。"]));
$uid = $tokens['id'];
$keyArr = $valArr = array();
$tmpData = strval(file_get_contents("php://input"));//Content-Type: application/json 需要用到php://input 处理输入流
if (!empty($tmpData)&& isset($tmpData)){
$postData = json_decode($tmpData,true);
$fangwumingcheng = $postData['fangwumingcheng'];
$resultInfo = table_sql("select fangwumingcheng from `fangwuzulin` where `fangwumingcheng` = '".$fangwumingcheng."'");
if ($resultInfo->num_rows > 0) {
exit(json_encode(['code'=>500,'msg'=>"房屋名称已存在"]));
}
foreach ($postData as $key => $value){
if (in_array($key, $this->columData)){
if(!empty($value) || $value === 0) {
if ($key == 'id') {
continue;
}
array_push($keyArr,"`".$key."`");
if($key == 'clicktime') {
array_push($valArr,"'".date('Y-m-d h:i:s', time())."'");
} else {
array_push($valArr,"'".$value."'");
}
}
}
}
}
$k = implode(',',$keyArr);
$v = implode(',',$valArr);
$sql = "INSERT INTO `fangwuzulin` (".$k.") VALUES (".$v.")";
$result = table_sql($sql);
exit(json_encode(['code'=>0]));
}
/**
* 新增数据接口 add
* post
*/
public function add(){
$keyArr = $valArr = array();
$token = $this->token();
$tokens = json_decode(base64_decode($token),true);
if (!isset($tokens['id']) || empty($tokens['id'])) exit(json_encode(['code'=>401,'msg'=>"你还没有登录。"]));
$uid = $tokens['id'];
$tmpData = strval(file_get_contents("php://input"));
if (!empty($tmpData)&& isset($tmpData)){
$postData = json_decode($tmpData,true);
$fangwumingcheng = $postData['fangwumingcheng'];
$resultInfo = table_sql("select fangwumingcheng from `fangwuzulin` where `fangwumingcheng` = '".$fangwumingcheng."'");
if ($resultInfo->num_rows > 0) {
exit(json_encode(['code'=>500,'msg'=>"房屋名称已存在"]));
}
foreach ($postData as $key => $value){
if (in_array($key, $this->columData)){
if(!empty($value) || $value === 0) {
if ($key == 'id') {
continue;
}
array_push($keyArr,"`".$key."`");
if($key == 'clicktime') {
array_push($valArr,"'".date('Y-m-d h:i:s', time())."'");
} else {
array_push($valArr,"'".$value."'");
}
}
}
}
}
$k = implode(',',$keyArr);
$v = implode(',',$valArr);
$sql = "INSERT INTO `fangwuzulin` (".$k.") VALUES (".$v.")";
$result = table_sql($sql);
exit(json_encode(['code'=>0]));
}
/**
* 更新接口
* post
*/
public function update(){
$token = $this->token();
$tokens = json_decode(base64_decode($token),true);
if (!isset($tokens['id']) || empty($tokens['id'])) exit(json_encode(['code'=>401,'msg'=>"你还没有登录。"]));
$uid = $tokens['id'];
$tmpData = strval(file_get_contents("php://input"));
$postData = json_decode($tmpData,true);
$fangwumingcheng = $postData['fangwumingcheng'];
$id = $postData['id'];
$resultInfo = table_sql("select fangwumingcheng from `fangwuzulin` where id <> ".$id." and `fangwumingcheng` = '".$fangwumingcheng."'");
if ($resultInfo->num_rows > 0) {
exit(json_encode(['code'=>500,'msg'=>"房屋名称已存在"]));
}
$v = array();
foreach ($postData as $key => $value){
if (in_array($key, $this->columData)){
if ($key == "id"){
$id = $value;
}
if(!empty($value) || $value === 0) {
array_push($v,$key." = '".$value."'");
}
}
}
$value = implode(',',$v);
$sql = "UPDATE fangwuzulin SET ".$value." where id = ".$id;
$result = table_sql($sql);
exit(json_encode(['code'=>0]));
}
/**
* 删除
* post
*/
public function delete(){
$ids = strval(file_get_contents("php://input"));//发现接收的是字符串
preg_match_all('/\d+/',$ids,$arr);
$str = implode(',',$arr[0]);//拼接字符，
$sql = "delete from fangwuzulin WHERE id in({$str})";
$result = table_sql($sql);
exit(json_encode(['code'=>0]));
}
// 查询单条记录（前端）
public function query(){
$where = "1";
foreach ($_REQUEST as $k => $val){
if(in_array($k, $this->columData) && !empty($val)){
$where.= " and ".$k." like '".$val."'";
}
}
$sql = "select * from `fangwuzulin` where ".$where;
$result = table_sql($sql);
if ($result->num_rows > 0) {
// 输出数据
while($row = $result->fetch_assoc()) {
$lists = $row;
}
}
exit(json_encode([
'code'=>0,
'data'=> $lists
]));
}
/**
* 查询一条数据
* get
*/
public function info($id=false){
$token = $this->token();
$tokens = json_decode(base64_decode($token),true);
if (!isset($tokens['id']) || empty($tokens['id'])) exit(json_encode(['code'=>401,'msg'=>"你还没有登录。"]));
$userid = $tokens['id'];
$name = isset($_REQUEST['name'])? $_REQUEST['name']:"";
if (!empty($id)){
$where = "`id` = ".$id;
}else{
$where = "`name` = ".$name;
}
$this->andone('fangwuzulin',$id,$column='clicknum',$num=1);
$sql = "select * from `fangwuzulin` where ".$where;
$result = table_sql($sql);
if ($result->num_rows > 0) {
// 输出数据
while($row = $result->fetch_assoc()) {
$lists = $row;
}
}
exit(json_encode([
'code'=>0,
'data'=> $lists
]));
}
/**
* 查询一条数据
* get
*/
public function detail($id=false){
$name = isset($_REQUEST['name'])? $_REQUEST['name']:"";
if ($id){
$where = "`id` = ".$id;
}else{
$where = "`name` = ".$name;
}
$this->andone('fangwuzulin',$id,$column='clicknum',$num=1);
$sql = "select * from `fangwuzulin` where ".$where;
$result = table_sql($sql);
if (!$result) exit(json_encode(['code'=>500,'msg'=>"查询数据发生错误。"]));
if ($result->num_rows > 0) {
// 输出数据
while($row = $result->fetch_assoc()) {
$lists = $row;
}
}
exit(json_encode([
'code'=>0,
'data'=> $lists
]));
}
/**
* 按值统计接口
**/
public function value(){
$url = explode('?',$_SERVER['REQUEST_URI']);
$request = explode('/',$url[0]);
$xColumnName = $request[4];
$yColumnName = $request[5];
$token = $this->token();
$tokens = json_decode(base64_decode($token),true);
$where = " where 1 ";
if($tokens['isAdmin'] != 1 && $tokens['tablename'] == 'fangdong') {
$where .= " and `fangdongzhanghao` = '".$tokens['username']."' ";
}
$sql = "SELECT ".$xColumnName.",sum(".$yColumnName.") total FROM fangwuzulin ".$where." group by ".$xColumnName;
if(urldecode($request[6]) == '日') {
$sql = "SELECT DATE_FORMAT(".$xColumnName.", '%Y-%m-%d') ".$xColumnName.", sum(".$yColumnName.") total FROM fangwuzulin ".$where." GROUP BY DATE_FORMAT(".$xColumnName.", '%Y-%m-%d')";
}
if(urldecode($request[6]) == '月') {
$sql = "SELECT DATE_FORMAT(".$xColumnName.", '%Y-%m') ".$xColumnName.", sum(".$yColumnName.") total FROM fangwuzulin ".$where." GROUP BY DATE_FORMAT(".$xColumnName.", '%Y-%m')";
}
if(urldecode($request[6]) == '年') {
$sql = "SELECT DATE_FORMAT(".$xColumnName.", '%Y') ".$xColumnName.", sum(".$yColumnName.") total FROM fangwuzulin ".$where." GROUP BY DATE_FORMAT(".$xColumnName.", '%Y')";
}
$result = table_sql($sql);
if ($result->num_rows > 0) {
// 输出数据
$total = array();
while($row = $result->fetch_assoc()) {
array_push($total,array('total' => intval($row['total']),$xColumnName => $row[$xColumnName]));
}
}
exit(json_encode(['code'=>0,'data'=>$total]));
}
/**
* (按值统计）时间统计类型(多)
**/
public function valueMul(){
$url = explode('?',$_SERVER['REQUEST_URI']);
$request = explode('/',$url[0]);
$xColumnName = $request[4];
$yColumnName = isset($_REQUEST['yColumnNameMul'])? $_REQUEST['yColumnNameMul']:"";
$token = $this->token();
$tokens = json_decode(base64_decode($token),true);
$where = " where 1 ";
if($tokens['isAdmin'] != 1 && $tokens['tablename'] == 'fangdong') {
$where .= " and `fangdongzhanghao` = '".$tokens['username']."' ";
}
$valueData = array();
foreach(explode(",", $yColumnName) as $item){
$sql = "SELECT ".$xColumnName.",sum(".$item.") total FROM fangwuzulin ".$where." group by ".$xColumnName." LIMIT 10";
if(urldecode($request[6]) == '日') {
$sql = "SELECT DATE_FORMAT(".$xColumnName.", '%Y-%m-%d') ".$xColumnName.", sum(".$item.") total FROM fangwuzulin ".$where." GROUP BY DATE_FORMAT(".$xColumnName.", '%Y-%m-%d') LIMIT 10";
}
if(urldecode($request[6]) == '月') {
$sql = "SELECT DATE_FORMAT(".$xColumnName.", '%Y-%m') ".$xColumnName.", sum(".$item.") total FROM fangwuzulin ".$where." GROUP BY DATE_FORMAT(".$xColumnName.", '%Y-%m') LIMIT 10";
}
if(urldecode($request[6]) == '年') {
$sql = "SELECT DATE_FORMAT(".$xColumnName.", '%Y') ".$xColumnName.", sum(".$item.") total FROM fangwuzulin ".$where." GROUP BY DATE_FORMAT(".$xColumnName.", '%Y') LIMIT 10";
}
$result = table_sql($sql);
if ($result->num_rows > 0) {// 输出数据
$total = array();
while($row = $result->fetch_assoc()) {
array_push($total,array('total' => intval($row['total']),$xColumnName => $row[$xColumnName]));
}
$valueData[] = $total;
}
}
exit(json_encode(['code'=>0,'data'=>$valueData]));
}
/**
* 获取需要提醒的记录数接口
* get
*/
public function remind($columnName,$type){
$remindStart = isset($_GET['remindstart'])?$_GET['remindstart']:"";
$remindEnd = isset($_GET['remindend'])?$_GET['remindend']:"";
$token = $this->token();
$tokens = json_decode(base64_decode($token),true);
$where = " where 1 ";//查询条件
if($tokens['isAdmin'] != 1 && $tokens['tablename'] == 'fangdong') {
$where .= " and `fangdongzhanghao` = '".$tokens['username']."' ";
}
if ($type == 1){//数字
if ($remindStart && $remindEnd){
$where .= " and ".$columnName."<='".$remindEnd."' and ".$columnName.">='".$remindStart."'";
}elseif($remindStart){
$where .= " and ".$columnName.">='".$remindStart."'";
}elseif($remindEnd){
$where .= " and ".$columnName."<='".$remindEnd."'";
}
}else{
if ($remindStart && $remindEnd){
$where .= " and ".$columnName."<='".date("Y-m-d",strtotime("+".$remindEnd." day"))."' and ".$columnName.">='".date("Y-m-d",strtotime("+".$remindStart." day"))."'";
}elseif($remindStart){
$where .= " and ".$columnName.">='".date("Y-m-d",strtotime("+".$remindStart." day"))."'";
}elseif($remindEnd){
$where .= " and ".$columnName."<='".date("Y-m-d",strtotime("+".$remindEnd." day"))."'";
}
}
$sql = "select * from `fangwuzulin` ".$where;
$result = table_sql($sql);
exit(json_encode(['code'=> 0 ,'count' => $result->num_rows]));
public function group($columnName){
$token = $this->token();
$tokens = json_decode(base64_decode($token),true);
$where = " where 1 ";
if($tokens['isAdmin'] != 1 && $tokens['tablename'] == 'fangdong') {
$where .= " and `fangdongzhanghao` = '".$tokens['username']."' ";
}
$sql = "SELECT ".$columnName.",count(".$columnName.") as total FROM fangwuzulin ".$where." GROUP BY ".$columnName." ORDER BY $columnName asc";
$result = table_sql($sql);
if ($result->num_rows > 0) {
// 输出数据
$total = array();
while($row = $result->fetch_assoc()) {
array_push($total,array('total' => $row['total'],$columnName => $row[$columnName]));
}
}
exit(json_encode(['code'=>0,'data'=>$total]));
/**
* 批量审批
* post
*/
public function shBatch(){
$ids = strval(file_get_contents("php://input"));//发现接收的是字符串
preg_match_all('/\d+/',$ids,$arr);
$str = implode(',',$arr[0]);//拼接字符，
$sql = "update fangwuzulin set sfsh = '".$_GET['sfsh']."', shhf='".$_GET['shhf']."' WHERE id in(".$str.")";
$result = table_sql($sql);
exit(json_encode(['code'=>0]));
}
}
💕💕作者：计算机源码社
💕💕个人简介：本人 八年开发经验，擅长Java、Python、PHP、.NET、Node.js、Android、微信小程序、爬虫、大数据、机器学习等，大家有这一块的问题可以一起交流！
💕💕学习资料、程序开发、技术解答、文档报告
💕💕如需要源码，可以扫取文章下方二维码联系咨询
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
