Crud project with 2 tables

General PHP Help
#1

Hello, I used MySql, PHP and PHPMyAdmin for the back end and HTML, CSS and Bootstrap for the front end

Here is an example of the tables I would like to create:

Table User:

  • name

  • email

  • id

Table Car:

  • Services

  • Plate Number

  • id (Foreign key)

Since my table ‘User’ is done, can I ask how can I add the second table so I can read, update and delete it as well using this source code below:

This source code contains the current full code (crud of table user)
https://drive.google.com/drive/folders/1a15Uxvf_eizznCZ-MymqAqnzQTj9_M_w

#2

The same way you did the “user” table. Just do that again.

#3

I keep on getting a lot of errors because I need the both id’s from both table to have a relationship

#4

What’s the relationship between a car and a user?

#5

The relationship vetween users and car is the id

#6

I mean, the business relationship. Does each car have a driver? Several drivers? Passengers?

Sponsor our Newsletter | Privacy Policy | Terms of Service