ThaiSEOBoard.com

<?php
$files = glob("images/*.*");
for ($i=0; $i<count($files); $i++)
{
	$image = $files[$i];
	$image2 = [$i];
	$supported_file = array(
		'gif',
		'jpg',
		'jpeg',
		'png'
);

$ext = strtolower(pathinfo($image, PATHINFO_EXTENSION));
	if (in_array($ext, $supported_file)) {

	$FileName = substr(basename($image), 0 , (strrpos(basename($image), ".")));
    echo '<a href="view.php?id='. $FileName .'" ><img src="' . $image . '" alt="Random image" style="width:200px" /></a>' . "&nbsp;&nbsp;&nbsp;";
		} else {
		continue;
		}
	}
?>

<?php

require('config.php');
require('common.php');

if (!isset($_SESSION['user']))
{
	exit_message('You are no authorised to access this page. Please log in.');
}

$user = $_SESSION['user'];

require('db.php');
$images = mysqli_prepare($db, 'SELECT `id`, `ext`, `time` FROM `images` WHERE `removed` = "0" ORDER BY `time` desc'); //ORDER BY `time` ASC'

mysqli_stmt_bind_param($images, 'i', $user);
mysqli_stmt_execute($images);
++$db_queries;
mysqli_stmt_store_result($images);

if (mysqli_stmt_num_rows($images) === 0)
{
	exit_message('You haven\'t uploaded any images yet!');
}

mysqli_stmt_bind_result($images, $id, $ext, $time);

require('inc/header.php');
require('inc/account.php');
require('inc/footer.php');

<?php
if (!defined('IN_SCRIPT'))
{
	header('location: ../index.php');
	exit;
}

?>

<div class="box">

	<p class="title">Your account</p>
	<p>Welcome to your account. You can view all of your uploads here, see the upload time and delete them</p>
	<div id="user-images"><!--

<?php

while (mysqli_stmt_fetch($images))
{

?>
		--><div class="user-image-box">
			<a href="<?php echo VIEW_PATH . $id; ?>"><img class="user-image" src="thumbs/<?php echo $id . '.jpg'; ?>" alt="<?php echo $id; ?>" /></a>
			<ul class="image-actions">
				<li>image ID : <?php echo $id; ?></li>
				<li>uploaded <?php echo $time; ?></li>
				<li><a class="delete" href="delete.php?id=<?php echo $id; ?>">DELETE image</a></li>
			</ul>
		</div><!--
<?php

}

?>
--></div>
<?php

mysqli_stmt_close($images);
mysqli_close($db);

?>
</div>

require('common.php');
require('paginator.php'); // หรือจะก็อปโค๊ดในคลาสมาใส่แทนตรงนี้ก็ได้

$strSQL = "SELECT `id`, `ext`, `time` FROM `images` WHERE `removed` = "0"";
$objQuery = mysql_query($strSQL);
$Num_Rows = mysql_num_rows($objQuery);

$Per_Page = 10;   //จำนวนต่อหน้า

$Page = $_GET["Page"];
if(!$_GET["Page"])
{
	$Page=1;
}

$Prev_Page = $Page-1;
$Next_Page = $Page+1;

$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
	$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
	$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
	$Num_Pages =($Num_Rows/$Per_Page)+1;
	$Num_Pages = (int)$Num_Pages;
}

$strSQL .=" ORDER BY `time` desc LIMIT $Page_Start , $Per_Page";

$images = mysqli_prepare($db, $strSQL);

<br>
Total <?php echo $Num_Rows;?> Record 

<?php

$pages = new Paginator;
$pages->items_total = $Num_Rows;
$pages->mid_range = 10;
$pages->current_page = $Page;
$pages->default_ipp = $Per_Page;
$pages->url_next = $_SERVER["PHP_SELF"]."?QueryString=value&Page=";

$pages->paginate();

echo $pages->display_pages()
?>	

$images = mysqli_prepare($db, 'SELECT `id`, `ext`, `time` FROM `images` WHERE `removed` = "0" ORDER BY `time` desc limit  $page, 10 ' );