Entry Form Database...

[wookie224]

Does anyone have a sample page where a user can enter information into a form and insert it into a database?

One to view the info would be nice too.

Thanks

[The Hobo]

If you're talking MySQL database, it would go like this:

if (isset($_POST['submit'])) {
    $sql = "INSERT INTO tblName (name, email) VALUES ";
    $sql .= "('" . $_POST['name'] . "', '" . $_POST['email'] . "')";

    $result = mysql_query($sql) or die(mysql_error());
    if ($result) {
        echo "Data entered successfully!";
    } else {
        echo "Failed to insert data!";
    }
} else {
    echo '<form action="insert.php" method="post">
        <b>Name</b>: <input type="text" name="name">
        <b>Email</b>: <input type="text" name="email">

        <input type="submit" name="submit" value=" Add ">
    </form>';
}

But, of course, you must have a database, table, and fields setup before it'll work.

[wookie224]

Thanks! Worked great!

Now... What is the easiest way to display some records?

Thank you for the help

[The Hobo]

Following the previous example I gave:

$people = mysql_query("SELECT * FROM tblName") or die(mysql_error());

if ($person = mysql_fetch_array($people)) {
    do {
        echo '<a href="mailto:' . $person['email'] . '">' . $person['name'] . '</a><br>";
    } while ($person = mysql_fetch_array($people));
} else {
    echo "No people found!";
}