Work Based Project - Town Council by Kate Slaney

2013

Tywyn Town Council Work Based Project To create a website for Tywyn Town Council based in Midwest Wales. The council currently do not have a website, or anything available online with information about themselves or possible ways to contact them.

[Type text]

Kathryn Slaney Glyndwr University â&#x20AC;&#x201C; Grwp Llandrillo Menai 2013

Tywyn Town Council January 1, 2013

Contents The Proposal.................................................................................................................................... 3 Introduction .................................................................................................................................... 3 Career Plan ...................................................................................................................................... 3

Skills Required ................................................................................................................. 3 Current Skills ................................................................................................................... 3 Skills Development and Project Benefits ........................................................................ 4 Outline of Proposal ......................................................................................................... 4 Compatibility with my Career Plan ................................................................................. 5 Learning Outcomes ......................................................................................................... 5 Resources ........................................................................................................................................ 6

Software .......................................................................................................................... 6 Hardware......................................................................................................................... 6 People ............................................................................................................................. 6 Content............................................................................................................................ 6 Review Points .................................................................................................................. 6 Aims and Objectives ........................................................................................................................ 7 Action Plan ...................................................................................................................................... 8

Project Tools.................................................................................................................... 8 The Planning Stage .......................................................................................................... 8 The Design Stage ............................................................................................................. 9 The Implementation Stage .............................................................................................. 9 Testing Stage ................................................................................................................... 9 Work Journal ................................................................................................................................. 10

Planning & Research â&#x20AC;&#x201C; Comparing Websites ................................................................ 10 Comparing Websites ..................................................................................................... 13 Meeting the Client ........................................................................................................ 14 The Meetings......................................................................................................................... 15

Research ........................................................................................................................ 16 Domain Names ...................................................................................................................... 16 Research of .gov.uk ............................................................................................................... 16 Hosting and Complete Packages ........................................................................................... 17

Kathryn Slaney

Tywyn Town Council January 1, 2013

Domain Name Price Comparison .................................................................................. 18 Hosting Price Comparison ............................................................................................. 19 Creating the Website .................................................................................................... 20 The Homepage ...................................................................................................................... 21 Town History ......................................................................................................................... 23 Town Councillors ................................................................................................................... 24 Council Minutes .................................................................................................................... 25 Policies & Procedures............................................................................................................ 26 Ynysmaengwyn Trust ............................................................................................................ 27 Events .................................................................................................................................... 28 Local Clubs & Services ........................................................................................................... 29 Contact Us ............................................................................................................................. 30 Administration Login ............................................................................................................. 31 Welsh and English ................................................................................................................. 33 Programming the CMS and MySQL ....................................................................................... 33 Uploading to the Server ........................................................................................................ 35 Overview ............................................................................................................................... 35 Features................................................................................................................................. 35

Testing ........................................................................................................................... 37 Conclusion ..................................................................................................................... 40 The Client .............................................................................................................................. 40 Personal Outcomes ............................................................................................................... 40

Websites Viewed........................................................................................................... 41 Appendices .................................................................................................................................... 43

Kathryn Slaney

Tywyn Town Council January 1, 2013

The Proposal Introduction My work based project is to create a website for Tywyn Town Council, based in Midwest Wales. The council currently do not have a website, or anything available online with information about themselves or possible ways to contact them, at the moment the only way to find information on the council is to head to their office on Tywyn High Street or to call them.

Career Plan I would like to become a website designer on the completion of this course, either freelance or within a company.

Skills Required To become a website designer to a professional standard I will need skills in:         

XHTML/CSS Design Sense JavaScript and Ajax PHP, ASP, Java, Perl or C++ MySQL database Flash SEO Knowledge Web Server Administration Project Management

Current Skills I feel that the skills I currently have which will help me progress towards my career choice are my skills in Project Management, and Design sense – I feel these are my strongest skills at the moment, as I have had to do a lot of project management, in this course and also previous courses, and have also had to use my design skills. I have however been using XHTML and CSS throughout the course so far. I do need to improve my programming skills, and SEO knowledge, as at the moment I only have the knowledge and skills I have picked up from doing this course. From the first year of my course I gained skills in creating suitable websites that met the usability and validation criteria, to make sure that websites will be accessible for all users, we looked in to colour schemes, acceptable fonts and layouts.

Kathryn Slaney

Tywyn Town Council January 1, 2013

Skills Development and Project Benefits I need to further develop all my current skills in web design, as at the moment they aren’t at a level that could help me become a professional website designer. This work based project for Tywyn Town Council helps to develop my skills further as I will have do a lot of programming, and my knowledge of XHTML and CSS will increase as I will be designing a whole website from scratch, I will also gain new skills in MySQL databases, as I have never used these before, and will hopefully be programming my own database to link to the website as well as creating a content management system for the client. My current skills in programming aren’t at a level where I feel confident enough to program a database without some supervision, so on conclusion of this project; I am hoping that my confidence in programming will have increased to a suitable level, as well as my confidence in databases. Also by doing this work based project I will be able to extend my current knowledge of Search Engine Optimisation (SEO) as I will have to put this in to practise.

Outline of Proposal Tywyn Town Council has asked me to create a website that is:     

Simple for the public to use Simple for the client to update and maintain A website that has the ability to store agendas/minutes and council news etc. A website that is also mobile compatible Bilingual throughout

The council do not currently have a website, so as the client they have asked for a simple but professional looking website that meets all their needs, but is easy to use as they are not as computer literate as the younger generation. Having looked at what the client requires, I have yet to sit down with the client to discuss their needs further but I can see at the moment that they require: 



A content management system – I have had a look at open source software available online, but have decided that I will be programming the content management so I will using Visual Studio and programming in C#. I will be creating a database using Access, as the client would like to be able to store PDF documents and images online in order for the users to be able to access information, agendas and minutes online. Mobile compatibility – I will need to ensure that throughout the project that the content is mobile friendly, I can use such tools as Google’s service ‘Howtogomo’ where I can find tutorials and an emulator to check that the website is mobile-compatible.

Kathryn Slaney

Tywyn Town Council January 1, 2013 There will be images on the website, and these will be provided by the client. I have arranged a meeting with the client, to sit down with them, to discuss layouts, colour schemes and content.

Compatibility with my Career Plan Doing this project will improve all my skills immensely this year, and will take me a lot closer to achieving my chosen career, as I will have to use all my current skills and knowledge from my first year and expand on them further this year and obtain new skills, such as programming my own content management system, a database and ensuring I create mobile compatible websites for the future.

Learning Outcomes Learning Outcomes

Activities

Evidence

Develop an understanding of MySQL databases

Creating and integrating a database in to the website

Fully Working Database Printouts Testing Documents

Develop my knowledge and programming skills on C#

Creating the database and content management system

Fully Working Content Management System & Database Printouts of Code

Successful Project Management

Use of Gantt Chart Meetings Reviews

Agendas/Minutes Copy of Gantt Chart

Expanding my knowledge of Search Engine Optimisation

Targeting different kinds of searches i.e. Image Search, Local Search, Video Search and other search options

Screen Printouts

Making a Mobile Compatible Website

Ensuring throughout the project that I use the available tools to check the compatibility and that the content is adequate throughout

Screenshots from a mobile and a tablet to show compatibility

People Skills

Listening to the clients requirements and putting them in to practice and sticking to the brief

A website, database and content management system that the client is completely happy with

Kathryn Slaney

Tywyn Town Council January 1, 2013

Resources

Software

Hardware

Dreamweaver Photoshop Visual Studio Microsoft Access Microsoft Word Mobile Compatibility Software (to be decided) PHP MySQL

Computer Mobile Phone Back Up Device Printer Server

People

Content

Site Testing Users Tywyn Town Council Work Based Project Tutors

Pictures Minutes Agendas Council Details Map Councilors Names & Contact Details Administration Login Bilingual Option Search Option

Review Points I will arrange to see my client, at the start/end of every stage such as the:   

Competition of Storyboards with colour scheme and layout Completion of the database Completion of the content management system

This will be negotiated in more depth once I have had a form meeting with my clients.

Kathryn Slaney

Tywyn Town Council January 1, 2013

Aims and Objectives These are the aims and objectives that I wish to achieve during my work based project, laying them out using the S.M.A.R.T technique I will then be able to see at the end of my project if I have met these objectives. Specific

Aim: A modern and simple to use website Objectives: To establish what makes an effective and modern website, that is easy to use and to do this I will compare other similar websites in the initial planning stage and take the good components from the websites and incorporate them in to the website.

Time

Realistic

Measurable

Achievable Figure 1: S.M.A.R.T Goals

Aim: To complete my project by the end of January Objectives: To ensure I meet this aim, I will devise a Gantt chart which will be broken down in to main tasks, and then subtasks within that in order to complete the tasks at the scheduled time.

Aim: To ensure that the client can use the website competently Objectives: To make sure I achieve this aim, I will be making a basic user manual for the client, and also offering them an hour or so hands on training session so they can use the website and understand it while I am there to help answer any questions.

Kathryn Slaney

Tywyn Town Council January 1, 2013

Action Plan This is my initial plan and tools I will use, before I can progress any further with my project.

Project Tools 5Ws and H – a project tool that asks basic questions that is useful for all stages of problem solving. Although this is established in the proposal, I would like to keep a second record of this with me as a reminder. Task Breakdown chart – a logical approach to identifying the tasks involved within my project, I can then use it to help make my Gantt chart more detailed and cover all the tasks I need to ensure my project is successful. Communications Matrix – I will use this mainly as a reminder of who I need to contact at each stage of my project. Risk Analysis/Problem Recognition – I will create this at the beginning of my project so it can help me predict any future problems, if any arise. Gantt chart – this will be the main project tool that I will use, as this will help me keep on top of my schedule, and I can make any amendments I need to as I go along. Handover Checklist – this is a closure list that I will create at the end of my project that will be a list of all the tasks throughout the project, to ensure they are all complete, and also with this I will include a small user manual for the client and I will also include a small teaching package, so I can spend an hour or so with the client to ensure they know how to use the website.

The Planning Stage        

Prepare Gantt chart Research Tywyn online Look at similar websites online and compare (see page 12) Establish main user requirements (established in the Proposal page 2) Prepare a basic storyboard Prepare agenda for the initial meeting with the client Prepare a copy of the proposal for the client to read and sign Agree a time scale and software needed (established in the Proposal page 2)

Kathryn Slaney

Tywyn Town Council January 1, 2013

The Design Stage       

Decide on a colour scheme Start the website layout Photographs of Tywyn Design header with Town Council Logo Layout for the homepage Layout for all pages, Welsh and English Versions Data Flow Diagram

The Implementation Stage    

Placing it on the local server Creating PHP login and Contact Form Programming for the MySQL Database Upload to the server via filezilla

Testing Stage     

Unit testing – testing the individual pages Module testing – testing the procedures for sending mail from the site and the login button System testing- test all the website, and MySQL database together. Acceptance testing – tested with data provided User testing – handed to a group of individuals to test

Kathryn Slaney

Tywyn Town Council January 1, 2013

Work Journal Planning & Research – Comparing Websites Once the proposal had been agreed upon with the client, I started looking in to and comparing other websites that were providing the same as what the client had asked for. I prepared a comparison table so I could look at the sites in more detail; I made my comparison table technical as well as commenting on the design of every site. I made the comparison table so I could look at the good and bad aspects from each site, and bring these together to make the Tywyn Town Council website. When I was looking in to the websites I didn’t just look at the layout and the design, I looked at what code it was written in, their Alexa Ranking, and the number of backlinks. The Alexa Traffic Rank will show how popular the site is compared to others, including Reach, Page views and more. It also can show you the kind of audience that a site is attracting. Unfortunately the three sites I compared have no Alexa Ranking – this is mainly due to the people who view these websites not having the Alexa Ranking tool bar installed on their browser. I then looked at the backlinks to see how many sites linked through to the sites I was comparing, to see how many would be likely to generate an audience for the sites in question. Out of the three sites it was the Aberystwyth site that had the most backlinks, this is understandable as it a larger place and is more likely to have more information on it than such smaller towns in the surrounding area. I looked at the layout of the websites, their colour schemes and chosen images. comparing all three I personally felt that discoverdolgellau.com was a more modern looking and looked a lot more professional, and along the lines of what the client is looking for, however the content was a lot less relevant compared to the other two websites, as the

After

Dolgellau website is mainly a tourist Figure 2: www.discoverdolgellau.com Homepage information site, and the town council information is well hidden in numerous page clicks. The layout is a very clean looking one, and makes it easier to find information as a tourist, but looking for information on the town council, unless I typed in to www.google.co.uk what it was I was actually looking for, I couldn’t locate on the site, so having noticed this I want to make sure that the clients website is easy to navigate, and the information is very easy to find especially as the audience who will be using the website, will not have time or want to spend a lot of time looking for information. I then went on to look at the content on all three of websites to see

Kathryn Slaney

Tywyn Town Council January 1, 2013 what was available on each. Although all the websites aim to deliver the same information to its user, the way they do this is very different. As the Aberystwyth website covers a larger area its content is more detailed and there is more available. The Dolgellau and Barmouth websites cover small towns so just have the information and content relevant to these towns – as Tywyn is a small town it will only need content that is relevant to the town its self and the smaller villages around it and possibly links to larger pages, and the Gwynedd Council website.

Figure 3: www.abersystwyth.gov.uk - Policies & Procedures

The Aberystwyth website has a lot of information on it, however it isn’t as well laid out as what it could be, there is a basic table layout with the name of the policy with the date it was released/created with the option to click it and open it in to a PDF. I feel that having this set up doesn’t make the site look as professional or as clean cut as it should for such a large place, I feel it makes the website look amateur. I do like how the website is very easy to navigate and all the links work as they are supposed to and everything is easily found, and it is also very obvious on how to switch to the welsh version of the site, as the welsh flag is in plain view at all times.

Kathryn Slaney

Tywyn Town Council January 1, 2013

Figure 4: www.barmouthtowncouncil.gov.uk - Services

There is a very similar layout to the Barmouth website when I compare the Aberystwyth website and the Barmouth one, the also both have similar gateways to enter the website, so it looks like the designer for the Barmouth website took their inspiration from this site and similar sites. Small differences between the sites are items such as the navigation bar, images and the colour scheme. On to the final website I looked at, the Barmouth Town Council one, as I mentioned previously it is very similar to the Aberystwyth website in regards to its entry on to the site, the layout of several of the pages. Looking at the navigation bar, on the Barmouth website it is horizontal and as you hover over the text, it highlights yellow, personally I didn’t like the navigation bar not being tabbed, and having the yellow hover didn’t really suit the colour scheme of the website itself. However I do think that the sliding gallery that you get on every page is a very nice idea, although there aren’t many pictures to look at. I also noticed while scrolling through the website that the font changes, looking back at the usability standards for it to be accessible for all audiences a particular type of font should be used at a particular size, and I noticed that there were 3 different kinds of fonts, and at different sizes. Looking at the content on all three websites especially the Aberystwyth and Barmouth sites, when looking at the councillor’s information – I felt that there was too much information available, personal addresses and personal numbers. As it is the client’s choice as to what is available to be viewed on the website I will discuss with them the issues concerning having too much personal information available online for the public to see. Overall all of the websites have different good points and different bad points; the next step is to compile a list of all the good points from all three websites, to discuss with the client so we can design a modern website that meets all the needs of the client and the websites users.

