MySQLi Tutorial Part 3

Its similar to part two and therefore only for repetition.

Connect and get data from database

table has 4 rows
male Patryk 80000
female Anne 5000
male Simon 40001
male Simon 40001

Update data in database in your code without a form

0

Delete data in database

0

Insert Data into database

Be aware of the bad intentions of people!

Binding

Binding Video by Codecourse

Joins

Dont duplicate code for example x persons are from several countries so use integers in one table and connect them with unique values in another table.
Dont create additional queries when you can join queries.
There is a inner, left and right join. Starts at about 12:00.

Joins explained by Codecourse

Tip of the day

Learn everyday!!!