MySQL control Panel/Auction site Instructions

The goal of this project is to clean up, at least partially, a poorly
designed simple auction site.

I. Get files installed and working on lampbusters (30pts)
    A. Unzip the files onto your zip drive
    B. Make a directory called prog4 on lampbusters.com
    C. Copy mysqlcp_param02.php into that directory
    D. Follow the instructions on mysqltest.sql and make sure the tables
        are created and data is in them (check out
            https://lampbusters.com/bob   to see what is inside)
    E.  Edit the mysqlcp_param02.php to get it to work
        1. replace m_coperni  with your dbname (Musername)
        2. Replace the one spot that has my username (coperni) with your username
        3. create a file in your main directory (level above public_html)
            then change ../blurg.inc  in the file to  ../../yourfilename.inc
            inside the file you should only see
            <?php
                $password ='  ';
             ?>
             Where you put your database password between the single quotes
        4. The viewauctions and the form for Additem should now work from the 
            pulldown menu.
    F. DO NOT CONTINUE ON UNLESS THE ABOVE is WORKING!
    
II. Remove functions from file (50pts)
    A. save the mysqlcp_param02.php file as prog4.php
    B. Inside prog4.php  search for mysqlcp_param02.php and make sure the name
        now says prog4.php and NOT mysqlcp_param02.php in 2-3 places
	(Note can also use $_SERVER[SCRIPT_NAME]  )
    C. Remove the form and put it into a file called form.php.inc
    D. Remove the viewauction() and additem() functions from the prog4.php file
        (do this one at a time, do viewauction first all the steps, then come back
        and do additem() )
    E. save them in files named viewauction.php and additem.php respectively
    F. Go back into the "control" portion of prog4.php and make sure to
       "include" the file JUST before the function it contains is called.
    G. Make sure that everything still works
   
III. Redo the database connections to use mydb3.php.inc (70pts)
    A. You do not use addauction_insert02.php yet, but look at it for help in
        doing this step. This is the part that takes some understanding of
        classes/objects
    B. Delete the section inside prog4.php that has the
        showerror() and connectdb()
    C. include towards the top of your php code the mydb3.php.inc file
    D. (again look at addauction_insert02.php for examples) rewrite first the
        viewauction.php and then the additem.php file to do the following
        1. the functions should take  the database name and the location of the
            password file as arguments
        2. change the functions to create mydb3 objects
            (use $db1 for viewauction() and $db2 for additem()  )
        3. Once both functions now work with the mydb3 class, test that
            addauction_insert02.php works and actually inserts into the db
               (browse table under phpmyadmin)
IV.  Filter  addauction_insert02.php  (50pts)
    A. create a file called safety.php.inc
    B. include it in the addauction_insert02.php file
    C. inside safety.php file you will create a function based on scrubadub that
        you used for the last assignment, and some of my examples
    D. Function should take the input to be filtered, the data type as arguments
        and, optionally, a maxlength field if you have time.
    E. use the function to clean all five of the variables at the top of the file
        BEFORE they are used in the insert (note, category is fairly easy, something
        like /[a-Z]{2,8}/   would get it totally ;)