 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| PHP Web Logs (BLogs) | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Submit Site | ||
| Forex Trading Online forex trading platform | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
<? /* * ********************************* * PHP Code Snippet Library V0.1 * ********************************* * * ********************************* * Author: Stuart Cochrane * Email: stuartc1@hotmail.com * Date: 23-07-2002 * Usage: All comments must remain * License: GNU Genral Public License * Message: * This is my first Open Source * script in PHP - so any comments are * very welcome :-) * ********************************** * * ********************************** * Description: * A very basic code snippets library * designed to hold commonly used code. * A great way to keep track of your * handy code snippets, functions and * classes. * ********************************** * * ********************************** * Requirements: * PHP and MySQL * Tested on Windows NT4 / IIS 4 / PHP 4.1.2 * with standard configuration - * but should run on all Platforms. * * ********************************** * Configuration: * Change the mysql database connections * to match yours - see function con() * Change the mysql database name * to match yours - see function sel() * * ********************************* * Below is the MySQL dump * needed to run this app * ********************************* # # Table structure for table 'snips' # CREATE TABLE `snips` ( `ID` bigint(5) unsigned NOT NULL auto_increment, `Title` varchar(250) default NULL, `Body` blob, `Description` blob, UNIQUE KEY `ID` (`ID`) ) TYPE=MyISAM; # # Dumping data for table 'snips' # INSERT INTO snips VALUES("12","Test Snippet", "echo \"This is the test snippet...\";", "just a test to get started with."); */ // database connection function con() { return mysql_connect("localhost", "root"); } // database selection function sel() { return mysql_select_db("snippets"); } // display the code in colour function dis($body) { $h_string = "<"."?\n\n".$body."\n\n?".">"; return highlight_string("$h_string"); } // retrieve the code from the database function hs($view) { $db = con(); sel(); $snip_sql = "SELECT Body FROM snips WHERE ID = $view"; $snip_qry = mysql_query($snip_sql, $db); while ($snip = mysql_fetch_array($snip_qry)) { dis($snip["Body"]); } } // retrieve the code description from the database function hsd($view) { $db = con(); sel(); $snip_sql = "SELECT Description FROM snips WHERE ID = $view"; $snip_qry = mysql_query($snip_sql, $db); while ($snip = mysql_fetch_array($snip_qry)) { echo $snip["Description"]; } } // retrieve and display the code titles function title($delete = "no") { $db = con(); sel(); $snip_sql = "SELECT ID, Title FROM snips ORDER BY Title"; $snip_qry = mysql_query($snip_sql, $db); while ($snip = mysql_fetch_array($snip_qry)) { $title = $snip["Title"]; $id = $snip["ID"]; if ($delete == "no") { echo "<a href=\"snip.php?view=$id\">$title</a><br>"; } else { echo "<a href=\"snip.php? opt=del&id=$id\">$title</a><br>"; } } } // add a snippet to the database function asnip($title,$code,$description = "none") { $db = con(); sel(); $snip_sql = " INSERT INTO snips (Title, Body, Description) VALUES ('$title', '$code', '$description')"; if (! mysql_query($snip_sql)){ echo mysql_error(); die; } else { return true; } } // delete snippet from the database function dsnip($id) { $db = con(); sel(); $snip_sql = " DELETE FROM snips WHERE ID = $id"; if (! mysql_query($snip_sql)){ echo mysql_error(); die; } else { return true; } } // build the start of a table function tstart($class, $width) { if($class == 1) { echo '<table class="table1" width="'.$width.'" cellpadding="2"> <tr> <td>'; } else { echo '<table class="table2" width="'.$width.'" cellpadding="2"> <tr> <td>'; } } // build the end of a table function tend() { echo '</td> </tr> </table>'; } // set the header vars $appname= '<b>PHP-CSL</b>'; $appversion = '<i>PHP Code Snippet Library V0.1</i>'; // get the diplay type if (isset($opt)) { if ($opt == "add") { $DoThis = "add"; } elseif ($opt == "del") { $DoThis = "del"; } } else { $DoThis = "snippets"; } ?> <style> BODY { background-color : #FFFFFF; color : #000000; font-family : Arial, Helvetica, sans-serif; font-size: 11px; font-weight : normal; background-attachment:fixed; scrollbar-arrow-color: 000000; scrollbar-track-color: ffffff; scrollbar-face-color: E9E9E9; scrollbar-highlight-color: ffffff; scrollbar-3dlight-color: 000000; scrollbar-darkshadow-color: 000000; scrollbar-shadow-color: 000000; } .table1 { background-color: #E9E9E9; border-color: #000000 #000000 #000000 #000000; border-style: solid; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: normal; color: #000000 } .table2 { background-color: #FFFFFF; border-color: #000000 #000000 #000000 #000000; border-style: solid; border-top-width: 1px; border-right-width: 1px; border-bottom-width: 1px; border-left-width: 1px; font-family: Arial, Helvetica, sans-serif; font-size: 12px; font-weight: normal; color: #000000 } .submit { background-color: #E9E9E9; font-family: Arial, Helvetica, sans-serif; font-weight: bold; font-size: 11; color: #000000; text-decoration:none; } </style> <? // draw the header tstart(1, "100%"); echo '<a href="snip.php">'.$appname.'</a> - '.$appversion; tend(); echo "<br>"; ?> <? if ($DoThis == "add") { //START ADD SNIPPETS if(isset($submit)) { // add the snippet to the database if (asnip($title,$code,$description)) { echo ' <script language="javascript"> alert("The snippet was added."); document.location="snip.php"; </script>'; } } else { // show the add form tstart(1,500); ?> <script language="javascript"> function val() { if (document.deletesnip.title.value == "" | document.deletesnip.code.value == "") { alert("You must complete both TITLE and CODE fields."); return false; } else { return true; } } </script> <form name="deletesnip" method="post" action="snip.php?opt=add" onSubmit="return val ();"> <b>Snippet Title: *</b><br> <input type="text" name="title" size="65"><br><br> <b>Snippet Code: *</b><br> <textarea cols="55" rows="15" name="code"></textarea><br><br> <b>Snippet Description:</b><br> <textarea cols="55" rows="6" name="description"></textarea> <p align="center"> <input type="submit" name="submit" class="submit" value="Add Snippet >>"> </p> </form> <? tend(); } } // END ADD ?> <? if ($DoThis == "del") { //START DELETE SNIPPETS if(isset($id)) { // delete snippet from the database if (dsnip($id)) { echo ' <script language="javascript"> alert("The snippet was deleted."); document.location="snip.php"; </script>'; } } else { // show available snippets tstart(1,200); tstart(2,"100%"); echo "<b>Select one to delete:</b>"; tend(); title("yes"); tend(); } } // END DELETE ?> <? if ($DoThis == "snippets") { // START SNIPPETS PAGE ?> <table width="100%" cellpadding="2" border="0"> <tr valign="top"> <td width="200"> <? tstart(1, 200); // show header tstart(2, "100%"); echo "<b>Snippets:</b>"; tend(); title(); echo "<br><br>"; tstart(2, "100%"); echo "<b>Options:</b><br>"; tend(); echo '<a href="snip.php?opt=add">Add Snippet</a><br>'; echo '<a href="snip.php?opt=del">Delete Snippet</a>'; tend(); ?> </td> <td valign="top" align="left"> <? if (isset($view)) { // show the code tstart(1, 540); // show the code description tstart(2, "100%"); echo "<b>Snippet Code:</b>"; tend(); hs($view); tstart(2, "100%"); echo "<b>Description:</b><br>"; hsd($view); tend(); tend(); } else { echo " "; } ?> </td> </tr> </table> <? } // END SNIPPETS PAGE ?> | |||||
| Related Code Examples | |||||
