欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

【php】三、学生管理系统-查看用户

程序员文章站 2022-05-23 21:14:19
...
【php】3、学生管理系统-查看用户
getpagecount($pagesize);    if(!empty($_GET['pagenow']))    {        $pagenow=$_GET['pagenow'];    }    $stulist = $service->getstulist($pagesize, $pagenow);    ?>		学生成绩管理系统
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; ?>
学生ID号 学生姓名 学生密码
"; //显示上一页和下一页 if($pagenow > 1) { $prePage=$pagenow - 1; echo "上一页   "; echo "《《   "; } echo ""; //中间打印10页选择 for($i=$pagenow; $i $i   "; } } echo ""; //下一页 if($pagenow 》》   "; echo "下一页   "; } echo ""; echo "当前页$pagenow/共{$pagecount}页面"; echo "
跳转到:


stuservice类

execute_dql($sql);            $row=mysqli_fetch_row($res);            if($row)            {                $num=$row[0];            }                        mysqli_free_result($res);            $mysql->close_connect();            return $num;                        }                //根据每页的大小,和当前的页面查询出所有的学生        public function getstulist($pagesize,$pagenow)        {            $mysql = new mysql(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);                        $sql="select * from student limit ".($pagenow-1)*$pagesize.",$pagesize";            $res=$mysql->execute_dql($sql);                        $arr=array();                        $i=0;                        while($row = mysqli_fetch_assoc($res))            {                $arr[$i++]=$row;            }                        mysqli_free_result($res);            $mysql->close_connect();            return $arr;        }                //得到总页数        public function getpagecount($pagesize)        {			$mysql = new mysql(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);			$sql="select count(stu_id) from student";			$res=$mysql->execute_dql($sql);						$i=0;			$row = mysqli_fetch_row($res);			if($row)			{				$rowcount=$row[0];			}						$pagecount=ceil($rowcount/$pagesize);    //返回不小于 value 的下一个整数,value 如果有小数部分则进一位。 			mysqli_free_result($res);			$mysql->close_connect();			return $pagecount;		}				//根据学生姓名得到相应数据		public function getstu($name)		{		    $stu = new student();		    $mysql = new mysql(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);		    $sql="select * from student where stu_name='".$name."'";		    $res=$mysql->execute_dql($sql);		    		    if($row = mysqli_fetch_assoc($res))		    {		        $stu->setStu_id($row['stu_id']);		        $stu->setStu_name($row['stu_name']);		        $stu->setStu_password($row['stu_password']);		    }		    		    mysqli_free_result($res);		    $mysql->close_connect();		    return $stu;		    		}				//根据id号获取user		public function getstubyid($id)		{		    $stu = new student();		    $mysql = new mysql(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);		    $sql="select * from student where stu_id='".$id."'";		    $res=$mysql->execute_dql($sql);		    		    if($row = mysqli_fetch_assoc($res))		    {		        $stu->setStu_id($row['stu_id']);		        $stu->setStu_name($row['stu_name']);		        $stu->setStu_password($row['stu_password']);		    }		    		    mysqli_free_result($res);		    $mysql->close_connect();		    return $stu;		}				//根据得到的对象修改数据库中的值		public function update(student $stu)		{		    $mysql = new mysql(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);		    $sql="update student set stu_name='".$stu->getStu_name()."',stu_password='".$stu->getStu_password()."'		                  where stu_id=".$stu->getStu_id();		    		    $b = $mysql->execute_dml($sql);// 		    if($b == 1)// 		    {// 		        return true;// 		    }            return $b;		}				//删除用户		public function delete(student $stu)		{		    $mysql = new mysql(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME);		    $sql = "delete from student where stu_id=".$stu->getStu_id().";";		    $b = $mysql->execute_dml($sql);		    		    return $b;		}    }?>

mysql类

link = new mysqli($this->db_host, $this->db_user, $this->db_password, $this->db_name);// 		    if(!$this->link){// 				die("连接失败".mysql_error());// 			}			//mysql_select_db($this->dbname,$this->link);		}				//执行SQL语句得到结果集,查询语句		public function execute_dql($sql)		{		    $res = $this->query($sql) or die(mysqli_error($this));		    return $res;		}				//执行SQLdml语句插入,更新,删除		public function execute_dml($sql)		{		    $b = $this->query($sql) or die(mysqli_error($this));		    if(!$b)		    {		        return 0;		    }		    else		    {		        if($this->affected_rows > 0)    //如果收影响的行数大于0		        {		            return 1; //OK了		        }		        else		        {		            return 2; //没有行收到影响		        }		    }		}				//关闭连接		public function close_connect()		{		    if(!empty($this))		        $this->close();		}    } ?>

student类

stu_id;        }          /**         * @return the $stu_name         */        public function getStu_name()        {            return $this->stu_name;        }          /**         * @return the $stu_password         */        public function getStu_password()        {            return $this->stu_password;        }          /**         * @param field_type $stu_id         */        public function setStu_id($stu_id)        {            $this->stu_id = $stu_id;        }          /**         * @param field_type $stu_name         */        public function setStu_name($stu_name)        {            $this->stu_name = $stu_name;        }          /**         * @param field_type $stu_password         */        public function setStu_password($stu_password)        {            $this->stu_password = $stu_password;        }    }    ?>    

config.php配置数据库


预览:

【php】三、学生管理系统-查看用户






【php】三、学生管理系统-查看用户

声明:本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn核实处理。

相关文章

相关视频