Deckyon's Script Center

Source Code - Cut and paste from the Source Code field.

Website Information
Author Bradley Buskey
Email deckyon@gmail.com
Website http://scripts.deckyon.com
Script Name Template - Admin
Language PHP/HTML
Purpose
Administers the Template app. Allows editing, deleting and adding records to the database. FYI: This website is based on this template!
Source Code - Use <CTRL> - <A> to select all and then <CTRL> - <C> to Copy the text.
<?php include('../inc/db.php'); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head>  <title>Change me to something else</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body bgcolor="#000000" link="#0000FF" vlink="#0000FF" alink="#0000FF"> <center> <table width="100%" border="0" cellspacing="1" cellpadding="1"> <tr> <td background="images/blue_spacer.gif"> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="5%" align="left" valign="middle" background="../images/blue_spacer.gif"><img src="../images/write.gif" width="50" height="30"></td>  <td width="95%" align="left" valign="middle" background="../images/blue_spacer.gif"> <font color="#FFFFFF" size="4" face="Trebuchet MS">Table Title - <i>and its description</i></font></td> </tr> <tr> <td colspan="2" bgcolor="#FFFFFF"> <?php echo ' <img src="../images/flech.gif" width="8" height="9"> <a href="'.$PHP_SELF."?action=insert#Add".'"><b>Click Here to Add a New Entry</b>'."</a><BR>"; echo "<TABLE cellspacing=\"0\" cellpadding=\"2\" border=\"1\" width=\"100%\" bordercolor=\"#c0c0c0\" bordercolordark=\"#ffffff\" bordercolorlight=\"#c0c0c0\">"; echo "<TR>"; echo "<TD width=\"5%\" align=\"center\" bgcolor=\"#e0e0e0\"><B>Edit</B></TD>"; echo "<TD width=\"5%\" align=\"center\" bgcolor=\"#e0e0e0\"><B>Delete</B></TD>"; echo "<TD width=\"5%\" align=\"center\" bgcolor=\"#e0e0e0\"><B>Id</B></TD>"; // TODO: Change width to equal 85 divided by number of columns. // TODO: Change and add the number of columns required. echo "<TD width=\"%\" align=\"center\" bgcolor=\"#e0e0e0\"><b>Column 1</b></TD>"; echo "<TD width=\"%\" align=\"center\" bgcolor=\"#e0e0e0\"><b>Column 2</b></TD>"; echo "</TR>"; $db = new DB(); // TODO: (+) Update the table name "tbl_table" and sort column "ID" $db->query("SELECT * FROM tbl_table ORDER BY ID"); // TODO: (+) Update the table data variable "$tbl_table" while ($tbl_table = $db->next_record()) { echo "<TR bgcolor=#f0f0f0>"; echo "<td align=\"center\"><a href=\"$PHP_SELF.?action=edit_entry&ID=$tbl_LFDKP_OnyxiaMC[ID]\"><img src=\"../images/edit_entry.gif\" border=\"0\" alt=\"Edit\"></td>"; echo "<td align=\"center\"><a href=\"$PHP_SELF?action=delete_entry&ID=$tbl_LFDKP_OnyxiaMC[ID]\"><img src=\"../images/delete_entry.gif\" border=\"0\" alt=\"Delete\"></td>"; // TODO: (+) Make sure table data variable array and column are updated // TODO: (-) This does not have to be the full numer of fields, but must magch the number of columns in the table. echo "<td align=\"center\"><b>".$tbl_table["ID"]."</b></td>"; echo "<td align=\"left\"><b>".$tbl_table["Column1"]."</b></td>"; echo "<td align=\"left\">".$tbl_table["Column2"]."</td>"; echo "</tr>"; } echo "<TR><TD align=\"center\" bgcolor=\"#d0d0d0\" colspan=\"10\"><a href=\"update.php#top\"><img src=\"../images/back1.gif\" class=\"doroll ../images/back2.gif\" alt=\"Back to Top\" border=0></a></td></tr>"; echo "</table>"; ?> </td> </tr> </table> </td> </tr> </table> </td> </tr> </table> <?php //______________________________Edit Entry______________________________// if($action == "edit_entry"){ echo "<br>"; $db = new DB(); if ($Submit) { // TODO: (+) Update the SQL statement to match the columns and data from the form below. $db->query("UPDATE tbl_table SET Column1 = '$Column1',Column2 = '$Column2' WHERE ID = '$ID'"); echo "<b><font color=\"#FF0000\" size=\"3\">Your category was updated.</font></b>"; echo "<br><br>"; echo '<meta http-equiv="refresh" content="0;URL='.$PHP_SELF.'">'; } $db->query("SELECT * FROM tbl_table WHERE ID='$ID'"); $tbl_table = $db->next_record(); ?> <form name="form" method="post" action=""> <TABLE cellspacing="0" cellpadding="2" border="1" width="100%" bordercolor='#c0c0c0' bordercolordark='#ffffff' bordercolorlight='#c0c0c0'> <tr><td align=center colspan=2 bgcolor="#d0d0d0"><b>Edit Entry</b></td></tr> <!-- // TODO: (+) Make sure the number of fields match the number of db fields in the SQL statement in line 71 <tr> <TD width="20%" align="left" bgcolor="#e0e0e0"><B>ID:</B></TD> <!-- // TODO: Name the field to match the SQL statment <!-- // TODO: Change the table name variable to match DB table name. <td width="80%" align="left" bgcolor="#f0f0f0"><?PHP echo $tbl_table[ID] ?></td> </tr> <tr> <!-- // TODO: Name the column/row to something understandable. <TD width="20%" align="left" bgcolor="#e0e0e0"><B>Column 1:</B></TD> <!-- // TODO: Name the field to match the SQL statment <!-- // TODO: Change the table name variable to match DB table name. <td bgcolor="#f0f0f0" align="left"><input type="text" name="Column1" value="<?php echo $tbl_table[Column1] ?>" size="100" maxlength="250"></td> </tr> <tr> <!-- // TODO: Name the column/row to something understandable. <TD width="20%" align="left" bgcolor="#e0e0e0"><B>Column 2:</B></TD> <!-- // TODO: Name the field to match the SQL statment <!-- // TODO: Change the table name variable to match DB table name. <td bgcolor="#f0f0f0" align="left"><input type="text" name="Column2" value="<?php echo $tbl_table[Column2] ?>" size="100" maxlength="250"></td> </tr> <tr> <td colspan=2 bgcolor="#d0d0d0" align="center"><input type="submit" name="Submit" value="Submit Changes"></td> </tr> </table> </form> <?php } //______________________________Delete Entry______________________________// if($action == "delete_entry"){ // TODO: (+) Update the SQL statement to the correct table name. $res = mysql_query("DELETE FROM tbl_table WHERE ID=$ID"); echo '<meta http-equiv="refresh" content="0;URL='.$PHP_SELF."".'">'; } //______________________________Insert Entry______________________________// if($action == "insert"){ ?> <form name="form" method="post" action=""> <? $db = new DB(); if ($Submit) { $db = new DB(); // TODO: (-) If you want required fields, change these to match, otherwise, they can be deleted. if($Column1==""){echo "Error -> Missing Column 2 Name - First Field";exit;} if($Column2==""){echo "Error -> Missing Column 2 Name - First Field";exit;} // TODO: (+) Update the SQL statement to match the columns and data from the form below and the table name. $db->query("INSERT INTO tbl_table (ID,Column1,Column2) VALUES ('','$Column1','$Column2')"); $id = $db->insert_id(); echo '<meta http-equiv="refresh" content="0;URL='.$PHP_SELF."".'">'; } ?> <form name="form" method="post" action=""> <TABLE cellspacing="0" cellpadding="2" border="1" width="100%" bordercolor='#c0c0c0' bordercolordark='#ffffff' bordercolorlight='#c0c0c0'> <tr><td align=center colspan=2 bgcolor="#d0d0d0"><b>Add New Entry</b></td></tr> <tr> <!-- // TODO: Name the column/row to something understandable. <TD width="20%" align="left" bgcolor="#e0e0e0"><B>Column 1:</B></TD> <!-- // TODO: Name the field to match the SQL statment <td bgcolor="#f0f0f0" align="left"><input type="text" name="Column1" value="" size="100" maxlength="250"></td> </tr> <tr> <!-- // TODO: Name the column/row to something understandable. <TD width="20%" align="left" bgcolor="#e0e0e0"><B>Column 2:</B></TD> <!-- // TODO: Name the field to match the SQL statment <td bgcolor="#f0f0f0" align="left"><input type="text" name="Column2" value="n/a" size="100" maxlength="250"></td> </tr> <tr> <td bgcolor="#d0d0d0" align="center" colspan=2><input type="submit" name="Submit" value="Submit"></td> </tr> </table> </form> <? } ?> <p><a href="../dbapp.php"><img src="../images/home1.gif" class="doroll ../images/home2.gif" alt="Return to Home" border="0"></a></p> <p><font color="#FFFFFF" size="2" face="Trebuchet MS">© Copywrite 2006, Bradley Buskey - </font><a href="mailto:deckyon@gmail.com"><font color="#D0D0D0" size="2" face="Trebuchet MS">deckyon at gmail dot com</font></a></p> </center> <script src="../images/doroll.js"></script> </body> </html>

Deckyon's Script Center - Select a script to see the source code and purpose.

View Script Name Language Author Email Website
SysInfo VBS Bradley Buskey
GroupMembers VBS Bradley Buskey
UserInfo VBS Bradley Buskey
WB Emailer WinBatch Bradley Buskey
GeoConvert WinBatch Bradley Buskey
CheckWks WinBatch Bradley Buskey
Template - View PHP/HTML Bradley Buskey
Template - Admin PHP/HTML Bradley Buskey
Template - DB Functions PHP Bradley Buskey
Template - Table SQL Bradley Buskey
Rollover Javascript Bradley Buskey
Restore Desktop VBS Bradley Buskey
User Backup VBS Bradley Buskey
Printer Map VBS Bradley Buskey
Ghost Server VBS Bradley Buskey
Profile Remover VBS Bradley Buskey

Special Download! - All the VB Scripts above PLUS some Bonus Scripts available for download in a single CHM help file. <Click Here>