Kathryn Slaney

Tywyn Town Council January 1, 2013

Comparing Websites Type of Site

Main Web Application Used Modern or Old Fashioned Design/Layout

Colour Scheme

Discoverdolgellau Information Based – non profit CMS

Aberystwyth Information Based – non profit Unknown

Unknown

Modern

Mix of Both

Container Box hovering in the centre of the page, horizontal menu at the top of the white container, images underneath the logo, option to select language. RSS Newsfeed, links to Facebook and Twitter Grey/Black/White/Greens

Gateway page to select language, town council crest on gateway. Vertical menu outside of white container box.

Gateway page to select language, town council crest on gateway. Horizontal menu, gallery under the menu, menu also available at the bottom of the page, as well as the language options Cream/Beige

ASPX

Light Blues/White ASPX

All Links work – font easily read The appearance of the website is very clean and modern, content is easy to find, mainly a tourist information site

All Links work – font easily read Appearance is clean and fresh, all the content is relevant and easy to locate

Main Site Keyword

“Dolgellau” is mainly used to find this site it has the highest % of search keywords

Alexa Ranking Backlinks

0**

“Aberystwyth” is mainly used to find this site it has the highest % of search keywords 0**

19 Backlinks

31 Backlinks

Codebase/Server Type Website Usability Website Quality

Barmouthtowncouncil Information Based – non profit

HTML/PHP All Links work – fonts don’t match Appearance is a combination of new and old, making it look slightly untidy, all the content is relevant and easy to find. *Currently no known keywords to find this site

0** 2 Backlinks

* Site is new so no known keywords are identified **Alexa or Spyfu data is normally valid if the user has the toolbar installed, so not always accurate

Kathryn Slaney

Tywyn Town Council January 1, 2013

Meeting the Client Once the comparison of the websites was completed, after several emails had been exchanged, a meeting was arranged with one of the council members, where we would discuss the proposal the website in detail, I prepared an agenda to make sure that I covered everything that was needed about the website and what the client requires, as this needs to be established before I can progress forward with the website.

Figure 6: Mock Up Homepage - Horizontal Menu

Before the meeting I prepared some basic storyboards for the client to see and for us to discuss in more detail during the meetings. The storyboards were designed to show the layout options for the navigation bar (menu) and possible page layouts. The page layout is based on a news page, giving the user the option to look at four pictures, have small amount of text and the option to carry the user on to a different page to continue reading the story, and with the option for administration to log in at the bottom of the page, and the option to change languages at the top right corner.

Figure 5: Mock Up Homepage - Vertical Menu

Kathryn Slaney

Tywyn Town Council January 1, 2013 I designed two basic screens for the client to see, with the same options on both but just different menu bar layouts. I met with my client from the town council at the college on the 16th of November 2012. In the meeting I introduced myself and explained the course, my project and then we went on to discuss the website and the clientâ&#x20AC;&#x2122;s needs. During the meeting, I established exactly what it was that the client required, and how they would like me to go about meeting their requirements, these are documented in more detail in the Meeting Minutes. Majority of the correspondence between myself and the client was over email, as it was a more convenient way to keep updated on the project and the development due to the client working their day job, and going back to report progress to the town council members at the meetings.

The Meetings Date 16/11/2012

Subject First initial meeting with client to discuss requirements of the website and possible content for the website.

11/12/2012

Discussion of the layout and possible domain names, client mentioned that they would like me to research domain names and hosting.

22/01/2013

Preview of the website before it was uploaded to the testing server and collection of the Town Council Crest.

19/02/2013

Meeting in Tywyn to discuss the website and to show the client what I had already completed and whether there was any available PDFâ&#x20AC;&#x2122;s or content for me to put on the website

26/03/2013

Demonstration of the completed login for the administration site of the website, to show the client what they will see when they login to update content.

09/04/2013

Final meeting with the client, to ask for content for the website and to show the near completed website.

Kathryn Slaney

Tywyn Town Council January 1, 2013

Research Domain Names After the first meeting with the client I set out to look at suitable domain names and hosting for the website, as the client had originally not considered this. During the meeting the client wasn’t sure whether Gwynedd Council had policies about town council’s setting up websites. I looked to see if there were any policies in place that would stop Tywyn Town Council having a website, I did telephone the main office in Caernarfon but they did not seem aware of any policies, however they did say they would find out and return my call on a few occasions but never did. I continued to research in to the cost of a server and domain name. The client did not specify what kind of domain name they would like so I took it upon myself to focus on 3, these are the 3 that I have chosen, reason being there is an English version of the name, a Welsh one and a mixture of them both:   

www.tywyncouncil.co.uk www.cyngortywyn.co.uk www.cyngortywyncouncil.co.uk

Firstly I looked at the cost of just the domain name itself before I looked at hosting and complete packages. At this stage I had looked at several domain sites and choose 6 to look at for the names and pricing. I only focused on looking for available domain names with .co.uk on the end as I wasn’t sure on the criteria for a .gov.uk address and wanted to discuss with the client whether they would like me to look in to this option.

Research of .gov.uk The .gov.uk domain name is subject to strict eligibility rules that are set by the UKERNA (United Kingdom Education and Research Networking Association). To be eligible for this domain name there is a criterion that the Cabinet Office (eGovernment Unit) has set. It is limited to:   

local and regional government bodies (including properly constituted town, parish and community councils) UK government and devolved administration departments and agencies Executive and advisory non-departmental public bodies and appropriate projects

The .gov.uk domain name is not to be to promote material, printed material or other media until it has correctly been applied for and approved by the Domain Naming and Approvals Committee. To apply for a .gov.uk domain name, an application form has to be filled in, and submitted; I found an application form on www.hcidata.co.uk/register-dot-gov-dot-uk.htm this will cost around £109 for 2 years (as of 1st of February 2013). As it will be used for an individual Town Council, it says that unless the full ‘towncouncil’ is use then a suffix is required with the hyphen ‘-tc’, in the client’s case they have the option:  

www.tywyntowncouncil.gov.uk www.tywyn-tc.gov.uk

Kathryn Slaney

Tywyn Town Council January 1, 2013 As the domain names are issued on a first come, first served basis by the Committee upon the approval of the application form, I looked online to see if any of the domain names I had mentioned previously with the .gov.uk had already been taken and as it is at the moment (January 2013) they are currently still available, and as I am making a user manual for my client, I will include information about the domain names and available hosting options.

Hosting and Complete Packages Having looked at domain names and individual costing, it was appropriate that I looked at hosting costs and what each package consists of. First of all I looked at what the client would need in the terms of hosting:     

Access to a MySQL database to store documents and content on the site. Sufficient storage space as there will be up to a year’s worth of documents needing to be stored on the database, so it can be accessed by the public. Possibly an email account linked to the website although the client already has an email address. Relatively large monthly bandwidth allocation Ability to upload PHP pages

Once I knew what it was that the client was looking for, I then started to look at different hosting packages and prices, as there is a variety of different companies offering the same or similar packages; I selected a handful of websites that I felt would provide the right package for my client.

Kathryn Slaney

Tywyn Town Council January 1, 2013

Domain Name Price Comparison Website Name

Domain Names 2years £6.98 £6.98 £6.98

www.123-reg.co.uk

tywyncouncil.co.uk cyngorcouncil.co.uk cyngortywyncouncil.co.uk

www.easyspace.com

tywyncouncil.co.uk cyngorcouncil.co.uk cyngortywyncouncil.co.uk

£9.50

www.fasthosts.co.uk

tywyncouncil.co.uk* cyngorcouncil.co.uk* cyngortywyncouncil.co.uk*

£2.95 £2.95 £2.95

www.uk.godaddy.com

tywyncouncil.co.uk cyngorcouncil.co.uk cyngortywyncouncil.co.uk

£6.98 £6.98 £6.98

www.names.co.uk

tywyncouncil.co.uk cyngorcouncil.co.uk cyngortywyncouncil.co.uk

£6.99 £6.99 £6.99

www.freeparking.co.uk tywyncouncil.co.uk** cyngorcouncil.co.uk** cyngortywyncouncil.co.uk** *if registered for 2/10years **per year

Price 5years £17.45 £17.45 £17.45

10years £34.90 £34.90 £34.90

£17.45 £17.45 £17.45

£34.90 £34.90 £34.90

£9.50

£41.99 £41.99 £41.99

£4.99 £4.99 £4.99 £4.99 £4.99 £4.99 £4.99 £4.99 £4.99 (Correct Pricing 28/01/2013)

The websites mentioned above offer hosting as well as domain names but this table only shows the price of domain names offered by the companies.

Kathryn Slaney

Tywyn Town Council January 1, 2013

Hosting Price Comparison Website www.easyspace.com

www.godaddy.uk.com

www.123-reg.co.uk

www.fasthosts.co.uk

Hosting Package Unlimited Webspace Unlimited Bandwidth Unlimited Databases 200 Email Boxes Free Domain Name Unlimited Subdomains *Free goMobi site *Back up & Restore Wordpress Ready 24/7 Phone Support Unlimited Bandwidth Linux/Windows Operating Systems Unlimited Websites Unlimited Disk Space 25 Databases 500 Email Addresses £33.30 Facebook Advertising Credit Customizable Mobile Site

Price From £7.99 per month

Sale £2.99 per month Normal £5.99 per month

Unlimited Webspace Unlimited Data Limit Unlimited Mailboxes Unlimited Databases (150MB per database) 3 Domain Names Host Multiple Sites Dedicated SSL Phone/Online Support

£8.99 per month

Unlimited Webspace Host 2 Websites Free .uk Domain Unlimited Subdomains Unlimited Bandwidth 100 MySQL Databases Unlimited Start Mailboxes Free OneClick Installer 100 FTP Accounts

£8.39 per month

(Prices are correct at the time of research 28/01/2013) all the prices shown are a minimum of a 12 month contract with the providers.

Kathryn Slaney

Tywyn Town Council January 1, 2013

Creating the Website After the meeting with the client, with everything agreed upon I started to create the website. I first looked at suitable backgrounds, as the colour scheme was chosen as Green; I wanted to give the website a fresh look, but still professional with the layout chosen by the client. Initially I started looking at green backgrounds; I had already chosen the type of navigation bar that would be used based on the requirements given by the client. I designed the background and once put all together I felt that it was just too much, and didn’t provide the website with a professional look that I had hoped to achieve. Figure 7: Version 1 of Tywyn Website

I looked at free backgrounds online to see what options would be suitable enough to provide my website with the professional look I want to achieve after looking on various websites, I found a dark grey background with black spots that would give the white content box the slick and clean look of a more modern website. It was decided early on in the meetings with the client that the navigation bar would be horizontal and green, we discussed what the navigation bar would contain, and we decided it would have:     

   

Home – takes the user directly back to the homepage at any point during using the website. Town History – this page will continue some brief history of the town itself. Meet the Councillors – this page will contain a list of the councillors, their duties and contact email address. Council Minutes – this page will store about a year’s worth of agendas and minutes of meetings that the town council has/will have. Policies & Procedures – this will be similar to the Council Minutes, but it will hold PDF documents of application forms/ information that is relevant to the town, that is dealt with by the town council itself, with the option to view, download of save. Ynysmaengwyn Trust – history about the Ynysmaengwyn building and gardens which are under the control of the town council. Events – Local Events in the area, dates and times. Local Clubs & Services – external links to other information and clubs, services that are offered in and around the area. Contact Us – an online form to contact the council, a number to contact the office, and an integrated Google map.

Kathryn Slaney

Tywyn Town Council January 1, 2013 The Homepage

The homepage is set out like a newspaper with a small article and picture, with the ability to have 4 of the latest stories in the area on this page; there is also an events box to the right of majority of the pages this displays up and coming events in the area for the next 5 months. All the pages have the same header which consists of the town council crest, a bilingual title and a picture of daffodils, there is also the option to change the website to welsh on the navigation bar. The client wanted this layout as they felt it would be the best way to layout information and news about the town and surrounding areas, with a summary of events coming up. The client specified that they only wanted the homepage to have 4 boxes of text, as they didnâ&#x20AC;&#x2122;t want to overcrowd the page or cause the users to have to scroll down a lot. This page is exactly the same layout as the welsh homepage, with the same information and pictures.

Kathryn Slaney

Tywyn Town Council January 1, 2013 When this page is in the edit mode there is the option for the Admin to have a picture or not, and the option for the length of text is also changeable. To make the edit page easier once Administration has logged in and clicked on the ‘Edit Homepage’ button there are edit buttons above each block of text, in order to edit that section the user then clicks the ‘Edit Text Block’ a pop up page then appears with the ability to edit both the Welsh and English in the same area, and to select a suitable picture once the administration has done this and selected update all, both the English and Welsh pages will be updated with the picture and relevant text.

Kathryn Slaney

Tywyn Town Council January 1, 2013 Town History

The client said they would like a page with a brief history of Tywyn as there wasn’t much available online and having looked at the other town council websites in the area, all of them have a little bit about the town itself on there. The client couldn’t provide the information at the time of creating the page so I found some information online on a historical website and a tourist information site, the information was limited. This page is editable in the same way as the homepage, is, although this page will probably only need updating when the client puts their information on to the website for the first, as history can’t exactly be changed, although they may want to change at some point what kind of history about the town is displayed.

Kathryn Slaney

Tywyn Town Council January 1, 2013 Town Councillors

As I was unable to get information from the client about the councillors and couldnâ&#x20AC;&#x2122;t find the information online, so for testing purposes I invented some names for the table for demonstration purposes. The clients decided as a group that it would be more appropriate to only have the names, roles and contact email addresses available to the public, as on some of the other town council websites, there are personal home telephone numbers and addresses. The edit page for this page, is a single pop out page, with an editable table on it, which will be able to edit existing council members details and add more, or if needed to delete the record. All this information will be stored in the MySQL database.

Kathryn Slaney

Tywyn Town Council January 1, 2013 Council Minutes

This page is where the Councils agendas and minutes will be kept. The client and I decided that it would be practical for the page to store a yearâ&#x20AC;&#x2122;s worth of agendas and minutes and if the public required older ones then they could contact the clerk and request this. These documents will be stored on the server in PDF/Word format, and will be downloadable, printable and also viewable online. This page is editable in a similar way to the Councillors page; however there will be an upload link so the admin can upload the document on to the server.

