|
|
|
PHP/MySQL Enhancement to Directory Listing script
posted on 27/5/2007PHP/MySQL Enhancement to Directory Listing script
I have existing system that returns suppliers details based on number of miles distance when a user enters their UK postcode into a web form. It simply displays results in order of closest first (i.e. ‘find my nearest’ type application). It’s a PHP/MySql simple directory system.
However the system has no proper admin interface, no registration page for suppliers to enter their own data, and the look of the published results is very basic.
This piece of work will extend the system to provide a secure admin back end, a robust front end for suppliers, and a nice looking output page for users. Details follow below.
Admin
Secure password entry
Add/Edit/Delete/View suppliers
Deactivate suppliers (i.e. records are only displayed for ‘active’ suppliers)
Change which fields to display for free and premium listing (the idea is that fields with a free listing display only basic info. but suppliers marked as premium will have more info displayed.
Change how premium displays are shown i.e. border and colour, background colour, supplier logo, etc. so these are highlighted
Premium entry payment plan – cost per month and per annum, PayPal link so it updates the supplier as paid and when next payment due
Alert – alerts supplier and admin near to when payment due. Deactivates account when payment past monthly or yearly deadline. Sends email to supplier.
Email –send email to all suppliers, or just free or premium suppliers. Welcome email, alert email when payment due as above.
Variables that need to be set (don’t need a front end for these – a config file would be fine). I’m sure there will be others, but I’d like to be able to change things easily rather than having to delve into code.
paypal id
address_for_payments (if they want to pay by cheque)
premium_monthly_charge
premium_yearly_charge
premium_border-size
premium_border_colour
premium_background_colour
premium_fields_to_display
Supplier
Register, forgot password, change own entry, pay for premium entry, delete entry, deactivate entry. Add a logo and service description if they are premium users.
Upgrade from free to premium.
Pay for a premium listing by PayPal or cheque (if cheques the Admin simply updates the supplier record when paid)
User
Search for suppliers near them by entering their postcode and number of miles max.
Ability to select suppliers to contact via email (email address not shown to prevent spamming, therefore a form may need to be created which allows email to be entered. Another variable would be ‘number_email_contacts_allowed’ to prevent a user from selecting all suppliers and mass emailing them (unless there is another approach to this ?)
Visual
Very simple front end with one box to type in own postcode and max. miles, and then the relevant records display below the box in a very attractive layout with contemporary icons. A sort of simple Google like front end. Premium listings will be highlighted as above.
Notes
Needs to be done in PHP/MySQL
I will supply the core code for the postcode searching
As this is a pretty mainstream application, I would be happy if someone knew of a directory program that they could adapt or enhance to do the above, as this would save on the mainstream code that has been done a million times elsewhere.
I’d like someone who can prove their PHP credentials and will be around should support and enhancements be needed (I’m sure they will!)
We are no longer accepting applications for this project.