封装类分页查询

1.引用封装类

<!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=utf-8" />
<title>无标题文档</title>
</head>

<body>
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
    <td>地区代号</td>
    <td>地区名称</td>
    <td>地区父级代号</td>
</tr>
<?php

    //加载类
    include("DBDA.php");
    include("page.class.php");
    
    //造对象
    $db = new DBDA();
    $sqlcount = "select count(*) from ChinaStates";
    $atrrc =  $db->Query($sqlcount);
    $total = $atrrc[0][0];
    
    //造分页对象
    $page = new page($total,15,"");
    
    $page->set('head','条数据');
    $page->set('prev',"<img src='0063.png' width='15' height='15' />");
    $page->set('frist','第一页');
    
    //显示
    $sql = "select * from ChinaStates ".$page->limit;
    echo $sql;
    $attr = $db->Query($sql);
    
    for($i=0;$i<count($attr);$i++)
    {
        echo "<tr><td>{$attr[$i][0]}</td><td>{$attr[$i][1]}</td><td>{$attr[$i][2]}</td></tr>";
    }
    
?>
</table>
<?php
    echo $page->fpage();
?>
</body>
</html>

2.查询

<!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=utf-8" />
<title>无标题文档</title>
</head>

<body>

<div>
    <form action="Test.php" method="post">
    <div>
        名称：
        <input type="text" name="name" />
        价格：
        <input type="text" name="price" />
        <input type="submit" value="查询" />
    </div>
    </form>
</div>
<br />
<table width="100%" border="1" cellpadding="0" cellspacing="0">
<tr>
    <td>代号</td>
    <td>名称</td>
    <td>价格</td>
</tr>
<?php
    
    include("DBDA.php");
    $db = new DBDA();
    
    /*$str = "";
    if(!empty($_POST["name"]))
    {
        $name = $_POST["name"];
        $price = $_POST["price"];
        
        $str ="";
        
        $str = "where";
        $tj1 = "";
        if($name !="")
        {
            $tj1 = " Name like '%{$name}%'";
        }
        else
        {
            $tj1 =" 1=1";
        }
        if($price !="")
        {
            $tj2 = "price ='{$price}'";
        }
        else
        {
            $tj2 ="1=1";
        }
        $str = "where".$tj1." and ".$tj2;
        
    }*/
    
        @$name = $_POST["name"];
        @$price = $_POST["price"];
        
        $str ="";
        
        //查询
        $tj1 = " 1=1";
        $tj2 = " 1=1";
        if($name !="")
        {
            $tj1 = " Name like '%{$name}%'";
        }
        
        if($price !="")
        {
            $tj2 = "price ={$price}";
        }
        $str = " where".$tj1." and ".$tj2;
    
    //写SQL语句
    $sql = "select Code,Name,Price from Car".$str;
    
    echo $sql;
    //调用里面的query方法执行SQL语句
    $attr = $db->Query($sql);
    
    for($i=0;$i<count($attr);$i++)
    {
        //关键字变色处理
        $mc = str_replace($name,"<mark><span style= 'color:red'>{$name}</span></mark>>",$attr[$i][1]);
        //$attr[$i][0];
        echo "<tr><td>{$attr[$i][0]}</td><td>{$mc}</td><td>{$attr[$i][2]}</td></tr>";
    }
    
    
    
    
    
    
    


?>
</table>
</body>
</html>

查询关键字变色处理

posted @ 2016-03-30 20:44  小美好。  阅读(498)  评论(0)  编辑  收藏  举报