I need someone to help me design the php/mysql code to fit this site: [login to view URL] I have the layout already designed, but I need help getting the site to work, along with an admin panel where I can administer all the necessary changes, and a user admin panel so users can login and update profile information. I also need the ability to install this site on another domain name, so site information should be pulled from a config file, not hard coded on the site.
The site is pretty straight forward, it is a business directory, each company should have these available fields....(I have a zipcode database which will be cross referenced to help determine the radius for the search...
## Deliverables
I need someone to help me design the php/mysql code to fit this site: [login to view URL] I have the layout already designed, but I need help getting the site to work, along with an admin panel where I can administer all the necessary changes, and a user admin panel so users can login and update profile information. I also need the ability to install this site on another domain name, so site information should be pulled from a config file, not hard coded on the site.
The site is pretty straight forward, it is a business directory, each company should have these available fields....(I have a zipcode database which will be cross referenced to help determine the radius for the search...
****Company Database*******
company_id
company_name
street_address
city
state
zip
phone_number
fax_number
web_address
email_address
county
category
sub_category1
sub_category2
sub_category3
sub_category4
premium_listing
display_package
keyword
description
display_image_300x250
display_image_468x60
*****************************
There are 2 types of busiensses, premium listings and regular listings. Regular listings will show up below the premium or featured listings in regular text, where the premium listings will have a special look, which i will also provide.
Only featured listings will have sub_categories, premium listing as (Y), a keyword, and a description, which the user will be able to edit via the user_admin panel.
When you are on a general page, there is a place that says "Featured Listings", I want 20 random featured listings to appear there using the keyword as the anchor text, and the web_address as the url (opening in a new window). (This should be done using PHP, so the text can appear as a static text).....When you are on specific category or subcategory pages, instead of "Featured Listing", it should say "Featured Category/Subcategory Listings"....
-Search By Cateogry Pages-
I want all the Subcategories for each main category to also appear.
Should say "Featured "Category" Listings", the featured listing should have 20 random featured listings where the category is the same as the page you're on....
I should have the ability to change the title and description on this and all pages
When You click on a category URL should be: [login to view URL]
-State and City specific Cateogry Pages-
When it shows all the states, that has that category, "Choose a state to find a local "Category_Name"", url should be: [login to view URL]
The featured category listings tab, should have up to 20 random featured companies from that category in that state(only)...same rules apply as you search down to the city....url for the city pages should be: [login to view URL]
-Search By State Pages-
All the states should appear, when you click the state url should be: [login to view URL]
Featured Listings should read, featured listings in $state, and a random 20 featured listings should appear within the state.
-Advertise Page-
The advertise page will just be a php page, which i will create, then I need a button on that page, along with 3 radio buttons, one says regular listing (FREE), the Featured Listing (i will determine price and enter in the admin panel), and Premium + Display Listin (I will determine the price in the admin panel)
After chosing an option and clicking the button, the user will end up on the appropriate signup page...
...Regular Listing Page...where you will create a form with all of the fields displayed above, including a username and password field...these are the required fields:
company_name
street_address
city
state
zip
category
email
username
password
when the user clicks submit it should activate their account automatically since it is a free listing.....
...Featured Listing Page....where you will create a form with all the above company fields displayed above, including a username and password field...these are the required fields:
company_name
street_address
city
state
zip
category
email
username
password
keyword
description
if the user leaves the keyword field blank, the company name shold be entered in that field.
when the user clicks submit it should take them to a paypal or 2checkout payment page (whichever you prefer to work with), where they make payment via paypal/2checkout and upon payment and confirmation, the account should be activated, if they don't pay and confirmation code doesn't go through, then they should not have their account activated, if they skip the payment section, they can login, and instead of seeing their updateable fields, it should have a payment option.
...Display Listing Page....this should be the same as the featured listing page, except that their should be two upload fields where the user would be able to upload 2 different images, a 300x250 jpg/gif and a 468x60 jpg/gif
(I need to be able to install this on multiple directories, so the sitename should be able to be changed in the admin panel, so i can install on different sitenames if necessary..)
(All Payments are recurring monthly payments)......