mysql and forms help

Question

I have been wondering how I would go about adding data from users in a form (firstname,lastname, email) and then putting that data into a mysql database.

Is this possible? Are there any tutorials on how to do this, if not could you show me the code?

Any help would be greatly appreciated. Thanks for your time. Dom

Accepted Answer

Below I have written up some code for you with detailed comments, if there's anything down there that you don't understand just send me an email: @live.com">n00ne @live.com.au

<?php

//We connect to the database first so that we can insert the data.

$server = "localhost"; //This is the default.
$db_user = "root"; //Username for your database.
$db_pass = "lockerngome"; //Password that goes with the username above.
$db_table = "users"; //Your table.

//Connect to the database.
mysql_connect($server, $db_user, $db_pass);
mysql_select_db($db_table);

?>
<html>

<form action='name-of-file-this-file.php' method='post'>
Firstname: <input type='text' name='firstname' /><br/ >
Lastname: <input type='text' name='lastname' /><br/ >
Email: <input type='text' name='email' /><br />
<input type='submit' name='submit' />
</form>

<?php

//If the form has been submitted.
if($_POST['submit']){

    //Getting the data from the form. 
    $firstname = mysql_real_escape_string($_POST['firstname']); //mysql_real_escape_string() is not necessary, it just makes the form more secure and protects from SQL injection.
    $lastname = mysql_real_escape_string($_POST['lastname']);
    $email = mysql_real_escape_string($_POST['email']);

    //Checking to see if those fields have been filled out.
    if($firstname && $lastname && $email){
        //Insert into the mysql database.
        //The blank value before first name ('') is the ID which should be set to auto increment.
        //WHERE id='1' means where the users id is 1, so John's id might be 1 so his data will be put into the database.
        //Generally you would not use id='1'. You would have the id set as a session so it would look like: WHERE id='".$session_id."'
        mysql_query("INSERT INTO users VALUES('', '$firstname', '$lastname', '$email') WHERE id='1'"); 
        //The VALUES above are in order so your mysql table would be: id, firstname, lastname, email. That's why you insert following that order.
    }
    else
        //If the firstname, lastname or email inputs have not been filled out, or if none of them have been filled out, echo an error.
        echo 'You have not filled out all of the inputs.';
}
//If the form hasn't been submitted.
echo 'Please fill out the form below.';

?>
</html>

Answer 2

0	http://www.freewebmasterhelp.com/tutorials/phpmysql/3 You can download this free chapter http://dev.mysql.com/tech-resources/articles/php-security-ch02.php http://itc.virginia.edu/desktop/web/database/inventory/display/home.html answered Apr 22 '11 at 09:23 HeadOvMetal 11●1

Answer 3

0

Sorry if this double posts - it did not appear for me.

Thank you all for your links / code it has really helped me with what i was looking for. I realise that I still needed to leave a blank gap for the auto-incrementing id so wat I put as a first name value was infact going to the id section and so forth. Once again I thank you all for your help.

answered Apr 23 '11 at 05:28

DomChester
391●12●16●25

mysql and forms help

Follow this question

Related questions

Lockergnome.net

Lockergnome