PHP Tutorials

Edit records from a MySQL database

display_admin.php

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Show all of my Quotes</title>
<style type="text/css">
<!--
body {background: #fff;}
#container {margin:auto; width: 700px;}
.quote {background: #F0F0E1; padding: 1em; font: 19px Georgia, "Times New Roman", Times, serif;}
.author {text-align: right; margin-bottom: 2em; font: 10px Verdana, Geneva, sans-serif;}

#edit_container {padding-bottom: 1em; text-align: right;}
#edit_container a {text-decoration: none; color:#F00; padding-left: 20px;}
#edit_container a:hover {color:#f90;}

/* page navigation */
#page_nav {clear:both;color:#3666d4;height:2em;margin:0;position:relative;}
#page_nav a.page_nav, #page_navSub a.page_nav {display:block;color:#777;float:left;margin:0 5px 5px 0;padding:1px 4px;text-align:center;text-decoration:none;background: #FFF1B9;}
span#currentPage {color:#777;float:left;margin:0 5px 0 0;padding:1px 4px;text-align:center;text-decoration:none;background: #f5f5f5;}
#page_nav a.page_nav:hover, #page_navSub a.page_nav:hover {background:#fc0;color:#fff;}

-->
</style>
</head>

<body>
<div id="container">

<?
include("my_database_connection.php");

$my_limit_var = 2; // number of records to show per page
$my_page_number=$_GET["my_page_number"];

if($my_page_number == "") $my_page_number=1;

$my_query_var=mysql_query("SELECT * FROM my_quotes LIMIT 0, 17 ") or die(mysql_error());
$my_number_of_results_var=mysql_num_rows($my_query_var);
$my_number_of_pages_var=ceil($my_number_of_results_var/$my_limit_var);
$quote_id=mysql_result($my_query_var,"quote_id");

$my_query_var=mysql_query("SELECT * FROM my_quotes LIMIT " . ($my_page_number-1)*$my_limit_var . ",$my_limit_var") or die(mysql_error());
while($my_row_var = mysql_fetch_object($my_query_var)) {

// show the edit container
echo "<div id='edit_container'>";
echo "<a href=\"update.php?quote_id=". $my_row_var->quote_id ."\">edit</a>";
echo "<a href=\"delete_confirm.php?quote_id=". $my_row_var->quote_id ."\">delete</a>";
echo "</div>";

// close the layer
echo "<div>";

echo "<div class='quote'>" . $my_row_var->quote . "</div>";
echo "<div class='author'>" . $my_row_var->first_name . "&nbsp;" . $my_row_var->last_name . "</div>";

echo "</div>";
//
}
//
$my_nav_var="";

echo "<div id='page_nav'>";

if($my_page_number > 1) {
$my_nav_var .= "<a class='page_nav' href='display_admin.php?my_page_number=" . ($my_page_number-1) . "'><< Previous</a>";
}

for ($i = 1 ; $i <= $my_number_of_pages_var ; $i++) {
if ($i == $my_page_number) {
$my_nav_var .= "<span id='currentPage'>$i</span>";
}

else
{
$my_nav_var .= "<a class='page_nav' href='display_admin.php?my_page_number=" . $i . "'>$i</a>";
}
}

if($my_page_number < $my_number_of_pages_var) {
$my_nav_var .= "<a class='page_nav' href='display_admin.php?my_page_number=" . ($my_page_number+1) . "'>Next >></a>";
}

echo "<br>" . $my_nav_var;
echo "</div>";

?>

</div>
</body>
</html>

PHP Tutorials
Other Tutorials