#native_company# #native_desc#
#native_cta#

Hafizan

By hafizan
on 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>&nbsp;&nbsp;";
        print"<a href="$PHP_SELF?offset=$lastpage&row=$row&sort=$sort"> [Last Page] </a>&nbsp;&nbsp;";
        }
        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>&nbsp;&nbsp;";
        print"<a href="$PHP_SELF?offset=$lastpage&datasearch=$datasearch"> [Last Page] </a>&nbsp;&nbsp;";
        }
        else {
        print"<a href="$PHP_SELF?">[First Page] </a>&nbsp;&nbsp;";
        print"<a href="$PHP_SELF?offset=$lastpage"> [Last Page] </a>&nbsp;&nbsp;";
        }
        }
        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>&nbsp;&nbsp;";
        }
        elseif($datasearch) {
        print"<a href="$PHP_SELF?offset=$prevoffset&row=$row&datasearch=$datasearch"><img border="0" src="image/prev.gif">Previous </a>&nbsp;&nbsp;";
        }
        else{
        print"<a href="$PHP_SELF?offset=$prevoffset"><img border="0" src="image/prev.gif"> Previous </a>&nbsp;&nbsp;";
        }
        }
        }
        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>&nbsp;&nbsp;";
        }
        elseif($datasearch) {
        print"<a href="$PHP_SELF?offset=$newoffset&row=$row&datasearch=$datasearch"><img border="0" src="image/next.gif"> Next </a>&nbsp;&nbsp;";
        }
        else {
        print"<a href="$PHP_SELF?offset=$newoffset"><img border="0" src="image/next.gif"> Next </a>&nbsp;&nbsp;";
                }
        }

        }
        }
        $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>"; ?>