And so it begins…
November 11, 2009…the main course, aka pulling and displaying data from the database.
I started by just implementing the muffin_list.php and muffin_view.php scripts into my original Rosewood Guitar page designs; not very pretty. Then I learned what the real assignment was so I began to hack apart the html.
the implementation was quite easy except I originally had some problems integrating the php into the html. The problems boiled down to bad quotation marks and then a stray semi-colon, but after these were resolved it was smooth sailing.
I had already created a four item table for the guitar strings named: tblStrings. I then learned that I had to have 20 items, so a lot of my time was entering the data into the database and finding and formatting appropriate images.
I added some fields to the database that I don’t directly use like: manufacturer, and I will test later to see if I can sort the items by manufacturer or price later.
Another issue is the length of the page, but I assume we will be covering limiting the items retrieved later.
Tested everything and it all looks good.
time: 3 hours
