Get the source code here: http://www.johnmorrisonline.com/lesson/build-advanced-html-form-using-php-mysql/ In this lesson, you’ll learn how to build a kick ass …
source
How to Build an Advanced HTML Form Using PHP and MySQL
Get the source code here: http://www.johnmorrisonline.com/lesson/build-advanced-html-form-using-php-mysql/ In this lesson, you’ll learn how to build a kick ass …
source
32 responses to “How to Build an Advanced HTML Form Using PHP and MySQL”
hi john, what if I only want certain fields to go to certain tables? for example if I want the student info to go into a student table, then their class info to go in the class table, all submitted on the same form.
Just stop making videos and practice for a while lol
After i update the .php code i tried to run the page to connect to mysql database on phpmyadmin on web browsers, but no message is shown. Only the source code is shown, does anyone know why?
Hi John, I've been trying to teach myself programming for a while now. I'm actually a full time psychologist, so the programming is more of a hobby that I do in my spare time. Anyway, I really like your tutorial. However, one question I can't seem to find an answer to is reloading form selections back into a form. So the idea would be that I could have a rather large form tied to a users name (patient's name in my case) and save their selections if they don't finish, then reload their selections again in the next session to allow them to finish. I was wondering if you could make a tutorial showing that process or direct me in some direction that shows it. I've been looking for a long time and really just not finding anything of value.
I've been told that mysql functions are deprecated and unsafe, and that we should always use the mysqli equivalents. Would you agree now it's 2017?
Hi John – thank you so much for your videos. I am learning a lot. I'm new to this but I couldn't find the form.php file in the code download…
The $ symbols in the connect function are confusing. They weren't in the last tutorial.
Sorry got another question…: I googled and got that $_POST array gets values from HTTP POST method. In your form.php, you have <input type="hidden" name="formID" value="form2"> without explicitly defining the method, and I also got from w3c that the default method is GET. Then, how could this table name be passed to $table = $_POST['formID'] without defining method = 'POST'?
Thanks for the help!
Another noob question: In your f_sqlConnect() function I didn't see a return statement inside of it, then how could you make $link= f_sqlConnect(blablabla) in your process.php? Does this $link "take" out the value of the local var $link inside of f_sqlConnect()?
Thanks
Hi Sorry but could you further explain what is "installed domain"? Is it just the current domain? Googled it got no answer…
Thanks
Your courses are awesome you put all the details together…easy to learn
Great ….awesome tutorials…Thank You very Much…just what I was looking for
I could not find the form.php file for this lecture. It was not included in the download. can someone please help?
Had been struggling for sometime with connecting with a database with php and you really helped me a lot. Great tutorials.
I had to tweak though some code due to mysqli.
very helpful
Awesome series. Everything I needed to fill the holes of my learning. Could you show the snipit for doing an UPDATE. (query read, change a field data, update). I've seen other examples but not in an array fashion. Thanks.
I tried the code and it worked with no error but its not taking value from the user. I'm not getting whats wrong with my code.
"You are not allowed to submit data to this form" this message is displayed after submission of form, any suggestions to get it correct ?
Hi very nice this video, but a have a doubt how can i select a form from an dropdown menu item? Regards.
The download source is different than this code here in the video
This guy is selling his source code: this is what i have found on his site: Looking for the source code? Get all my source code (even the paid stuff) when you support the show at $5/month or more.
source code isn't online
How do I get all the $_POST info back into the original page to do a mail() function?
I don't want to put the mail function in my process.php because I use it for many forms.
can i still use this concept if i have only Apache and create database via cmd command?
Okay, there is definitely something buggy here. It just can't create a table over 19 entries (not counting the ID, timestamp, etc.) without smashing you over the head with error messages. It's either a fault with my localhost software (or its components) or some issue in the code…
Sod this fancy automated stuff, I'm going to create the tables manually. Life is too short to waste it debugging when there's a simpler way to get the end result.
Great tutorial, though clearly not for the novice, that's for sure. A real oddity for me when using the dynamic form code is everything works like a charm as long as I don't go above 19 fields. If I use 20+ fields, it still creates and populates the database table, but dishes out a host of undefined index and undefined constant alter errors rather than redirecting to my success page… Will have "fun" digging into the reasons for that.
You have saved me so much time. Thank you!
Hey John, this has been a really great tutorial and I love the concept of being able to create table items from the HTML. When I applied your code to my contact page I keep receiving the "You are not allowed to submit data to this form" error message. I was wondering what your thoughts on this might be. there must be something up on my end with the if ($domain == $r_domain) portion.
Love it!
i need the source code !
i think i finished the multiple captcha … I have not seen anything in my mail yet, so what's next sir?
the link won't open
Hi, I've a problem, when I click the submit, it returns me "The reCAPTCHA wasn't entered correctly. Go back and try it again.(reCAPTCHA said: incorrect-captcha-sol)". How can I configure recaptcha in the code?
Thank you for this tutorial, it is very helpful.