notepad Options

[Maccabee]

im wanting to make an online notepad for personal use. ive got a server. it could be like the one cb uses or this.
http://jumk.de/notepad/

i use that all the time but it sucks. haha.

i figured the best way to do this would be with a database as opposed to cookies or something so that way you can always access it from any pc.

how would i go about this? i only started learning database stuff recently.

fanks. its also just for the learning experience.

[fixtatik]

Do you know about logins, too? Assuming you do, something as simple as the example you put could be done with five (you could do it with four if you really wanted to) columns in a database:

CODE

<?php
// Connect to MySQL
mysql_query("CREATE TABLE memo (id INT NOT NULL AUTO_INCREMENT, PRIMARY KEY(id), user CHAR(15) NOT NULL, pass CHAR(32) NOT NULL, date DATETIME NOT NULL, last DATETIME NOT NULL, memo TEXT NOT NULL)");
?>

CODE

<?php
// Create a new user
if(count($_POST) > 0) {
  $user = $_POST['user'];
  $pass = md5($_POST['pass']);
  if($user && $pass) mysql_query("INSERT INTO memo ('', '$user', '$pass', NOW(), '', '')");
}
?>

CODE

<?php
// Insert a new memo
if(count($_POST) > 0) {
  $id = $_COOKIE['user']; // When they login, set a cookie as their user ID
  $memo = $_POST['memo'];
  mysql_query("UPDATE memo SET last = NOW() WHERE id = $id"); // Update the last memo time
  mysql_query("UPDATE memo SET memo = '$memo' WHERE id = $id"); // Update the memo
}
?>

CODE

<?php
// To read the memo
$id = $_COOKIE['user'];
$query = mysql_fetch_assoc(mysql_query("SELECT date, last, memo FROM memo WHERE id = $id"));
$date = $query['date'];
$last = $query['last'];
$memo = $query['memo'];
?>