Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- case alpha:
- $sql = "SELECT COUNT(file_name) FROM image";
- $rs_result = mysql_query($sql);
- $row = mysql_fetch_row($rs_result);
- $total_records = $row[0];
- $total_pages = ceil($total_records / 2);
- echo "page(s) <a href='image.php?page=100&id=".$_GET['id']."'>ALL</a>";
- for ($i=1; $i<=$total_pages; $i++) {
- echo " <a href='image.php?page=".$i."&id=".$_GET['id']."'>".$i."</a>";
- }
- if ($_get["page"]==$page) {
- if (isset($_GET["page"])) { $page = $_GET["page"]; } else { $page=1; };
- $start_from = ($page-1) * 2;
- $query = "SELECT * FROM image ORDER BY file_name LIMIT $start_from, 2";
- $result = mysql_query ($query);
- while ($row = mysql_fetch_array($result)) {
- $result_array[]="<a href='image/".$row['file_link']."' target='_blank'><img src='image/".$row['file_link']."'
- width='150px' height='100px' /><br><center>".$row['file_name']."</center>";
- }
- mysql_free_result($result);
- $counter=1;
- echo "<table>";
- echo "<tr>";
- foreach ($result_array as $link) {
- if ($counter <= 1) {
- echo "<td>";
- echo $link;
- echo "</td>";
- $counter ++;
- }
- else {
- echo "<td>";
- echo $link;
- echo "</td>";
- echo "</tr><tr>";
- $counter=1;
- }
- }
- }
- else {
- if ($_get["page"]=ALL and $_get['id']=$_get['id']) {
- $query="select * from image order by file_name";
- $result=mysql_query($query);
- while ($row = mysql_fetch_array($result)) {
- $result_array[]="<a href='image/".$row['file_link']."' target='_blank'><img src='image/".$row['file_link']."'
- width='150px' height='100px' /></a><br><center>".$row['file_name']."</center>";
- }
- $counter=1;
- echo "<table>";
- echo "<tr>";
- foreach ($result_array as $link) {
- if ($counter <= 3) {
- echo "<td>";
- echo $link;
- echo "</td>";
- $counter ++;
- }
- else {
- echo "<td>";
- echo $link;
- echo "</td>";
- echo "</tr><tr>";
- $counter=1;
- }
- }
- }
- }
- break;
Add Comment
Please, Sign In to add comment