Kathryn Slaney

Tywyn Town Council January 1, 2013 Policies & Procedures

This page is where the policies and procedures for this year will be kept. The client and I decided that there would only be documents that were applied to the town and surrounding area that the town council had knowledge on, in order for the council to be able to help the public with queries on the documents if they had any This page is editable in a similar way to the Council Minutes page; there will be an upload link so the admin can upload the document on to the server. When a link is clicked a PDF page opens: (The document shown was used for testing purposes only and to demonstrate what would be shown if the links are clicked)

Kathryn Slaney

Tywyn Town Council January 1, 2013 Ynysmaengwyn Trust

The client said they would like a page with a brief history of the Ynysmaengwyn Trust as there wasnâ&#x20AC;&#x2122;t much available online. The client didnâ&#x20AC;&#x2122;t provide the information at the time of creating the page so for testing purposes; I found some information online and used it to demonstrate what the page could look like. This page is editable in the same way as the town history, is, although this page will probably only need updating when the client puts their information on to the website themselves.

Kathryn Slaney

Tywyn Town Council January 1, 2013 Events

When this page was first created there was going to be an interactive calendar, and to keep costs low the client suggested that we looked at free calendars to integrate in to the site. The client wanted the website as simple as possible and I found with integrated calendars that in order to update the calendar the client would have to log in to the external site input the details and it would then update the calendar on the website. As the client wanted it simple, I felt that having to go to a different website and then back to the Tywyn Town Council website, would be tedious so I felt that a simple easy to update table would be better and clearer to read. This page is editable like the Councillors page; both Welsh and English are entered in to the same table, as much detail or as little detail as the client wants can be entered in to each event, however this will make the page scroll down more.

Kathryn Slaney

Tywyn Town Council January 1, 2013 Local Clubs & Services

During our meeting the client said that they would like a page with external links to relevant pages in the area, such as local clubs and services. As the client hasnâ&#x20AC;&#x2122;t given me any content for this page, I just found some local attractions in the area that could be used as an example for testing purposes. To edit this page, the admin would need to take the same procedure as they would to edit the homepage, and on the pop out screen there is a description box and link box, for the user to input the information, once its saved the information will update the table on the local clubs and services page.

Kathryn Slaney

Tywyn Town Council January 1, 2013 Contact Us

The Contact Us page has an integrated Google map that I did but putting in the location of the town council office, and embedding the html code in to my website. Although the town council have their contact email address, I have integrated a PHP contact form on the page, that requires the user to fill in all the boxes, and this email will be sent to the town council, although at present it currently goes to the Spam folder, I am working on changing this. I have input a profanity filter on to the contact form, so any emails with particular words will not get sent to the client, this also prevents spam being sent.

Kathryn Slaney

Tywyn Town Council January 1, 2013 Administration Login

In order to access the administration side of the website, there is the option at any time at the bottom of the white content box to login in, at the moment for testing purposes it is set with a simple username and password. The username/password is changeable in the MySQL database, and the client will be able to do this when they have the completed website. Once the login button has been clicked, the user is then taken to the login page.

Once here the user will have to input their username and password, it was suggested to the client that it would be an idea to have two users with different logins so that if one left, or was unable to update the website then there would be another person available to do this. If the username and password are correct they will be able to enter the administration page, if they are wrong, they are taken to another page that states that the password or username is wrong.

Kathryn Slaney

Tywyn Town Council January 1, 2013 Once in to the adminstration page the user gets the option to edit all the pages, with similar edit boxes to the one seen on the homepage. The page is bilingual in order to make it easier for the client to update the relevant pages all in one place instead of having to go to the Welsh and English versions of each page.

Kathryn Slaney

Tywyn Town Council January 1, 2013 Welsh and English As the client is a local Town Council the ability to have the website changing from Welsh to English and vice versa is vital, and in order to achieve this I have made a button on the navigation bar. If the user clicks the Welsh Flag at any time they will be taken to the welsh version of the website, and the same with the British flag, however when the user first accesses the site it is English, the information contained on both the Welsh and English versions of the website are exactly the same just translated. I have made the Meeting Minutes, Meet the Councillors, Local Clubs & Services and Policies & Procedures pages bilingual as the information on these can’t be changed and will be readily available in both languages, I thought it would save the Administration time, by just putting the information on once in one place, instead of in two different places. Programming the CMS and MySQL When it came to choosing the Content Management System, I was originally going to look for open source software, because the client mentioned that they would like to keep all the costs at a minimum. I looked at possible options before deciding to program the CMS myself using PHP. 

Drupal - Drupal is a free software package that allows you to easily organize, manage and publish your content, with an endless variety of customization.



Concrete5 - an editing toolbar gives you all the controls you need to update your website. No intimidating manuals, no complicated administration interfaces - just point and click.



Joomla – enables you to build Web sites and powerful online applications. Many aspects, including its ease-of-use and extensibility, have made Joomla the most popular Web site software available. Best of all, Joomla is an open source solution that is freely available to everyone.

Having looked at the open source content management systems available online, I then decided that it would be better to program the CMS myself, as this would be more personal towards the client’s needs. I also looked at adding WYSIWYG editors (an acronym for "what you see is what you get"). WYSIWYG implies a user interface that allows the user to view something very similar to the end result while the document is being created. PHP (recursive acronym for PHP: Hypertext Pre-processor) is a widely-used open source generalpurpose scripting language that is especially well-matched for web development and can be embedded into HTML. I hadn’t used PHP before, and found that it was extremely simple and offers many advanced features for more professional programming. With PHP, you can connect to manipulate databases.

Kathryn Slaney

Tywyn Town Council January 1, 2013 MySQL is the most popular database system used with PHP. MySQL is a database system used on the web, it runs on a server. MySQL is ideal for both small and large applications and is very fast, reliable and easy to use. The data in MySQL is stored in tables; a table is a collection of related data that consists of columns and rows. Databases are very useful when storing information categorically. The tables used in my MySQL are related to the page names, the tables contain all the content that is on the website, and can be changed using the editable pages, which are coded with PHP in order to update the database with the new content:

Kathryn Slaney

Tywyn Town Council January 1, 2013 Uploading to the Server

Overview FileZilla Client is a fast and reliable cross-platform FTP, FTPS and SFTP client with lots of useful features and an intuitive graphical user interface. Features Among others, the features of FileZilla include the following:       

Easy to use Supports FTP, FTP over SSL/TLS (FTPS) and SSH File Transfer Protocol (SFTP) Cross-platform. Runs on Windows, Linux, *BSD, Mac OS X and more IPv6 support Available in many languages Supports resume and transfer of large files >4GB Tabbed user interface

Kathryn Slaney

Tywyn Town Council January 1, 2013             

Powerful Site Manager and transfer queue Bookmarks Drag & drop support Configurable transfer speed limits Filename filters Directory comparison Network configuration wizard Remote file editing Keep-alive HTTP/1.1, SOCKS5 and FTP-Proxy support Logging to file Synchronized directory browsing Remote file search (Found on www.filezilla-project.org/client_features.php, March 2013)

To upload my website on to the testing server I used filezilla, because it is an open source program and is easy accessible. In order for me to do this I had to input the host address, the username allocated to me and the password, once I had access to the server I then transferred all the PHP pages, CSS pages, images and documents that will be available online, I did consider putting these in to folders but as there wasn’t many I thought I would leave it as it would make it easier to locate them instead of having to find the files pathname etc.

Kathryn Slaney

Tywyn Town Council January 1, 2013

Testing When testing my website, at every small change I tested that the website worked, then at the end I had some users look at my website, and then tested it, here are the results: Test No.

Page

What will be Tested

Expected Result

001 index.php

Navigation Bar

All the tabs work and take the user to the correct page



002 index2.php

Navigation Bar

All the tabs work and take the user to the correct page



003 history.php

Navigation Bar

All the tabs work and take the user to the correct page



004 hanes.php

Navigation Bar

All the tabs work and take the user to the correct page



005 councillors.php

Navigation Bar

All the tabs work and take the user to the correct page



006 minutes.php

Navigation Bar

All the tabs work and take the user to the correct page



007 policy.php

Navigation Bar

All the tabs work and take the user to the correct page



008 ynys.php

Navigation Bar

All the tabs work and take the user to the correct page



Kathryn Slaney

Actual Result

Changes Made

Tywyn Town Council January 1, 2013

009 events.php

Navigation Bar

All the tabs work and take the user to the correct page



010 clubs.php

Navigation Bar

All the tabs work and take the user to the correct page



011 contactus.php

Navigation Bar

All the tabs work and take the user to the correct page



012 ynysmaen.php

Navigation Bar

All the tabs work and take the user to the correct page



013 cysylltuni.php

Navigation Bar

All the tabs work and take the user to the correct page



014 login.php

Takes you to the administration page



015 login.php

Wrong Login

Takes you to an error page



016 contactus.php

Contact Form sends email

Sends email



017 contactus.php

Google Map works

Shows location and offers directions



018 cysylltuni.php

Contact Form sends email

Sends email



Kathryn Slaney

Stop it going to Spam

Tywyn Town Council January 1, 2013

019 cysylltuni.php

Google Map works

Shows location and offers directions



020 Index.php

Converts to Welsh

Successfully changes language



021 Index2.php

Converts to English

Successfully changes language



022 ComingUp box

Updates When Edited

Updates



023 login_success.php

Admin Page

View Admin Page



024 login_success.php

Buttons all work

Successfully takes you to the edit pages



025 login_success.php

Logs Out

Successfully Logs Out



026 edithomepage.php

Buttons to Edit work

Edit Text Button loads up page



027 edittextbox.php

Pops up when button is pressed

Screen Pops Up



028 edittextbox.php

Text is Editable

Updates the text on Website



029 edittextbox.php

Image is Editable

Updates the images on Website



Kathryn Slaney

Tywyn Town Council January 1, 2013

Conclusion Overall I feel the project went well, Tywyn Town Council had asked me to create a website that was:     

I believe I have achieved majority of their requirements, apart from the mobile compatible requirement as I discussed with the client that it would be a costly process to get this done properly, however, the website is still viewable on all current smart phones, as I demonstrated this to them on my IPhone 5 – they then decided that this was not a priority. The Client At the beginning of the project, I was getting full cooperation from the client, and exchanging emails on a regular basis, however this soon ended as the client began to lose interest, mainly due to their own commitments in their own lives, but this meant it was harder for me to get information from them. I do believe that if the client had been fully involved that the website would be at a better standard than what it is currently at, because I had to do a lot of the finding content and layout myself and hoped that I was still within the original brief set by the client. Although the client was not completely involved towards the end, I shouldn’t have left the workload as much as I did, as I felt I couldn’t continue with the project without their input, I know now that to stick to a strict schedule I have to carry on, with or with out the client. Personal Outcomes I have learnt a lot from this project, mainly about new programming language PHP, MySQL and how to integrate them in to the development of my website but also about time management and how crucial this is to have a successful project at the end. I also am now aware that I need to research more about the new techniques I have learnt so I can develop on them for future projects. My professional skills have also developed as I had to meet with my client and exchange emails, overall I feel this has been a major learning experience and stepping stone towards my future career choice. If I could do this differently I would make sure that I didn’t leave the programming of the CMS until the last few weeks, as it was a lot more stressful and it took majority of the time, however in the future I may consider using CMS that is open source rather than progrmming it, it was definitely a learning curve.

Kathryn Slaney

Tywyn Town Council January 1, 2013

Websites Viewed www.discoverdolgellau.com

Last Accessed:

03/11/2012

www.aberystwyth.gov.uk

Last Accessed:

03/11/2012

www.barmouthtowncouncil.gov.uk

Last Accessed:

09/11/2012

www.cssmenus.co.uk/

Last Accessed:

20/11/2012

www.subtlepatterns.com/

Last Accessed:

21/11/2012

www.w3schools.com/

Last Accessed:

21/11/2012

www.drupal.org/

Last Accessed:

23/11/2012

www.concrete5.org/about/

Last Accessed:

23/11/2012

www.php.net

Last Accessed:

23/11/2012

www.joomla.org/

Last Accessed:

23/11/2012

www.easyspace.com

Last Accessed:

03/01/2013

www.godaddy.uk.com

Last Accessed:

03/01/2013

www.123-reg.co.uk

Last Accessed:

03/01/2013

www.fasthosts.co.uk

Last Accessed:

03/01/2013

www.freeparking.co.uk

Last Accessed:

03/01/2013

www.names.co.uk

Last Accessed:

03/01/2013

www.hcidata.co.uk/register-dot-gov-dot-uk.htm

Last Accessed:

05/01/2013

www.alexa.com

Last Accessed:

09/02/2013

www.moonsy.com

Last Accessed:

09/02/2013

www.a3webtech.com

Last Accessed:

12/02/2013

www.freecontactform.com/email_form.php

Last Accessed:

12/02/2013

Kathryn Slaney

Tywyn Town Council January 1, 2013

en.neuroticweb.com/neurotic

Last Accessed:

21/02/2013

www.phpeasystep.com/phptu/6.html

Last Accessed:

21/02/2013

www.sqa.org.uk/e-learning/SDPL03CD/page_18.htm

Last Accessed:

24/02/2013

www.filezilla-project.org/client_features.php

Last Accessed:

10/03/2013

www.validator.w3.org/

Last Accessed:

09/04/2013

www.sbpoley.home.xs4all.nl/webmatters/checklist.html

Last Accessed:

09/04/2013

Kathryn Slaney

Tywyn Town Council January 1, 2013

Appendices Emails from Client First Agenda First Meeting Minutes Data Flow Diagram Program Code (HTML /PHP) CSS

Kathryn Slaney

Tywyn Town Council January 1, 2013

