有时候我一直在寻找一个适当的解决方案,我的分页困境,我下面的perl脚本确实工作,但它创建页面链接数百看起来很奇怪,我需要一个紧凑的一个,为此我遇到了一个网站,提供了解决方案,我正在寻找,但帮助是非常稀少的,我不是一个jquery的人,我一直在谷歌周围,看看我是否可以使用这个jquery脚本自己,但无法找到有用的提示,因此我在这里溢出寻求您的帮助在集成这个jquery插件与我的代码。
这是我上面提到的jquery代码和演示。
如果你知道jquery,但现在没有时间,请把它标记出来,当你有时间的时候,但请帮忙,我在这里看到了很多由你的专家提供的代码。
下面是我的脚本:# Count how many rows are there in a table, so that we can use it for $pagenum.
my $sql = qq!SELECT COUNT(*) from "Orders" !;
my $sth = $dbh->prepare ("$sql");
$sth->execute() || quit();
my @row = $sth->fetchrow_array;
$sth->finish;
# Setting offset, limit and page number
my $offset = 0;
my $limit = 8;
my $pagenum = ceil($row[0]/$limit);
# Assigning value to $offset as 0 or whatever will be the $pagenum i.e. 1 or 2 ....
$offset=param('page')? $limit*param('page') :0;
# Get the data
$sql = qq!SELECT
a."OrderID", b."CompanyName" AS "CustomerName",
c."FirstName"::text || ' ' ||c."LastName"::text AS "EmployeeName",
a."OrderDate"::DATE, a."RequiredDate"::DATE, a."ShippedDate"::DATE,
d."CompanyName" AS "ShipVia", a."Freight", a."ShipName",
a."ShipAddress", a."ShipCity", a."ShipRegion",
a."ShipPostalCode", a."ShipCountry"
FROM
"Orders" a, "Customers" b, "Employees" c, "Shippers" d
WHERE
a."CustomerID" = b."CustomerID" AND
a."EmployeeID" = c."EmployeeID" AND
a."ShipVia" = d."ShipperID"
ORDER BY 1
LIMIT $limit OFFSET $offset !;
$sth=$dbh->prepare("$sql");
$sth->execute() || quit();
#.... then html stuff skiped....
# Showing page number with link
my $first_page = $pagenum - $pagenum ;
my $last_page = $pagenum - 1;
$pagenum = $pagenum - 1;
print q(<ul class="tsc_pagination tsc_paginationA tsc_paginationA09">);
print qq(<li><a href='vieword.pl?page=$first_page'>First>);
for my $i (0 .. $pagenum)
{
print qq(<li><a href='vieword.pl?page=$i'>$i>);
}
print qq(<li><a href='vieword.pl?page=$last_page'>Last>);
print q(</ul>);
非常感谢!
首先声明:
my $reqpage = $q->param('reqpage') || '1';
,然后在脚本的body部分添加以下内容:
<script src="js/jquery.paginate.js" type="text/javascript"></script>
<script type="text/javascript">
$(function() {
$("#demo2").paginate({
count : $your_page_count,
start : $reqpage,
onChange : function(reqpage) {
location.href = 'your_script.pl?reqpage='+ reqpage;},
display : 27,
border : false,
text_color : '#303030',
background_color : '#EEE',
text_hover_color : 'black',
background_hover_color : '#CFCFCF'
});
});
</script>