//原装分页
<?php
header("Content-type:text/html;Charset=utf8");
$link=mysqli_connect("localhost:3306","root","root","weektwo");
if(!$link) echo "连接失败的原因是：" . mysqli_connect_error();
mysqli_query($link,"set names utf8");
$tiao=4;
$sql="select count(*) from kao";
$res=mysqli_query($link,$sql);
$zong=mysqli_fetch_assoc($res);
$z=count($zong);
$max=ceil($z/$tiao);
if(!$_GET['page']){
$page=1;
}else{
if($page<1){
$page=1;
}elseif($page>$max){
$page=$max;
}else{
$page=$_GET['page'];
}
}
$ye=($page-1)*$tiao;
$sql="select * from kao where limit ".$ye.",".$tiao;
$a=mysqli_query($link,$sql);
while($res=mysqli_fetch_assoc($a)){
$arr[]=$res;
}
// var_dump($arr);die;
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>
<table border="1">
<tr>
<td>编号</td>
<td>姓名</td>
<td>分类</td>
<td>单价</td>
<td>状态</td>
<td>库存</td>
<td>产地</td>
</tr>
<?php foreach($arr as $key => $v) {?>
<tr>
<td><?php echo $v['id']?></td>
<td><?php echo $v['name']?></td>
<td><?php echo $v['fen']?></td>
<td><?php echo $v['dj']?></td>
<td><?php echo $v['zhuang']?></td>
<td><?php echo $v['kucun']?></td>
<td><?php echo $v['chan']?></td>
</tr>
<?php }?>
<a href="1.php?page=1">首页</a>
<a href="1.php?page=<?php echo $page-1;?>">上一页</a>
<a href="1.php?page=<?php echo $page+1;?>">下一页</a>
<a href="1.php?page=<?php echo $max;?>">尾页</a>
</table>
</body>
</html>
//正则验证
各种验证
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>正则</title>
</head>
<body>
<form action="" onsubmit="fun()">
<table border="1">
<tr>
<td>姓名</td>
<td><input type="text"></td>
<td width="200"><span></span></td>
</tr>
<tr>
<td>性别</td>
<td>
<input type="radio" name="sex">男
<input type="radio" name="sex">女
</td>
<td width="200"><span></span></td>
</tr>
<tr>
<td>密码</td>
<td><input type="text" id="xm"></td>
<td width="200"><span></span></td>
</tr>
<tr>
<td>确认密码</td>
<td><input type="text" id="xm"></td>
<td width="200"><span></span></td>
</tr>
<tr>
<td>邮箱</td>
<td><input type="text"></td>
<td width="200"><span></span></td>
</tr>
<tr>
<td>城市</td>
<td>
<select name="a4" id="o" onclick="fun1()">
<option value="">请选择</option>
<option value="0" >北京</option>
<option value="1">上海</option>
<option value="2">衡水</option>
<option value="3">石家庄</option>
</select>
</td>
<td width="200"><span></span></td>
</tr>
<tr>
<td>手机号</td>
<td><input type="text"></td>
<td width="200"><span></span></td>
</tr>
<tr>
<td>座机号</td>
<td><input type="text"></td>
<td width="200"><span></span></td>
</tr>
<tr>
<td>身份证号</td>
<td><input type="text"></td>
<td width="200"><span></span></td>
</tr>
<tr>
<td>QQ号</td>
<td><input type="text"></td>
<td width="200"><span></span></td>
</tr>
<tr>
<td>自我介绍</td>
<td><input type="text"></td>
<td width="200"><span></span></td>
</tr>
<tr>
<td><input type="submit" value="登录"></td>
<td><input type="submit" value="重置"></td>
</tr>
</table>
</form>
<script>
var inp = document.getElementsByTagName('input');
var sp = document.getElementsByTagName('span');
var o = document.getElementsByTagName('option');
var reg = /^[a-zA-Z][a-zA-Z0-9]{4,9}$/;
var pass =/^[a-zA-Z0-9_]{6,}$/;
var p=/^[0-9]+[a-zA-Z]{3,}$/;
var emile =/^[a-zA-Z0-9]+@[a-zA-Z0-9](.)(.net|cn){2,6}$/;
var tel =/^1[5|8|3][0-9]{9}$/;
var qq= /^[0-9]{8,11}$/;
var t=/^[0-9][0-9][0-9]-[0-9]{8}$/;
var shen=/^[0-9]{14,17}[0-9X]$/;
var te=/^[0-9a-zA-Z_]{0,20}$/;
var city=/^[0-9]$/;
inp[0].onblur = function (){
//console.log(inp[0].value);
if(!reg.test(inp[0].value)){
sp[0].innerText = "必须由5到10位数字或字母组成，不允许数字开头";
}else{
sp[0].innerText= "√";
}
}
inp[3].onblur = function (){
if(!pass.test(inp[3].value)){
sp[2].innerText = "密码必须在6位以上";
}else{
sp[2].innerText= "√";
}
}
inp[3].onblur = function (){
if(!pass.test(inp[3].value)){
sp[2].innerText="密码必须6位以上";
}else{
sp[2].innerText="√";
}
}
inp[4].onblur = function (){
if(inp[3].value!=inp[4].value){
sp[3].innerText = "确认密码和密码必须一致";
}else{
sp[3].innerText= "√";
}
}
function fun(){
var sex=document.getElementsByName('sex');
if(!sex[0].checked && !sex[1].checked){
sp[1].innerText="必选一项";
}else{
sp[1].innerText= "√";
}
}
inp[5].onblur = function (){
if(!emile.test(inp[5].value)){
sp[4].innerText = "必须包含@符号或者cn或者.net结尾";
}else{
sp[4].innerText= "√";
}
}
inp[6].onblur = function (){
if(!tel.test(inp[6].value)){
sp[6].innerText = "必须是11位数字开头，以15，18，13开头";
}else{
sp[6].innerText= "√";
}
}
inp[7].onblur = function (){
if(!t.test(inp[7].value)){
sp[7].innerText = "必须是010-68801717这种格式，前面三位是区号，后面是8位电话号，中间是-";
}else{
sp[7].innerText= "√";
}
}
inp[8].onblur = function (){
if(!shen.test(inp[8].value)){
sp[8].innerText = "必须是15到18位数字组成，18位的最后一位可以是X";
}else{
sp[8].innerText= "√";
}
}
inp[9].onblur = function (){
if(!qq.test(inp[9].value)){
sp[9].innerText = "必须是8到11位数字组成";
}else{
sp[9].innerText= "√";
}
}
inp[10].onblur = function (){
if(!te.test(inp[10].value)){
sp[10].innerText = "必须是8到11位数字组成";
}else{
sp[10].innerText= "√";
}
}
function fun1(){
var o=document.getElementById('o');
if(!city.test(o.value)){
sp[5].innerText = "必选一项";
return false;
}else{
sp[5].innerText= "√";
return true;
}
}
</script>
</body>
</html>