php3 registration form

Anon

I need to create a registration form for a web site. I want the form to able to store new information in a database. This would include being able to add new rows. Will somebody give me a real answer to the question I had previously instead of theoretical answers. I know how to do this with Microsoft databases but how do you do this with MySQL? Remember that this is a registration form that will be filled out by clients not data entry clerks, so please consider that when you give me an answer.

Anon

You are asking a very broad question where there really isn't any answer. If you can do it with ODBC then you shouldn't have any problem with Mysql. I think your best bet is to either download phpmyadmin from www.phpwizard.net and then pick it apart so that it does what you are wanting.....or have someone who already knows mysql/php whip one up for you?

regards,
scott d~

Anon

OK.... (excuse dodgy cut'n'paste formatting)

<?php
include "header.inc";

echo "<p>To register, you must provide some information about yourself.</p>";
/*  return to normal html */
?>
<form name="userdetails" method="post" action="confirmation.php3">
<table>
    <tr><label><td>Name: </td><td><input type="text" name="fullname"></label></td></tr>
<tr><label><td>Email: </td><td><input type="text" name="email"></label></td></tr>
</table>

<input type="submit" name="registered" value="Register!">
</form>

</body>

In the script confirmation.php3 you will have access to the variables $email and $fullname submitted with the form. You should
(1)check $email to ensure it doesnt permit dodgy characters that would cause havoc if you ever tried to email to it.
(2) check if a record with this $email exists in your table (assuming its your unique field to identify a user.)
(3) If all your checks are OK (maybe you want to limit number of users or some other checks), its time to insert it into your table.
(4) If the insert works, display a wee message to the user.

I can't give code for this cos being a newbie myself I havent written it yet 🙂 I hope to do this very soon, like tonight or tomorrow.
I hope this isnt too simplistic for your problem if I have misread your question.