31: MySQL Insert Into Database | PHP Tutorial | Learn PHP Programming | PHP for Beginners

MySQL Insert Into Database | PHP Tutorial | Learn PHP Programming | PHP for Beginners. Today we will learn how to insert data into database tables in phpMyAdmin.

➤ GET ACCESS TO MY LESSON MATERIAL HERE!

First of all, thank you for all the support you have given me!

I am really glad to have such an awesome community on my channel. It motivates me to continue creating and uploading content! So thank you!

I am now using Patreon to share improved and updated lesson material, and for a small fee you can access all the material. I have worked hard, and done my best to help you understand what I teach.

I hope you will find it helpful :)

[wirito]

5:35 For the people that got confused on what he said, take a moment to read it and see if it clicks:

The code we just used inside our SQL is gonna be the same code we're gonna use when we actually get to insert data inside the code of a website. So when we write our PHP code, we're actually gonna be writing SQL code inside our PHP code which then runs the SQL code from PHP, into the database and does something with the database depending on the SQL code we wrote inside the PHP code.

Thanks for the videos dude. I am learning a lot!!

[lawrencemichael]

Who made it here starting from episode 1?
Nice work friend! You can do this!

[Kuuuhrizz]

You can also use:
insert into posts VALUES(NULL, 'This is a subject', 'This is an example of a content that contains contents to be viewed as a content', '2018-11-27 11:03:01');

[bamfodinho]

great job. Your way of explaining things is so outstanding. There's no better tutorial online than this one. Thanks a lot, bro. Waiting for a tutorial in python.

[CannabiiiisX]

Realy helpfull video's for me, i knew a few bits of the puzzle before i started your video series and watching them made me fit everything together . Youre doing a great job as instructor and somehow now how to get so many people hooked until episode 31 (so far) thanks you for that and i'm looking forward to progress in the series as i speak !

[wmrdwijerathna]

Thank you so much.Keep up the good work.

[shuyisun]

Thanks a lot for your tutorial !!!! It is really helpful!

[dasshrs]

Set default value to date - current_timestamp and the date would be generated automatically, so you don't have to insert it.

[Royalediamond_]

Helpful. What app do you use for php programming? And while using both apps to create a portal, do you first write the php code or you create the database in phpmyadmin first?

[leng]

Hi, I got one error when I tried to insert the data into table: error #1036 table is read only. Please help me to fix that.
Thanks a lot

[machalismos]

you can also use the fuction now() to get the current time

[nigelpallatt]

insert into posts (subject
MySQL said:  #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

[ainiomr]

hello, how do i create an infinite number of users in the table ?

[sivi]

Dani's crush: Hey can you show me how to code in PHP?
Dani: 5:27

[vik]

04:34 I'm watching this in 2022 January... hearing 2015 gave me a quarter life crisis XD

[Stoney_Eagle]

This is so funny. Im sitting here like I just press SELECT and double click a item on the right... How old is this video 🤣. I'm spoiled af. I actually copy all my shit and I actually don't learn what I'm doing I just see results crossing my fingers if it will actually works. Now I'm actually learning how it works. I'll keep watching.

[gv]

If I create php login system,
Can I just mail that thing to my friend?
Will that work?

[derlerner]

Is it seconds or milliseconds in 4:42?

[pianoLee-sxdx]

I just notice that when you are inserting datas, especially password, it doesn't hash it here? Do you need to add another code to hash it?

[FskpZ]

Hey mmtuts thx for your tutorials.

I have one question about comments and posts on sites. Is it better to use data base for those two or is it better to write comments, posts inside .txt files that we can create with php every time user comment or post something. We can write some check if file exist write inside existing file, else create new .txt file and write post, comment inside. But than question arise.... how to separate comments inside this file by users, time, topic?

PS: Sorry for mt English. It's not my native language.