

<form action="add.php" method="post">
Name: <input type="text" name="name" />
<br />
URL: <input type="text" name="url" value="http://" />
<br />
<input type="submit" value="Submit" />
</form>
<?php
//File where all links are stored
$file='links.txt';
//Variables Posted
$name=$_POST['name'];
$url=urldecode($_POST['url']);
//Open File and Add Link
$handle=fopen($file,'a');
//Check that all data is filled in
if($name == '' || $url == ''){
die("Please fill in all fields correctly");
} else{
fwrite($handle,$name.'=>'.$url.'
');
}
?>
<?php
//Path to links file
$links='links.txt';
//Open
$links=file($links);
//print_r($links);
//Display
foreach($links as $line){
list($name,$url)=explode('=>',$line);
$url=str_replace('
','',$url);
echo '<a href="'.$url.'">'.$name.'</a>';
echo '<br /><br />';
}
?>
<?php
$cfg['dbhost'] = 'localhost';
$cfg['dbuser'] = 'user';
$cfg['dbpass'] = 'pass';
$cfg['dbname'] = 'database';
//connect to the database
function connectdb(){
global $cfg;
mysql_connect($cfg['dbhost'],$cfg['dbuser'],$cfg['dbpass']);
mysql_select_db($cfg['dbname']);
}
?>
<?php
include_once('config.inc.php');
$action=$_POST['action'];
$name=$_POST['name'];
$url=$_POST['url'];
if($action == 'add'){
//Add User and Link To DB
connectdb();
if($name == !'' || $url = !''){
if(mysql_query("INSERT INTO `links` VALUES (NULL,'$name','$url')")){
echo "Link Added";
}
}
}
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<input type="hidden" name="action" value="add" />
Name: <input type="text" name="name" />
<br />
URL: <input type="text" name="url" value="http://" />
<br />
<input type="submit" value="Submit" />
</form>
<?php
include_once('config.inc.php');
connectdb();
$query=mysql_query("SELECT * FROM `links`");
$rows=mysql_numrows($query);
$i=0;
while($i < $rows){
$name=mysql_result($query,$i,'name');
$url=mysql_result($query,$i,'url');
echo '<a href="'.$url.'">'.$name.'</a><br />';
$i++;
}
?>
CREATE TABLE `links` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`name` TEXT NOT NULL ,
`url` TEXT NOT NULL
)



