Folio

MySQL in practice

Notes, with the queries showing.

  1. 01 Select
  2. 02 Insert
  3. 03 Update
  4. 04 Delete

A small desk for login and CRUD.

Sign in

Open your desk.

Use the demo account, then read, write, update, and remove notes.

Demo admin password

SQL on this page 
SELECT id, username, password_hash FROM users WHERE username = ?

The password is checked in PHP with password_verify(), so the hash never goes back into the query.