server-side PHP code to process the form to mysql

Question

I have a form (on page form.php) and when the submit button is clicked it sends the data to mysql using:

  <form name="food."; action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" >

I now want to submit it to mysql then go to 'thankyou.php' page. So I need a server side PHP code to process the form to mysql.

  <form name="food."; action="thankyou.php" method="post" >

thankyou.php will submit the form then display 'thank you, your form has been submitted'.

What would the code need to be on the thankyou.php page to submit the form data on the form.php page.

Dude, you're missing php basics, you should google for php form control tutorials like this one html-form-guide.com/php-form/php-form-tutorial.html btw: is this a homework? — Vyktor
– Vyktor, Commented Feb 6, 2012 at 21:02
Basically the exact question text as: stackoverflow.com/questions/9165182/… You really should learn basic HTTP form handling before going for "fancy" stuff. — Marc B
– Marc B, Commented Feb 6, 2012 at 21:04

score 1 · Accepted Answer · 2012-02-06 21:55:32Z

1

You should go through some basic tutorials for it: http://www.w3schools.com/php/php_mysql_insert.asp

Here is sample code :

<?php
    $con = mysql_connect("localhost","peter","abc123");
    if (!$con)
      {
      die('Could not connect: ' . mysql_error());
      }

    mysql_select_db("my_db", $con);

    $sql="INSERT INTO Persons (FirstName, LastName, Age)
    VALUES
    ('$_POST[firstname]','$_POST[lastname]','$_POST[age]')";

    if (!mysql_query($sql,$con))
      {
      die('Error: ' . mysql_error());
      }
   header("Location:thankyou.php");

    mysql_close($con)
    ?>

edited Feb 6, 2012 at 21:55

answered Feb 6, 2012 at 21:06

user319198

Sign up to request clarification or add additional context in comments.

11 Comments

user1188711 Over a year ago

I have followed this tutorial, my code is here pastebin.com/DCJTjCPr . Im getting error 'Not Submitted'. All field names are correct. It is connecting to the db but not storing the data. Do you have any idea why?

user319198 Over a year ago

you should quote all passed values properly. Like : '".$_POST[attendance1]."','".$_POST[colour1]."',.....

user319198 Over a year ago

$sql="INSERT INTO user (attendance1, colour1, shade1, attendance2, colour2, shade2) VALUES ('".$_POST[attendance1]."','".$_POST[colour1]."','".$_POST[shade1]."','".$_POST[attendance2]."','".$_POST[colour2]."','".$_POST[shade2]."')";

user1188711 Over a year ago

ok got it working however it creates a new record in mydql. how do I just update the record?

user319198 Over a year ago

just go through tutorials for updating records. use UPDATE query for that

|

tomexsans · Accepted Answer · 2012-02-07 05:52:08Z

1

you Are using the

    <?php echo $_SERVER['PHP_SELF']?>

meaning you are sending that on the same page,

    if(isset($_POST['submit'])){
    //validate your post
    if (post validated)
    insert to database
    use the header("location:thankyou.php");


    }

edited Feb 7, 2012 at 5:52

answered Feb 6, 2012 at 21:48

tomexsans

4,5374 gold badges37 silver badges49 bronze badges

Comments

Michael L Watson · Accepted Answer · 2012-02-06 21:05:52Z

0

First setup your database connection, this information is best saved in a separate file

http://php.net/manual/en/function.mysql-connect.php

depending on what your form fields are, these would need to be added to the database with an INSERT Query

http://www.tutorialspoint.com/mysql/mysql-insert-query.htm

Then use

header("Location:thankyou.php");

(make sure there is no html before the redirect)

You don't need to another form

answered Feb 6, 2012 at 21:05

Michael L Watson

98013 silver badges26 bronze badges

Collectives™ on Stack Overflow

server-side PHP code to process the form to mysql

3 Answers 3

11 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

11 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related