菜鸟中的菜鸟啊,刚进公司就让做项目啊
最简单的都不会啊,百度了半天也没找到方法
想问一下现在想做一个用户管理模块的增删改查,应该怎么做呢?
收先,select * from user 的输出怎么输出啊
还有,每个输出结果之后都要加个两个按钮 修改 删除
求解啊,怎么做啊user百度增删改查问题
最简单的都不会啊,百度了半天也没找到方法
想问一下现在想做一个用户管理模块的增删改查,应该怎么做呢?
收先,select * from user 的输出怎么输出啊
还有,每个输出结果之后都要加个两个按钮 修改 删除
求解啊,怎么做啊user百度增删改查问题
session_start();
include 'conn/conn.php';
include 'check_login.php';
include 'page.class.php';
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>更改医院信息</title>
<link rel="stylesheet" type="text/css" href="style/modhos.css" />
</head>
<body>
<div id="content">
<h1>123</h1>
<table cellspacing="0">
<caption>修改医院信息</caption>
<thead>
<th>医院名称</th>
<th>位置</th>
<th>总需求人数</th>
<th>是否分性别</th>
<th>需求男</th>
<th>需求女</th>
<th>操作</th>
<th>操作</th>
</thead>
<tbody>
<?php
$sql = "select * from hos ;";
$result = mysql_query($sql)or die(mysql_error());
$page=new Page(mysql_num_rows($result),15);
$sql="select * from hos order by id {$page->limit}";
$result = mysql_query($sql)or die(mysql_error());
$info = mysql_fetch_array($result);
do {?>
<tr>
<td><?php echo $info['name'];?></td>
<td><?php echo $info['location'];?></td>
<td><?php echo $info['total'];?></td>
<td><?php
if($info['same']){echo "是";}
else{echo "否";};
?>
<td><?php
if($info['same']){echo $info['men'];}
else {echo "-";}?></td>
<td><?php
if($info['same']){echo $info['wom'];}
else {echo "-";}?></td>
<td><a href="mod_hos1.php?id=<?php echo $info['id'];?>">更改</a></td>
<td><a href="del_hos.php?id=<?php echo $info['id'];?>" onclick= "return confirm('你确定删除吗?')">删除</a></td>
</tr>
<?php }while($info = mysql_fetch_assoc($result)); ?>
</tbody>
</table>
</div>
</body>
</html>
class Page {
private $total; //数据表中总记录数
private $listRows; //每页显示行数
private $limit;
private $uri;
private $pageNum; //页数
private $config=array('header'=>"", "prev"=>"Page_up", "next"=>"Page_down", "first"=>"First_page", "last"=>"Last_page");
private $listNum=8;
/*
* $total
* $listRows
*/
public function __construct($total, $listRows=10, $pa=""){
$this->total=$total;
$this->listRows=$listRows;
$this->uri=$this->getUri($pa);
$this->page=!empty($_GET["page"]) ? $_GET["page"] : 1;
$this->pageNum=ceil($this->total/$this->listRows);
$this->limit=$this->setLimit();
} private function setLimit(){
return "Limit ".($this->page-1)*$this->listRows.", {$this->listRows}";
} private function getUri($pa){
$url=$_SERVER["REQUEST_URI"].(strpos($_SERVER["REQUEST_URI"], '?')?'':"?").$pa;
$parse=parse_url($url); if(isset($parse["query"])){
parse_str($parse['query'],$params);
unset($params["page"]);
$url=$parse['path'].'?'.http_build_query($params);
} return $url;
} private function __get($args){
if($args=="limit")
return $this->limit;
else
return null;
} private function start(){
if($this->total==0)
return 0;
else
return ($this->page-1)*$this->listRows+1;
} private function end(){
return min($this->page*$this->listRows,$this->total);
} private function first(){
if($this->page==1)
$html.='';
else
$html.=" <a href='{$this->uri}&page=1'>{$this->config["first"]}</a> "; return $html;
} private function prev(){
if($this->page==1)
$html.='';
else
$html.=" <a href='{$this->uri}&page=".($this->page-1)."'>{$this->config["prev"]}</a> "; return $html;
} private function pageList(){
$linkPage="";
$inum=floor($this->listNum/2);
for($i=$inum; $i>=1; $i--){
$page=$this->page-$i; if($page<1)
continue; $linkPage.=" <a href='{$this->uri}&page={$page}'>{$page}</a> "; }
$linkPage.=" {$this->page} ";
for($i=1; $i<=$inum; $i++){
$page=$this->page+$i;
if($page<=$this->pageNum)
$linkPage.=" <a href='{$this->uri}&page={$page}'>{$page}</a> ";
else
break;
} return $linkPage;
} private function next(){
if($this->page==$this->pageNum)
$html.='';
else
$html.=" <a href='{$this->uri}&page=".($this->page+1)."'>{$this->config["next"]}</a> "; return $html;
} private function last(){
if($this->page==$this->pageNum)
$html.='';
else
$html.=" <a href='{$this->uri}&page=".($this->pageNum)."'>{$this->config["last"]}</a> "; return $html;
} private function goPage(){
return ' <input type="text" onkeydown="javascript:if(event.keyCode==13){var page=(this.value>'.$this->pageNum.')?'.$this->pageNum.':this.value;location=\''.$this->uri.'&page=\'+page+\'\'}" value="'.$this->page.'" style="width:25px"><input type="button" value="GO" onclick="javascript:var page=(this.previousSibling.value>'.$this->pageNum.')?'.$this->pageNum.':this.previousSibling.value;location=\''.$this->uri.'&page=\'+page+\'\'"> ';
}
function fpage($display=array(0,1,2,3,4,5,6,7,8)){
$html[0]='';
$html[1]='';
$html[2]=" <b>{$this->page}/{$this->pageNum}</b> ";
$html[3]=$this->first();
$html[4]=$this->prev();
$html[5]=$this->pageList();
$html[6]=$this->next();
$html[7]=$this->last();
$html[8]=$this->goPage();
$fpage='';
foreach($display as $index){
$fpage.=$html[$index];
} return $fpage; }
}