Snippets Databases
Databases
Hafizan
by: hafizan
|
January 4, 2004
Version: 1.3
Type: Full Script
Category: Databases
License: GNU General Public License
Description: A php and mysql template to speed up php and mysql program developement
Now with classes
<?
include("./include/connection.php");
print"<html>
<HEAD>
<TITLE>Story Management</TITLE>
</HEAD>
<link rel=\"stylesheet\" href=\"./css/default.css\" type=\"text/css\">
<BODY text=\"#000000\" vLink=\"#5493b4\" link=\"#006699\" bgColor=\"#3a6ba5\">
<TABLE cellSpacing=\"0\" cellPadding=\"10\" width=\"100%\" align=\"center\" border=\"0\">
<TBODY>
<TR>
<TD class=\"bodyline\">";
print"<h1>$categoryname</h1><br>";
print"<a href=\"manages.php?mode=1\"><img border=\"0\" src=\"image/post.gif\" width=\"82\" height=\"25\" alt=\"Add new information\"></a>";
print"<TABLE class=\"forumline\" cellSpacing=\"1\" cellPadding=\"3\" width=\"645\"
border=\"0\">
<TBODY>
<TR>
<TH class=\"thHead\" height=\"25\" width=\"629\" colspan=\"3\">
<b>View</b>
</TH>
</TR>
<TR>
<TD class=\"row1\" width=\"619\" valign=\"top\" align=\"right\" colspan=\"3\">";
// set per page view
$limit="3";
// first page offset equal to 0
if (empty($offset)) {
$offset =0;
}
if($row && $sort) {
$total_query="select id from story where $row like '$sort%' ";
$sql="select * from story where $row like '$sort%' desc limit $offset,$limit";
}
elseif($datasearch) {
$total_query="select id from story where $row like '$datasearch' ";
$sql="select * from story where $row like '$datasearch' order by 'id' desc limit $offset,$limit ";
}
else {
$total_query="select id from story";
$sql="SELECT * from story order by id desc limit $offset,$limit";
}
$countRecord=mysql_query($total_query,$connect)or die (mysql_errno()."<br>". mysql_error()."total query count problem");
$numrows = mysql_num_rows($countRecord);
$result =mysql_query($sql,$connect)or die (mysql_errno()."<br>". mysql_error()."data output problem");
class navigation {
function first_lastpage($offset,$row,$sort,$datasearch,$numrows) {
$lastpage=$numrows - 1 ;
if($row && $sort) {
print"<a href=\"$PHP_SELF?\">[Reset Finding]</a>
<a href=\"$PHP_SELF?offset=0&row=$row&sort=$sort\">[First Page] </a> ";
print"<a href=\"$PHP_SELF?offset=$lastpage&row=$row&sort=$sort\"> [Last Page] </a> ";
}
elseif($datasearch){
print"<a href=\"$PHP_SELF?category=$category\">[Reset Finding]</a><a href=\"$PHP_SELF?offset=0&datasearch=$datasearch&category=$category\">[First Page] </a> ";
print"<a href=\"$PHP_SELF?offset=$lastpage&datasearch=$datasearch\"> [Last Page] </a> ";
}
else {
print"<a href=\"$PHP_SELF?\">[First Page] </a> ";
print"<a href=\"$PHP_SELF?offset=$lastpage\"> [Last Page] </a> ";
}
}
function next_page($offset,$row,$sort,$datasearch,$numrows,$limit) {
if($offset >= 1) {
$prevoffset = $offset - $limit ;
if($row && $sort) {
print"<a href=\"$PHP_SELF?offset=$prevoffsetsort=$sort&row=name\"><img border=\"0\" src=\"image/prev.gif\"> Previous </a> ";
}
elseif($datasearch) {
print"<a href=\"$PHP_SELF?offset=$prevoffset&row=$row&datasearch=$datasearch\"><img border=\"0\" src=\"image/prev.gif\">Previous </a> ";
}
else{
print"<a href=\"$PHP_SELF?offset=$prevoffset\"><img border=\"0\" src=\"image/prev.gif\"> Previous </a> ";
}
}
}
function prev_page($offset,$row,$sort,$datasearch,$numrows,$limit) {
$lastpage=$numrows - 1 ;
$pages=intval($numrows/$limit);
if($numrows % $limit) {
$pages ++;
}
if ($pages!=1 or (($pages==1 and ($numrows%$limit)))) {
$newoffset =$offset +$limit ;
if($row && $sort) {
print"<a href=\"$PHP_SELF?offset=$newoffset$sort&row=name\"><img border=\"0\" src=\"image/next.gif\"> Next </a> ";
}
elseif($datasearch) {
print"<a href=\"$PHP_SELF?offset=$newoffset&row=$row&datasearch=$datasearch\"><img border=\"0\" src=\"image/next.gif\"> Next </a> ";
}
else {
print"<a href=\"$PHP_SELF?offset=$newoffset\"><img border=\"0\" src=\"image/next.gif\"> Next </a> ";
}
}
}
}
$navigation = new navigation ;
echo $navigation->first_lastpage($offset,$row,$sort,$datasearch,$numrows);
echo $navigation->next_page($offset,$row,$sort,$datasearch,$numrows,$limit);
echo $navigation->prev_page($offset,$row,$sort,$datasearch,$numrows,$limit);
if(($offset < 0)or($offset > $numrows)) {
echo message("Admin Message","Not Found <br><a href=\"$PHP_SELF?category=$category\">Please click to reset search result</a><img src=\"smiles/smile.gif\">");
}
else {
if($numrows >=1) {
while ($row = mysql_fetch_array($result)){
print"</td>
</TR>
<TR>
<TD class=\"row1\" width=\"542\"></TD>
<TD class=\"row1\" width=\"42\">
<a href=\"manages.php?mode=2&id=$row[id]\">
<img src=\"image/icon_edit.gif\" width=\"59\"
height=\"18\" border=\"0\" alt=\"add current information\">
</a>
</TD>
<TD class=\"row1\" width=\"35\"><a href=\"manages.php?mode=3&id=$row[id]\">
<img src=\"image/icon_delete.gif\" width=\"16\" height=\"18\" border=\"0\"
alt=\"Are sure you want to delete this information\"></a></TD>
</TR>
<TR>
<TD class=\"row1\" width=\"619\" colspan=\"3\">";
print"<font color=\"black\">Id : $row[id]<br>
Name : $row[name]<br>
Story : $row[story]</font><br>
</TD>
</TR>";
// end loop
}
}
else {
echo message("Admin Message","Not Found <br><a href=\"$PHP_SELF\">Please click to reset search result</a><img src=\"smiles/confuse.gif\">");
}
}
print"<TR>
<TD class=\"row1\" width=\"619\" valign=\"top\" align=\"right\" colspan=\"3\">";
echo $navigation->first_lastpage($offset,$row,$sort,$datasearch,$numrows);
echo $navigation->next_page($offset,$row,$sort,$datasearch,$numrows,$limit);
echo $navigation->prev_page($offset,$row,$sort,$datasearch,$numrows,$limit);
print"</TD>
</TR>
</TBODY>
</TABLE>";
// both two include are optional
include("./include/sort.php");
include("./include/search.php");
print"</TD>
</TR>
</TBODY>
</TABLE>
</BODY>
</html>"; ?>
PHPBuilder
Policies
PHP Developer
Topics
PHP Developer
Resources
PHP Developer
References
