I was hoping someone else would have answered this by the time I woke up :D
I'm going to assume you use PHPMyAdmin to administer your mysql databases. Create a new table (I called it textentries) with the following layout:
EntryID (Type: MEDIUMINT ; Length: 5 ; Attributes: UNSIGNED ; Null: not null ; Extra: auto_increment ; Primary)
Data (Type: text ; Null: not null) - The TEXT type will allow up to 64Kb of text data entry, if you need larger then use mediumtext which allows up to 16Mb
The code for the form.php page is:
<html>
<head>
<title>Textarea post</title>
</head>
<body>
<?php
// Address to the MySQL database server
$dbServer = "localhost";
// MySQL username
$dbUser = "your-username";
// MySQL username's password
$dbPassword = "your-password";
// MySQL database name
$dbName = "test";
// Check to see if data was posted and that it's at least one character long
if ( ($_POST["submit"] == "Post") && (strlen($_POST["textentry"]) > 0) ) {
$Data = $_POST["textentry"];
if (!get_magic_quotes_gpc())
$Data = addslashes($Data);
// Connect to the MySQL server
$LinkID = mysql_connect($dbServer, $dbUser, $dbPassword);
// Select to the database
mysql_select_db($dbName, $LinkID);
// Do the query
mysql_query("INSERT INTO textentries (Data) VALUES('".$Data."')", $LinkID);
echo "The data was added to the database.";
} else {
$iEntryID = $_GET["entry"];
// Make sure the entry ID is numeric
if (is_numeric($iEntryID)) {
// Connect to the MySQL server
$LinkID = mysql_connect($dbServer, $dbUser, $dbPassword);
// Select to the database
mysql_select_db($dbName, $LinkID);
// Do the query
$Result = mysql_query("SELECT Data FROM textentries WHERE EntryID = ".$iEntryID);
// Output the result
if (mysql_num_rows($Result) == 0)
echo "No data found.";
else {
$Row = mysql_fetch_assoc($Result);
echo "<pre>".$Row["Data"]."</pre>";
}
} else
ShowForm();
}
// This function will output the form
function ShowForm() {
?>
<form action='<?=$_SERVER['PHP_SELF'];?>' method='post'>
Type some text here:<br> <textarea cols='40' rows='10' name='textentry'></textarea>
<br><input type="submit" name="submit" value="Post">
</form>
<?php
}
?>
</body>
</html>I added comment where I thought it was necessary. It's not really a cut and paste script since you said you just needed it for educational purposes :).
It has absolutely no error handling. If something is wrong the MySQL server, database or table they'll see an "ugly" PHP error.
When you copy the code use the quote button below my post since vBulletin seems to be in the habit of "eating" certain characters. Hope it helps you some :)