Example #1
0
<body class="home">
<?php 
require_once "head.php";
?>
<div class="full-width-wrapper">
  <div class="fixed-width-wrapper" id="body-content"><!--Content-->
    <div id="content" class="fixed-width-wrapper">
      <div class="header-text">
        <ul id="breadcrumbs">
          <li><a href="#" title="">首页</a></li>
          <li class="current"><a href="#" title="">产品中心</a></li>
        </ul>
        <h1 class="first-word double-color sp">产品中心</h1>
      </div>      
      <?php 
$pagex = new page_lister_7x($mysqlhost, $mysqlname, $mysqlpsw, $mydata, "select id from hy_product where name like '%{$q}%' or description like '%{$q}%' or feature like '%{$q}%'", "select * from hy_product where name like '%{$q}%' or description like '%{$q}%' or feature like '%{$q}%'", "12", "7");
while ($row = mysql_fetch_assoc($pagex->rs)) {
    ?>
   
      <table width="978" border="1" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
        <tr>
          <td valign="middle" bgcolor="#FFFFFF"><?php 
    echo $row['id'];
    ?>
</td>
          <td valign="middle" bgcolor="#FFFFFF"><?php 
    echo $row['name'];
    ?>
</td>
          <td valign="middle" bgcolor="#FFFFFF"><img src="uploads/<?php 
    echo getPath($row['thumb'], 'thumb');
Example #2
0
if (!empty($_GET["title"]) && empty($fid)) {
    $cSql = "select id from hy_article where title like '%{$title}%'";
    $pSql = "select * from hy_article where title like '%{$title}%'";
    $condition = "标题中含有'{$title}'";
}
if (empty($_GET["title"]) && !empty($fid)) {
    $cSql = "select id from hy_article where fid={$fid}";
    $pSql = "select * from hy_article where fid={$fid}";
    $condition = "栏目为 {$cate_array[$fid]}";
}
if (!empty($_GET["title"]) && !empty($fid) && intval($fid) > 0) {
    $cSql = "select id from hy_article where title like '%{$title}%' and fid={$fid}";
    $pSql = "select * from hy_article where title like '%{$title}%' and fid={$fid}";
    $condition = "标题中含有'{$title}' 且 栏目为 {$cate_array[$fid]}";
}
$pagex = new page_lister_7x($mysqlhost, $mysqlname, $mysqlpsw, $mydata, $cSql, $pSql, "12", "7");
?>
<table width="99%" height="393" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="17" valign="top" background="images/mail_leftbg.gif"><img src="images/left-top-right.gif" width="17" height="29" /></td>
    <td valign="top" background="images/content-bg.gif"><table width="100%" height="31" border="0" cellpadding="0" cellspacing="0" class="left_topbg" id="table2">
      <tr>
        <td height="31"><div class="titlebt">管理文章</div></td>
      </tr>
    </table></td>
    <td width="16" valign="top" background="images/mail_rightbg.gif"><img src="images/nav-right-bg.gif" width="16" height="29" /></td>
  </tr>
  <tr>
    <td height="345" valign="middle" background="images/mail_leftbg.gif">&nbsp;</td>
    <td valign="top" bgcolor="#F7F8F9">
      
Example #3
0
$rs = mysql_query($sql, $conn);
while ($row = mysql_fetch_assoc($rs)) {
    ?>
            <th index="1"><?php 
    echo $row['name'];
    ?>
</th>
<?php 
}
?>
            
          </tr>
        </thead>
        <tbody>
<?php 
$pagex = new page_lister_7x($mysqlhost, $mysqlname, $mysqlpsw, $mydata, "select id from hy_product where fid={$_GET['fid']}", "select * from hy_product where fid={$_GET['fid']} order by id desc", "12", "7");
while ($row = mysql_fetch_assoc($pagex->rs)) {
    ?>
      
        <tr>
            <td align="center"><div class="check"></div>
            <div class="name"><a id="o1_flyout" href="product.php?id=<?php 
    echo $row['id'];
    ?>
&fid=<?php 
    echo $row['fid'];
    ?>
" target="_tiProd"><?php 
    echo $row['name'];
    ?>
</a> <?php