... Your Seattle Cake Specialist

Demo Mysqli

This page is both a test page for your mysqli connection, and a starting point for building DB applications using mysqli connections

creates a simple mysqli connection via the function conn()

SQL STATEMENT: select CakeID, CakeName, Flavor, MetaDescription, MetaKeywords, Price from Cakes

Cake Name: Manhattan Beach
Flavor: This Pumpkin Pie cake has Cinnamon Spice
MetaDescription: Chocolate Filling
MetaKeywords: and has 5 tiers
Price: 250.99

Cake Name: August
Flavor: Yummy, Bananas Foster
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 3 tiers
Price: 225.99

Cake Name: Vanderbilt
Flavor: Pear Compote and Ginger cake
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 3 tiers
Price: 225.99

Cake Name: Sofia
Flavor: Italian Orange and Vanilla cake
MetaDescription: with Traditional buttercream filling
MetaKeywords: and has 3 tiers
Price: 175.49

Cake Name: Scenes of Italy
Flavor: Cardamom and Pistachio cake
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 4 tiers
Price: 225.99

Cake Name: Rosie
Flavor: Cherry and Almond
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 4 tiers
Price: 250.99

Cake Name: Perfect Pink
Flavor: Strawberry Shortcake
MetaDescription: with Strawberry buttercream filling
MetaKeywords: and has 3 tiers
Price: 199.99

Cake Name: Love Birds
Flavor: Red Velvet Chocolate
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 3 tiers
Price: 225.99

Cake Name: Katherine
Flavor: Blackberry Sourcream
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 3 tiers
Price: 375.99

Cake Name: Greece
Flavor: Peanut Butter Cup
MetaDescription: with Chocolate frosting filling
MetaKeywords: and has 8 tiers
Price: 375.99

Cake Name: Giovana
Flavor: Blueberry Muffin
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 5 tiers
Price: 299.99

Cake Name: Folk Art
Flavor: Black Forest
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 7 tiers
Price: 275.99

Cake Name: Dia de los Muertos
Flavor: Ginger and Green Tea
MetaDescription: with Green Tea buttercream filling
MetaKeywords: and has 3 tiers
Price: 275.99

Cake Name: Deco
Flavor: Pear Spice
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 6 tiers
Price: 325.99

Cake Name: Daisy
Flavor: Pineapple Coconut
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 5 tiers
Price: 325.99

Cake Name: China Pattern
Flavor: White
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 3 tiers
Price: 275.99

Cake Name: Boheme
Flavor: Curry Caramel
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 4 tiers
Price: 285.99

Cake Name: Bohand Utz
Flavor: Pear Compote and Ginger
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 4 tiers
Price: 275.99

Cake Name: Birdy
Flavor: Blueberry Muffin
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 2 tiers
Price: 199.99

Cake Name: Bird Song
Flavor: Beurre Noisette
MetaDescription: with Buerre Noisette buttercream filling
MetaKeywords: and has 4 tiers
Price: 325.99

Cake Name: Belle
Flavor: Lemon Poppyseed
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 3 tiers
Price: 250.99

Cake Name: Babys Breath
Flavor: Almond
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 3 tiers
Price: 274.99

Cake Name: Argyle
Flavor: Tiramisu
MetaDescription: with Kahlua buttercream filling
MetaKeywords: and has 5 tiers
Price: 325.99

Cake Name: Amy and Ryan
Flavor: Egg Nog
MetaDescription: with Italian buttercream filling
MetaKeywords: and has 4 tiers
Price: 275.99