Foreign Key not visible in the PHP tables

Question

Please help these are all the error that I encountered. I an using php and mysql

1. The Supplier ID is not visible in the Supplier’s Location table and Ingredient Table

2. The Ingredient_Id is not visible in the Transaction table

3. In the ingredient table, I entered “Bun” and “125 however it went to Ingredient Id number 2 instead of 1

This is the link of my codes: https://codeshare.io/5ND6gV

Please help me, I’m just a beginner please dont be mean

Answer 1

4. After I fill out the Supplier’s Location, the data is not visible in the table