Hello Kate, I have been in touch with Graham Hall about the possibility of an IT project to involve setting up a website for the Town Council, at Tywyn, Meirionydd. Graham has seen I think a draft site I set up some years ago, but it may be better to start afresh with your ideas. I am sure you are more familiar with what technology can do now compared to 8 years ago ; or at least you should be by the end of the course! I can write in HTML, but my coding is rather outdated. I also use Wordperfect to design pages, then it's translation facility to convert it to .html. This does not always work perfectly, but it's a good short-cut. I think Word can do something similar, but I don't like Word. I use it at work, but not at home. There are other wordprocessing and translation programs of course. I myself have been a Councillor at Tywyn for just over 8 years now. I spoke to the Clerc (Elwyn Evans) yesterday, and we agreed it would be reasonable to let you create a website as a draft, and then seek Councillors' approval before it goes 'live'. I am sure the Mayor will agree. If all agree then, the project will be to create a suitable website, find a suitable server to 'park' it, and handover to the Clerc how to update it. This will probably involve liaising with Council, Councillors, Council employees, server service provider, and discussing and choosing suitable format, policies on document and personal information publication, and presentation to Council at least once on the project. We cannot guarantee that Council will adopt it at the end of the day, however good it is, but I think they should see it as necessary for progress it the modern world. What I can guarantee is that there will be some explaining to do to the less computer-literate Councillors, and maybe some difficult questions to answer. We need something simple to look after, and also simple for people to use. If it can be suitable for download not only to PCs, but also to other mobile devices, this might be useful. It will need to consider how easy it is to update. There may be legislation we have to follow. I can obtain advice from legal department at Gwynedd County Council and One Voice Wales, the association of local councils, where this is needed. You will need to look at a variety of other Council's websites, and choose the best bits of all. My background is as a GP at Machynlleth, where I set up the Practice' Intranet site, although the public website was designed and controlled by the server provider's programmer. I have set up a personal website at Geocities.com in 19995/6, and a Moonfruit website for Tywyn Model Rail Club about 2 years ago. I have never used facebook, twitter, etc, and my mobile phone does not receive texts or messages, but is now less than 5cm thick (the previous one wasn't). I am currently working Wednesday to Fridays at Machynlleth Health Centre, and have Mondays and Tuesdays when I can by arrangement be free or travel up to Coleg Dolgellau. Council meetings are on the second Wednesday of each month except August, and Elwyn works usually Monday to Thursdays 10 am to 3pm at the Council offices in Tywyn. 01654 712411. You can usually find me at home evenings after seven on 01654 712739, or mobile 07990 522353. The weekends I may be hard to find Saturdays as I am usually sailing at Bala. Sunday often have the phone on at times even if I am out. Mondays/Tuesdays I usually carry mobile, but often out of range as coverage down here is interrupted by the hills, although I will not be home much at all until term starts about 4th September. I have had a variety of short teaching/supervising appointments over the years, so I don't mind if you ask questions! We look forward to working with you. Best wishes, David Church Councillor, Tywyn, Meirionydd. :-)

Kathryn Slaney

Tywyn Town Council January 1, 2013 Hi David I was wondering if it would be possible to set up a meeting, when you are next available in order to discuss the website requirements in a bit more detail. I am normally available in the college on a Tuesday afternoon, but if this isn't convenient for you, I could travel to Tywyn on one of the days you are available. Thanks

I can come up to college Tuesday afternoon 23rd october. I believe it's the college site in Dolgellau on the north side of the bypass? However, I have never been inside the college or even onto the site, so will need some directions. Would this be okay? Otherwise, you are welcome at our house in Tywyn, or we could meet up at the Council Office, and you can also meet Elwyn the Clerk. Council Office is on Tywyn High Street, between Baptist Church and Leisure Centre/Swimming Pool. Opposite the Post Office. and NOT in the 'Institute'. David :-) Hi Kate, sorry I had a diary accident. Turned 2 pages at once. I can come up to Dolgellau tuesday 23rd October, OR I can come to Dolgellau Tuesday afternoon 16th Octbober if that's better. likewise, me and the Clerk are available Tuesday 16th in Tywyn if you want to come here. David Church

Hi I'm sorry for not getting in touch sooner, we've all been unwell so I haven't checked my emails. Is it still possible for you to come to Dolgellau on Tuesday? Thanks

Kathryn Slaney

Tywyn Town Council January 1, 2013

Sorry to hear you were poorly. Hope all well again, if not, I'll bring the Doctor with me! Tuesday 23rd is fine. If you can let me know best time and where to meet.

I have also been rooting in the attic for something, and we have some old equipment in working order if it is of use to anyone: 1 - SCSI scanner, HP Scanjet ADF, with SCSI port and OLD (square) USB port (not the flat one), but no software. 2 - Paper roll printer, Panasonic KX-P2023, with spare new ink ribbon, 24-pin head, and 36 pin flat printer socket (no USB at all). It uses rolls or flat-folded pads of continuous paper with punched borders, but used to be able to print single pages by hand too - I haven't tried it, but was working when we put it away. No paper or software for this either. If either are useful to anyone at the computing department, (or the electronics spares department!) let them know they can have them for free.

David Church :-)

Hi I'm available after 1pm on Tuesday, and if you can come to the college campus I will meet you at the reception. Thanks

OK, will be there about 1ish. Lots of road-works, hopefully no hold ups. David Church

Kathryn Slaney

Tywyn Town Council January 1, 2013

First Official Client Meeting November 16, 2012 1pm â&#x20AC;&#x201C; 2.30pm Meeting called by: Kathryn Slaney Attendees: David Church, Kathryn Slaney Please read: None Please bring: Kathryn Slaney - Client Proposal Document Basic Storyboards Navigation Options

[Introduction] Discussion about the about the proposal, and what it contains and that the client needs to take it with them and read it and sign it in agreement with what has been proposed for the project

VC Room 1

Storyboards Storyboard with a horizontal navigation bar

VC Room 1

Storyboard with a vertical navigation bar Discuss both, and possible tab names Possible Content Discuss Tab names

VC Room 1

Content Hosting Domain Names Possibly Costs Photography Wrap-Up Arrangement of next meeting to review, email with updates on progress

Kathryn Slaney

VC Room 1

Tywyn Town Council January 1, 2013

Minutes First Official Meeting Minutes November 16, 2012 The meeting was called to order by Kathryn Slaney at 1pm In attendance David Church Kathryn Slaney Approval of Minutes None Budget Still to be arranged New Business Introduction It was discussed that what the Work Based Project, what Kathryn Slaney would gain from doing the project and also what the client (Tywyn Town Council) would gain. Purpose of the Website It was decided that the website would be used for the council, with a page of links to external sites for the tourist information for Tywyn Layouts for the website/colours and menu options Storyboards were brought to the meeting by Kathryn Slaney to show David Church in order to discuss the layout and colour options. Kathryn Slaney prepared storyboards with both a vertical and horizontal menu showing David Church the advantages and disadvantages of both options. It was discussed that greens would be a good colour pallet to use, as the countryside around Tywyn and Wales itself. The layout for majority of pages would be in a 4 block basis, with optional picture next to each block of text, with an events column on each page to see the latest up and coming events. The rest was left to Kathryn Slaney to decide upon, but stick to the brief provided by the client.

Kathryn Slaney

Tywyn Town Council January 1, 2013

Content of the website The content of the website would be council related content, but it wasnâ&#x20AC;&#x2122;t discussed in depth at this point, as David Church would approach the council members at a later date with regards to what information they would like on the site, and what personal information about the councillors should be available on the website. The content of the website needs to be all council related, with links to external sites such as Gwynedd Council and local clubs. It was also brought to attention that an area available to access and download PDFâ&#x20AC;&#x2122;s would be required for the download/printing of meeting minutes and application forms for the public. Content management, and MySQL database David Church enquired as to how the Council would keep the website updated once Kathryn Slaney had completed it. Kathryn Slaney then went on to explain that there would be a content management and MySQL database linked to the website in order to store information and update the website. David Church brought to light that this feature would need to be simple to use as it would be the Clerk of the town council responsible for the upkeep of the website once it was complete and that it would also require a secure login feature, Kathryn Suggested that a simple wizzywig editor was integrated preferably open source, or there was the option of having one created specifically for the website, that would require programming in PHP. David Church was more than happy to go with either suggestion, and left this decision to Kathryn to make. Other Issues During the meeting it was mentioned about domain names and hosting, David Church pointed out that the council had not considered this and would like if Kathryn Slaney could research this, and also look at possible policies that Gwynedd Council had in place for making town council websites.

Next Meeting December 18, 2012 Adjourned at 2.30pm by Kathryn Slaney.

Kathryn Slaney

Data Flow Diagram

Tywyn Council Homepage

Edit Homepage

Update?

Yes

Homepage Updated

Edit Town History

Update?

Yes

Town History Updated

Edit Coming Up

Update?

Yes

Coming Up Updated

Upload Minutes

Update?

Yes

Uploaded Minutes

Upload Policies

Update?

Yes

Uploaded Polices

Edit Ynysmaengwyn

Update?

Yes

Ynysmaengwyn Updated

Edit Events

Update?

Yes

Events Updated

Edit Local Clubs & Services

Update?

Yes

Local Club & Services Updated

Edit Contact Us

Update?

Yes

Homepage

Town History

Meet the Councillors

Town Council Minutes

Policies & Procedures

B r o w s e P a g e s

Ynysmaengwyn Trust

Yes

Events

Local Clubs & Services

Logout

[Type text] Yes

Program Code index.php !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Tywyn Council</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" />

<? include ('user.inc');

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

$query="SELECT * FROM homepage"; $result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close();

[Type text]

Tywyn Town Council January 1, 2013 for ($i=0;$i<$num;$i++) { $j=$i+1; $title[$j]=mysql_result($result,$i, "title"); $content[$j]=mysql_result($result,$i, "content"); $image[$j]=mysql_result($result,$i, "image"); } ?> </head> <body> <div id="custom-doc" class="yui-t4"> <div id="hd">  <img src="Tywyn.jpg" width="267" height="200" alt="Tywyn Crest" /> <img src="TTC.jpg" width="770" height="200" alt="Tywyn Council" /> <img id ="flowers" src="dafo.jpg" height="159" alt="dafodils" /> <div id='cssmenu'> <ul>

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <li><a href='clubs.php'><span>Local Clubs & Services</span></a></li> <li><a href='contactus.php'><span>Contact Us</span></a></li> <li><a href='index2.php'><img id="welsh" src="flag.GIF" width="27" height="27" alt="welsh flag" /></a> </li> </ul>

</div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g"> <div class="yui-u first">  <? echo"<h2> $title[1] </h2>"; echo"<p>$content[1]</p>"; if (strlen($image[1])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[1]' width='400' />";

echo"</div></center>"; } ?>

Kathryn Slaney

Tywyn Town Council January 1, 2013 &nbsp; <? echo"<h2> $title[2] </h2> "; echo"<p>$content[2]</p>";

if (strlen($image[2])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[2]' width='400' />";

echo"</div></center>"; } ?>

</div> <div class="yui-u">  <? echo"<h2> $title[3] </h2>"; echo"<p> $content[3]</p>"; if (strlen($image[3])>0) { echo"<center> <div id='image2'>"; echo"<img src='$image[3]' width='400' />";

Kathryn Slaney

Tywyn Town Council January 1, 2013 echo"</div></center>"; } ?>

&nbsp; <? echo"<h2> $title[4] </h2>"; echo"<p>$content[4]</p>"; if (strlen($image[4])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[4]' width='400' />";

echo"</div></center>"; } ?>

</p> </div> </div> </div> </div> <div id="side-b"> <div class="yui-b">

Kathryn Slaney

Tywyn Town Council January 1, 2013 <? include ('user.inc');

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

$query="SELECT * FROM forthcoming"; $result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close(); $monthname[1]="January"; $monthname[2]="February"; $monthname[3]="March"; $monthname[4]="April"; $monthname[5]="May"; $monthname[6]="June"; $monthname[7]="July"; $monthname[8]="August"; $monthname[9]="September"; $monthname[10]="October"; $monthname[11]="November"; $monthname[12]="December"; echo"<h3><center>Coming up</center></h3>"; for ($m=1; $m<=5; $m++) {

Kathryn Slaney

Tywyn Town Council January 1, 2013 echo"<h3>&nbsp;$monthname[$m]</h3>";

for ($i=0;$i<$num;$i++) {

$month=mysql_result($result,$i, "month"); if ($month == $m) { $date=mysql_result($result,$i, "date"); $description1=mysql_result($result,$i, "description1"); $description2=mysql_result($result,$i, "description2"); echo"<b><i>&nbsp;".$date."</i></b><br>"; echo "&nbsp;&nbsp;&nbsp;&nbsp;" .$description1."<br>"; if (strlen($description2)>0) echo "&nbsp;&nbsp;&nbsp;&nbsp;" .$description2."<br>"; } } echo"<br>"; }

?> </div> </div> </div>

</div><div id="ft">

Kathryn Slaney

Tywyn Town Council January 1, 2013 <p>Web Design by Kathryn Slaney ÂŠ Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

index2.php !DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Cyngor Tywyn</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" /> <? include ('user.inc');

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

$query="SELECT * FROM catref"; $result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close(); for ($i=0;$i<$num;$i++) { $j=$i+1; $title[$j]=mysql_result($result,$i, "title"); $content[$j]=mysql_result($result,$i, "content"); Kathryn Slaney

Tywyn Town Council January 1, 2013 $image[$j]=mysql_result($result,$i, "image"); } ?> </head>

<li><a href='index2.php'><span>Cartref</span></a></li> <li><a href='hanes.php'><span>Hanes Y Tref</span></a></li> <li><a href='councillors.php'><span>Cynghorwyr</span></a></li> <li><a href='policy.php'><span>Cyfarfodydd</span></a></li> <li><a href='policy.php'><span>Polisïau a Gweithdrefnau</span></a></li> <li><a href='ynysmaen.php'><span>Ynysmaengwyn</span></a></li> <li><a href='events.php'><span>Digwyddiadau</span></a></li> <li><a href='clubs.php'><span>Clybiau a Gwasanaethau Lleol</span></a></li> <li><a href='cysylltuni.php'><span>Cysylltu â Ni</span></a></li>

Kathryn Slaney

Tywyn Town Council January 1, 2013

</ul> </div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g"> <div class="yui-u first"> <br /> <br />  <? echo"<h2> $title[1] </h2>"; echo"<p>$content[1]</p>"; if (strlen($image[1])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[1]' width='400' />";

echo"</div></center>"; } ?> &nbsp;

Kathryn Slaney

Tywyn Town Council January 1, 2013 <? echo"<h2> $title[2] </h2> "; echo"<p>$content[2]</p>";

if (strlen($image[2])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[2]' width='400' />";

echo"</div></center>"; } ?>

</div> <div class="yui-u">  <? echo"<h2> $title[3] </h2>"; echo"<p> $content[3]</p>"; if (strlen($image[3])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[3]' width='400' />";

Kathryn Slaney

Tywyn Town Council January 1, 2013

echo"</div></center>"; } ?>

&nbsp; <? echo"<h2> $title[4] </h2>"; echo"<p>$content[4]</p>"; if (strlen($image[4])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[4]' width='400' />";

echo"</div></center>"; } ?>

</p> </div> </div> </div> </div> <div id="side-b"> <div class="yui-b">

Kathryn Slaney

Tywyn Town Council January 1, 2013  <? include ('user.inc');

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

$query="SELECT * FROM forthcoming"; $result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close(); $monthname[1]="Ionawr"; $monthname[2]="Chwefror"; $monthname[3]="Mawth"; $monthname[4]="Ebrill"; $monthname[5]="Mai"; $monthname[6]="Mehefin"; $monthname[7]="Gorffenaf"; $monthname[8]="Awst"; $monthname[9]="Medi"; $monthname[10]="Hydref"; $monthname[11]="Tachwedd"; $monthname[12]="Rhagfer"; echo"<h3><center>Digwyddiadau ar ddod</center></h3>"; for ($m=1; $m<=5; $m++)

