How to Create an HTML Form That Stores Data in a MySQL Database Using PHP Part 3 of 4

Make sure to watch the UPDATED version of this tutorial here:

Learn how to create a PHP form that will store data in a MySQL database. In this 4-part series, you'll learn the exact PHP code you need to connect to, access, and store data in a MySQL database using a simple HTML form. Part 3 of 4

-~-~~-~~~-~~-~-
Please watch: "Ryan Carson: How to Get an IT Job WITHOUT a College Degree"
-~-~~-~~~-~~-~-
#php #webdev

[dignyochick]

4 years later, this is EXACTLY what I need. Thank you very much sir!

[john.morris]

Best place to go to see them all is the playlist here:

[bobo]

Excellent tutorial. I was having some issues on a school assignment and this tutorial straightened it right up. Thanks!

[nyakwada]

this videos helped me a lot with my assignment.

[thierrydore]

Hi there and thanks a lot for your tutorails.
Could you put a link to the next 'episode' ? because i can't find the last part .

Thanks

Ok, I've just watched your final video (4/4) and I got it. Can you please post the link for the video "advanced form construction" you have mentioned.
Thank you
Fábio

[john.morris]

@phillmadz Well, you have to make sure the field/value names you substituted in the form are also substituted in the script. A query was empty error sounds like the script isn't getting any data from the form... which could be caused by not substituting the field/values in the script.

[JeremyvanVliet]

Hey dude, what a great video-serie it is!
Thank you for your great way of explaining, the demo.php (i've called it save.php) doesn't do anything! it just stays blank, no echo and no error.... could you help me out?
What information do you need?

Thanks so much. I am heading to your site now.

[kimv]

I've followed tutorial exactly and love it.  But on my server side, there is no data that is showing up?  Any suggestions?

[eddiecardona]

Thank You John U tha Man Helped me out Big Time

[PaidfromHomewithTee]

I did a test demo the exact way you did. I was taken to a blank page on submit...

[thestudiovegas]

Do you have a tutorial on how to create a form that uploads to an SQL database and sends a confirmation e-mail?

Nice tutorial.
My question is:
You've got the following code:

$value = $_POST ['input1'];
$sql = "INSERT INTO demo (input1) VALUES ('$value')";


So, considering i've got input2, input3 in my database, how do I send those multiples values to my database?
Appreciate your time.

[jeyaprakaz]

Hai Sir ... Thank you very much it was very useful for me...but please help me to add one more tab like input 1.Please sir !

[MrAcebest]

I have followed your instruction carefully step by step. But when I tried to submit my form, there's a undefined index notice on my browser, and the input didn't get to mysql. where did I go wrong? I use dreamweaver as an editor, and xampp package. Thanks bro.

[john.morris]

Is your form field named "input1". If not, you'll need to change $_POST['input1'] to whatever the name of your form field is.

[MemoriesByTheSmile]

Ok, I am following along, but is there anywhere that you explain how to put in a success message? Like, once someone uses my form and the information has been successfully submitted, they should get a message like "thank you for submitting." Do you explain that anywhere? Or can you tell me how to do that PLEASE? I'm so close to having this all worked out!!!

Thank you

[Vandole]

i have a really bad professor that didn't explain this well enough in class, but since I am watching these videos i'm understanding it more, but where do i put my php files that i'm making for MySQL so that i can browse them via localhost? i've yet to find anything that can answer this question.

[john.morris]

@autumnreign86 I'd have to know what errors you're getting to really be able to help. Also, have you watched all four videos?