First create a database name tips, with whatever username and password you desire. (remember to edit the MySql details in config.php with your username and password). Then in that database, run the following query:
CREATE TABLE `tips` (
`id` INT NOT NULL AUTO_INCREMENT ,
`name` VARCHAR( 25 ) NOT NULL ,
`author` VARCHAR( 35 ) NOT NULL ,
`content` TEXT NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = MYISAM
Now here's the codes for each page:
index.php
<?php
require_once("config.php");
?>
<a href="add.php">Add tips</a>
<?php
$query = mysql_query("SELECT * FROM `tips`");
$display = mysql_fetch_array($query);
?>
<b>Tips</b><br />
<a href="view.php?id=<?php echo $display['id']; ?>"><?php echo $display['name']; ?></a>view.php
<?php
require_once("config.php");
$getid = $_GET['id'];
$query = mysql_query("SELECT * FROM `tips` WHERE `id` = '".$getid."'");
$display = mysql_fetch_array($query);
echo $display['name'] . "by:" . $display['author'] . "<br />" . $display['content'];
?>
add.php
<?php
require_once("config.php");
if($_GET["action"] == "submit"){
$name = clean($_POST['name']);
$author = clean($_POST['author']);
$content = clean($_POST['content']);
if($name == ""){
echo "You forgot a title";
}
if($author == ""){
echo "You forgot your name";
}
if($content == ""){
echo "You forgot your content";
} else { ?>
Thanks for adding your tip, you may view it <a href="view.php?id="<?php $display['id']; ?>">here</a>
<?php
}
}
?>
<form method="post" action="action?submit">
Tip name:
<input type="text" name="name">
Author (your name):
<input type="text" name="author">
Content:
<input type="text" name="content">
</form>
config.php
$database = array();
$database['host'] = 'localhost';
$database['name'] = 'kolzy_ws';
$database['user'] = 'kolzy_w';
$database['pass'] = 's';
$mysql_connection = mysql_pconnect($database['host'], $database['user'], $database['pass']);
mysql_select_db($database['name'], $mysql_connection);
function clean($s){
$s = addslashes($s);
$s = htmlspecialchars($s,ENT_QUOTES);
return $s;
}
I haven't actually ran the code on my server, so there may be some errors.
For a tiny script, 4 pages?
You could have just used $_GET for view/add.