Directory PHP Programming Project

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