View

Snippets Add/View

Snippet Author: FURBY
Rated:

Snippet Description: ok, its alot like codedb.org's snippet but its 100% purely mine.

there is an upload.php and view.php

When you upload this to your webserver just change the database information. add a database as follow

snippets (database name)
snippet_type (mIRC/php/tcl)
snippet_id (int auto_increcment)
snippet_date (date)
snippet_user (username that uploaded the script)
snippet_title (the title of the snippet)
snippet_code (the actual snippet)
snippet_description (a description of the snippet)

once you upload visit http://yourwebsite.com/upload.php?type=mIRC (for uploading a mIRC snippet) and once you've filled in all fields then visit http://yourwebsite.com/view.php?snippet=1 <--- will show you the very first snippet posted.

i've left out the copyright stuff because i don't care about it. people normally rip other peoples stuff so its easyier this way. just feedback would be welcomed.

################
Start upload.php
################

$snippets = $_GET[type];

$dbhost='localhost';
$dbusername='root';
$dbuserpass='root';
$dbname='root';

// connect to the mysql database server.
mysql_connect ($dbhost, $dbusername, $dbuserpass);
mysql_select_db($dbname) or die("Cannot select database");

//Are they just getting here or submitting their info?
if (isset($_POST["name"])) {
$snippet = $_POST["name"];
$description = $_POST["description"];
$code = $_POST["script"];
$date = date("Y-m-d");
$username = $_COOKIE['name'];
//Was a field left blank?
if($snippet==NULL|$description==NULL|$code==NULL) {
echo "A field was left blank.";
}else{
//Everything seems good, lets insert.
$query = "INSERT INTO snippets VALUES('$snippets','','$date','$_COOKIE[user]','$snippet','$description','$code')";
mysql_query($query) or die(mysql_error());
echo "The Code $snippet has been successfully added.";
}
}
?>
<html>
<body>
        <?
        $snippets = $_GET[type];

if (isset($_COOKIE['user'])) {
?>
<form method="post" action="upload.php?type=<? echo $snippets; ?>" name="add" align="center">Snippet Title: <input name="name"><br><br>
Snippet Description:<br>
 <textarea cols="30" rows="10"
 name="description"></textarea><br>
Snippet Code: (test it firstly)<br>
  <textarea cols="30" rows="10" name="script"></textarea>
  <input value="Submit this Code" type="submit"></form>
<?
}else{
        echo "Please login to post a Script.";
        }
        ?>
</body>
</html>

#################
End of upload.php
#################

#################
Start of View.php
#################

<?
require('config.php');

$snippets = $_GET[snippet];

$row1 = mysql_query("SELECT * FROM snippets WHERE `snippet_id` = '$snippets'") or die(mysql_error());
while ($row=mysql_fetch_array($row1))
{
echo "<H1>$row[snippet_title]</H1><br>";
echo "<b>Snippet Author:</b> $row[snippet_user]</b><br>";
echo "<b>Snippet Description:</b> $row[snippet_description]</b><br>";
echo "<blockquote>";
echo "<textarea rows=\"25\" cols=\"57\" class=\"snippetarea\">$row[snippet_code]</textarea>";
echo "</blockquote>";
}
?>
###############
End of View.php
###############

Favorite Script -

FURBY

Comments:
Do you guys want me to post edit.php ? :P

Posted by: FURBY

FURBY

Comments:
oh and also delete.php? :P

Posted by: FURBY

sakjur

Comments:
:D Looks nice, I'll try it someday..

Posted by: sakjur

Smilies	Message:
	Comments:

X-Static Codes

Search

Scripting

Links

Sponsors

Stats

View

Snippets Add/View