PHP Tutorial (& MySQL) #30 - Saving Data to the Database

Hey gang, in this PHP & MySQL tutorial I'll explain how to save data to our MySQL database. We'll do this with a SQL command called INSERT.

----------------------------------------

🐱‍💻 🐱‍💻 Course Links:

🤑🤑 Donate


🎓🎓 Find me on Udemy

[hassaanhameed]

the thing in this video is that telling the SQL injection concept too at the beginners level so nice Shaun

[francisseneve]

I am waiting for the PDO class because you are a great teacher!

[TheLinguists]

You are truly NINJASTIC! I bought a Udemy PHP course (one of the "so-called" best ) and I gave it up that since I couldn't get what the guy was talking about. I love your way of explaining things and making everything so clear. My next step is getting your Javascript course which I have planned to get actually for a couple of months :D but was waiting to finish the PHP. Thank you so much for everything :)

[rakhandawood]

For people who had problems with displaying data.
When writing
$sql start with double block quotes and when writing the variables for VALUE use the single quote.

[nimishakhadilkar]

My college project was possible only because of you.Thank you.

[ayushvarma]

Great Series, you're a gem bro ♥

[Tuttigiu]

This is a big one. Couldn't have success because of damn semicolons, damn misspellings, but after I reviewed every single character and corrected misspellings it worked. I was getting a blank page because I typed in "msqli" instead of "mysqli" ...

[Dr.Ecksack]

Thanks for the tutorial. Are you going to make an "updated" tutorial for preventing SQL injections? mysqli_real_escape_string is deprecated and I read you should always use PDO, prepared statements and a whitelist. I'd love to see this explained by you, because you always make things well understandable.

[bastaty]

It’s an amazing tutorial, I got so many important stuff, thank you so much
But could you please make a PDO tutorial in PHP with Msql
And Laravel 8

[AetherSummers]

I’ve triple checked and I have the syntax correct here, but when I submit my form I just get a blank page instead of redirecting to another and storing the input. Do you know what might be happening?

[Daniel-bkob]

I really hope I can become a great coder like you. You seem to have never encountered a bug ever. Hahaha

[wademorris]

This video is very helpful. I am planning on building an online classified ads. Can you do a video on that user after logged in that they can add and delete the post from the user area?

[ladogelava]

I have a query error. Can you help me?

[cedric_ds]

You did not cloes the connection to the database here.
Would it make sense to put the code to close a connection in the footer.php, or maybe even create a new .php file for that and include it at the end?

[lasagna]

Hi, Thank you for the awesome tutorial. I have a general question that should we close connection to db every time a mysqli_connect is called or we only close connection after result is fetched from db? I'm confused since no mysqli_close is called in add_pizza.php.

[Knowledgeseeker]

Thank you so much for very simple explanation ❤❤

[musicmukuljaipur]

01:31 how does externalization helps in preventing repeating database connections? That db_connect still gonna invoke every time the page refreshed and connection will establish

[rakibhasannur]

Form validation doesn’t work after adding the database in the add.php page.
Any help regarding the problem would be appreciated

[artco]

when i click add a pizza it send me to the homepage and add an empty slot div of pizzas in the homepage, without bringing me to the form page to actually add pizzas ingredients, why?

[SuperSayiyajin]

Hi. I did same thing but include is not worked for me.Require worked .Why is that?