All pastes #606165 Raw Edit

Someone

public text v1 · immutable
·published 2007-07-06 18:11 UTC
rendered paste body
<?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>&nbsp;";
 
    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'];
 
 
 
?>