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

Cancelado Publicado Nov 16, 2010 Pagado a la entrega
Cancelado Pagado a la entrega

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 [url removed, login to view] 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 [url removed, login to view] similar in style to [url removed, login to view](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 ([url removed, login to view]) 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 [url removed, login to view])

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 [url removed, login to view]) 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 [url removed, login to view] 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 [url removed, login to view] 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 [url removed, login to view])

**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 [url removed, login to view]** - Generate a [url removed, login to view] 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!

PHP

Nº del proyecto: #3858225

Sobre el proyecto

6 propuestas Proyecto remoto Activo Jan 3, 2011

6 freelancers están ofertando un promedio de $426 por este trabajo

NetzPro

See private message.

$1360 USD en 21 días
(388 comentarios)
8.7
antonyngo

See private message.

$297.5 USD en 21 días
(13 comentarios)
5.6
readyfacts

See private message.

$85 USD en 21 días
(38 comentarios)
4.4
riaexpertvw

See private message.

$127.5 USD en 21 días
(22 comentarios)
3.4
erpoojasharma

See private message.

$297.5 USD en 21 días
(1 comentario)
0.0
idiotsvw

See private message.

$391 USD en 21 días
(2 comentarios)
0.0