I am creating a website for a friend that lists all upcoming events. In the course of time, my friend will need to update the info on that page (remove old events, add new events) by himself. Do i need to create a database table for that? And then, how can i link it to my webpage? I am using a template for all the common features on all my pages and have editable regions for the content of each page.
And last question, how can I give access to my friend to be able to himself update information presented on his website?
I'd appreciate any help/ideas.
What you need to look into is called a Content Management System. There are plenty of offerings out there, just a matter of personal taste of setting up. Much more powerful that a DW template and it will allow you to give them access without your friend needing Dreamweaver:
CMS Made Simple - http://www.cmsmadesimple.org/
PyroCMS - http://www.pyrocms.com/
Wordpress - http://wordpress.org/
Drupal - http://drupal.org/
Joomla - http://www.joomla.org/
Perch - https://grabaperch.com/
Concrete - http://www.concrete5.org/
Those are all PHP ones. If you need ASP just post back and a list can be provided.
Thanks for the list, I have no experience with CMS yet. But I'm guessing this doesn't mean that I have to throw away all that I did in Dreamweaver, right? Can I use CMS only for info updating and keep all the designing within dw?
Cushy CMS might be all you need for this project. Watch their video to see how.
If you use a real CMS like WordPress, Drupal, Joomla or Concrete5, you would not need Dreamweaver to maintain the site. Page creation and updates are performed in your browser by logging in to the CMS's admin panel.
Alt-Web Design & Publishing
Web | Graphics | Print | Media Specialists
Can I use CushyCMS locally? I couldn't find that info on their website...
Only if your local website is publically accessible on the web.
Cushy is remotely hosted and needs access to your code to allow others to make edits.
Can I use CushyCMS locally?
No. Cushy CMS requires you to:
a) register at their site,
b) add Cushy div tags to your HTML code,
c) Upload your Cushy editable page to a designated folder (Cushy) on your server.
For obvious security reasons, you wouldn't want to allow access to your entire site.
Your client can log-in at Cushy.com to edit their web pages.
I have a working demo you can try below:
Alt-Web Design & Publishing
Web | Graphics | Print | Media Specialists
My personal favourites in order:
Concete5.5 (free) http://www.concrete5.org/
Wordpress (free) http://wordpress.org/download/
Perch (£35 per site) http://grabaperch.com/
I've been testing Concrete5.5 out of late and it can do excatly what you require. So can Wordpress.
I would turn each of your pages into either a Concrete5.5 or Wordpress template theme. It would then be quite simple to allow your client to add and delete event pages but leaving the pages you don't want to the client to touch uneditable. Can't think of anything worse than letting the client loose on all the page......the website will be a train wreck in no time at all. The one thing I would say is keep the pages that are going to be updated by the client as simple as possible. CMS's have their limited uses but if a page is too complex the client will have no chance of updating without breaking the design.
Concrete5.5 has clear and precise instructions on how to convert your existing pages into a template theme: http://www.concrete5.org/documentation/how-tos/designers/make-a-theme/
Wordpress documentation is shite and most of the tutorials you'll find are outdated. You'll have to look longer and harder to find anything that helps you convert your pages into a template theme. The problem is most that exist are years behind the current version of Wordpress so are useless to follow. Having said that IF you can get passed GO Wordpress will also allow you to create new pages and delete old pages quite simply.
The trick to using both Concrete5.5 and Wordpress is only implementing the bits which are applicable to your website. For instance why would anyone give the client the option of creating new main menu buttons especially in the case of a horizontal menu where the addition of a couple more navigataion tabs could blow the whole design apart. Yuk.
Good luck.....it's by no means simple if its your first time.
Thanks everyone for your ideas. I installed Joomla on localhost. I understand that I can design my pages in Joomla but since I've already created my pages in DW, I would like to keep them and just use joomla for the updatable information (like osgood_ was saying). That IS possible with Joomla, right?
If yes, how can I link DW and joomla in one project? I mean, my pages are ready in design, I just need to add the Events content, the News content, Products content... so I am assuming that I should add my content in joomla (through "add an article"???) and then link that info into my DW page on localhost? Am I anywhere close?
Personally I've started using PyroCMS for my new projects with Wordpress on the side, although I do have a limited knowledge of Drupal (albeit more than Joomla). My issue with Joomla is that when you are designing templates, the Menus control more of the pages then the Templates do. It's a little hard to type out the understanding I have of it so far, but my templating issues with Joomla start when I hit the roadblock of how Menus control Templates and understanding Template overrides and alternative layouts (eg: layout 1 - simple, full page; layout 2 - 2 column layout). However, one plus to Joomla is that the Admin Panel is visually appealing with nice graphics, but that is where it ends.
Hopefully this makes some sense. If you have specific questions or need further help don't hesitate to ask.
Most certainly, just give him/her access to the backend and all is well.
The front end was created using Spry and can be seen here http://ncca.com.au/index.php?mod=events
If you need further assistance, please come back here.
This site, which I am working on as we speak, shows a more elaborate front end for the events http://eurowomen.com.au/. The backend was created in much the same way as I explained before albeit with more pleasing styling as in
Personally I've started using PyroCMS for my new projects
I've just downloaded PyroCMS and it looks pretty good, not that I understand how it works but I'm digging around and looking for tutorials.
One thing I noticed is how do you create links to internal web pages? It gives an option to create a link outside the website itself but I can't see anything whereby you can select a piece of text and link that to an internal page, must be there but I can't see it in the editing environment?
Also do you have any information about how to integrate a static html site into this CMS. Not too much documentation or tutorials at the moment but it looks promising.
After installing Joomla on my computer, and defining my site in DW, linking the database, and starting on the CRUD path (all with your help!), I have some new questions;
Any help will be greatly appreciated!
1. I am not familiar with Joomla, but my guess is that you should have a dynamic table, that is a table with repeating rows containing data from the database. This can easily be achieved using DW as follows
2. There should be a field in the database called link or similar where you can place the name of the document that you want to link to. This name can include the name of the folder if the folder changes from document to document as in myfolder/mydocument.pdf. Then in the dynamic table you can place the word link or similar, or even a graphic, and link that to the document, e.g. <a href='myPath/<?php echo $rs_row['myLink']; ?>Link</a>