
平台论坛博客文库

› 论坛 › 程序设计 › PHP › smarty问题，求助

smarty问题，求助 [复制链接]

niedongming

白手起家

论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2008-04-08 10:55 |只看该作者 |倒序浏览

问题如下，我用PHP+smarty做了个分页，分页正常显示了，但是内容列表却显示不了，对smarty不甚了解，还请大家指导，我把代码贴出来

PHP file

<?php
/*
 * Created on 2008-4-7
 *
 * To change the template for this generated file go to
 * Window - Preferences - PHPeclipse - PHP - Code Templates
 */
  include_once("../smarty/temp/Smarty.class.php"); //包含smarty类文件

define("NUM",8 ); //定义每次显示的新闻条数

require('../include/mysql.php');
$smarty = new Smarty(); //建立smarty实例对象$smarty

$smarty->templates_dir = "../smarty/china/"; //设置模板目录

$smarty->compile_dir = "../smarty/templates_c"; //设置编译目录

$smarty->cache_dir = "../smarty/cache"; //设置缓存目录

$smarty->cache_lifetime = 60 * 60 * 24; //设置缓存时间

$smarty->caching = false; //这里是调试时设为false,发布时请使用true

$smarty->left_delimiter = "<{"; //设置左边界符

$smarty->right_delimiter = "}>"; //设置右边界符

$db = mysql_connect("$db_server", "$db_username", "$db_password") or die("数据库连接错误!");
mysql_select_db("$db_name", $db);
mb_internal_encoding("UTF-8");
//silk line list

    //$smarty->caching = false;

    $lady_url ="http://192.168.0.141/china/silk.php";
    $content = array();
    $pagesize = 1;
    $strQuery= "SELECT id,line_name,line_upload,line_intro,line_vprice from line_lines where line_show=0 order by id desc";
    $result = mysql_query($strQuery);
    //结果集

    $total = mysql_num_rows($result);
    //记录条数

    $totalpage = ceil($total/$pagesize);
    //总页数

    $page = ceil($_GET["pos"])+1;
    //当前页

    $strQuery= "limit ".($pagesize * ($page-1)).", ".$pagesize;
    //语句

    $idx = 0;
    $result = mysql_query($strQuery);
    while ($row = @mysql_fetch_array($result))
{     
        $array[] = array("id"=>$row["id"],
                         "name"=>$row["line_name"],
                         "price"=> $row["line_vprice"],
                         'image'=>$row['line_upload'],
                         'intro'=>$row['line_intro'],
);    
    }
    $smarty->assign("line_list", $array);
    unset($array);
    $smarty->assign('totalpage',$totalpage);
    $smarty->assign('lady_url',$lady_url);
    $smarty->display("silk.tpl",$page);

mysql_close($db);
$smarty->display("../../smarty/china/silk.tpl");
?>

TPL:

<{section name=loop loop=$line_list}>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" class="shtour2">
<tr>
<td width="82%" height="20" class="shtour2"><h3><{$line_list[loop].name}></h3></td>
<td width="18%" align="center" class="STYLE5">$<{$line_list[loop].price}></td>
</tr>
<tr>
<td colspan="2"><table width="590" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="490" height="50" align="left" class="shtour2"><{$line_list[loop].intro}></td>
<td width="100" rowspan="2" align="center"><img src="../<{$line_list[loop].image}>" width="90" height="60" border="1"></td>
</tr>
<tr>
<td height="20" align="left" class="shtour2">Detail</td>
</tr>
</table></td>
</tr>
</table>
<{sectionelse}>
对不起，没有任何新闻输入！
<{/section}>
<br>
<{pager rowcount=$totalpage limit=1 shift=1 no_first=true separator="|" class_text="pager_text" txt_pos="side"}>
<p> </p></td>
</tr>
</table>

复制代码

文库|博客

niedongming

白手起家

论坛徽章:: 0

2楼 [报告]

发表于 2008-04-08 11:09 |只看该作者

效果图

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

ideawu

小富即安

论坛徽章:: 0

3楼 [报告]

发表于 2008-04-08 12:08 |只看该作者

数据库没数据, $line_list为空.

niedongming

白手起家

论坛徽章:: 0

4楼 [报告]

发表于 2008-04-08 12:34 |只看该作者

