1。Warning: mysqli_query() expects at least 2 parameters, C:\wamp\www\leave\student\index.php on line 9
2。Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in C:\wamp\www\leave\student\index.php on line 12完整代码:<?php
$page = empty($_GET['page'])?1:$_GET['page'];//获取地址栏的参数 page的值
$keyword = empty($_GET['keyword'])?'':$_GET['keyword'];
$pagesize = 20; //每页显示10条记录
$offset = ($page-1)*$pagesize;
$sqli = "select * from `leave` where leave_text like '%$keyword%' limit $offset,$pagesize";
$query = mysqli_query($sqli); //执行查询命令返回的是结果集
//$row = mysqli_fetch_assoc($query); //将结果集转换成数组 ,但是每次只转换一条数据,指针指向下一条,如果下一条没有数据了,直接返回false
$result = array();
while($row = mysqli_fetch_assoc($query)){
$sqli = "select * from teacher where teacher_id = ".$row['teacher_id'];
$q = mysqli_query($sqli);
$one = mysqli_fetch_assoc($q);
$row['teacher_name'] = $one['name'];
$result[] = $row;
//print_r($row);
}
//print_r($result);?>
2。Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, null given in C:\wamp\www\leave\student\index.php on line 12完整代码:<?php
$page = empty($_GET['page'])?1:$_GET['page'];//获取地址栏的参数 page的值
$keyword = empty($_GET['keyword'])?'':$_GET['keyword'];
$pagesize = 20; //每页显示10条记录
$offset = ($page-1)*$pagesize;
$sqli = "select * from `leave` where leave_text like '%$keyword%' limit $offset,$pagesize";
$query = mysqli_query($sqli); //执行查询命令返回的是结果集
//$row = mysqli_fetch_assoc($query); //将结果集转换成数组 ,但是每次只转换一条数据,指针指向下一条,如果下一条没有数据了,直接返回false
$result = array();
while($row = mysqli_fetch_assoc($query)){
$sqli = "select * from teacher where teacher_id = ".$row['teacher_id'];
$q = mysqli_query($sqli);
$one = mysqli_fetch_assoc($q);
$row['teacher_name'] = $one['name'];
$result[] = $row;
//print_r($row);
}
//print_r($result);?>
Call Stack
/*
Navicat MySQL Data TransferSource Server : 888
Source Server Version : 50540
Source Host : localhost:3306
Source Database : leaveTarget Server Type : MYSQL
Target Server Version : 50540
File Encoding : 65001Date: 2019-06-24 21:15:46
*/SET FOREIGN_KEY_CHECKS=0;-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` char(20) NOT NULL,
`password` char(30) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES ('1', 'admin', '123456');-- ----------------------------
-- Table structure for leave
-- ----------------------------
DROP TABLE IF EXISTS `leave`;
CREATE TABLE `leave` (
`leave_id` int(11) NOT NULL AUTO_INCREMENT,
`student_id` int(11) NOT NULL COMMENT '请假的学生对应的student_id',
`leave_time` text,
`teacher_id` int(11) NOT NULL COMMENT '审批的老师对应的teacher_id',
`leave_text` text COMMENT '请假原因',
`add_time` int(11) DEFAULT NULL COMMENT '写请假单的时间',
`approval_time` int(11) DEFAULT NULL COMMENT '审批时间',
`status` tinyint(1) NOT NULL COMMENT '0是待审批 1 审批通过 -1 审批不通过',
PRIMARY KEY (`leave_id`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of leave
-- ----------------------------
INSERT INTO `leave` VALUES ('1', '7', '7月1号-7月30号', '2', '回家相亲', null, null, '1');
INSERT INTO `leave` VALUES ('2', '7', '2019-7-1 到 2019-8-1', '3', '回家放牛', '1561378262', '1561381340', '1');
INSERT INTO `leave` VALUES ('3', '7', '2019-7-1 到 2019-8-1', '3', '回家放牛', '1561378370', '1561381345', '-1');
INSERT INTO `leave` VALUES ('4', '7', '明天早上9点-下午18:00', '1', '回去看病', '1561379724', null, '0');
INSERT INTO `leave` VALUES ('5', '7', '明天早上9点-下午18:00', '3', 'kkkkk', '1561381437', '1561381463', '-1');-- ----------------------------
-- Table structure for student
-- ----------------------------
DROP TABLE IF EXISTS `student`;
CREATE TABLE `student` (
`student_id` int(11) NOT NULL AUTO_INCREMENT,
`student_no` char(20) NOT NULL COMMENT '学号',
`password` char(32) NOT NULL,
`name` char(30) NOT NULL COMMENT '姓名',
`phone` char(11) NOT NULL COMMENT '手机号',
`sex` tinyint(1) NOT NULL DEFAULT '0' COMMENT '性别 0男1女',
`classname` char(50) DEFAULT NULL COMMENT '班级名称',
PRIMARY KEY (`student_id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of student
-- ----------------------------
INSERT INTO `student` VALUES ('1', '2007107100', 'e10adc3949ba59abbe56e057f20f883e', '刘备', '134564565', '1', '计算机3班');
INSERT INTO `student` VALUES ('2', '2007107106', 'e10adc3949ba59abbe56e057f20f883e', '张行', '1512154654', '0', '计算机4班');
INSERT INTO `student` VALUES ('3', '2011', 'c8758b517083196f05ac29810b924aca', '张思', '1345788965', '1', '07班');
INSERT INTO `student` VALUES ('6', '', 'dc5c7986daef50c1e02ab09b442ee34f', '曹操', '1345788965', '0', '');
INSERT INTO `student` VALUES ('7', '2019', 'ea6b2efbdd4255a9f1b3bbc6399b58f4', '凌宇', '13457996577', '0', '1702班');-- ----------------------------
-- Table structure for teacher
-- ----------------------------
DROP TABLE IF EXISTS `teacher`;
CREATE TABLE `teacher` (
`teacher_id` int(11) NOT NULL AUTO_INCREMENT,
`teacher_no` char(30) NOT NULL COMMENT '教师编号',
`password` char(32) NOT NULL COMMENT '登陆密码',
`name` char(30) DEFAULT NULL,
`sex` tinyint(1) NOT NULL DEFAULT '0' COMMENT '性别0男1女',
`phone` char(11) DEFAULT NULL,
PRIMARY KEY (`teacher_id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;-- ----------------------------
-- Records of teacher
-- ----------------------------
INSERT INTO `teacher` VALUES ('1', '001', 'e10adc3949ba59abbe56e057f20f883e', '曹操', '0', '1345788965');
INSERT INTO `teacher` VALUES ('2', '002', 'e10adc3949ba59abbe56e057f20f883e', '小乔', '1', '1345788964');
INSERT INTO `teacher` VALUES ('3', '003', 'e88a49bccde359f0cabb40db83ba6080', '大乔', '1', '15287895');