<?php
$conn = mysql_connect("sql11.webair.com", "", "") or die(mysql_error());
mysql_select_db("kol") or die(mysql_error());
// how many rows to show per page
$rowsPerPage = 24;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['pagina']))
{
$pageNum = $_GET['pagina'];
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
$query = "SELECT * FROM picpost";
$result = mysql_query($query)
or die(mysql_error());
#display results
for ($i=0; $row = mysql_fetch_array($result); $i++ ) {
echo "<a href=\"$row[0]\" target=\"_blank\"><img src=\"$row[1]\" cellspace=\"5\" cellpadding=\"4\" border=\"2\" /></a> ";
if ( $i % 44 ) { echo "<br />"; }
if ( $i % 35 ) { echo "<br /><hr /><br />"; }
}
// print the random numbers
while(list($val) = mysql_fetch_array($result))
{
echo "$val <br>";
}
echo '<br>';
// how many rows we have in database
$query = "SELECT COUNT(url) AS numrows FROM picpost";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
?>