Kathryn Slaney

Tywyn Town Council January 1, 2013 { echo"<h3>&nbsp;$monthname[$m]</h3>";

for ($i=0;$i<$num;$i++) {

</div> </div> </div>

Kathryn Slaney

Tywyn Town Council January 1, 2013 </div><div id="ft">  <p>Web Design by Kathryn Slaney ÂŠ Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

history.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<? include ('user.inc');

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

$query="SELECT * FROM history"; $result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close(); for ($i=0;$i<$num;$i++) { Kathryn Slaney

Tywyn Town Council January 1, 2013 $j=$i+1; $title[$j]=mysql_result($result,$i, "title"); $content[$j]=mysql_result($result,$i, "content"); $image[$j]=mysql_result($result,$i, "image"); } ?> </head> <body> <div id="custom-doc" class="yui-t4"> <div id="hd">  <img src="Tywyn.jpg" width="267" height="200" alt="Tywyn Crest" /> <img src="TTC.jpg" width="770" height="200" alt="Tywyn Council" /> <img id ="flowers" src="dafo.jpg" height="159" alt="dafodils" /> <div id='cssmenu'> <ul>

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

<li><a href='councillors.php'><span>Meet the Councillors</span></a></li> <li><a href='meetings.php'><span>Town Council Minutes</span></a></li> <li><a href='policy.php'><span>Policies & Procedures</span></a></li> <li><a href='ynys.php'><span>Ynysmaengwyn Trust</span></a></li> <li><a href='events.php'><span>Events</span></a></li> <li><a href='clubs.php'><span>Local Clubs & Services</span></a></li> <li><a href='contactus.php'><span>Contact Us</span></a></li>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <li><a href='index2.php'><img id="welsh" src="flag.GIF" width="27" height="27" alt="welsh flag" /></a> </li> </ul>

echo"<center> <div id='image2'>";

echo"<img src='$image[1]' width='400' />";

echo"</div></center>"; } ?>

Kathryn Slaney

Tywyn Town Council January 1, 2013

<? echo"<h2> $title[3] </h2>"; echo"<p align='justify'>";

echo"$content[3]"; echo"</p>"; if (strlen($image[3])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[3]' width='400' />";

echo"</div></center>"; } ?>

</div> <div class="yui-u">  <? echo"<h2> $title[2] </h2> "; echo"<p align='justify'>"; echo"$content[2]"; echo "</p>";

Kathryn Slaney

Tywyn Town Council January 1, 2013 if (strlen($image[2])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[2]' width='400' />";

echo"</div></center>"; } ?> <? echo"<h2> $title[4] </h2>"; echo"<p align='justify'>"; echo"$content[4]"; echo "</p>"; if (strlen($image[4])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[4]' width='400' />";

echo"</div></center>"; } ?>

</p>

Kathryn Slaney

Tywyn Town Council January 1, 2013 </div> </div> </div> </div> <div id="side-b"> <div class="yui-b">  <h3><center>Coming up</center></h3> <h4>&nbsp; &nbsp; January</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;February</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;March</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;April</h4>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;May</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> </div> </div> </div>

</div><div id="ft">  <p>Web Design by Kathryn Slaney ÂŠ Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

hanes.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Hanes Tywyn</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" /> </head>

Tywyn Town Council January 1, 2013 <li><a href='ynysmaen.php'><span>Ynysmaengwyn</span></a></li> <li><a href='events.php'><span>Digwyddiadau</span></a></li> <li><a href='clubs.php'><span>Clybiau a Gwasanaethau Lleol</span></a></li> <li><a href='cysylltuni.php'><span>Cysylltu 창 Ni</span></a></li>

</ul> </div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g"> <div class="yui-u first"> <br /> <br />  <h2> Hello </h2> <p> Lorem ipsum dolor sit amet, velit vulputate vel inceptos. Ac interdum libero nulla viverra dui condimentum, hac feugiat sapien facilisi ligula ut velit, vel turpis cras scelerisque mi elit at, odio elementum ipsum cum tempus eu ipsum. Lacus eu consequat nibh turpis libero scelerisque, qui elementum nonummy quam ut feugiat, sodales pellentesque. Lacinia vel semper in egestas aliquam, posuere magna eu erat. Enim commodo ipsam nulla in.</p> &nbsp; <h2> Hello </h2>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <p> Lorem ipsum dolor sit amet, velit vulputate vel inceptos. Ac interdum libero nulla viverra dui condimentum, hac feugiat sapien facilisi ligula ut velit, vel turpis cras scelerisque mi elit at, odio elementum ipsum cum tempus eu ipsum. Lacus eu consequat nibh turpis libero scelerisque, qui elementum nonummy quam ut feugiat, sodales pellentesque. Lacinia vel semper in egestas aliquam, posuere magna eu erat. Enim commodo ipsam nulla in. </p> </div> <div class="yui-u"> <br /> <br />  <h2> Hello </h2> <p> Lorem ipsum dolor sit amet, velit vulputate vel inceptos. Ac interdum libero nulla viverra dui condimentum, hac feugiat sapien facilisi ligula ut velit, vel turpis cras scelerisque mi elit at, odio elementum ipsum cum tempus eu ipsum. Lacus eu consequat nibh turpis libero scelerisque, qui elementum nonummy quam ut feugiat, sodales pellentesque. Lacinia vel semper in egestas aliquam, posuere magna eu erat. Enim commodo ipsam nulla in. </p> &nbsp;

<h2> Hello </h2> <p>Lorem ipsum dolor sit amet, velit vulputate vel inceptos. Ac interdum libero nulla viverra dui condimentum, hac feugiat sapien facilisi ligula ut velit, vel turpis cras scelerisque mi elit at, odio elementum ipsum cum tempus eu ipsum. </p> <center> <div id="image2"><img src="tally.jpg" width="200" height="129" alt="taly" /></div></center> </p> </div> </div>

Kathryn Slaney

Tywyn Town Council January 1, 2013 </div> </div> <div id="side-b"> <div class="yui-b">  <h3><center>Llawn Addewid</center></h3> <h4>&nbsp; &nbsp; Ionawr</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;Chewfror</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;Mawth</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;Ebrill</h4> <ul> <li>commodo ipsam nulla in</li>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;Mai</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> </div> </div> </div>

</div><div id="ft">  <p>Web Design by Kathryn Slaney ÂŠ Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

councillors.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Tywyn Councillors</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" />

</head> <body> <div id="custom-doc" class="yui-t4"> <div id="hd">  <img src="Tywyn.jpg" width="267" height="200" alt="Tywyn Crest" /> <img src="TTC.jpg" width="770" height="200" alt="Tywyn Council" /> <img id ="flowers" src="dafo.jpg" height="159" alt="dafodils" /> <div id='cssmenu'> <ul>

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <li><a href='councillors.php'><span>Meet the Councillors</span></a></li> <li><a href='meetings.php'><span>Town Council Minutes</span></a></li> <li><a href='policy.php'><span>Policies & Procedures</span></a></li> <li><a href='ynys.php'><span>Ynysmaengwyn Trust</span></a></li> <li><a href='events.php'><span>Events</span></a></li> <li><a href='clubs.php'><span>Local Clubs & Services</span></a></li> <li><a href='contactus.php'><span>Contact Us</span></a></li> <li><a href='index2.php'><img id="welsh" src="flag.GIF" width="27" height="27" alt="welsh flag" /></a> </li> </ul>

</div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g"> <div class="yui-u first">

<div id="event"> <center><h2>Cynghorwyr/Councillors</h2></center>

<table width="504" height="187" border="1"> <tr> <th width="100" bgcolor="#7fa208">Swydd/Position</th> <th width="105" bgcolor="#7fa208">Enw/Name</th> <th width="100" bgcolor="#7fa208">Cysylltu/Contact</th>

Kathryn Slaney

Tywyn Town Council January 1, 2013 </tr> <tr> <td>Council Clerk</td> <td>Mr Elwyn Evans</td> <td>email@email.com</td> </tr> <tr> <td>Chairperson</td> <td>Hilary Thomas</td> <td>email@email.com</td> </tr> <tr> <td>Treasurer</td> <td>Marcus Castle</td> <td>email@email.com</td> </tr> </table>

</div> </div> </div> </div> </div> </div> <div class="yui-b">

Kathryn Slaney

Tywyn Town Council January 1, 2013

</div> </div>

</div><div id="ft">  <p>Web Design by Kathryn Slaney ÂŠ Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

contactus.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Contact Us</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" />

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

Kathryn Slaney

</div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g"> <div class="yui-u first">  <h3>Contact Us</h3> <h5>For all enquiries please fill in the form below.</h5> </blockquote> <div id="contactform"> <blockquote> <form method="post" action="form-process.php"> <table border="0"> <tr>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <td>First name: </td> <td><input type="text" name="firstname" size="52"></td> </tr> <tr> <td>Last name:</td> <td> <input type="text" name="lastname" size="52" ></td> </tr> <tr> <td>Email:</td> <td> <input type ="text" name="email" size="52"/></td> </tr> <tr> <td>Subject:</td> <td> <input type="text" name="subject" size="52"/></td> </tr> <tr> <td>Message:</td> <td> <textarea name="comments" rows="10" cols="100"></textarea>

</td> </tr> <tr> <td></td> <td> <input type="submit" name="submit"> <input type="reset" value="reset" ></td>

Kathryn Slaney

Tywyn Town Council January 1, 2013 </tr> </table> </form> <h5>Your form will be sent to the council, who will contact you as soon as possible.</h5> </blockquote> </div> </div> <div class="yui-u">  <div id="googlemap"><iframe width="425" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.co.uk/maps?safe=active&amp;ie=UTF8&amp;q=tywyn+town+council &amp;fb=1&amp;gl=uk&amp;hq=council&amp;hnear=0x48657d1fba5e9093:0x35448de7e70b2 18c,Tywyn,+Gwynedd&amp;cid=0,0,14769153459509391822&amp;t=m&amp;ll=52.586392,4.089347&amp;spn=0.006295,0.006295&amp;output=embed"></iframe><br /><small><a href="https://maps.google.co.uk/maps?safe=active&amp;ie=UTF8&amp;q=tywyn+town+counci l&amp;fb=1&amp;gl=uk&amp;hq=council&amp;hnear=0x48657d1fba5e9093:0x35448de7e70b 218c,Tywyn,+Gwynedd&amp;cid=0,0,14769153459509391822&amp;t=m&amp;ll=52.586392,4.089347&amp;spn=0.006295,0.006295&amp;source=embed" style="color:#0000FF;textalign:left">View Larger Map</a></small></div> </div> </div> </div> </div> </div> <div class="yui-b">  <div id="contactus"> <p><img src="gb-w-tywyn.gif" alt="flag" width="160" height="95" align="left" /></p> <strong> &nbsp;Council Office<br /> &nbsp;High Street<br />

Kathryn Slaney

Tywyn Town Council January 1, 2013 &nbsp;Tywyn<br /> &nbsp;Gwynedd<br /> &nbsp;LL36 9AD<br /> </p> </blockquote> </strong> <p></p> <strong>

01654 712 411

</strong> <p></p> <strong>

tywyntowncouncil@btinternet.com</strong> </div>

</div> </div> <div id="ft">  <p>Web Design by Kathryn Slaney ÂŠ Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

cysylltuni.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Cysylltu a Ni</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" /> </head>

</ul> </div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g"> <div class="yui-u first"> <br /> <br />  <h3>Cysylltu 창 ni</h3> <h5>Ar gyfer pob ymholiad os gwelwch yn dda llenwch y ffurflen isod.</h5> </blockquote> <div id="contactform"> <blockquote> <form method="post" action="form-process.php"> <table border="0">

Kathryn Slaney

Tywyn Town Council January 1, 2013 <tr> <td>Enw Cyntaf: </td> <td><input type="text" name="firstname" size="52"></td> </tr> <tr> <td>Cyfenw:</td> <td> <input type="text" name="lastname" size="52" ></td> </tr> <tr> <td>Ebost:</td> <td> <input type ="text" name="email" size="52"/></td> </tr> <tr> <td>Pwnc:</td> <td> <input type="text" name="subject" size="52"/></td> </tr> <tr> <td>Neges:</td> <td> <textarea name="comments" rows="10" cols="100"></textarea>

</td> </tr> <tr> <td></td> <td> <input type="submit" name="submit">

Kathryn Slaney

Tywyn Town Council January 1, 2013 <input type="reset" value="reset" ></td> </tr> </table> </form> <h5>Bydd eich ffurflen yn cael ei hanfon at y cyngor, a fydd yn cysylltu 창 chi cyn gynted ag y bo modd.</h5> </blockquote> </div> </div> <div class="yui-u">  <div id="googlemap"><iframe width="425" height="350" frameborder="0" scrolling="no" marginheight="0" marginwidth="0" src="https://maps.google.co.uk/maps?safe=active&amp;ie=UTF8&amp;q=tywyn+town+council &amp;fb=1&amp;gl=uk&amp;hq=council&amp;hnear=0x48657d1fba5e9093:0x35448de7e70b2 18c,Tywyn,+Gwynedd&amp;cid=0,0,14769153459509391822&amp;t=m&amp;ll=52.586392,4.089347&amp;spn=0.006295,0.006295&amp;output=embed"></iframe><br /><small><a href="https://maps.google.co.uk/maps?safe=active&amp;ie=UTF8&amp;q=tywyn+town+counci l&amp;fb=1&amp;gl=uk&amp;hq=council&amp;hnear=0x48657d1fba5e9093:0x35448de7e70b 218c,Tywyn,+Gwynedd&amp;cid=0,0,14769153459509391822&amp;t=m&amp;ll=52.586392,4.089347&amp;spn=0.006295,0.006295&amp;source=embed" style="color:#0000FF;textalign:left">View Larger Map</a></small></div> </div> </div> </div> </div> </div> <div class="yui-b">  <div id="contactus"> <p><img src="gb-w-tywyn.gif" alt="flag" width="160" height="95" align="left" /></p>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <strong> Swyddfa'r Cyngor<br /> Stryd Fawr<br /> Tywyn<br /> Gwynedd<br /> LL36 9AD<br /> </blockquote> </strong> <p></p> <strong>

01654 712 411

</strong> <p></p> <strong>

email@email.com</strong> </div>

Kathryn Slaney

Tywyn Town Council January 1, 2013

checklogin.php <?php $host="localhost"; // Host name $username="web180-student19"; // Mysql username $password="xhtrtyycj"; // Mysql password $db_name="web180-student19"; // Database name $tbl_name="members"; // Table name

// Connect to server and select databse. mysql_connect("$host", "$username", "$password")or die("cannot connect"); mysql_select_db("$db_name")or die("cannot select DB");

// username and password sent from form $myusername=$_POST['myusername']; $mypassword=$_POST['mypassword'];

// To protect MySQL injection (more detail about MySQL injection) $myusername = stripslashes($myusername); $mypassword = stripslashes($mypassword); $myusername = mysql_real_escape_string($myusername); $mypassword = mysql_real_escape_string($mypassword); $sql="SELECT * FROM $tbl_name WHERE username='$myusername' and password='$mypassword'"; $result=mysql_query($sql);

// Mysql_num_row is counting table row $count=mysql_num_rows($result);

Kathryn Slaney

Tywyn Town Council January 1, 2013 // If result matched $myusername and $mypassword, table row must be 1 row if($count==1){

// Register $myusername, $mypassword and redirect to file "login_success.php" session_register("myusername"); session_register("mypassword"); header("location:login_success.php"); } else { echo "Wrong Username or Password"; } ?>

Kathryn Slaney

Tywyn Town Council January 1, 2013

clubs.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Local Clubs & Services</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" />

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

Kathryn Slaney

</div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g"> <div class="yui-u first">  <table border="1"> <? include ('user.inc');

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

$query="SELECT * FROM clubs";

Kathryn Slaney

Tywyn Town Council January 1, 2013 $result=mysql_query($query);

$num=mysql_numrows($result); mysql_close();

echo"<h2> Local Services & Clubs</h2>"; echo"<p><b>Links to External Websites for Clubs/Local Services</b>"; for ($i=0;$i<$num;$i++) {

$description=mysql_result($result,$i, "description"); $link=mysql_result($result,$i, "link"); echo"<li><tr><td>".$description." <p></td><td><a href='$link'>".$link."</td></tr></a></li>&nbsp;";

} ?> </table> </div> </div> </div> </div> <div id="side-b"> <div class="yui-b">  <? include ('user.inc');

Kathryn Slaney

Tywyn Town Council January 1, 2013

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

$query="SELECT * FROM forthcoming"; $result=mysql_query($query);

$num=mysql_numrows($result);

Kathryn Slaney

Tywyn Town Council January 1, 2013 for ($i=0;$i<$num;$i++) { $month=mysql_result($result,$i, "month"); if ($month == $m) { $date=mysql_result($result,$i, "date"); $description1=mysql_result($result,$i, "description1"); $description2=mysql_result($result,$i, "description2"); echo"<b><i>&nbsp;".$date."</i></b><br>"; echo "&nbsp;&nbsp;&nbsp;&nbsp;" .$description1."<br>"; if (strlen($description2)>0) echo "&nbsp;&nbsp;&nbsp;&nbsp;" .$description2."<br>"; } } echo"<br>"; } ?> </div> </div> </div> </div><div id="ft">  <p>Web Design by Kathryn Slaney ÂŠ Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

