Storing Information and displaying...

[SquireQuack]

Link Program

I'm trying to create a program where anyone can enter in a Link and the link gets displayed in a page and anyone can click on it.

here's the code for the program above:

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Links</title>
</head>

<body>

<?php if (!empty($_POST['Anchor']))
echo "<a href=\"{$_POST['Anchor']}\">{$_POST['Name']}</a>" ?>

<form name="Links" action="" method="post" >
Link Location: <input name="Anchor" type="text" size="100" /> <br>
Link Name<input name="Name" type="text" size="50" /><br>
<input type="submit" value="Link it!">
</form>

</body>
</html>

I was wondering how do I do the actual storing?

 

[iNod]

Hello,

Well first lets get down what you want to store it in?

MySql or Files?

Once I get this I will assist you with creating the code.

iNod

 

[user-7256]

As in a Database? Google it

 

[SquireQuack]

Hello,

Well first lets get down what you want to store it in?

MySql or Files?

Once I get this I will assist you with creating the code.

iNod

I'm just trying to make it so anyone can enter information in the textfields and a link will be created and displayed in a list. I'm wondering how do I store the information in the textbox...

I was thinking I could also write it to a file...but I think database might be the better solution.

 

[Eric]

Here's something basic... I've commented throughout.. Hope you understand a tad.

<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Links</title>
</head>

<body>

<form name="Links" action="" method="post" >
Link Location: <input name="Anchor" type="text" size="100" /> <br>
Link Name<input name="Name" type="text" size="50" /><br>
<input type="submit" value="Link it!">
</form>

<?php

if(!empty($_POST['Anchor']))
{

  //Connect to a database.
  //Replace dbuser, dbpass, and dbname with appropriate values
  $db = mysql_connect("localhost", "dbuser", "dbpass") or die(mysql_error());
  mysql_select_db("dbname", $db) or die(mysql_error());

  //Get the Name
  $name = $_POST['Name'];
  //Get the link
  $anchor = $_POST['Anchor'];

  //Insert the data into the database
  //This is assuming you have the table "links", with columns/fields "anchor" and "name"
  $q = mysql_query("INSERT INTO links (anchor, name) VALUES('$anchor', '$name')") or die(mysql_error());

  echo "Your link: <a href=\"$anchor\">$name</a> was successfully added.";
  //Provide a link to show all links
  echo "<br><br><a href=\"Links.php?do=show_all\">View all links</a>.";

    //If they clicked the "View all links" link
    if($do == "show_all")
    {
      $query = mysql_query("SELECT * FROM links");

      while($row = mysql_fetch_array($query))
        {
          $show = $row['anchor'];
          $show2 = $row['name'];

          echo "<a href=\"$show\">$show2</a><br>";

        }
      }
   }

?>

</body>
</html>

 

[SquireQuack]

Thanks! I appreciate the help!