Et simpelt eksempel. Tilslutningen til databasen og den videre opsætning (validering etc.) må du selv stå for, men dette skulle gerne være et udemærket udgangspunkt.
[tabledump]
#
# Table structure for table `linkdex`
#
CREATE TABLE linkdex (
id int(11) NOT NULL auto_increment,
title varchar(100) NOT NULL default '',
url varchar(250) NOT NULL default '',
username varchar(25) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
*/
[bookmark.php]
<form method="post" action="<?php print basename($_SERVER['PHP_SELF']); ?>">
<input type="hidden" name="sent" value="1" />
Title:<br />
<input type="text" name="title" /><br /><br />
Url:<br />
<input type="text" name="url" /><br /><br />
<input type="submit" value="Send" />
</form>
<?php
require_once("inc.config.php");
mysql_connect($cfg['mysql_server'], $cfg['mysql_username'], $cfg['password']);
mysql_select_db($cfg['mysql_db']);
if (isset($_POST['sent'])) {
mysql_query("INSERT INTO `linkdex` VALUES ('', '".$_POST['title']."', '".$_POST['url']."', '".$_SESSION['user']."')") or die(mysql_error());
print "Dit bookmark blev vidst nok tilføjet";
}
?>
[bookmarks.php]
<?php
require_once("inc.config.php");
mysql_connect($cfg['mysql_server'], $cfg['mysql_username'], $cfg['password']);
mysql_select_db($cfg['mysql_db']);
$result = mysql_query("SELECT `title`, `url` FROM `linkdex` WHERE `username` = '".$_SESSION['user']."'") or die(mysql_error());
if (mysql_num_rows($result) > 0) {
print "<ul>";
while ($data = mysql_fetch_array($result)) {
$data['title'] = (empty($data['title']) ? $data['url'] : $data['title']);
print "<li><a href=\"".$data['url']."\">".$data['title']."</a></li>";
}
print "</ul>";
}
?>
