An offer you might like

Question

Sorcher 6 Junior Poster

13 Years Ago

Hello peeps!
I really need a pagination for this code:

<body>
<div class="myFiles-content">
<div id="myFiles-upload">
<table>
<tr>
<td class="login-form">
    <form action="index.php?page=user_upload2" method="post" enctype="multipart/form-data">
        <input class="button1" type="file" name="uploaded_file"><br>
        <input class="button1" type="text" name="description" maxlength="60" value="Description" onClick="this.value='';">
    <input class="button1" type="submit" value="Upload">
    </form>
</td>
</tr>
</table>
</div>
    </div><br>
<table cellpadding="0" cellspacing="0" border="0">
       <tr class="myFiles-thtable">
       <th class="myFiles-thtable-red" width="200"><p><font color="black">File</font></p></th>
       <th class="myFiles-thtable-red" width="200"><p><font color="black">Description</font></p></th>
       <th class="myFiles-thtable-red" width="200"><p><font color="black">Link</font></p></th>
       <th class="myFiles-thtable-red" width="150"><p><font color="black">Date</font></p></th>
       <th class="myFiles-thtable-red" width="50"><p><font color="black">#</font></p></th>
        </tr>
        
<?php 
$id = $_SESSION['loginid']; // login session.
$sql = "Select * from userfile2 where userid='$id' ORDER BY created desc;";
$result = mysql_query($sql);
while($row = mysql_fetch_assoc($result)) {
?>
<?php
$id = $_SESSION['loginid'];
?>
       <tr>
 
       <td width="200" class="files2-borderbottom"><p><font color="#000099"><a href="u/<?php echo $id ?>/<?php echo  $row['name']; ?>"><?php echo  $row['name']; ?></a></font></p>
       </td>
       <td width="200" class="files2-borderbottom" align="center"><p><?php echo $row['description']; ?></p></td>
       <td width="200" class="files2-borderbottom"><p><input type="text" value="www.xxxx.com/u/<?php echo $id ?>/<?php echo $row['name'];?>" class="button1"></p></td>
       <td width="150" class="files2-borderbottom" align="right"><p><?php echo $row['created']; ?></p></td>
       <?php $id = $row['id']; 
	   ?>
       
       <td width="50" class="files2-borderbottom"><a href="edit_files.php?deleteid=<? echo base64_encode($id);?>"><small> (delete)</small></a><a href="update.php?id=<? echo $row['id']; ?>"><small></small></a></td>
       </tr>
        <?php
	   }
	   ?>
       </Table>
       </body>
</html>

Its a list generated from mysql and i've tried to understand pagination for like months now. Cant do it. Its the last <tr> tag that echoes out he data.
I do not have money for this but i could offer you an FTP account with unlimited storage/bandwith pointed at your own ISL secured folder and also a sub domain if you'd want that.

I really hope someone can put together a pagination for this. If you do just PM me and the FTP account is yours! Unlimited space.

*crossing fingers*
Regards,
Sorcher

mysql php ui-ux

Edited 13 Years Ago by Sorcher because: n/a

2 Contributors
6 Replies
221 Views
1 Day Discussion Span
Latest Post 13 Years Ago Latest Post by pritaeas

pritaeas 2,194 ¯\_(ツ)_/¯

13 Years Ago

So, instead of listing all files for a user, you want to show (say) 10 files and below that links to the previous/next pages ?

Anyway, maybe this can help.

Edited 13 Years Ago by pritaeas because: n/a

pritaeas 2,194 ¯\_(ツ)_/¯

13 Years Ago

Never mind. I'll combine the two when I get home.

Reply to this topic

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Sorcher 6 Junior Poster · Answer 1 · 2011-01-10T19:57:11+00:00

Did not understand one line of code in that topic u replyed with. It got nothing to do with my code.

Sorcher 6 Junior Poster · Answer 2 · 2011-01-10T19:59:46+00:00

I apologize if that sounded frustrating from my side. But i'm pretty tierd of searching.

Sorcher 6 Junior Poster · Answer 3 · 2011-01-10T20:39:44+00:00

I'd appreciate that allot. Just nod and i'll PM some FTP settings.

pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster · Answer 4 · 2011-01-11T15:45:49+00:00

The following is adjusted to my test tables, so you'll have to replace some stuff. You can view the output of my file here.

