Program is live and online at
http://www.kbelectronics.com

Screenshots of portions of the Distributor/Rep Search Program administration are available here:

Main Menu: choose which admin area to enter: database (search), user access (file protection) or executive admin.

Database administration: main page, add record, search listing, update record.

Executive admin.

Screenshots of portions of the Technical Notes User Registration/Log-in Program administration are available here:

User Administration: the part of the administration section that allows the admin to add a new user, view a list of users (to update or delete), and view the visit statistics of each user.

Database Export: the control panel also includes a function to export the current database in Excel format.

User Registration: the front end allows any user to register or log-in to the password protected area.

 

KB Electronics, Inc.
Distributor and Representative Locator
Password Protected Technical Notes Download Section

KB Electronics is a manufacturer of Motor Drives, Automation Controls & Fan Speed Controls.

Problem:

1. Customers are located globally requiring 24/7 customer service and assistance locating a Distributor and a KB representative.
2. The list is updated frequently.
3. Customers require copies of technical notes that are updated frequently.
4. Technical notes are "somewhat" proprietary and KB needs to track who is downloading them.

Solution:

For KB Electronics to remain competitive in their industry they needed to provide an on-line solution to meet their customer's needs WHILE maintaing in-house control to update the program and database contents on the fly.

We created a program using PHP and MySql technology that allows users to search for a either a Distributor or Representative either by name or geographically.

The program also allows the user to optionally locate "stocking" distributors only.

We then created an additional User Registration/Log-in program that integrates the 2 programs in the administration section.

Users must register to gain access to the technical notes. The user's password is generated by the program and e-mailed to the user to ensure the user has registered with a valid e-mail address.

This program also includes a comprehensive, password protected administration area that allows KB to perform the following functions:

1. Add, modify or delete any distributors or representatives records in the database.
2. Export a copy of the MySql database in Excel format.
3. Ability to add/modify/delete or suspend users access.
4. View access log files containing user name, date and files accessed.
 
Copyright © 2002 - 2008, eSpyderWeb Design Group, Inc. All Rights Reserved. TERMS OF SERVICE

Tel: (011) 954.474.9279, Toll Free: (US only) 877.389.4085
Fax: (011) 954.423.6975

11861 SW 9th Manor
Davie, FL 33325 USA