mysql> use tourochi_tour;
Database changed
mysql> SELECT id,line_name,line_upload,line_intro,line_vprice from line_lines wh
ere line_show=0 order by id desc;
+----+--------------------------------------------------------------------------
-----+-----------------------------------------------+--------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-------------------------------------------------+-------------+
| id | line_name
| line_upload | line_intro
| line_vprice |
+----+--------------------------------------------------------------------------
-----+-----------------------------------------------+--------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-------------------------------------------------+-------------+
| 84 | 10-day tour to Beijing, Xian, Guilin and Hong Kong
| /uploadfiles/lines/2008/03/xian1.jpg | This fatastic 12-day tour
will show you the elite sceneries of China. The imposing Great Wall, limpid Li
River, ancinet Terracotta Warriors in Xian , a modern Shanghai and "the Pearl of
the Orient" Hong Kong are all included in this tour. You may have a comprehensi
ve experience of this magic nation. | 1550.00 |
| 83 | Elite Tour of China
| /uploadfiles/lines/2008/03/suzhou garden3.jpg | China covers a large area
, ranking third in the world. It is granted with diverse sceneries. In this 12-d
ay tour you may experience for yourself the differences
| 1458.00 |
| 82 | East China Tour
| /uploadfiles/lines/2008/03/suzhou garden4.jpg | Enjoy sightseeing of beau
tiful Chinese gardens and small steams winding around featured ancient houses. A
lso you may wander arouns old stone arch bridges.
| 583.00 |
| 81 | Sightseeing of Chinese Ancient Capitals
| /uploadfiles/lines/2008/03/summer palace.jpg | Many dynasties rose and f
ell in China鈥檚 long histiry. They left many valuable historical relics which w
e can visit today. Don鈥檛 hesitate. Come to China and visit those imperial for
yourself
| 1410.00 |
| 80 | Beijing and Shanghai 6 Days Tour
| /uploadfiles/lines/2008/03/beijing~.jpg | Beijing, capital of China
, is also the political center. Its long history left it with many cultural heri
tages. Shanghai, a metropolitan city, is economic center of China. In this 6-da
y tour, we will guide you to explore these two cities.
| 529.00 |
| 79 | Shanghai, Beijing and Kongfu 11- day Experience
| /uploadfiles/lines/2008/03/shaolin.jpg | Imposing Beijing, modern
Shanghai and mysterious Shaolin Kungfu, while refering to China, those words may
appear in your mind. In this tour you have the opportunity to visit those place
s for yourself. Come and experience this magic nation.
| 1199.00 |
| 78 | Exotic Experience in West China
| /uploadfiles/lines/2008/03/hohhot5.jpg | In this 8-day tour you ha
ve the chance to climb the imposing Great Wall and explore the elegant Summer Pa
lace and other historical relics in Beijing. Another highlight of this tour is t
he beauty of natural grassland in Hohhot. Anyway you will find a different China
in this tour. | 739.00 |
| 76 | Beijing and East China Tour
| /uploadfiles/lines/2008/03/optv.jpg |
| 1328.00 |
| 75 | Beijing Shanghai and Mt. Yellow
| /uploadfiles/lines/2008/03/west lake.jpg |
| 1119.00 |
| 74 | 11-day tour to Beijing, Shanghai, and Water Towns
| /uploadfiles/lines/2008/03/west lake2.jpg |
| 1139.00 |
| 73 | 14-day tour around Beijing, Mt.Yellow,Suzhou, Zhou Village, Xian and Hang
zhou | /uploadfiles/lines/2008/03/mt. yellow.jpg | A 14-Day private tour tou
r includes highlight cities in China, such as Beijing, Shanghai, Xian. Mt. Yello
w and also feature water towns of South China, such as Zhouzhuang. Gardens in Su
zhou is also a must while travelling in China.
| 1409.00 |
| 71 | 10 Days Tour to Beijing, Xian,Guilin,Yangshuo and Shanghai
| /uploadfiles/lines/2008/03/guilin.jpg | This wonderful tour is a
combination of the latter-day China together with the Ming-Qing royal collapse(B
eijing), the ancient attraction of China (Xi鈥檃n), a cosmopolitan city(Shanghai
), and Guilin鈥檚 extremely charming natural sceneries.
| 2399.00 |
| 70 | 8 Days Tour Beijing, Shanghai and Xian
| /uploadfiles/lines/2008/03/forbidden city.jpg | Long history granted Chin
a with many great relics. And deligent Chinese never stop construncting a strong
nation. So travelling in China you will view both ancient cultures and modern m
iracles. The Great Wall. Forbidden City, and Terracotta Warriors, as well as mod
ern Shanghai are all included in this itinerary. | 1356.00 |
| 69 | Beijing+Xian+Guilin+Yangshuo+Shanghai 11-Day luxury tour
| /uploadfiles/lines/2008/03/beijing1.jpg | This wonderful tour is a
combination of the latter-day China together with the Ming-Qing royal collapse(B
eijing), the ancient attraction of China (Xi鈥檃n), a cosmopolitan city(Shanghai
), and Guilin鈥檚 extremely charming natural sceneries.
| 1135.00 |
| 68 | 7 Days Tour Shanghai/Zhouzhuang/Suzhou/Wuxi/Nanjing
| /uploadfiles/lines/2008/02/shanghai1.jpg | Enjoy sightseeing of beau
tiful Chinese gardens and small steams winding around featured ancient houses. A
lso you may wander arouns old stone arch bridges.
| 819.00 |
+----+--------------------------------------------------------------------------
-----+-----------------------------------------------+--------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
-------------------------------------------------+-------------+
15 rows in set (0.20 sec)
mysql>

复制代码

返回列表

Chinaunix › 论坛 › 程序设计 › PHP › smarty问题，求助

smarty问题，求助 [复制链接]

浏览过的版块