inserting data into two db tables using php

How to insert data into two different tables in the database using php

[@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.

[@kotimunkansi3055]

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

[@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👍👍👍👍👍👍👍👍👍👍

[@johnjack577]

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

[@dennischarles4384]

Thanks indeed, your contribution is the best!

[@niwamicha226]

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

[@sharthakrai4482]

just the video I needed for my assignment! thanks

[@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

[@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

[@Shr3zza]

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

[@samtadhanve8539]

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

[@Giangbpro]

Gracias me ha ayudado mucho

[@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?

[@aymanechnaif9308]

Thanks for the video it was great

[@priyankasawant2083]

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

[@mohammedabdhullah6359]

Thanx brother!
Very useful

[@ImproveProgrammingLogic]

Good..

[@balogunsemako1912]

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

[@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

[@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.

[@dianaabdulrasyid4766]

May God bless you

[@marigiyvonne294]

Very Helpful

[@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?

[@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.

[@0sawelucky815]

Thanks

[@anxious3350]

Its always failed, why ?

[@gokulg2756]

Code plz