Mam coś takiego:
$foty = new db();
$foty->count_query('zdjecia');
$row = $foty->fetch_array();
$recordsCount = $row[0];
try{
$pager = new Pager('1','?page=logi&pp1=#PAGE#');
$pager->SetTotalRecords($recordsCount);
$pager->SetRecordsPerPage(9);
$pager->Make(true);
$pag = $pager->Render();
$start = $pager->GetIndexRecordStart();
$end = $pager->GetIndexRecordEnd();
}
catch (Exception $e) {
}
$foty->query('zdjecia','Order by id DESC limit '.$start.','.($end - $start + 1).'');
echo'<div class="item"><ul>'; while($wynik=$foty->fetch_array())
{
echo'<li><a href="'.$wynik['url'].'" rel="example1" title=""><img src="'.$wynik['url_th'].'" alt="#" /></a></li>';
}
$foty->close();
Wyświetla ładnie 9 fotek.
Na stronie wygląda to mniej więcej tak:

na dole są dwie strzałki. Muszę je podczepić w klasie? w sekcji od linków?
Używam do tego
jquery.bxslider.js i nie definiuję tych strzałek w dokumencie... nie wiem jak to ugryźć...
@nospor, zrobiłem tak jak w Twoim skrypcie, tyle że pobiera mi zawartość całej strony...

<script type="text/javascript" src="scripts/Mixed.js"></script>
<script type="text/javascript" src="scripts/ActionsManager.js"></script>
<script type="text/javascript" src="scripts/plugins/ActionsManager_advAjax.js"></script>
<script type="text/javascript">
ActionsManager.loadPlugins('dynamic, position');
</script>
<script type="text/javascript" src="scripts/advajax.js"></script>
<script type="text/javascript">
AjaxAction.prototype.oldAfterRun = AjaxAction.prototype.afterRun;
AjaxAction.prototype.afterRun = function(ajaxObj,params, resultOk){
//i zamykamy okno
ActionsManager.hide(this);
this.oldAfterRun(ajaxObj, params, resultOk); //wywołanie starej metody by zachować jej funkcje
//wpisujemy nowe dane
document.getElementById('mainDiv').innerHTML = ajaxObj.responseText;
}
function loadPage(page){
ActionsManager.setup({
'guid' : 'pager',
'link' : 'galeria.php?onlyData=1&page='+page,
'titleRunning': 'Pobieranie strony...',
'center' : false,
'type' : 'html'
});
}
</script>
class PagerE extends Pager {
protected function toString() {
if ($this->totalRecords <= $this->RecordsPerPage)
return '';
$_str = '';
$sep = ' ';
if (isset($this->array[self::GOTO_FIRST])) $_str .= $this->createHTMLLink('Pierwsza strona', $this->array[self::GOTO_FIRST][self::LINK], '|<',1
).$sep; if (isset($this->array[self::GOTO_PREV_X])) $_str .= $this->createHTMLLink($this->array[self::PAGES_PER_NAV].' stron(y) do tyłu', $this->array[self::GOTO_PREV_X][self::LINK], '<<',$this->array[self::GOTO_PREV_X][self::PAGE]).$sep; if (isset($this->array[self::GOTO_PREV])) $_str .= $this->createHTMLLink('Poprzednia strona', $this->array[self::GOTO_PREV][self::LINK], '<',$this->array[self::GOTO_PREV][self::PAGE]).$sep;
foreach ($this->array[self::PAGES] as $_page => $_pageLink){
if (!$_pageLink)
$_str .= '<span>'.$_page.'</span>';
else
$_str .= $this->createHTMLLink("Strona ".$_page, $_pageLink, $_page, $_page);
$_str .= $sep;
}
if (isset($this->array[self::GOTO_NEXT])) $_str .= $sep.$this->createHTMLLink('Następna strona', $this->array[self::GOTO_NEXT][self::LINK], '>', $this->array[self::GOTO_NEXT][self::PAGE]); if (isset($this->array[self::GOTO_NEXT_X])) $_str .= $sep.$this->createHTMLLink($this->array[self::PAGES_PER_NAV].' stron(y) do przodu', $this->array[self::GOTO_NEXT_X][self::LINK], '>>',$this->array[self::GOTO_NEXT_X][self::PAGE]); if (isset($this->array[self::GOTO_LAST])) $_str .= $sep.$this->createHTMLLink('Ostatnia strona', $this->array[self::GOTO_LAST][self::LINK], '>|',$this->array[self::GOTO_LAST][self::PAGE]);
return $_str;
}
protected function createHTMLLink($title, $link, $text,$page) {
return '<a title="'.$title.'" href="'.$link.'" onclick="loadPage('.$page.');return false;">'.$text.'</a>';
}
}
if($_GET['d'] == "zwierzeta")
{
$foty = new db();
$foty->count_query('zdjecia');
$row = $foty->fetch_array();
$totalRecords = $row[0];
try {
$pager = new PagerE('1');
$pager->SetTotalRecords($totalRecords);
$pager->SetRecordsPerPage(9);
$pager->SetPagesPerNav(2);
$pager->Make(true);
$pag = $pager->Render();
$indexStart = $pager->GetIndexRecordStart();
$indexEnd = $pager->GetIndexRecordEnd();
}
catch (Exception $e) {
}
$foty->query('zdjecia','Order by id DESC limit '.$start.','.($end - $start + 1).'');
echo '<div id="mainDiv">'; while($wynik=$foty->fetch_array())
{
echo'<li><a href="'.$wynik['url'].'" rel="example1" title=""><img src="'.$wynik['url_th'].'" alt="#" /></a></li>';
}
$foty->close();
}
i dodatkowo:
Warning
: mysql_fetch_array(): supplied argument is not a valid
MySQL result resource in E
:\WebServ\httpd\adami\core\db
.class.php on line
152