dref.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Cyngor Tywyn</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" /> </head>

Kathryn Slaney

</div><div id="ft">  <p>Web Design by Kathryn Slaney ÂŠ Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

edithomepage.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Homepage</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" /> </head>

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

<li><a href='councillors.php'><span>Meet the Councillors</span></a></li> Kathryn Slaney

Tywyn Town Council January 1, 2013 <li><a href='meetings.php'><span>Town Council Minutes</span></a></li> <li><a href='policy.php'><span>Policies & Procedures</span></a></li> <li><a href='ynys.php'><span>Ynysmaengwyn Trust</span></a></li> <li><a href='events.php'><span>Events</span></a></li> <li><a href='clubs.php'><span>Local Clubs & Services</span></a></li> <li><a href='contactus.php'><span>Contact Us</span></a></li> <li><a href='index2.php'><img id="welsh" src="flag.GIF" width="27" height="27" alt="welsh flag" /></a> </li> </ul>

</div> </div> <div id="block1"> <? include ('user.inc'); $newimage =$_REQUEST['newimage']; if ($newimage=='yes') {

$blockID =$_REQUEST['blockID']; if($_FILES['photo']['name']) {

//if no errors... if(!$_FILES['photo']['error']) { $file_name=$_FILES['photo']['name'];

Kathryn Slaney

Tywyn Town Council January 1, 2013 //move it to where we want it to be move_uploaded_file($_FILES['photo']['tmp_name'], $file_name);

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

$query="UPDATE homepage SET image='$file_name' WHERE blockID=$blockID"; $result=mysql_query($query);

mysql_close();

} //if there is an error...

}

} $save=$_REQUEST['save']; if($save=='yes') { $blockID=$_REQUEST['blockID']; $title=$_REQUEST['title']; $content=$_REQUEST['content']; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

Kathryn Slaney

Tywyn Town Council January 1, 2013

$query="UPDATE homepage SET title='$title', content='$content' WHERE blockID='$blockID'"; $result=mysql_query($query);

mysql_close(); echo "<font color=black>"; }

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database"); $query="SELECT * FROM homepage"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); for ($i=0; $i<$num;$i++) { $blockID=mysql_result($result,$i, "blockID"); if ($blockID==1) { $title=mysql_result($result,$i, "title"); $content=mysql_result($result,$i, "content"); $image=mysql_result($result,$i, "image");

echo "<Form method=post action=edithomepage.php>"; echo "<input type=text name=title value='$title'><p>"; echo "<textarea name=content cols=80 rows=20>"; echo $content;

Kathryn Slaney

Tywyn Town Council January 1, 2013 echo "</textarea>";

echo"<div id='block1a'>"; echo "<br><input type=submit value='Save Title/Text'>"; echo"</div>"; echo "<input type=hidden name=save value='yes'>"; echo "<input type=hidden name=blockID value='$blockID'>"; echo "</Form>";

echo "<p> <img src='$image' height=200px >"; echo "<form action=edithomepage.php method=post enctype='multipart/form-data'>"; echo "Your Photo: <input type=file name=photo size=25 />"; echo "<input type=submit name=submit value=Submit />"; echo "<input type=hidden name=newimage value='yes'>"; echo "<input type=hidden name=blockID value='$blockID'>"; echo "</form>"; } } ?> </div> </body>

</html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

edittextbox.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Untitled Document</title> </head>

<body> <? include ('user.inc'); $blockwanted=$_REQUEST['block']; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database"); $query="SELECT * FROM homepage"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close();

for ($i=0; $i<$num;$i++) { $blockID=mysql_result($result,$i, "blockID"); if ($blockID==$blockwanted) { $title=mysql_result($result,$i, "title"); $content=mysql_result($result,$i, "content"); $image=mysql_result($result,$i, "image"); Kathryn Slaney

Tywyn Town Council January 1, 2013 } }

echo"<table border = 0 cellpadding=10>"; echo"<tr><th>English</th>"; echo"<th>Cymraeg</th>"; echo"<tr><td>"; echo"<h2><input type=text value ='$title' size='70'></h2>"; echo "<textarea name=content cols=60 rows=12>"; echo $content; echo "</textarea>";

include ('user.inc'); $blockwanted=$_REQUEST['block']; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database"); $query="SELECT * FROM catref"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close();

for ($i=0; $i<$num;$i++) { $blockID=mysql_result($result,$i, "blockID"); if ($blockID==$blockwanted) { $title=mysql_result($result,$i, "title");

Kathryn Slaney

Tywyn Town Council January 1, 2013 $content=mysql_result($result,$i, "content"); $image=mysql_result($result,$i, "image"); } } echo"<td>"; echo"<h2><input type=text value ='$title' size='70'></h2>"; echo "<textarea name=content cols=60 rows=12>"; echo $content; echo "</textarea>";

echo"</table>";

echo"<p><center><img src='$image'></center>"; echo"<p><center><input type = file value = 'Select Image'></center>"; echo"<br><br><br><center><input type = submit value = 'Update All'></center>"; ?>

</body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

edittownhistory.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Town History</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" /> </head>

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

<li><a href='councillors.php'><span>Meet the Councillors</span></a></li> <li><a href='meetings.php'><span>Town Council Minutes</span></a></li> Kathryn Slaney

Tywyn Town Council January 1, 2013 <li><a href='policy.php'><span>Policies & Procedures</span></a></li> <li><a href='ynys.php'><span>Ynysmaengwyn Trust</span></a></li> <li><a href='events.php'><span>Events</span></a></li> <li><a href='clubs.php'><span>Local Clubs & Services</span></a></li> <li><a href='contactus.php'><span>Contact Us</span></a></li> <li><a href='index2.php'><img id="welsh" src="flag.GIF" width="27" height="27" alt="welsh flag" /></a> </li> </ul>

</div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g"> <div class="yui-u first">

<? include ('user.inc'); $save=$_REQUEST['save']; if($save=='yes') { $blockID=$_REQUEST['blockID']; $title=$_REQUEST['title']; $content=$_REQUEST['content']; mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

Kathryn Slaney

Tywyn Town Council January 1, 2013

$query="UPDATE history SET title='$title', content='$content' WHERE blockID='$blockID'"; $result=mysql_query($query);

mysql_close(); echo "<font color=black>"; }

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database"); $query="SELECT * FROM history"; $result=mysql_query($query); $num=mysql_numrows($result); mysql_close(); for ($i=0; $i<$num;$i++) { $blockID=mysql_result($result,$i, "blockID"); if ($blockID==1) { $title=mysql_result($result,$i, "title"); $content=mysql_result($result,$i, "content");

echo "<Form method=post action=edittownhistory.php>"; echo "<input type=text name=title value='$title'><p>"; echo "<textarea name=content cols=80 rows=20>"; echo $content; echo "</textarea>";

Kathryn Slaney

Tywyn Town Council January 1, 2013

echo "<form action=edittownhistory.php method=post enctype='multipart/form-data'>"; echo "<input type=submit name=submit value=Submit />"; echo "<input type=hidden name=blockID value='$blockID'>"; echo "</form>"; } } ?> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

engnews.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Tywyn Town History</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" /> <? include ('user.inc');

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

$query="SELECT * FROM history"; $result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close(); for ($i=0;$i<$num;$i++) { $j=$i+1; $title[$j]=mysql_result($result,$i, "title"); Kathryn Slaney

Tywyn Town Council January 1, 2013 $content[$j]=mysql_result($result,$i, "content"); $image[$j]=mysql_result($result,$i, "image"); } ?> </head> <body> <div id="custom-doc" class="yui-t4"> <div id="hd">  <img src="Tywyn.jpg" width="267" height="200" alt="Tywyn Crest" /> <img src="TTC.jpg" width="770" height="200" alt="Tywyn Council" /> <img id ="flowers" src="dafo.jpg" height="159" alt="dafodils" /> <div id='cssmenu'> <ul>

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

Kathryn Slaney

Tywyn Town Council January 1, 2013 </ul>

</p> </div> </div> </div> </div> <div id="side-b"> <div class="yui-b">  <h3><center>Coming up</center></h3>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <h4>&nbsp; &nbsp; January</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;February</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;March</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;April</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;May</h4> <ul> <li>commodo ipsam nulla in</li>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> </div> </div> </div>

</div><div id="ft">  <p>Web Design by Kathryn Slaney ÂŠ Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

events.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Tywyn Council - Events</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" />

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

Kathryn Slaney

</div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g"> <div class="yui-u first">  <div id="event"> <center><h2>Digwyddiadau/Events</h2></center>

<table width="504" height="187" border="1"> <tr> <th width="63" bgcolor="#7fa208">Mis/Month</th> <th width="305" bgcolor="#7fa208">Digwyddiad/Event</th> </tr>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <tr> <td>Ionawr/Janurary 2013</td> <td>row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2</td> </tr> <tr> <td>Chwefror/Feburary 2013</td> <td>row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2</td> </tr> <tr> <td>Mawth/March 2013</td> <td>row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2</td> </tr> <tr> <td>Ebrill/April 2013</td> <td>row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2</td> </tr> <tr> <td>Mai/May 2013</td> <td>row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2</td> </tr> <tr> <td>Mehefin/June 2013</td> <td>row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2</td> </tr> <tr> <td>Gorffennaf/July 2013</td> <td>row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2</td>

Kathryn Slaney

Tywyn Town Council January 1, 2013 </tr> <tr> <td>Awst/August 2013</td> <td>row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2</td> </tr> <tr> <td>Medi/September 2013</td> <td>row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2</td> </tr> <tr> <td>Hydref/October 2013</td> <td>row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2</td> </tr> <tr> <td>Tachwedd/November 2013</td> <td>row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2</td> </tr> <tr> <td>Rhagfyr/December 2013</td> <td>row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2<br />row 1, cell 2</td> </tr> </table> </div> </div> </div> </div> </div>

Kathryn Slaney

Tywyn Town Council January 1, 2013 </div> <div class="yui-b">  </div> </div>

</div><div id="ft">  <p>Web Design by Kathryn Slaney © Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

form-process.php <?php if (!isset($_POST['submit']) || $_SERVER['REQUEST_METHOD'] != "POST") { exit("<p>You did not press the submit button; this page should not be accessed directly.</p>"); } else { $exploits = “###Removed by Kate due to content"; $profanity = “###Removed by Kate due to content"; $spamwords = “###Removed by Kate due to content"; $bots = “###Removed by Kate due to content"; if (preg_match($bots, $_SERVER['HTTP_USER_AGENT'])) { exit("<p>Known spam bots are not allowed.</p>"); } foreach ($_POST as $key => $value) { $value = trim($value);

if (empty($value)) { exit("<p>Empty fields are not allowed. Please go back and fill in the form properly.</p>"); } elseif (preg_match($exploits, $value)) { exit("<p>Exploits/malicious scripting attributes aren't allowed.</p>"); } elseif (preg_match($profanity, $value) || preg_match($spamwords, $value)) { exit("<p>That kind of language is not allowed through our form.</p>"); }

$_POST[$key] = stripslashes(strip_tags($value)); }

Kathryn Slaney

Tywyn Town Council January 1, 2013 if (!ereg("^[_a-z0-9-]+(.[_a-z0-9-]+)*@[a-z0-9-]+(.[a-z0-9-]+)*(.[az]{2,6})$",strtolower($_POST['email']))) { exit("<p>That e-mail address is not valid, please use another.</p>"); }

$recipient = "slaneyk@gmail.com"; $subject = "Contact Form Mail";

$message = "You've received an e-mail through your website mail form: \n"; $message .= "Name: {$_POST['firstname']} \n"; $message .= "Name: {$_POST['lastname']} \n"; $message .= "E-mail: {$_POST['email']} \n"; $message .= "Country: {$_POST['subject']} \n"; $message .= "Feedback: {$_POST['comments']} \n";

$headers = "From: YOUR WEBSITE NAME <$recipient> \n"; $headers .= "Reply-To: <{$_POST['email']}>";