<?php
  function createNavigation($current = 1, $total = 1, $enclose = 2, $endpoint = 2) {
	if ($current < 1)
		$current = 1;
	if ($total < 1)
		$total = 1;
	if ($current > $total)
		$current = $total;

	$front = array();
	$middle = array();
	$last = array();
	
	for ($i = 1; $i <= $endpoint; $i++)
		$front[] = $i;
	for ($i = $current - $enclose; $i <= $current + $enclose; $i++)
		$middle[] = $i;
	for ($i = $total - $endpoint + 1; $i <= $total; $i++)
		$last[] = $i;
	
	$nav = array_merge($front, $middle, $last);
	$nav = array_unique($nav, SORT_NUMERIC);
	
	$nav2 = array ();
	foreach ($nav as $val)
		if ($val > 0 && $val <= $total)
			$nav2[] = $val;
			
	$nav = array ();
	$prev = 0;		
	foreach ($nav2 as $val) {
		if ($val > $prev + 1)
			$nav[] = '..';

		if ($val == $current)
			$nav[] = "<span class='current'>$val</span>";
		else
			$nav[] = "<a href='?page=$val'>$val</a>";

		$prev = $val;
	}
	
	return implode(' ', $nav);
  }

  include 'defines.inc.php';
  $link = @mysql_connect(HOST, USER, PASS);
  @mysql_select_db(DATABASE);
?>
<html>
 <body>
  <div class="myFiles-content">
   <div id="myFiles-upload">
    <table>
     <tr>
      <td class="login-form">    
       <form action="index.php?page=user_upload2" method="post" enctype="multipart/form-data">        
        <input class="button1" type="file" name="uploaded_file"><br>        
        <input class="button1" type="text" name="description" maxlength="60" value="Description" onClick="this.value='';">    
        <input class="button1" type="submit" value="Upload">    
       </form>
      </td>
     </tr>
    </table>
   </div>    
  </div>
  <br>
  <table cellpadding="0" cellspacing="0" border="0">       
   <tr class="myFiles-thtable">       
    <th class="myFiles-thtable-red" width="200"><p><font color="black">File</font></p></th>       
    <th class="myFiles-thtable-red" width="200"><p><font color="black">Description</font></p></th>       
    <th class="myFiles-thtable-red" width="200"><p><font color="black">Link</font></p></th>       
    <th class="myFiles-thtable-red" width="150"><p><font color="black">Date</font></p></th>       
    <th class="myFiles-thtable-red" width="50"><p><font color="black">#</font></p></th>        
   </tr> 
   <?php 
    $id = -1; 
    // login session.
    
    $sql = "Select count(*) as count from countries";
    $result = mysql_query($sql);
    $row = mysql_fetch_assoc($result);
    $numresults = $row['count'];
    mysql_free_result($result);
    
    $itemsperpage = 2;
    $numpages = ceil($numresults / $itemsperpage);
    $currentpage = isset($_GET['page']) ? $_GET['page'] : 1;

    $from = ($currentpage - 1) * $itemsperpage;
    $to = $from + $itemsperpage;

    $sql = "Select * from countries limit $from,$to";
    $result = mysql_query($sql);
    
    while ($row = mysql_fetch_assoc($result)) 
    {
     $id = -1;
   ?>       
   <tr>        
    <td width="200" class="files2-borderbottom"><p><font color="#000099">
     <a href="u/<?php echo $id ?>/<?php echo  $row['name']; ?>"><?php echo  $row['name']; ?></a>
    </font></p></td>       
    <td width="200" class="files2-borderbottom" align="center"><p><?php echo $row['description']; ?></p></td>       
    <td width="200" class="files2-borderbottom"><p>
     <input type="text" value="www.xxxx.com/u/<?php echo $id ?>/<?php echo $row['name'];?>" class="button1">
    </p></td>       
    <td width="150" class="files2-borderbottom" align="right"><p><?php echo $row['created']; ?></p></td>       
    <?php $id = $row['id']; ?>        
    <td width="50" class="files2-borderbottom"><a href="edit_files.php?deleteid=<? echo base64_encode($id);?>"><small> (delete)</small></a><a href="update.php?id=<? echo $row['id']; ?>"><small></small></a></td>       
   </tr>        
   <?php	   
    }	   
   ?>       
  </Table> 
  <?php
    echo createNavigation($currentpage, $numpages);
  ?>      
 </body>
</html>