inserting data into two db tables using php

[@bstechideas2173]

Thank you so much for this. Been looking for this fro 2 months! You got yourself another subscriber. Bravo

[@rakaadiprasetya6863]

thank you so much for this video bro, finally got the answer for my problem👍👍👍👍👍👍👍👍👍👍

[@kotimunkansi3055]

This video was very helpful... i had lost so much hope in finding a solution

[@justgotravel6646]

I guess you never heard the concept of relational database.
How would you be able to link the user to the message? The way you do it would be a mess. If a message record is deleted/wrong inserts you would have a mismatch in primary keys. Furthermore if you later on want to extend with more tables then all the autoincrement keys are not in sync.
I suggest you add userid column to the message table. Then you need to insert the user in first SQL insert, have the new user ID returned (you can do this in PHP), do the second SQL2 query adding the message and userid to the message table.
With this method you can have several messages for the same user record.
And now you have a relationship - Relational Database.

[@dennischarles4384]

Thanks indeed, your contribution is the best!

[@dianaabdulrasyid4766]

May God bless you

[@johnjack577]

Boss kindly do a tutorial on a foreign key, relating two tables together on a database

[@sharthakrai4482]

just the video I needed for my assignment! thanks

[@samtadhanve8539]

Thank u so much it's help me lot..

[@niwamicha226]

thank you so much for this tutorial , can i you please do it for the foreing key

[@aymanechnaif9308]

Thanks for the video it was great

[@diedsoul7591]

great but i have a quest, how can we put the id the same i mean in the messages table the id should be the same to the id of the table user

[@priyankasawant2083]

thank you man thank you so much its help me a lot.

[@mohammedabdhullah6359]

Thanx brother!
Very useful

[@ImproveProgrammingLogic]

Good..

[@Shr3zza]

Hi How would i do this if I wanted to insert it into 3 different tables ?

[@marigiyvonne294]

Very Helpful

[@Giangbpro]

Gracias me ha ayudado mucho

[@balogunsemako1912]

Nice Video Bro
how can i insert into two db table base on gander select

[@kainatit4649]

I wanna use database tables as options in drop down menu to insert data of different semester's student into different separate tables. how can I do this?

[@afrikblog5162]

Sir please I will really appreciate it if you could do a video on how to insert into a table that has a foreign key constraint and also teach on auto date with php ..which means when a user click on the submit button they should be a auto date of the registration

[@petermsomphola4497]

on auto date just create current timestamp in your database

[@afiqahsaid5763]

hi, how do you do for auto increment unique id (same for 2 tables in database) so that we know based on the same id (connected between 2 table)? really appreciate your help on this . thanks

[@justgotravel6646]

I suggest you add userid column to the message table. Then you need to insert the user in first SQL insert, have the new user ID returned (you can do this in PHP), do the second SQL2 query adding the message and userid to the message table.

[@0sawelucky815]

Thanks

[@mouradmessaoud7440]

hello, it's beautiful I understood everything but I ask you a query that is inserted in two tables with recovery of identifier auto increment after each request, then inserted into the third table, thank you very much and good continuity.

[@rizwanrizu6694]

But id is vering

[@akhilkazi1454]

Hello sir please update a video as price qty total with inserting to database.

[@abrakadabrajordan5184]

I tried this code and it worked, although the second time it did not work, and then after that it never worked again, can anyone explain this?

[@anxious3350]

Its always failed, why ?

[@therandompostguy]

I was thinking you could do this project for me. Do provide your email so we can talk privately.

[@zegitalacademy6281]

[e-mail]

[@therandompostguy]

@@zegitalacademy6281Thank you so much for replying, I have sent you an email.

[@gokulg2756]

Code plz