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 comment
Share on other sites

 Share

×
×
  • Create New...