LAMP Tutorial Series originally published on PHPFreaks.com Tue, May 27. 2008
A few years ago I published a 3 part LAMP tutorial series entitled LAMP, MySQL/PHP Database Driven Websites on the well known php community website PHPFreaks.com. This series dealt with a slew of practical issues including how a LAMP server works, relational database design using MySQL, many to many tables, SQL inner and outer joins, practical PHP debugging, php documentation tools, basic PHP classes, css, interactive javascript & DHTML with a chooser widget, php HEREDOC and php basics like how to process forms and utilize GET and POST methods.
The series was fairly successful, (a 4.5 of 5 after hundreds of ratings), many pages of comments and questions, and page views to the 100k's+ although PHPFreaks auditing system was turned off at some point and stopped recording views.
Unfortunately, some years ago PHPFreaks.com suffered some fairly catastrophic issues with its publishing system. There were also some bugs, and the site was exploited with some XSS, and the admins simply decommissioned the majority of the site. My series was part of what disappeared. At that point, a couple of college Computer Science courses on web development had taken the series and integrated it into their curriculum, and the professor of one of these courses had converted it into a Word document, which I was able to download and convert to pdf.
I plan to write a compatible publishing addon for gizmola.com so that I can take the original markup and republish it here, but in the meantime, here is the series in pdf format. The conversion utility they used stripped out the original markup, and page breaks are gone, but the text, source code, and illustrations are all still there.
I also offer all the source code for parts 2 & 3 of the series. I'm not sure what happened to the source for part 1, however, it is all included inline in the tutorial. The LAMP, MySQL/PHP Database Driven Websites series is now available in pdf format. Click here.
The series was fairly successful, (a 4.5 of 5 after hundreds of ratings), many pages of comments and questions, and page views to the 100k's+ although PHPFreaks auditing system was turned off at some point and stopped recording views.
Unfortunately, some years ago PHPFreaks.com suffered some fairly catastrophic issues with its publishing system. There were also some bugs, and the site was exploited with some XSS, and the admins simply decommissioned the majority of the site. My series was part of what disappeared. At that point, a couple of college Computer Science courses on web development had taken the series and integrated it into their curriculum, and the professor of one of these courses had converted it into a Word document, which I was able to download and convert to pdf.
I plan to write a compatible publishing addon for gizmola.com so that I can take the original markup and republish it here, but in the meantime, here is the series in pdf format. The conversion utility they used stripped out the original markup, and page breaks are gone, but the text, source code, and illustrations are all still there.
I also offer all the source code for parts 2 & 3 of the series. I'm not sure what happened to the source for part 1, however, it is all included inline in the tutorial. The LAMP, MySQL/PHP Database Driven Websites series is now available in pdf format. Click here.
Free Apple Mac style Dock with Windows Vista and RocketDock Sun, Feb 10. 2008
One of the distinctive features of Apple computers is a piece of software called "The Dock". The Dock is sort of an always there menu with big icons that spawn your most frequently used programs. Docks also can run small programs or docklets that can do things like display a clock or show you the weather. Docks also can be configured to display running programs that have been minimized in a mini window. You bring a running program to the front, or launch a program by hovering over the dock with your mouse, and clicking on the icon.
I suppose that people who don't know any better might think that this is something you can only get from Apple, but as it turns out there are docks for Linux and Windows. At home I have a Gateway computer running Windows Vista business, and I wanted to add a Dock. After a bit of hunting, I found some recommendations and settled upon RocketDock from Punk Labs. Punk Labs as it turns out is really a couple (he's a programmer, she's a designer) who go by the pseudonyms of PolyVector and Skunkie respectively. The about screen describes RocketDock tongue in cheek as a "peace offering" from the pair of self admitted Apple fans to Windows users everywhere.
The RocketDock website provides links to the various versions and a straightforward online manual. You get most of the features of the Apple Dock program, and it's very easy to work with. Once installed and running, the RocketDock appears at the top of the screen, with a set of default icons. Right click on the RocketDock and you get a menu that lets you adjust Dock settings. There are various themes that will style the look and feel of the RocketDock, and the RocketDock site offers an Extra's link with downloads to styles and docklet programs other people have contributed. While it's just a quibble with this otherwise great program, there's not much in the way of Docklets available, but I found it hard to resist adding on the simple analog style clock.
Continue reading "Free Apple Mac style Dock with Windows Vista and RocketDock" »
West Texas UFO sightings, Cloverfield promotion? Wed, Jan 16. 2008
Only days before the virally marketed JJ Abrams film Cloverfield is due to open, does anyone else find it suspicious that a major news outlet like ABC news would be drumming up a UFO sighting story, based solely on a handful of "eyewitness" testimony? Seriously -- this is 2008? You mean to tell me that not a single person had a digitial camera, video or even a run of the mill cell phone on em? Precedence for this goes back at least 80 years, to the infamous War of the Worlds RKO radio show. What would it take to get such a rumor going? A few people in cahoots, and a gullible local news affiliate? What could possibly explain this making it to the national news?
Chuck Norris Facts.... by Chuck Norris Wed, Dec 5. 2007
The Movie-Gurus.com archive. Tue, Nov 27. 2007
*Update*
Since i wrote this, my hosting account ran out of juice and took to thrashing and locking up on a regular basis due to the number of mysql processes it required and the amount of buffer memory being used. I run this site on a coop server under UML and we have been talking for two years now about moving to a new server with a different virtualization solution, probably OpenVZ. I currently don't want to invest the time and effort I'll need to rebuild and reconfigure the server (no more Gentoo this time, as I don't have the personal bandwidth to stay up with the maintenance and don't use Gentoo at work).
I spoke with David of MG and we agreed to resurrect MG officially, since he still owns the domain and gets a fair amount of traffic to the review urls, which redirect to his community site Movieloons.com. I'm hopeful we'll get there soon, but for reasons I'll keep to myself, there can be no movement on this project until David sorts an issue with his hosting company.
Movie-Gurus.com went down for the count when the hosting company wiped the site. As we'd lost around a months worth of reviews, I didn't feel like resurrecting it at the time and starting fresh. Then I started thinking about the 1500+ reviews in the database, and all the time and effort that went into the site, so I decided to see if I could resurrect it from backups. I quietly put it back up, and left a little message at the forum run by the MG originator, but that generated no interest, so I left it up and largely forgot about it. Only one little problem there --- search bots found it, and what did they want? They wanted pictures! Mostly pictures of actresses! So I suppose that MG lives again, even if for now it's only as a shadow of its former self, visited by people who are only interested in a small picture. You can find the site for now at Site taken down.
Since i wrote this, my hosting account ran out of juice and took to thrashing and locking up on a regular basis due to the number of mysql processes it required and the amount of buffer memory being used. I run this site on a coop server under UML and we have been talking for two years now about moving to a new server with a different virtualization solution, probably OpenVZ. I currently don't want to invest the time and effort I'll need to rebuild and reconfigure the server (no more Gentoo this time, as I don't have the personal bandwidth to stay up with the maintenance and don't use Gentoo at work).
I spoke with David of MG and we agreed to resurrect MG officially, since he still owns the domain and gets a fair amount of traffic to the review urls, which redirect to his community site Movieloons.com. I'm hopeful we'll get there soon, but for reasons I'll keep to myself, there can be no movement on this project until David sorts an issue with his hosting company.
Movie-Gurus.com went down for the count when the hosting company wiped the site. As we'd lost around a months worth of reviews, I didn't feel like resurrecting it at the time and starting fresh. Then I started thinking about the 1500+ reviews in the database, and all the time and effort that went into the site, so I decided to see if I could resurrect it from backups. I quietly put it back up, and left a little message at the forum run by the MG originator, but that generated no interest, so I left it up and largely forgot about it. Only one little problem there --- search bots found it, and what did they want? They wanted pictures! Mostly pictures of actresses! So I suppose that MG lives again, even if for now it's only as a shadow of its former self, visited by people who are only interested in a small picture. You can find the site for now at Site taken down.
Fun with Windows Vista and the Maxtor Shared Storage Drive Fri, Jul 27. 2007
I have a pair of 200 gigabyte Maxtor Shared Storage drives -- which are relatively inexpensive network storage drives that integrate with windows client machines. They come with an ethernet port you use to connect to a switch or hub on your home LAN, and will plug and play by negotiating an IP via DHCP. Maxtor (now owned by Seagate) provided a windows client that helps with finding and setting up the drives, since they advertise themselves as Workgroup peers that can be shared. I use the drives to store things like digital camera pictures and DVD's I've ripped in order to play them through my Tivo Series 2. They also come with some software that makes it easy to backup the My Documents area of our windows machines.With Windows XP, the Shared Storage drives worked fairly reliably, but after I upgraded my Gateway desktop to Vista Business edition, I found myself unable to connect to the drives I'd mapped to it. Trying to mount them manually, I'd receive a login dialog. The name and password I use from my XP Pro based computer works fine, but on Vista the drive would reject the same credentials.
It took me a while to sit down and dig into the issue, and my first guess was that firmware might fix the problem. The Shared Storage drive predates Vista, so it wasn't a total surprise to me that authentication didn't work. The bundled web interface allows you to login with a browser, and administer the drive, setting up user accounts and mounting and unmounting USB devices you can connect to either of 2 provided USB ports. We have a printer attached.
After logging into the webserver, it displays a menu that includes the Firmware version -- mine was 1.2. A quick search of the Seagate site, and I found Maxtor offering version 2.6.2 firmware! The Advanced Settings | System Maintenance menu | System update menu provided a simple upload and update process that was completed in about 2 minutes. Despite the major point upgrade to the drive bios, I still was unable to login to the drive from Vista. What made this even more confusing is that I somehow had been able to successfully find the unit on the Windows network, authenticate to it and map a drive when I had first done the Vista upgrade. A bit of googling on the problem, and I discovered something surprising about the Maxtor unit I'd never suspected -- it is actually a linux box....
Continue reading "Fun with Windows Vista and the Maxtor Shared Storage Drive" »
« previous page
(Page 1 of 13, totaling 77 entries)
next page »



















