Skip navigation
anb_newbie
Currently Being Moderated

database, link to webpage, give access to smone else to update info...

Mar 29, 2012 1:38 PM

Tags: #dreamweaver #database

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.

 
Replies
  • Currently Being Moderated
    Mar 29, 2012 1:41 PM   in reply to anb_newbie

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Mar 29, 2012 4:08 PM   in reply to anb_newbie

    Cushy CMS might be all you need for this project.  Watch their video to see how.

    http://www.cushycms.com

     

    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.

     

     

     

    Nancy O.

    Alt-Web Design & Publishing

    Web | Graphics | Print | Media  Specialists 

    http://alt-web.com/

    http://twitter.com/altweb

    http://alt-web.blogspot.com/

     
    |
    Mark as:
  • Currently Being Moderated
    Mar 29, 2012 5:17 PM   in reply to anb_newbie

    anb_newbie wrote:

     

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Mar 29, 2012 5:22 PM   in reply to anb_newbie

    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:

    http://alt-web.com/Tutorials/CUSHYCMS/

     

     

    Nancy O.

    Alt-Web Design & Publishing

    Web | Graphics | Print | Media  Specialists 

    http://alt-web.com/

    http://twitter.com/altweb

    http://alt-web.blogspot.com/

     
    |
    Mark as:
  • Currently Being Moderated
    Mar 29, 2012 9:35 PM   in reply to anb_newbie

    Either Contribute (http://www.adobe.com/products/contribute.html) or Konductor (http://konductor.net/).

     

    I would say Konductor makes the most sense since your editable regions would work with it natively - nothing would need to change.

     

    Hope that helps.

     
    |
    Mark as:
  • Currently Being Moderated
    Mar 30, 2012 1:09 AM   in reply to anb_newbie

    How about using a spry data set then it's only a matter of editing an xml file and even notepad can do that.

     
    |
    Mark as:
  • Currently Being Moderated
    Mar 30, 2012 6:38 AM   in reply to anb_newbie

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 1, 2012 7:26 AM   in reply to anb_newbie

    Don't make a great deal out of it. Create a secured backend with CRUD ( create, read, update and delete) modules. This can easily be done with DW's data insert panel, insert, uodate and delete form wizards and a dynamic table to view the events. The latter will look similar to

    capture.png

     

    Gramps

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 1, 2012 7:32 AM   in reply to anb_newbie

    Anb, just to clarify what's going on.  When you go to a CMS, you can continue to use, and should continue to use, something like Dreamweaver to code your pages because most of the templates created by the content management systems are stored in HTML files (with the exception of CMSMS that I mentioned).  So if you want to use DW with Joomla you can create and modify the template with Dreamweaver, but you would need to use the CMS for the content.  So if this content is already in DW documents, you would need to copy and paste it into the Joomla Article Editor so that it shows up on your pages.  This is because while the template is in HTML documents ( /templates/{template_name} ) the content is stored in the database.  Also, if you need to include page specific PHP, javascript or CSS I recommend looking into a plugin called Sourcerer ( http://extensions.joomla.org/extensions/edition/custom-code-in-content /5051 ).  From my limited experience with Joomla that is the best extension out there for those inclusions.

     

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 1, 2012 7:34 AM   in reply to anb_newbie

    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.

     

    Gramps

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 1, 2012 7:42 AM   in reply to Ben Pleysier

    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

     

    capture.png

     

    Gramps

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 2, 2012 4:27 PM   in reply to Ben Pleysier
     
    |
    Mark as:
  • Currently Being Moderated
    Apr 3, 2012 7:19 AM   in reply to SnakEyez02

    SnakEyez02 wrote:

     

     

    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.

     
    |
    Mark as:
  • Currently Being Moderated
    Apr 6, 2012 1:57 PM   in reply to anb_newbie

    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

    _capture.png

     

    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>

     

    Gramps

     
    |
    Mark as:

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points