Php buffer problem
Posted: Mon Dec 05, 2011 12:04 am
Code: Select all
<?php
$dbhost = '**********';
$dbuser = '**********';
$dbpass = '**********';
$rec_limit = 16;
$conn = mysql_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db('*******');
/* Get total number of records */
$sql = "SELECT count(srno) FROM images ";
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data: ' . mysql_error());
}
$row = mysql_fetch_array($retval, MYSQL_NUM );
$rec_count = $row[0];
if( isset($_GET{'page'} ) )
{
$page = $_GET{'page'} + 1;
$offset = $rec_limit * $page ;
}
else
{
$page = 0;
$offset = 0;
}
$left_rec = $rec_count - ($page * $rec_limit);
$sql = "SELECT name ".
"FROM images ".
"LIMIT $offset, $rec_limit";
$retval = mysql_query( $sql, $conn );
if(! $retval )
{
die('Could not get data: ' . mysql_error());
}
?>
<table cellspacing="10" border="0" cellpadding="0">
<tr>
<?php
$i=0;
while($row = mysql_fetch_array($retval, MYSQL_ASSOC))
{
$i=$i+1;
if($i>4)
{
$n=$row['name'];
echo "</tr><tr><th width='152px' height='152px'>";
echo "<a href='http://wallpapers.everything.org.in/images/". $n ."'><img src='http://wallpapers.everything.org.in/images/" .$n."'></a>";
echo "</div></th>";
$i=1;
}
else{
$n=$row['name'];
echo "<th width='152px' height='152px'>";
echo "<a href='http://wallpapers.everything.org.in/images/". $n ."'><img src='http://wallpapers.everything.org.in/images/" .$n."'></a>";
echo "</div></th>";
}
}
echo "</tr></table>";
if( $page > 0 )
{
$last = $page - 2;
echo "<a href=\"$_PHP_SELF?page=$last\" style='background:black;color:white;'>Last 16 Records</a> |";
echo "<a href=\"$_PHP_SELF?page=$page\" style='background:black;color:white;'>Next 16 Records</a>";
}
else if( $page == 0 )
{
echo "<a href=\"$_PHP_SELF?page=$page\" style='background:black;color:white;'>Next 16 Records</a>";
}
else if( $left_rec < $rec_limit )
{
$last = $page - 2;
echo "<a href=\"$_PHP_SELF?page=$last\" style='background:black;color:white;'>Last 16 Records</a>";
}
mysql_close($conn);
?>all images are thumbnails! but most of them end up unloaded
I never understood php buffer how can I buffer the output so that everything loads up!