... Your Seattle Cake Specialist

Demo Mysql

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

creates a simple mysql connection via the function conn()

Error in file: '/home/jlever02/jeremieleverich.com/cakes/inc_0700/conn_inc.php' on line: 98 Error message: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead

BackTrace:
Array
(
    [0] => Array
        (
            [file] => /home/jlever02/jeremieleverich.com/cakes/inc_0700/config_inc.php
            [line] => 186
            [function] => printDeveloperError
            [args] => Array
                (
                    [0] => /home/jlever02/jeremieleverich.com/cakes/inc_0700/conn_inc.php
                    [1] => 98
                    [2] => mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
                    [3] => 1
                )

        )

    [1] => Array
        (
            [function] => myErrorHandler
            [args] => Array
                (
                    [0] => 8192
                    [1] => mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead
                    [2] => /home/jlever02/jeremieleverich.com/cakes/inc_0700/conn_inc.php
                    [3] => 98
                    [4] => Array
                        (
                            [access] => 
                            [improved] => 
                            [myHostName] => itc280.remiedesigns.com
                            [myUserName] => jeremiel
                            [myPassword] => TeamJC#1
                            [myDatabase] => remiedesigns_itc280
                        )

                )

        )

    [2] => Array
        (
            [file] => /home/jlever02/jeremieleverich.com/cakes/inc_0700/conn_inc.php
            [line] => 98
            [function] => mysql_connect
            [args] => Array
                (
                    [0] => itc280.remiedesigns.com
                    [1] => jeremiel
                    [2] => TeamJC#1
                )

        )

    [3] => Array
        (
            [file] => /home/jlever02/jeremieleverich.com/cakes/demo/demo_mysql.php
            [line] => 47
            [function] => conn
            [args] => Array
                (
                    [0] => 
                    [1] => 
                )

        )

)



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