if (mail($recipient,$subject,$message,$headers)) { echo "<p>Thank you! Your mail was successfully sent to the webmaster. Thank you for your time.</p>"; } else { echo "<p>Sorry, there was an error and your mail was not sent. Please find an alternative method of contacting the webmaster.</p>"; } } ?>

Kathryn Slaney

Tywyn Town Council January 1, 2013

homepagetest.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

$query="SELECT * FROM homepage"; $result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close(); for ($i=0;$i<$num;$i++) { $j=$i+1; $title[$j]=mysql_result($result,$i, "title"); Kathryn Slaney

Tywyn Town Council January 1, 2013 $content[$j]=mysql_result($result,$i, "content"); $image[$j]=mysql_result($result,$i, "image"); } ?> </head> <body> <div id="custom-doc" class="yui-t4"> <div id="hd">  <img src="Tywyn.jpg" width="267" height="200" alt="Tywyn Crest" /> <img src="TTC.jpg" width="450" height="200" alt="Tywyn Council" /> <img id ="flowers" src="dafo.jpg" height="159" alt="dafodils" /> <div id='cssmenu'> <ul>

<li><a href='index.php'><span>Home</span></a></li> <li><a href='town.php'><span>Town History</span></a></li> <li><a href='#'><span>Town Council</span></a></li>

<li><a href='ynys.php'><span>Ynysmaengwyn Trust</span></a></li> <li><a href='events.php'><span>Events</span></a></li>

Kathryn Slaney

Tywyn Town Council January 1, 2013

<li><a href='local.php'><span>Local Clubs & Services</span></a></li>  <li><a href='contactus.php'><span>Contact Us</span></a></li> <li><a href='index2.php'><img id="welsh" src="flag.GIF" width="27" height="27" alt="welsh flag" /></a> </li>

</ul>

</ul> </div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g"> <div class="yui-u first">  <? echo"<h2> $title[1] </h2>"; echo"<p>$content[1]</p>"; if (strlen($image[1])>0)

Kathryn Slaney

Tywyn Town Council January 1, 2013 {

echo"<center> <div id='image2'>";

echo"<img src='$image[1]' width='200' height='129' />";

echo"</div></center>"; } ?> &nbsp; <? echo"<h2> $title[2] </h2> "; echo"<p>$content[2]</p>";

if (strlen($image[2])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[2]' width='200' height='129' />";

echo"</div></center>"; } ?>

</div> <div class="yui-u">

Kathryn Slaney

Tywyn Town Council January 1, 2013  <? echo"<h2> $title[3] </h2>"; echo"<p> $content[3]</p>"; if (strlen($image[3])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[3]' width='200' height='129' />";

echo"</div></center>"; } ?>

&nbsp; <? echo"<h2> $title[4] </h2>"; echo"<p>$content[4]</p>"; if (strlen($image[4])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[4]' width='200' height='129' />";

echo"</div></center>";

Kathryn Slaney

Tywyn Town Council January 1, 2013 } ?>

</p> </div> </div> </div> </div> <div id="side-b"> <div class="yui-b">  <h3><center>Coming up</center></h3> <h4>&nbsp; &nbsp; January</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;February</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;March</h4> <ul> <li>commodo ipsam nulla in</li>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;April</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;May</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> </div> </div> </div>

</div><div id="ft">  <p>Web Design by Kathryn Slaney ÂŠ Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

login.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Login</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" />

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

Kathryn Slaney

</div> </div>

<center><h1>Login</h1></center> <table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC"> <tr> <form name="form1" method="post" action="checklogin.php"> <td> <table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF"> <tr> <td colspan="3"><strong>Member Login </strong></td> </tr> <tr> <td width="78">Username</td> <td width="6">:</td>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <td width="294"><input name="myusername" type="text" id="myusername"></td> </tr> <tr> <td>Password</td> <td>:</td> <td><input name="mypassword" type="text" id="mypassword"></td> </tr> <tr> <td>&nbsp;</td> <td>&nbsp;</td> <td><input type="submit" name="Submit" value="Login"> <input type="reset" value="reset" ></td> </tr> </table> </td> </form> </tr> </table>

</div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

login_success.php <?php session_start(); if(!session_is_registered(myusername)){ header("location:main_login.php"); } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<title>Administration/Gweinyddiad</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" />

Tywyn Town Council January 1, 2013 <img id ="flowers" src="dafo.jpg" height="159" alt="dafodils" /> <div id='cssmenu'> <ul>

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

</div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g"> <div class="yui-u first">

Kathryn Slaney

Tywyn Town Council January 1, 2013 <div class="yui-u">  <div id="staff"> <h3> <center>Administration/Gweinyddiad</center> </h3> <table border=0 cellpadding=10 width="450"> <tr> <form method=post action=editindex.php> <td> <input type=submit value="

"class = "button">

</td> </form> <td> Edit Homepage/Newid Hafan </td> </tr> <tr> <form method=post action=edittownhistory.php> <td> <input type=submit value="

</td> </form> <td> Edit Town History/Newid Hanes </td> </tr> <tr> <form method=post action=editSurroundingArea.php>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <td> <input type=submit value="

</td> </form> <td> Edit Coming Up/Llawn Addewid </td> </tr> <tr> <form method=post action=viewBookingsRecieved.php> <td> <input type=submit value="

</td> </form> <td> Edit Councillors/Newid Cynghorydd </td> </tr> <tr> <form method=post action=editAvailability.php> <td> <input type=submit value="

</td> </form> <td> Upload Minutes/Llwytho i Fyny Cofnodiau </td>

Kathryn Slaney

Tywyn Town Council January 1, 2013 </tr> <tr> <form method=post action=editGallery.php> <td> <input type=submit value="

</td> </form> <td> Upload Policies/Llwytho i Fyny Polisiau </td> </tr> <tr> <form method=post action=Index.html> <td> <input type=submit value="

</td> </form> <td> Edit Ynysmaengwyn/Newid Ynysmaengwyn </td> </tr> <tr> <form method=post action=Index.html> <td> <input type=submit value="

</td> </form>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <td> Edit Events/Newid Digwyddiadau </td> </tr> <tr> <form method=post action=Index.html> <td> <input type=submit value="

</td> </form> <td> Edit Local Clubs & Services/ Newid Clwbiau a Gwasanaethiau Lleol </td> </tr> <tr> <form method=post action=Index.html> <td> <input type=submit value="

</td> </form> <td> Edit Contact Us/ Newid Cysylltu a Ni </td> </tr> <tr> <form method=post action=index.php> <td>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <input type=submit value="

</td> </form> <td> Logout/Allgofnodi </td> </tr> </table>

</div> </div> </div> </div>

<br /> <div id="ft">  <p>Web Design by Kathryn Slaney &copy; Tywyn Town Council 2013 &nbsp;-&nbsp;</p> </div> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

logout.php <?php session_start(); session_destroy(); ?>

Kathryn Slaney

Tywyn Town Council January 1, 2013

meetings.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Meeting Minutes</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" />

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

<li><a href='councillors.php'><span>Meet the Councillors</span></a></li> Kathryn Slaney

</div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g"> <div class="yui-u first">  <div id="content1"> <h2> Cyfarfodydd/Meetings </h2> <p>Cynhelir cyfarfodydd ar ddydd Mawrth cyntaf o bob mis yn y llyfrgell yn Ysgol UwchraddTywyn.</p> Meetings are held on the first Tuesday of every month in the library at Ysgol Uwchradd Tywyn. </p> <br /> &nbsp;<li>commodo ipsam nulla in <a href="blah.html"><span>Cyfarfod/Meeting 16/01/2012</span></a></li>&nbsp;

Kathryn Slaney

Tywyn Town Council January 1, 2013 <li>commodo ipsam nulla in <a href="blah.html"><span>Cyfarfod/Meeting 16/02/2012</span></a></li>&nbsp; <li>commodo ipsam nulla in <a href="blah.html"><span>Cyfarfod/Meeting 16/03/2012</span></a></li>&nbsp; <li>commodo ipsam nulla in <a href="blah.html"><span>Cyfarfod/Meeting 16/04/2012</span></a></li>&nbsp; <li>commodo ipsam nulla in <a href="blah.html"><span>Cyfarfod/Meeting 16/05/2012</span></a></li>&nbsp; <li>commodo ipsam nulla in <a href="blah.html"><span>Cyfarfod/Meeting 16/06/2012</span></a></li>&nbsp; <li>commodo ipsam nulla in <a href="blah.html"><span>Cyfarfod/Meeting 16/07/2012</span></a></li>&nbsp; <li>commodo ipsam nulla in <a href="blah.html"><span>Cyfarfod/Meeting 16/08/2012</span></a></li>&nbsp; <li>commodo ipsam nulla in <a href="blah.html"><span>Cyfarfod/Meeting 16/09/2012</span></a></li>&nbsp; </div> <div class="yui-u">

<div id="notebook"><img src="notebook.jpg" width="600" height="400" alt="meeting minutes image" /></div> </div> </div><div id="ft">  <p>Web Design by Kathryn Slaney ÂŠ Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

newyddion.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Hanes Tywyn</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" /> </head>

Kathryn Slaney

</div><div id="ft">  <p>Web Design by Kathryn Slaney ÂŠ Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

policy.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Policies & Procedures</title> <link rel="stylesheet" type="text/css" href="menu.css"> <link rel="stylesheet" type="text/css" href="reset-fonts-grids.css"> <link rel="stylesheet" type="text/css" href="base.css"> <link href="ttc.css" rel="stylesheet" type="text/css" /> </head>

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

<li><a href='councillors.php'><span>Meet the Councillors</span></a></li> <li><a href='meetings.php'><span>Town Council Minutes</span></a></li> Kathryn Slaney

</div> </div> <div id="bd"> <div id="yui-main"> <div class="yui-b"> <div class="yui-g"> <div class="yui-u first">  <div id="content1"> <br/><br/> <? include ('user.inc');

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

$query="SELECT * FROM documents"; $result=mysql_query($query);

Kathryn Slaney

Tywyn Town Council January 1, 2013

$num=mysql_numrows($result); mysql_close();

echo"<h2> Polisïau a Gweithdrefnau/Policies & Procedures</h2>"; echo"<p><b>Polisïau a Gweithdrefnau/Policies & Procedures PDF's:</b></p><br>"; for ($i=0;$i<$num;$i++) { $description=mysql_result($result,$i, "description"); $link=mysql_result($result,$i, "link"); echo"<li>".$description. "&nbsp;&nbsp;&nbsp;<a href='$link'>".$link."</a></li>&nbsp;"; } ?> </div> <div class="yui-u">

<br /><br /><br /><div id="image3"><img src="policies.jpg" width="580" height="254" alt="policies" /></div></div> </div><br /><div id="ft">  <br /> <p>Web Design by Kathryn Slaney © Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

ynys.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">

<? include ('user.inc');

mysql_connect(localhost,$username,$password); @mysql_select_db($database) or die ("unable to select database");

$query="SELECT * FROM ynys"; $result=mysql_query($query);

$num=mysql_numrows($result);

mysql_close(); for ($i=0;$i<$num;$i++) { Kathryn Slaney

<li><a href='index.php'><span>Home</span></a></li> <li><a href='history.php'><span>Town History</span></a></li>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <li><a href='index2.php'><img id="welsh" src="flag.GIF" width="27" height="27" alt="welsh flag" /></a> </li> </ul>

echo"<center> <div id='image2'>";

echo"<img src='$image[1]' width='400' />";

echo"</div></center>"; } ?>

Kathryn Slaney

Tywyn Town Council January 1, 2013 &nbsp;

</div> <div class="yui-u">  <? echo"<h2> $title[3] </h2>"; echo"<p> $content[3]</p>"; if (strlen($image[3])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[3]' width='400' />";

echo"</div></center>"; } ?> </br> <? echo"<h2> $title[4] </h2>"; echo"<p>$content[4]</p>"; if (strlen($image[4])>0) {

echo"<center> <div id='image2'>";

Kathryn Slaney

Tywyn Town Council January 1, 2013 echo"<img src='$image[4]' width='400' />";

echo"</div></center>"; } ?>

<? echo"<h2> $title[5] </h2>"; echo"</br>"; echo"<center>$content[5]</center>";

if (strlen($image[5])>0) {

echo"<center> <div id='image2'>";

echo"<img src='$image[4]' width='400' />";

echo"</div></center>"; } ?>

</p> </div> </div> </div> </div>

Kathryn Slaney

Tywyn Town Council January 1, 2013 <div id="side-b"> <div class="yui-b">  <h3><center>Coming up</center></h3> <h4>&nbsp; &nbsp; January</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;February</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;March</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> <h4>&nbsp;&nbsp;April</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li>

Kathryn Slaney

Tywyn Town Council January 1, 2013 </ul> <h4>&nbsp;&nbsp;May</h4> <ul> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> <li>commodo ipsam nulla in</li> </ul> </div> </div> </div>

</div><div id="ft">  <p>Web Design by Kathryn Slaney ÂŠ Tywyn Town Council 2013 &nbsp;-&nbsp;<a href='login.php'><span>Login</span></a></p> </div> </body> </html>

Kathryn Slaney

Tywyn Town Council January 1, 2013

user.inc <? $username="web180-student19"; $password="xhtrtyycj"; $database="web180-student19"; ?>

Kathryn Slaney

Tywyn Town Council January 1, 2013

CSS base.css /*Copyright (c) 2008, Yahoo! Inc. All rights reserved. Code licensed under the BSD License: http://developer.yahoo.net/yui/license.txt version: 2.5.1 */ /* base.css, part of YUI's CSS Foundation */ h1 { /*18px via YUI Fonts CSS foundation*/ font-size:138.5%; } h2 { /*16px via YUI Fonts CSS foundation*/ font-size:123.1%; } h3 { /*14px via YUI Fonts CSS foundation*/ font-size:108%; } h1,h2,h3 { /* top & bottom margin based on font size */ margin:1em 0; } h1,h2,h3,h4,h5,h6,strong { /*bringing boldness back to headers and the strong element*/ font-weight:bold;

Kathryn Slaney

Tywyn Town Council January 1, 2013 } abbr,acronym { /*indicating to users that more info is available */ border-bottom:1px dotted #000; cursor:help; } em { /*bringing italics back to the em element*/ font-style:italic; } blockquote,ul,ol,dl { /*giving blockquotes and lists room to breath*/ margin:1em; } ol,ul,dl { /*bringing lists on to the page with breathing room */ margin-left:2em; } ol li { /*giving OL's LIs generated numbers*/ list-style: decimal outside; } ul li { /*giving UL's LIs generated disc markers*/ list-style: disc outside; } dl dd {

Kathryn Slaney

Tywyn Town Council January 1, 2013 /*giving UL's LIs generated numbers*/ margin-left:1em; } th { /*distinguishing table headers from data cells*/ font-weight:bold; text-align:center; } caption { /*coordinated margin to match cell's padding*/ margin-bottom:.5em; /*centered so it doesn't blend in to other content*/ text-align:center; } p,fieldset,table,pre { /*so things don't run into each other*/ margin-bottom:1em; } /* setting a consistent width, 160px; control of type=file still not possible */ input[type=text],input[type=password],textarea{ width: 20.5em;

*width:11.9em;}

