Shopping List Database

Sample of php accessing MySQL (MariaDB) database, with images stored IN THE DATABASE as Binary Large OBjects (BLOBs)

Database ER Diagram is below. Image thumbnails are 0.8% of original size; you can download full resolution by right-clicking/long tapping (depending on your device) the thumbnail and choosing "save as" or similar.

The List Type can be anything but the query shows only "Shopping" list types.

SELECT
item.list_name
, item.item_name
,item_image
, is_deleted
, list.list_type 
FROM
 list
,item
 where
 item.list_name=list.list_name 
and list.list_type='Shopping' order by 1,2
List NameList TypeItem NameLogically DeletedItem Image
Fry'sShoppingBread0
Home DepotShoppingExtension Cord1
Home DepotShoppingFlowers1
SafewayShoppingLight Bulb0
select
 list.list_name
,list_type
,item_name
,is_deleted
,item_image 
from 
list left outer join item 
on item.list_name=list.list_name
and list.list_type='Shopping' order by 1,2
List NameList TypeItem NameLogically DeletedItem Image
AmazonShopping
Fry'sShoppingBread0
Home DepotShoppingExtension Cord1
Home DepotShoppingFlowers1
PhotosPrivate
SafewayShoppingLight Bulb0