[SOURCE]GiantsFan23's Personal Notepad[/SOURCE]

[GiantsFan23]

Wrote this for a guy on Hackforums, thought I'd share it here as well. Let me know of any bugs / issues. Planning on adding some security to it with a login system if I get the time and people want it.

Here is the table, and the coding. All you have to do is set config.php to be connected to your database.

CREATE TABLE `notepad` (
  `id` int(1) NOT NULL,
  `text` varchar(500) NOT NULL,
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Then find the little SQL window, and run the following query:

INSERT INTO `notepad` (`id`, `text`, `time`) VALUES
(1, 'This is your personal notepad! 500 character limit!', '2010-09-12 12:02:12')

Here is the main page, notepad.php:

<?php include('config.php');

$grabinfo = mysql_query("SELECT * FROM notepad WHERE id = '1'");

while($fetch = mysql_fetch_array($grabinfo))
{
$text = $fetch['text'];
$time = $fetch['time'];
}
?>
<style type="text/css">
#notepad { text-align: center; }
</style>

<div id="notepad">

<form action="update.php" method="post">
<textarea name="text" id="text" rows="10" cols="30"><?php echo $text; ?></textarea> 
<input type="submit" name="submit" id="submit" value="Submit">
</form>

</div>

And the action, update.php is below. On update.php, update the "$update" query with your database name where it says `database_name`.`notepad`. Here is the code:

<?php include('config.php');

if(isset($_POST['submit'];))
{
$text = mysql_real_escape_string($_POST['text'];

$update = mysql_query("UPDATE `database_name`.`notepad` SET text = '".$text."'");

if($update)
{
echo "Notepad content updated!";
}
else
{
echo "Notepad content unsuccessfully updated!";
}
?>

 

[Proof_mybb_import11519]

The data base won't recognize the line breaks, and when you try to output it, it will all be on one line.

HintHint:

nl2br()

 

[RAF]

Trashed: [SOURCE]GiantsFan23's Personal Notepad[/SOURCE]

This thread has been trashed, it will be moderated by the Administrators for a further opinion.

 

[RAF]

Trashed: [SOURCE]GiantsFan23's Personal Notepad[/SOURCE]

This thread has been verified to be a quality thread and has been moved back into the rightful forum section.

Please contact Management if this was wrongfully done.