Database driven page system

Php Code: Database driven page system

Next Code

This stores pages into a database using an edit page and the stored pages may be viewed using the page.

####_edit_.php###########REMOVE THIS LINE########################## <?php ####max page form (1=9, 2=99, 3=999 and so on)#### $maxlen = "1"; ################################################## function db() { $conn = mysql_connect("db_host", "db_user", "db_pass") or die(mysql_error()); mysql_select_db("db_name",$conn) or die(mysql_error()); return $conn; } $conn = db(); if (!$_POST[pagenum]) { $editid = "1"; } else { $editid = "$_POST[pagenum]"; } $result = mysql_query("SELECT * FROM edit WHERE id='$editid'"); while($row = mysql_fetch_array($result)) { $edit = $row['edit']; $pageid = $row['id']; } $getedits .= "$edit"; if ($_POST[op] == "add") { mysql_query("DELETE FROM edit WHERE id='$editid'"); $addedit = "INSERT INTO edit (id, edit) VALUES ('$editid', '$_POST[edit]')"; mysql_query($addedit,$conn) or die(mysql_error()); } mysql_close($conn); ?> <?php if ($_POST[op] == "add") { header ("Location: /_edit_.php"); } ?> <head> <title>Edit Page</title> </head> <html> <body> <form action="<? echo $_SERVER["PHP_SELF"]; ?>" method="post"> <label>Edit - Current page: <? echo $pageid; ?> - <font color="red">NO server side scripting</font><br /><textarea name="edit" rows="25" cols="100" <? echo $tf; ?>><? echo $getedits; ?></textarea></label><br /> <input type="hidden" name="op" value="add" /><br /> <label for="pagenum">Page number</label><input type="text" name="pagenum" size="2" maxlength="<? echo $maxlen; ?>" value="<? echo $editid; ?>" onClick="this.form.pagenum.value=''" /> <input type="submit" name="submit" value="Edit" /><a href="/"><button>Home</button></a><font color="red"><--[step <b?</b> and <b?</b> for creating a page]-- Put your html in the text area then hit edit.</font> </form> <form method="post" action="<? echo $_SERVER["PHP_SELF"]; ?>"> <label for="pagenum">Page number</label><input type="text" name="pagenum" size="2" maxlength="<? echo $maxlen; ?>" value="<? echo $editid; ?>" onClick="this.form.pagenum.value=''" /> <input type="submit" name="submit" value="Get Page" /><font color="red"><--[step <b?</b> for creating a page]-- Type in a page number then hit get.</font></form> Go to <a href="/page.php?page=<? echo $editid; ?>" target="_blank">Page <? echo $editid; ?></a><font color="red"><--[step <b?</b> for creating a page]-- go back to step <b?</b> and go back to your newly created page then click this link.</font> <br /><br /> </body> </html> ####page.php###########REMOVE THIS LINE########################## <?php ######Default page##### $defaultpg = "0"; ####################### function db() { $conn = mysql_connect("db_host", "db_user", "db_pass") or die(mysql_error()); mysql_select_db("db_name",$conn) or die(mysql_error()); return $conn; } $conn = db(); if (!$_GET[page]) { $pg = $defaultpg; } else { $pg = "$_GET[page]"; } $result = mysql_query("SELECT * FROM edit WHERE id='$pg'"); while($row = mysql_fetch_array($result)) { $edit = $row['edit']; } <br><font face="Tahoma"><a target="_blank" href="http://www.phpfreecode.com/"><span style="font-size: 8pt; text-decoration: none">PHP Free Code</span></a></font>

If you don't know how to use this code or need more information Click here!

Go to Homepage

PHP Best Codes

Php Code: Database driven page system

You can leave comments once you sign in/up.

Review

Links

Visitor

Find Us

Link Us