Jump to content
Larry Ullman's Book Forums

Recommended Posts

i have went thru this script forward and backwards a million and still have problems, i am not getting any error msgs, i am completely lost. please help.

<?php # Script 10.4 - view_users.php #4
	// this script retrieves all the records from the user table
	// the new version paginates the query results

	$page_title = 'View the Current Users';
	include ('include/header.html');
	echo '<h1>Registered Users</h1>';

	require_once ('mysqli_connect.php');

	// Number of records to show per page
	$display = 10;

	// determine how many pages there are
	if (isset($_GET['p']) && is_numeric($_GET['p'])) { // Already been determined
	
	$pages = $_GET['p'];

	} else { //need to be determined

	//count the number records in the database
	$q = "SELECT COUNT(user_id) FROM users_info";
	$r = @mysqli_query ($dbc, $q); //
	$row = @mysqli_fetch_array ($r, MYSQLI_NUM); //
	$records = $row[0];
	
	// calculate the number of pages...
	if ($records > $display) { // More than 1 page.
	$pages = ceil ($records/$display);
	} else {
		$pages = 1;
	} 
	
} // end of p IF.

 // Determine where in the database to start returning results...
 	if (isset($_GET['s']) && is_numeric($_GET['s'])) {
 		$start = $_GET['s'];
 	} else {
 		$start = 0;
 	}
 	
 	//Define the query:
 	$q = "SELECT last_name, first_name, DATE_FORMAT(time, '%M %d, %Y') AS dr, user_id FROM users_info ORDER BY time ASC LIMIT $start, $display";
 	$r = @mysqli_query ($dbc, $q); //
 	
 		// Table header:
 		echo '<table align="center" cellspacing="0" cellpadding="5" width="75%">
 		<tr>
 			<td align="left"><b>Edit</b></td>
 			<td align="left"><b>Delete</b></td>
 			<td align="left"><b>Last Name</b></td>
 			<td align="left"><b>First Name</b></td>
 			<td align="left"><b>Date Registered</b></td>
 		</tr>
 		';
 		
 		// Fetch and print all the records.....
 	    
 	    $bg = '#eeeeee'; // set the initial background color
 	    
 	    while ($row = mysqli_fetch_array($r, MYSQLI_ASSOC)) {
 	    
 	    	$bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee'); // Switch the background color.
 	    	
 			echo '<tr bgcolor="' . $bg . '">
			<td align="left"><a href="edit_user.php?id=' . $row['user_id'] . '">Edit</a></td>
			<td align="left"><a href="delete_user.php?id=' . $row['user_id'] . '">Delete</a></td>
			<td align="left">' . $row['last_name'] . '</td>
			<td align="left">' . $row['first_name'] . '</td>
			<td align="left">' . $row['dr'] . '</td>
		</tr>
		';
 	    
 	    } // End of While loop.
 	    
 	    echo '</table>';
 	    mysqli_free_result ($r);
 	    mysqli_close($dbc);
 	    
 	    // make the links to other pages, if necessary.
 	    if ($pages > 1) {
 	     
 	     // add some spacing and start a paragraph:
 	     echo '<br /><p>';
 	     
 	     // Determine what page the script is on
 	     $current_page = ($start/$display) + 1;
 	     
 	     // If it's not the first page, make a Previous link:
 	     if ($current_page != 1) {
 	     	echo '<a href="view_users.php?s=' . ($start - $display) '&p=' . $pages . '">Previous</a> ';
 	     }
 	     
 	     // Make all the numbered pages:
 	     for ($i = 1; $i <= $pages; $i++) {
 	     	if ($i != $current_page) {
 	     		echo '<a href="view_users.php?s=' . (($display * ($i - 1))) . '&p=' . $pages . '">' . $i . '</a> ';
 	     	} else {
 	     		echo $1 . ' ';
 	     	}
 	     } // End of FOR loop.
 	     
 	     // If it's not the last page, make a Next botton:
 	     if ($current_page != $pages) {
 	     	echo '<a href="view_users.php?s=' . ($start + $display) . '&p=' . $pages . '">Next</a>';
 	     }
 	     
 	     	echo '</p>'; // close the paragraph.
 	     	
 	    } // End of links section.
 	    
 	    include ('include/footer.html');
 	    ?>
Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...