Auto Generation of html pages using PHP and information from a database

$100-500 USD

Annulleret

Slået op

over 13 år siden

$100-500 USD

Betales ved levering

I wish to have html web-pages auto-created using a php system . The system will use a design template and information contained in a MySQL database to generate the html pages. A [login to view URL] file is also required to be generated ## Deliverables **Summary (please remove XXX from the URLS mentioned below!)** I am a wedding photographer who photographs weddings at many venues. I wish to allow visitors to my site to view details of wedding venues I am familiar with, and view pictures from each wedding I shoot. Currently when I photograph a wedding I upload all the pictures to a gallery (using adobe lightroom) and create a blog entry on my blog showing a few example pictures. I want visitors to my site to be able to click on a wedding venue link and then not only see details of the venue but also be given the option of clicking links that direct them to image galleries and blog entries relating to that venue. To create these pages and keep them updated would be very time-consuming - so I require an automated system where web-pages are automatically generated using information within a database. The database is a 'parent-child' transactional database where each venue will have a number of weddings associated with it. This system is to create a series of html web pages to help with SEO on the website [login to view URL] similar in style to [login to view URL](the map of the uk to select the venues is not required) This 'system' is to be placed in a sub-folder of the main site (/venues). Using the information in the database a series of .html pages are to be generated on the server when the 'generate pages' option on the admin menu is selected. The main 'template' design of the web-pages is to be editable by me so I am able to add menu options, extra text ect, as and when required. My server is a Linux/Apcahe/MySql/PHP installation. **Website structure** The 'starting' page ([login to view URL]) will show a list of wedding venues alphabetically sorted on the Venue Description field along with the venue thumbnail image (and 'alt' tag from the venues table), link to the venue and some simple text (as per [login to view URL]) The venue title, alt tag and thumbnail picture are 'pulled' from information in the venues table of the database. When a venue is selected, that venues web page is shown (eample at [login to view URL]) this page will have been generated when 'generate pages' has been run from the admin paneland will have relevant meta tag and alt tag details pulled from the venues table of the database. I would like the top left of the page to not only show the link to the venues web-site URL and some SEO text (as is done on the ryanXXX-browne site ) but also links to the most recent 3 wedding galleries and blog postings relating to the venue (the URLS to be pulled from the weddings table of the database) The bottom left section of the page to show 'other venues in this region' with links to the pages that have been generated from other venues in the area (eg Cheshire, Manchester, Lancashire etc) as is the case on the ryanXXX-browne site. Whilst I would like the site to operate in a similar way to [login to view URL] I would not like it to look too visually similar as to contravene their copyright on their design, and as previously mentioned, would like the addition of links to my image galleries and the auto-creation of a [login to view URL] file. **Database Structure :** **Venues** Table (initially will contain about 60 venues, growing to a max of about 150) **Venue Ref**: Numeric, 5 digits, unique, indexed - The unique reference that relates to each venue, generated by the software. **Area** : Text (to be selected from a drop down menu with options - Cheshire, Manchester, Lancashire, Merseyside, The Wirral, North Wales, The Lake District), indexed **Venue Description** : Text, 60 characters, indexed - The description/title of the venue **Title Meta Tag** : Text, 80 characters - The 'title' meta tag to be used in the <head> section of web pages **Description Meta Tag** : Text, 80 characters - The 'description' meta tag to be used in the <head> section of web pages **Keywords Meta Tag** : Text, 120 characters - The 'keywords' meta tag to be used in the <head> section of web pages **Alt tags** : Text, 80 characters - The content of all image 'alt' tages be used on the page **Link** : Text, 80 characters - The URL of the venue **Picture URL** : Text, 80 characters - The URL of the wedding venue picture (600 x 400px) **Thumb URL** : Text, 80 characters - The URL of the wedding venue Thumbnail (300 x 200px) **Slug URL** : The URL of the page generated to show to the viewer (eg if the venue is Allerton Castle, the slug would be something like [login to view URL]) **Weddings Table** - Transaction table (Initiall will contain about 50 weddings, growing to a max of about 400) **Wedding Ref** : Numeric 5 digits, unique, indexed - The unique reference that relates to each wedding. **Venue Ref** : 5 characters, indexed - Pulled from Venues table to indentify the venue of the wedding **Pictures URL** : 80 characters - the URL of the wedding photographs **Blog URL** : 80 characters - the URL of the blog posting relating to the wedding ** Admin system** Menu Options **1 - Add new Wedding Venue** - Allows the creation of a new venue **2 - Edit Wedding Venue Details** - Change details of a venue **3 - Delete Wedding Venue** - Delete Venue and all the transactions relating to it **4 - Add new wedding** - Add new record in Weddings Table **5 - Edit Wedding** - Amend record in Weddings Table **6 - Delete Wedding** - Delete Wedding in Weddings Table **7 - Generate pages** - Runs through all venues and Weddings and generates the html web-pages on the server. **8 - Generate [login to view URL]** - Generate a [login to view URL] file of the pages generated so I can copy/paste the details into my existing sitemap file. If you need any more information just ask!

Auto Generation of html pages using PHP and information from a database

$100-500 USD

$100-500 USD

Om projektet

Leder du efter muligheder for at tjene penge?

Fordele ved budafgivning på Freelancer

Om klienten

Klientverificering

Andre jobs fra denne klient

Lignende jobs