RTE on the home page

I have added the RTE to the home page so that the “news” section can be edited. I also added a link and description to the admin page.

Time:30mins

RTE

Uploaded all of the files for the RTE. I was a little confused as to which packages and files I should be uploading so i just downloaded the full fckeditor and worked from there.  The main problems were getting the styling right so that it would appear on the page correctly, plus I originally pointed it towards my main style sheet, but that didn’t work so well so i pointed it towards the editot style sheet contained within the fckeditor package.  All to do now would be to integrate it with the index page so that the text can be edited.

time:2hrs

Image Upload

Added image upload functionality to the string_view.php page(s).

Changed pathing and then had to adjust CSS, adding class to image upload link, to make sure it was fully visible on the live page.

Tested when logged out to make sure “peek a boo” link is not visible.

added thumbnail creation.  Re-uploaded all of my images to have thumbnails generated.  readjusted my strings.php list page to accommodate the new smaller thumbnails.

will look later at the “meaningful” and “list_multi” options.

time: 1 hr

nmAdmin

Added the administrative login functionality to the site.

Pretty easy implementation.  Began by putting the non-root include files into the correct folders.  Then searched and replaced with the correct pathing for my server.  Uploaded all the files to the correct folders then tested by trying to direct link to all the visible files to make sure that they redirect to the admin_login.php page which they did.

The most time consuming process was adding a slight bit of CSS to ensure that the text was legible on a black background as well as giving the sections a little bit of breathing room.  Also not hard to implement, but it takes a bit of sleuthing through the PHP code to see where to put the new HTML tags.  Had one snag until I realized that there are two HTML sections on the admin_reset.php page.

 

Time: 1.5 hrs

Page listing

Added the page listing to the Rosewood strings page. Not very difficult, just changed the pathing to my “img” folder, and changed the default number of items shown.
I also uploaded the images for the paging feature.
Tested, everything works fine.

time:30mins

And so it begins…

…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

List-View application

Created a database table called “muffins” then created both muffin_view.php and muffin_list.php.  Changed the pathing in the files then styled the text so that it appears on a black background.  The instructions say to add the images from the class demo to an “uploads” folder, but I could find no images.  Tested.

time: 1 hour

Functional Includes

In class, worked on implementing functional includes to the site.  There were a few steps involved:

1. creating new inc and log folders on my root folder on Bluehost
2. changing all login/path information on the new include files provided by Bill (used find and replace, but then realized that I had to go through and manually change the path to my root folder as well).
3. commented out the sessions folder in the config_inc file
4. copy/pasted the header info from Bill’s index to my index.
5. moved my header/footer includes to the inc_rosewood folder in the root
6. kept my titling function and added that include to the folder as well
7. tested

time: 2.5 hours

First steps to database

Created include and log folders outside of the web root and set to 0700. Had to do some research to find the absolute path names.

time:20mins

Dynamic Page Names

Well, thanks to PHP Solutions I have dynamic page names for my site.  So I was able to ditch the homepage specific header include for a universal one.  Now I will have to include that on all the rest of my pages and make sure they are named something appropriate for the script.

Time: 1hr for research and implementation