ograyk Posted November 4, 2014 Share Posted November 4, 2014 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 More sharing options...
Larry Posted November 6, 2014 Share Posted November 6, 2014 Okay, you'll need to tell us something about what's working or what's not working and what debugging steps you've taken. Right now we have nothing to go on. Link to comment Share on other sites More sharing options...
Recommended Posts