We specialize in PHP programming and MySQL databases. We write custom PHP programs and customize PHP/MySQL-based packages like open source software products: WordPress® blogs, osCommerce (open source eCommerce solution), and OpenX, formerly known as phpAdsNew (open source Ad Management solution). We have interfaced osCommerce and custom-developed order forms with payment gateways like AuthorizeNet®.
Sampling of Custom PHP Programming
* Blog Preview Window
* Dynamic Selection Fields
* Content Maintenance Module
* PHP Dynamic Site Plan
* Search Within Radius
Blog Preview Window
Blog Preview WindowChris Ploof Studio of Pawtucket RI creates custom, one-of-a-kind jewelry for clients worldwide.
hired Adventures Online to install and customize a blog for his website. At the same time, he wanted to add a blog preview window on the Home page to let people know that he is blogging about all the exciting news about his business.
Solution
Adventures Online installed and customized a WordPress® blog, then wrote a custom PHP program that reads the latest post in the blog and displays the first 25 words of the post in the preview window on the Home page (circled, left). Included in the blog preview is a link to the full post. When the link is clicked, the blog displays with the full post at the top
Dynamic Selection Fields
Vehicle Selection FormThe Lube Dudes of Marlborough MA provides on-site vehicle maintenance to fleets and corporate employees throughout Eastern Massachusetts.
The Lube Dudes hired Adventures Online to design and develop a website for them. In addition to the brochure-type portion of the website, The Lube Dudes wanted a Customers-Only section where new customers could sign up online, create a personal profile and build a portfolio of their verhicles, and, existing customers could login, manage their vehicle portfolio and schedule maintenance for their vehicles.
The Lube Dudes had a special requirement for the Add a Vehicle process, and that was that the choices displayed in the Year, Make, and Model selection pull-down lists be “valid”choices; meaning that the list of Years could only include the list of years that the The Lube Dudes would service, and the list of Makes could only include the Makes that existed in the Year the customer had just selected, and that the list of Models could only include models available in the year:make combination that the customer had just selected. Because each customer would choose different year-make-model combinations and those combination were impossible to predict, the selection fields needed to be dynamically-generated based on the current customer’s selections.
Solution
When the website was launched, there were nearly 12,000 Year-Make-Model combinations that The Lube Dudes were interested in servicing.
1. A custom PHP program was written to insert the initial ~12,000 year-make-model combinations into the online database.
2. An online module was created so that The Lube Dudes could maintain (add, change and delete) year-make-model combinations.
3. Custom PHP programs were written to extract Year-Make-Model combinations to text files. (The text files are used to load the Year, Make, Model selection fields.)
4. JavaScript programs were written to determine which text files to use to load the correct selections in the Year, Make and Model fields.
Adventures Online used a combination of PHP and JavaScript to develop the programming and a MySQL database to store the data.
Custom Content Maintenance Module
PHP programming example Hudson MAReal estate investment manager, Calare Properties of Hudson MA hired Adventures Online to redesign its website. In addition to the redesign, Calare Properties wanted to add functionality – to display its portfolio of properties. They also wanted the ability for staff to maintain the portfolio and have the updates be immediately visible on the website.
Solution
Adventures Online redesigned the website and added menu items for viewing the portfolio of properties. Display pages were created for each individual property, each state and the United States (shown above). The content on those pages changes dynamically according to what the staff enters in the online database. An online maintenance module was created to enable staff to keep the list of properties and descriptions of individual properties up to date. The updates (adds, deletes, changes) are immediately visible on the website.
PHP programs were used to develop the custom content maintenance module. JavaScript was used to validate the information on the data entry forms in the maintenance module, and, a MySQL database stores the portfolio and information about the individual properties. View the portfolio of properties. [US Map creation by MannisMacNeil Design Group.]
PHP Radius Search
Website for Non-Profit AssociationThe American Society of Home Inspectors, New England Chapter (ASHINE), hired Adventures Online to redesign its website. In addition to the website redesign, the association wanted to add the ability for visitors to find home inspectors (ASHI New England members) in their own geographical area.
Business Requirements
1. Allow visitors to search by three different criteria on the Home page; by zip code, city & state, and state alone
2. Include home inspectors within a 10-mile radius of the zip code or city-state in the search results.
3. Include all home inspectors in the state in the search results of a state search.
4. Provide an Advanced Search page on which visitors are able to search by inspector’s business name or last name, and can change the radius (number of miles to include) in order to manipulate the search results.
Solution
A MySQL database was created to store ASHINE’s membership information. Multiple custom PHP programs were written to interface ASHINE’s membership database with a commercially-available US zip code database in order to return the correct results. Try out the Advanced Search!
PHP Dynamic Site Plan
PHP Dynamic Site PlanSteve McKenna & The Home Advantage Team, Arlington MA, the exclusive real estate sales team for Prescott Farms in Bedford MA, hired Adventures Online to bring life to the online Prescott Farms site plan. Although the plan is a simple drawing, there are highly complex, multi-tiered PHP programs running behind the scenes that make the site plan respond differently depending on the phase of the build, the clicking actions of the current viewer and the status of the lot that is clicked.
Business Requirements
1. Website visitors should be able to:
* Quickly understand which lots are available with just a glance at the plan
* Click on each lot and learn the details about it, like the size of the lot, the home styles that can be built on it and the asking price for each home style
* Click on each home style to see the details of the home style, like see a rendering of the floor plan, a written description of the style and the parameters for customization.
2. Staff should be able to:
* Change the status of a lot at any time
* Update information about each lot – like the size and the styles of homes that can be built on the lot
* Open and close phases of the build
* Add and remove lots from phases
3. Updates should be immediately visible on the website.
Solution
1. Assign colors to the different statuses that a lot can have. Add a legend to the site plan. *
2. Create four graphics for each lot, one in each color (status) . *
3. Create an online MySQL database to store the status and other information about each lot
4. Write custom spreadsheet-like PHP programs to enable staff to update (add, change, delete) the status of the lots, the detailed information about each lot, the phase of the build, and the lots included in each phase.
5. Write JavaScript scripts and PHP programs to determine which colored graphic of a lot to display on the site plan
6. Write custom PHP programs to dynamically display a lot’s details (lot size, house styles available for this lot, and pricing for each house style on the lot) -depending on its status
7. Write custom PHP programs to dynamically display information about each house style (like a rendering of the floor plan, a written description of the style, and customization parameters).
This is an ideal application for high-end real estate agents with exclusive agreements on new home developments!
* Graphic design by Circle Graphics, Hingham MA
[In February 2009 all the lots were sold and the website was removed.]
Other PHP Programming Efforts
Personal Best Personal Training, Marlborough MA
Besides being an attractive and informative website, this website has a very robust backend that helps the owner communicate with her clients and manage her business. There is a password-protected Administration Module that the owner uses to monitor clients’ progress, manage health forms processing, and produce reports. Also in the backend, there is a password-protected Members-Only section where members enter food and exercise logs, have access to special fitness articles and the online encyclopedia of exercises, download fitness programs, enter the comprehensive intake forms, and more.
Over 30 PHP programs and two MySQL databases were used to create the Adminsitrative and Members-Only modules.
Regional Chamber of Commerce, Marlborough MA
The Chamber wanted to display the membership list in small, discrete packages. Adventures Online used PHP to interface with a MySQL database to group, retrieve and display information about Chamber members. Try it out!
In the backend, there is a Maintenance Module which the Chamber uses to maintain its Calendars of Events and lists of Directors and Officers. As soon as updates are made to either of these, they are visible on the website, and, since the maintenance module is at the website, staff can make updates any time they want from wherever they are. The Calendars and lists of Directors and Officers are dynamically generated from the MySQL database each time they are viewed.
PHP Online Schedule Maintenance
Turfbuilder Marketing hired Adventures Online to work with Marita Froimson Design to bring life to a website re-design project for its client WAC Consulting in Northborough MA.
No comments:
Post a Comment