<style type="text/css">
.num {
float: left;
color: black;
margin-right: 6pt;
padding-right: 6pt;
border-right: 1px solid gray;}
</style>
<?php
function highlight_num($file)
{
  echo '<code class="num">';
  $lines = explode("\n", $file); for ($x = 0; $x < count($lines); $x++) { echo $x+1 .". ".$lines[$x]; echo "<br>"; }
  echo "</code>";
}
$dbuser = "MYSQL DB USERNAME";
$dbpass = "MYSQL DB PASSWORD";
$dbserver = "MYSQL DB ADDRESS";
$db = "Your mysql database name";
$url = "The URL to this file!";
mysql_connect($dbserver, $dbuser, $dbpass) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());
if (!$_POST['submit'] AND !$_GET['id']) {
   echo "<form method=\"post\" action=\"pastebin.php\">
   Enter text here:<br>
            <textarea name=\"submit\" rows=\"25\" cols=\"80\"></textarea>
            <br><br>
            <input type=\"submit\" value=\"submit\">
        </form>";
}
if ($_GET['id']) {
   $num = $_GET['id'];
   $query = "SELECT Paste FROM PasteBin WHERE Number='$num'";
    $result = mysql_query($query);
    $row = mysql_fetch_array($result);
    if (!$row['Paste']) { echo "sorry, I couldn't find that entry in the database"; } else {
    echo "Paste Number $num:\r\n";
    echo "<pre>".highlight_num($row['Paste'])."</pre>";
    echo "   <br><br><br \><form method=\"post\" action=\"pastebin.php\">
            Make changes:<br>
            <textarea name=\"submit\" rows=\"25\" cols=\"80\">"; echo $row['Paste']."</textarea>
            <br><br>
            <input type=\"submit\" value=\"submit\"></form>";
}
}
if ($_POST['submit']) {
   $paste = $_POST['submit'];
   $query = "SELECT MAX(Number) AS Number FROM PasteBin";
    $result = mysql_query($query);
    $row = mysql_fetch_array($result);
    $num = $row['Number'] + 1;
    mysql_query("INSERT INTO PasteBin (Number, Paste) VALUES('$num',  '$paste') ") or die(mysql_error());
    echo "Your post was sucessfully submitted!\r\n<br> It can be found at <a href=\"$url?id=$num\">$url?id=$num</a>";
}
?>