The current website includes a preschool directory at:
[login to view URL]
Each preschool is categorized by state, and city.
The site currently has thousands of static pages:
We would like to turn that into a dynamic, database driven page running off of 1-3 php pages and add it to Wordpress where the rest of the site is currently being
Another essential aspect of the program is maintaining the current url path to each page, for seo and page ranking purposes. I believe this will need to be accomplished using server configurations to redirect/rename the url pages
Here are the 3 main levels of the current site:
• -the main index page by state: [login to view URL]
• -Cities in a state (Alabama): [login to view URL] You’ll notice that the url name is the 2 letter state abbreviation
• -The preschool list for a city (Abbeville, Alabama): [login to view URL] You’ll notice that the url is the 2 letter state abbreviation, and ‘_’ and the city name
The php pages need to include the new design template that is visible on the site: [login to view URL]
We also need an admin page where we can search for preschools on all of the database criteria, and add, edit, or delete entries.
Here are the columns we will need in the database:
id – primary key
url – the url that will show on site, must be exactly the same as on the current site
name – the preschool name
address – the preschool street address
city – the preschool city
state – the preshool’s state
zip – the preschool’s zip code (include the first 5 digits, a dash, and the last 4 digits)?
phone – the preschool’s phone number
added – the date the entry was added to our database
lastUpdate – the date of the last update to info for this entry
website – the url of the website for the preschool, if they have one
isactive – Boolean indicating weather the listing shows up on the live site
hasBacklink – Boolean, weather they have linked back to our site
backlink – url of the page on their site that has a link to us
Deliverables:
1-3 php pages
Mysql database tables
Server configurations for url mapping/redirecting to maintain current urls
I have 7+ years of hands-on PHP + MySQL and other programming experience, and Web scraping happens to be my specialty. Please see my personal message - I may be able to do a free demo to get us started.