How to Insert Form Data Into a MySQL Database Using PHP

Here's the special discount link for Rob's course:

Training Center:

Subscribe on YouTube:

Subscribe on SoundCloud:

Subscribe on iTunes:

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

[livinglies]

whoa! wow! omg...I cannot believe there actually exist a programmer who can teach!!! so, many...too many tutorials seek to convey an understanding of web dev/c.s., but leave their audience behind. most usually because of some detail or nuance the developer assumes or takes for granted, and forgetting that many students are even still trying to understand the terminology within the science, or in having that, are still very novice relative to detail. moreover, many of us are self taught, scrambling to piece together aspects of development as we go and as it is necessary. Therefore, we havnt accumulated a large avenue of the bits and pieces that makeup the whole of the science. Although, whenever we encounter those keystone bits of info, receiving it fully explained or even if by chance discover an example in virtual application, these make much of the science come together. By far, this is one of the best videos I have observed over processing and handling of data...Well done! I am definitely going to subscribe...Awesome!

[mrRobertdrums]

Thanks John, this works perfect! The only thing I did different is create variables for my connection and my php is on an external sheet.

[Adepentane]

Thank you for this sir. More videos about login, registration fields and redirecting to either admin if admin, or user pages if user. Thanks in anticipation.

[ArijitBanerjeeArley]

Very much helpful. I am watching late but thanks for describing so nicely and well.

[myle]

I fucked up on school but u saved my ass i think. Thank you for taking the time to make a video dude:)

[darshankini]

empty function is not validating whether it is empty or not. It just insert blank values into the database.

[soban]

I am having a problem that when the information is sent to the database, instead of showing the name and email in the database. It shows 0 in the place of name and email. How can I fix this?

[claverbrou]

The soundtrack of the beginning is very cool

[chrissythompkin]

Just what I was looking for! Thanks for the video

[ozzysideika]

Great video. super simple to understand well explained.

[novosprospectus]

How do you validate it then submit data into the database if no errors are found?

[chuckbear]

great tutorial but when you refresh the page it inserts back to the Database...

[azeemunnisakhan]

Thank you so much sir. This helped me alott

[flstudiotricks]

I miss webmatrix.. on Linux now so using xampp but webmatrix was an awesome program... nice tutorial just did this for a client.

[livinglies]

Again, Awesome work! Superb explanation being concise, but through enough in detail to convey the lesson...I do have a question that perhaps you could answer?...You referred to the the order of the data set or column arrangement relative to the arrangement of matcjing form fields...So, what if the form ommitted certain column meta data and you couldn't match it up due to the missing form fields? Also, what if you had a registration form trying to match form fields with database fields? It seems as tho I remember seeing that the form also had to have an ID to coincide with the submission entry #, so that the submission could be related to the form submission author? what of this, and how would one do it?would it be relative to the user_id or form entry ID or form entry submit #? Again. thank you for clarifying things a bunch...Great Video!

[PriyabratChoudhary]

Hi what if i want to add more fields like adding work, experience or almamater, so how can i match it with the primary key as id so that when user inputs the basic details he/she can input their work experiences or any other fields accordingly.
Need Code for that mapping up.

[richarddunne]

I'm looking for tutorials on submitting a form with expandable tables, so each field name is an array? (WAMP)

[apseh]

Hello John,  
A great tutorial once again just like the other tutorials from you. I read your mail and as wanted by you I would like to ask for two tutorials from you which I think would be a great help to all and sundry.

Ok so the first tutorial that I would like to see is that of handling errors in an application. Now while most tutorials show how to handle errors in a development scenario, none of them really cover a production scenario. While we can use the die statements and use errors to check the code and find the errors at the development stage, its definitely what we want to do during production. So a comprehensive video tutorial on error handling in a production environment is what I would like to see from an expert like you. I think it would be really very helpful for all.

Another tutorial that I would request for is one that would show and help me graduate from a procedural programming to a framework based oops programming basics. I have made two attempts to try and move to a framework based programming but I am totally lost. So if you could do a "moving to a framework for Dummies" kinda tutorial that would be great !!

Thanks for your awesome tutorials that are always so clear and always with detailed explanations. I always refer to them when in doubt. Thanks again.

[nilsgarland]

Can't you write the code whilst you record? More effective because I don't really understand it when you are just explaining it.

[sddrthpkhrna]

mysqli is not working.
I used the mysql_connect command for logging in.That worked.
what do i do for this register page?