PHPBuilder - Hafizan



RSS Twitter
Snippets 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>&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>"; ?>

Comment and Contribute

Your comment has been submitted and is pending approval.

Author:
hafizan

Comment:



Comment:

(Maximum characters: 1200). You have characters left.