Kathryn Slaney

Tywyn Town Council January 1, 2013

menu.css #cssmenu{ /*Size of text area*/

text-align:left; /* leave unchanged */ width:66.25em;/* non-IE */ *width:79.50em;/* IE */

}

#cssmenu{ height:37px; width:96em; display:block; padding:0; margin:0px auto; border:1px solid; border-radius:5px; margin-top: 0px; } #cssmenu > ul {list-style:inside none; padding:0; margin:0; } #cssmenu > ul > li {list-style:inside none; padding:0; margin:0; float:left; display:block; position:relative; } #cssmenu > ul > li > a{ outline:none; display:block; position:relative; padding:12px 20px; font:bold 11px/100% Arial, Helvetica, sans-serif; text-align:center; text-decoration:none; textshadow:1px 1px 0 rgba(0,0,0, 0.4); }

#welsh { outline:none; display:block; text-align:center; text-decoration:none; height:13px; } /*added2*/

#cssmenu > ul > li:first-child > a{border-radius:5px 0 0 5px;} #cssmenu > ul > li > a:after{ content:''; top:-1px; bottom:-1px; right:-2px; z-index:99; } #cssmenu > ul > li.welsh > a:after{ content:''; border-right:0px solid; top:-1px; bottom:-1px; right:-2px; z-index:99; } /*added2*/

#cssmenu ul li.has-sub:hover > a:after{top:0; bottom:0;} #cssmenu > ul > li.has-sub > a:before{ content:''; position:absolute; top:18px; right:6px; border:5px solid transparent; border-top:5px solid #fff; } #cssmenu > ul > li.has-sub:hover > a:before{top:19px;}

Kathryn Slaney

Tywyn Town Council January 1, 2013 #cssmenu ul li.has-sub:hover > a{ background:#3f3f3f; border-color:#3f3f3f; paddingbottom:13px; padding-top:13px; top:-1px; z-index:999; } #cssmenu ul li.has-sub:hover > ul, #cssmenu ul li.has-sub:hover > div{display:block;} #cssmenu ul li.has-sub > a:hover{background:#3f3f3f; border-color:#3f3f3f;} #cssmenu ul li > ul, #cssmenu ul li > div{ display:none; width:auto; position:absolute; top:38px; padding:10px 0; background:#3f3f3f; border-radius:0 0 5px 5px; z-index:999; } #cssmenu ul li > ul{width:200px;} #cssmenu ul li > ul li{display:block; list-style:inside none; padding:0; margin:0; position:relative;} #cssmenu ul li > ul li a{ outline:none; display:block; position:relative; margin:0; padding:8px 20px; font:10pt Arial, Helvetica, sans-serif; color:#fff; text-decoration:none; text-shadow:1px 1px 0 rgba(0,0,0, 0.5); } #cssmenu, #cssmenu > ul > li > ul > li a:hover{ background:#97c20a; background:-moz-lineargradient(top, #97c20a 0%, #8da408 100%); background:-webkit-gradient(linear, left top, left bottom, color-stop(0%,#97c20a), color-stop(100%,#8da408)); background:-webkit-lineargradient(top, #97c20a 0%,#8da408 100%); background:-o-linear-gradient(top, #97c20a 0%,#8da408 100%); background:-ms-linear-gradient(top, #97c20a 0%,#8da408 100%); background:linear-gradient(top, #97c20a 0%,#8da408 100%); filter:progid:DXImageTransform.Microsoft.gradient( startColorstr='#97c20a', endColorstr='#8da408',GradientType=0 ); } #cssmenu{border-color:#647306;} #cssmenu > ul > li > a{border-right:1px solid #647306; color:#fff;} #cssmenu > ul > li.welsh > a{border-right:0px solid #647306; color:#fff;} /*added2*/ #cssmenu > ul > li > a:after{border-color:#c2f224;} #cssmenu > ul > li > a:hover{background:#7fa208;} /* #cssmenu li.welsh a{border-right:1px solid #647306; color:#fff;} #last li.welsh{border-color:#647306;} #last li.welsh > ul > li > a{border-right:1px solid #647306; color:#fff;} #last li.welsh> ul > li > a:after{border-color:#c2f224;} #last li.welsh > ul > li > a:hover{background:#7fa208;} */

Kathryn Slaney

Tywyn Town Council January 1, 2013

reset-fonts-grids.css /* Copyright (c) 2008, Yahoo! Inc. All rights reserved. Code licensed under the BSD License: http://developer.yahoo.net/yui/license.txt version: 2.5.1 */ html{color:#000; padding:1em; backgroundimage:url('background2.gif');}body,div,dl,dt,dd,ul,ol,li,h1,h2,h3,h4,h5,h6,pre,code,form,fieldset, legend,input,textarea,p,blockquote,th,td{margin:0;padding:0;}table{bordercollapse:collapse;borderspacing:0;}fieldset,img{border:0;}address,caption,cite,code,dfn,em,strong,th,var{fontstyle:normal;font-weight:normal;}li{list-style:none;}caption,th{textalign:left;}h1,h2,h3,h4,h5,h6{font-size:100%;fontweight:normal;}q:before,q:after{content:'';}abbr,acronym {border:0;font-variant:normal;}sup {vertical-align:text-top;}sub {vertical-align:text-bottom;}input,textarea,select{fontfamily:inherit;font-size:inherit;font-weight:inherit;}input,textarea,select{*fontsize:100%;}legend{color:#000;}body {font:13px/1.231 arial,helvetica,clean,sans-serif;*fontsize:small;*font:x-small;}table {font-size:inherit;font:100%;}pre,code,kbd,samp,tt{fontfamily:monospace;*font-size:108%;line-height:100%;} body{text-align:center; /*white box*/ background:#FFF; margin:auto; text-align:left; /* leave unchanged */ width:96.82em;/* non-IE */ *width:87.38em;/* IE */ /*min-width:600px; optional but recommended */

;} #ft{clear:both;}

Kathryn Slaney

Tywyn Town Council January 1, 2013 #bd{ padding:1em; } #custom-doc { /*Size of text area*/ margin:auto; height:70em; text-align:left; /* leave unchanged */ width:96.82em;/* non-IE */ *width:87.38em;/* IE */ } #doc,#doc2,#doc3,#doc4,.yui-t1,.yui-t2,.yui-t3,.yui-t4,.yui-t5,.yui-t6,.yui-t7{margin:auto;textalign:left;width:57.69em;*width:56.25em;minwidth:750px;}#doc2{width:73.076em;*width:71.25em;}#doc3{margin:auto 10px;width:auto;}#doc4{width:74.923em;*width:73.05em;}.yui-b{position:relative;}.yuib{_position:static;}#yui-main .yui-b{position:static;}#yui-main{width:100%;}.yui-t1 #yuimain,.yui-t2 #yui-main,.yui-t3 #yui-main{float:right;margin-left:-25em;}.yui-t4 #yui-main,.yui-t5 #yui-main,.yui-t6 #yui-main{float:left;margin-right:-25em;}.yui-t1 .yuib{float:left;width:12.30769em;*width:12.00em;}.yui-t1 #yui-main .yui-b{marginleft:13.30769em;*margin-left:13.05em;}.yui-t2 .yuib{float:left;width:13.8461em;*width:13.50em;}.yui-t2 #yui-main .yui-b{marginleft:14.8461em;*margin-left:14.55em;}.yui-t3 .yuib{float:left;width:23.0769em;*width:22.50em;}.yui-t3 #yui-main .yui-b{marginleft:24.0769em;*margin-left:23.62em;}.yui-t4 .yuib{float:right;width:13.8456em;*width:13.50em;}.yui-t4 #yui-main .yui-b{marginright:14.8456em;*margin-right:14.55em;}.yui-t5 .yuib{float:right;width:18.4615em;*width:18.00em;}.yui-t5 #yui-main .yui-b{marginright:19.4615em;*margin-right:19.125em;}.yui-t6 .yuib{float:right;width:23.0769em;*width:22.50em;}.yui-t6 #yui-main .yui-b{marginright:24.0769em;*margin-right:23.62em;}.yui-t7 #yui-main .yui-b{display:block;margin:0 0 1em 0;}#yui-main .yui-b{float:none;width:auto;}.yui-gb .yui-u,.yui-g .yui-gb .yui-u,.yui-gb .yui-g,.yuigb .yui-gb,.yui-gb .yui-gc,.yui-gb .yui-gd,.yui-gb .yui-ge,.yui-gb .yui-gf,.yui-gc .yui-u,.yui-gc .yuig,.yui-gd .yui-u{float:left;}.yui-g .yui-u,.yui-g .yui-g,.yui-g .yui-gb,.yui-g .yui-gc,.yui-g .yui-gd,.yui-g .yui-ge,.yui-g .yui-gf,.yui-gc .yui-u,.yui-gd .yui-g,.yui-g .yui-gc .yui-u,.yui-ge .yui-u,.yui-ge .yuig,.yui-gf .yui-g,.yui-gf .yui-u{float:right;}.yui-g div.first,.yui-gb div.first,.yui-gc div.first,.yui-gd div.first,.yui-ge div.first,.yui-gf div.first,.yui-g .yui-gc div.first,.yui-g .yui-ge div.first,.yui-gc div.first div.first{float:left;}.yui-g .yui-u,.yui-g .yui-g,.yui-g .yui-gb,.yui-g .yui-gc,.yui-g .yui-gd,.yui-g .yui-

Kathryn Slaney

Tywyn Town Council January 1, 2013 ge,.yui-g .yui-gf{width:49.1%;}.yui-gb .yui-u,.yui-g .yui-gb .yui-u,.yui-gb .yui-g,.yui-gb .yui-gb,.yuigb .yui-gc,.yui-gb .yui-gd,.yui-gb .yui-ge,.yui-gb .yui-gf,.yui-gc .yui-u,.yui-gc .yui-g,.yui-gd .yuiu{width:32%;margin-left:1.99%;}.yui-gb .yui-u{*margin-left:1.9%;*width:31.9%;}.yui-gc div.first,.yui-gd .yui-u{width:66%;}.yui-gd div.first{width:32%;}.yui-ge div.first,.yui-gf .yuiu{width:74.2%;}.yui-ge .yui-u,.yui-gf div.first{width:24%;}.yui-g .yui-gb div.first,.yui-gb div.first,.yui-gc div.first,.yui-gd div.first{margin-left:0;}.yui-g .yui-g .yui-u,.yui-gb .yui-g .yui-u,.yuigc .yui-g .yui-u,.yui-gd .yui-g .yui-u,.yui-ge .yui-g .yui-u,.yui-gf .yui-g .yuiu{width:49%;*width:48.1%;*margin-left:0;}.yui-g .yui-gb div.first,.yui-gb .yui-gb div.first{*margin-right:0;*width:32%;_width:31.7%;}.yui-g .yui-gc div.first,.yui-gd .yuig{width:66%;}.yui-gb .yui-g div.first{*margin-right:4%;_margin-right:1.3%;}.yui-gb .yui-gc div.first,.yui-gb .yui-gd div.first{*margin-right:0;}.yui-gb .yui-gb .yui-u,.yui-gb .yui-gc .yuiu{*margin-left:1.8%;_margin-left:4%;}.yui-g .yui-gb .yui-u{_margin-left:1.0%;}.yui-gb .yui-gd .yui-u{*width:66%;_width:61.2%;}.yui-gb .yui-gd div.first{*width:31%;_width:29.5%;}.yui-g .yuigc .yui-u,.yui-gb .yui-gc .yui-u{width:32%;_float:right;margin-right:0;_margin-left:0;}.yui-gb .yuigc div.first{width:66%;*float:left;*margin-left:0;}.yui-gb .yui-ge .yui-u,.yui-gb .yui-gf .yuiu{margin:0;}.yui-gb .yui-gb .yui-u{_margin-left:.7%;}.yui-gb .yui-g div.first,.yui-gb .yui-gb div.first{*margin-left:0;}.yui-gc .yui-g .yui-u,.yui-gd .yui-g .yui-u{*width:48.1%;*margin-left:0;}s .yui-gb .yui-gd div.first{width:32%;}.yui-g .yui-gd div.first{_width:29.9%;}.yui-ge .yuig{width:24%;}.yui-gf .yui-g{width:74.2%;}.yui-gb .yui-ge div.yui-u,.yui-gb .yui-gf div.yuiu{float:right;}.yui-gb .yui-ge div.first,.yui-gb .yui-gf div.first{float:left;}.yui-gb .yui-ge .yui-u,.yuigb .yui-gf div.first{*width:24%;_width:20%;}.yui-gb .yui-ge div.first,.yui-gb .yui-gf .yuiu{*width:73.5%;_width:65.5%;}.yui-ge div.first .yui-gd .yui-u{width:65%;}.yui-ge div.first .yui-gd div.first{width:32%;}#bd:after,.yui-g:after,.yui-gb:after,.yui-gc:after,.yui-gd:after,.yuige:after,.yui-gf:after{content:".";display:block;height:0;clear:both;visibility:hidden;}#bd,.yuig,.yui-gb,.yui-gc,.yui-gd,.yui-ge,.yui-gf{zoom:1;}

Kathryn Slaney

Tywyn Town Council January 1, 2013

ttc.css /* CSS Document */ #side-b{ float:right; width:auto; color:#000; border-style:solid; border-color:#98bf21; border-width: medium;

} #notebook{ margin-left:29.7em; margin-top: -17.2em; opacity:0.4; filter:alpha(opacity=40); postion:; } #image3{ margin-left:31em; margin-top:17em; opacity:0.4; filter:alpha(opacity=40); postion:absolute; } #contactform{ font-size:13px;

Kathryn Slaney

Tywyn Town Council January 1, 2013 display:block; border: none; } #contactus{ background: #97c20a; padding:1em; margin-top:2em; width:25em; margin-left:-13.2em; } #googlemap{ margin-left:5em; margin-top:4em; } a:link { COLOR: #00C; } a:visited { COLOR: #000; } a:hover { COLOR: #000; } a:active { COLOR: #000; } #img5{

Kathryn Slaney

Tywyn Town Council January 1, 2013 position:center; margin-right: 32px; float: right; padding:2px; } #staff { margin-left:5em; border-color: transparent; } #cal{ margin-left:10em; } #image4{ opacity:0.4; filter:alpha(opacity=40); margin-top:10em; float:left; } #event{ margin-left:27em; } #block1{ float:left; } #block1a{ float:left; padding:20px;}

Kathryn Slaney