Home arrow MySQL arrow The Perfect Job (part 1)

The Perfect Job (part 1)

Recruitment - the art of matching qualified applications to openpositions within an organization - is one of the most challenging tasks forany Human Resources department. However, powerful open-source tools likePHP and mySQL have made the process simpler, more efficient and moreeconomical than at any time in the past. This case study demonstrates how,by building a complete job listing and resume management system fromscratch.

  1. The Perfect Job (part 1)
  2. An Ideal World
  3. Entry Point
  4. Going To The Database
  5. The Five Rs
  6. Lucky Thirteen
  7. Building The Foundation
  8. The Devil Is In The Details
  9. Applying Yourself
  10. Testing Times
  11. Filing It All Away
By: icarus, (c) Melonfire
Rating: starstarstarstarstar / 4
June 28, 2001

print this article


It might not seem all that hard, but manning an organization's Human Resources division is actually a pretty difficult task. Sure, HR guys and gals don't have to worry about memory leaks, garbage collection or mangled code; however, their problems are often just as compelling and challenging as those of any software programmer or interface designer.

One of the most challenging problems for any Human Resources department is recruitment, the art of matching potential employees with vacancies within the organization. The process is complex: place an advertisement, wait for resumes to roll in, and then begin the arduous task of sifting through them in search of potential recruits. This is usually followed by interviews and reference checks of potential candidates, and perhaps a job offer.

Now, back before the Web was a buzzword, the only way to let potential employees know about a job was via advertisements, either in a newspaper or journal, or on television. And once responses started rolling in, HR would have the unenviable task of wading through mounds of paper to find the perfect match for the open position. Along the way, you could almost always expect to misplace or destroy a few of those resumes, sustain multiple paper cuts, and say goodbye to any hope you might have had of a social life.

However, with everyone and their deaf grandma now connected to the Web, reaching out to potential candidates has become much easier. A company can now either advertise vacancies through online employment agencies, or place job listings on their own Web site. Since online employment agencies aren't in the biz out of the goodness of their hearts, the latter option is usually the one smaller companies prefer, if only for economical reasons.

Of course, putting up jobs on a Web site is just the tip of the iceberg. Once those resumes begin coming in, there's still the task of organizing them into categories, wading through all the data to short-list candidates for interviews, and filing rejected applications for future use. Oh, yes...and just to make things interesting, there's usually a clock ticking away in the background as well.

With the help of powerful open-source tools like PHP and mySQL, the process can be simplified considerably. And over the course of this article, I'm going to demonstrate how, by building a job listing system suitable for a small- or medium-sized business.

The goal here is two-fold: to introduce novice and intermediate programmers to the process of designing and implementing a Web-based application; and to offer HR managers and other interested folk a possible solution to their woes.


This article copyright Melonfire 2001. All rights reserved.

>>> More MySQL Articles          >>> More By icarus, (c) Melonfire

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort


- Oracle Unveils MySQL 5.6
- MySQL Vulnerabilities Threaten Databases
- MySQL Cloud Options Expand with Google Cloud...
- MySQL 5.6 Prepped to Handle Demanding Web Use
- ScaleBase Service Virtualizes MySQL Databases
- Oracle Unveils MySQL Conversion Tools
- Akiban Opens Database Software for MySQL Use...
- Oracle Fixes MySQL Bug
- MySQL Databases Vulnerable to Password Hack
- MySQL: Overview of the ALTER TABLE Statement
- MySQL: How to Use the GRANT Statement
- MySQL: Creating, Listing, and Removing Datab...
- MySQL: Create, Show, and Describe Database T...
- MySQL Data and Table Types
- McAfee Releases Audit Plugin for MySQL Users

Developer Shed Affiliates


Dev Shed Tutorial Topics: