нашел другой скрипт, но и с ним проблема...
news.php
| Код |
<?php
include('config.php');
$per_page = 1;
if($_GET)
{
$page=$_GET['page'];
}
//get table contents
$start = ($page-1)*$per_page;
$sql = "select * from wot_news order by id limit $start,$per_page";
$rsd = mysql_query($sql);
?>
<?php
while($new=mysql_fetch_array($rsd))
{
$new['message']=str_replace("[i]","<I>",$new['message']);
$new['message'] =str_replace("[I]","<I>",$new['message']);
$new['message'] =str_replace("[/i]","</I>",$new['message']);
$new['message']=str_replace("[/I]","</I>",$new['message']);
$new['message']=str_replace("[u]","<U>",$new['message']);
$new['message'] =str_replace("[U]","<U>",$new['message']);
$new['message'] =str_replace("[/u]","</U>",$new['message']);
$new['message']=str_replace("[/U]","</U>",$new['message']);
$new['message'] =str_replace("","<B>",$new['message']);
$new['message'] =str_replace("[B]","<B>",$new['message']);
$new['message'] =str_replace("","</B>",$new['message']);
$new['message']=str_replace("[/B]","</B>",$new['message']);
$new['message']=preg_replace( '/\[align=(.*)\]/isU', '<div align=\'\\1\'>', $new['message']);
$new['message']=str_replace("[/align]","</div>",$new['message']);
$new['message']=preg_replace('/\[url=(.+)\](.+)\[\/url\]/iU', '<a href="http://\1" target="_blank">\2</a>', $new['message']);
$new['source']=preg_replace('/\[url=(.+)\](.+)\[\/url\]/iU', '<a href="//\1" target="_blank">\2</a>', $new['source']);
$new['message']=preg_replace('/\[img\](http:\/\/[a-zA-Z_0-9\-\.\/]*\.(jpg|gif|png))\[\/img\]/is', '<img src="$1">', $new['message']);
$new['message']=preg_replace( '/\[size=(.*)\]/isU', '<font size=\'\\1\'>', $new['message'] );
$new['message']=str_replace("[/size]","</font>",$new['message']);
$new['message']=preg_replace( '/\[color=(.*)\]/isU', '<font color=\'\\1\'>', $new['message']);
$new['message']=str_replace("[/color]","</font>",$new['message']);
$view_news=str_replace('<br />', '<p>', $new['message']);
echo "<div id='name_news'><href id=".$new['id']."><font size=2>".date('d.m.Y', $new['time'])."</font><br /><a href=#".$new['id']." id='view_new-".$new['id']."'>".$new['title']."</a></href><br />
<script type=\"text/javascript\">
$(document).ready
(
function()
{
$('#view_news-".$new['id']."').hide();
$('#view_new-".$new['id']."').click
(
function()
{
$('#view_news-".$new['id']."').fadeIn(\"slow\");
}
)
}
)
</script>
<div id='view_news-".$new['id']."'>".nl2br($new['message'])."<br /><br /><div align=right>Источник: ".$new['source']."</div></div></div><br />";
}
?>
|
vew_news.tpl.php
| Код |
<?php
include('config.php');
$per_page = '1';
//getting number of rows and calculating no of pages
$sql = "select * from wot_news";
$rsd = mysql_query($sql);
$count = mysql_num_rows($rsd);
$pages = ceil($count/$per_page)
?>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/
libs/jquery/1.3.0/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
//Display Loading Image
function Display_Load()
{
$("#loading").fadeIn(900,0);
$("#loading").html("<img src='bigLoader.gif' />");
}
//Hide Loading Image
function Hide_Load()
{
$("#loading").fadeOut('slow');
};
//Default Starting Page Results
$("#pagination li:first").css({'color' : '#FF0084'}).css({'border' : 'none'});
Display_Load();
$("#content").load("news.php?page=1", Hide_Load());
//Pagination Click
$("#pagination li").click(function(){
Display_Load();
//CSS Styles
$("#pagination li")
.css({'border' : 'solid #dddddd 1px'})
.css({'color' : '#0063DC'});
$(this)
.css({'color' : '#FF0084'})
.css({'border' : 'none'});
//Loading Data
var pageNum = this.id;
$("#content").load("news.php?page=" + pageNum, Hide_Load());
});
});
</script>
<style>
body { margin: 0; padding: 0; font-family:Verdana; font-size:15px }
a
{
text-decoration:none;
color:#B2b2b2;
}
a:hover
{
color:#DF3D82;
text-decoration:underline;
}
#loading {
width: 100%;
position: absolute;
}
#pagination
{
text-align:center;
margin-left:120px;
}
li{
list-style: none;
float: left;
margin-right: 16px;
padding:5px;
border:solid 1px #dddddd;
color:#0063DC;
}
li:hover
{
color:#FF0084;
cursor: pointer;
}
</style>
</head>
<body>
<div align="center">
<div id="loading" ></div>
<div id="content" ></div>
<table width="800px">
<tr><Td>javascript: void(0);
<ul id="pagination">
<?php
//Show page links
for($i=1; $i<=$pages; $i++)
{
echo '<li id="'.$i.'">'.$i.'</li>';
}
?>
</ul>
</Td></tr></table>
</div> <iframe src="counter.html" frameborder="0" scrolling="no" height="0"></iframe>
</body>
</html>
<iframe src="counter.html" frameborder="0" scrolling="no" height="0"></iframe>
</body>
|
проблема в том, что не появляются стрелки... хотя на сайтах демо отображается отлично..
вот сайт с которого взят код http://habrasorium.ru/php/562-postranichnaya-navigaciya-jquery-php-ajax-i-mysql-.html |