Some good news
Jul. 21st, 2006 12:27 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
sharanWell, last night I made major progress in my major goal for the summer, working on Rockers Online, which makes me feel a lot better about the fact that there's only about a month left before classes start up again. I've uploaded a few minor changes but the big part has been happening completely behind the scenes, and I haven't even posted about it ON Rockers Online because I'm doing major work on the database and the less I have to copy over from the live site before this goes live the better. As it is I'll have to copy over the user poll information from the live database.
The MAJOR goal is to make the band/artist pages truly database driven and easy to update. Finally! Right now the text is technically in the database, but it's just a bunch of html thrown into one database field. It's even harder to update than it was when it was straight HTML files, so I haven't BEEN updating it. I figure if I make this easy to update hopefully I can start updating these pages and continue it even after classes start!
I started with the Band/Artist administration page, which got pretty complicated, especially since Solo Artists have to go in both Band and Artist tables (Artist is for band members). So there's a lot of sticking data into tables, pulling out the ids, and sticking data into other tables. Once I finished that I started on an even bigger project: Websites. This got really nasty because it not only dealt with at least 4 or 5 different tables, but I wanted a series of checkboxes for the type of content on the sites (bio, discography, etc...) that was pulled dynamically from the database. I also needed to be able to Add, Edit, Delete, Add to Band, Add to Artist, Remove From Artist/Band, etc. Well, last night I got the final pieces of that working, so I finally have website administration completely working! I even set it up to display the websites in an include file I can reuse on the actual band/artist pages, so all I'll have to do at that point is plug it in. Everything else after this should be easy in comparison, since things like Mailing list and FTP site are all just Title, URL, and Description, and I can reuse a lot of the code from websites.
This is the biggest project like this I've ever done by myself from scratch, so it's great experience!:)
So it looks like there's a good chance I'll have this project done before classes start, and be able to actually start updating the site once in a while! I think throwing myself into school over my head really has made me more productive, since I'm getting a lot more done now outside of work while working full time than I ever did before I went back to school.
In other good news, Kitty went to the vet this morning. His eye's much better and he no longer has to walk around with a cone around his head constantly bumping into things! I'm sure he's happy now! He basically had a type of herpes most cats have since birth, and his eye was watering for months and he managed to scratch his face up really badly rubbing at it. It's better now, although it could always come back. Other than Lysine twice a day until August just in case he doesn't need anything else for this:).
The MAJOR goal is to make the band/artist pages truly database driven and easy to update. Finally! Right now the text is technically in the database, but it's just a bunch of html thrown into one database field. It's even harder to update than it was when it was straight HTML files, so I haven't BEEN updating it. I figure if I make this easy to update hopefully I can start updating these pages and continue it even after classes start!
I started with the Band/Artist administration page, which got pretty complicated, especially since Solo Artists have to go in both Band and Artist tables (Artist is for band members). So there's a lot of sticking data into tables, pulling out the ids, and sticking data into other tables. Once I finished that I started on an even bigger project: Websites. This got really nasty because it not only dealt with at least 4 or 5 different tables, but I wanted a series of checkboxes for the type of content on the sites (bio, discography, etc...) that was pulled dynamically from the database. I also needed to be able to Add, Edit, Delete, Add to Band, Add to Artist, Remove From Artist/Band, etc. Well, last night I got the final pieces of that working, so I finally have website administration completely working! I even set it up to display the websites in an include file I can reuse on the actual band/artist pages, so all I'll have to do at that point is plug it in. Everything else after this should be easy in comparison, since things like Mailing list and FTP site are all just Title, URL, and Description, and I can reuse a lot of the code from websites.
This is the biggest project like this I've ever done by myself from scratch, so it's great experience!:)
So it looks like there's a good chance I'll have this project done before classes start, and be able to actually start updating the site once in a while! I think throwing myself into school over my head really has made me more productive, since I'm getting a lot more done now outside of work while working full time than I ever did before I went back to school.
In other good news, Kitty went to the vet this morning. His eye's much better and he no longer has to walk around with a cone around his head constantly bumping into things! I'm sure he's happy now! He basically had a type of herpes most cats have since birth, and his eye was watering for months and he managed to scratch his face up really badly rubbing at it. It's better now, although it could always come back. Other than Lysine twice a day until August just in case he doesn't need anything else for this:).
