Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 9 of 9
  1. #1
    Junior Member
    Join Date
    Aug 2004
    Posts
    5
    Member #
    7247
    I'm creating a page for my church's youth group to be able to look at upcoming events. You can see a non-working sample here ( http://www.oasisoo.org/calendar/calendar.html ). There is also a form to manage input of information here (http://www.oasisoo.org/calendar/newevent.html).

    So far, I'm thinking about having only one table called 'events' in my database. It would hold all the information shown on the previous link (newevent.html), plus an auto-incrementing id number. HTML event files would be created based on the id combined with the day number submitted on the newevent form. (ex. 0123.html) Is that wise?

    When you click on a month in the top left section of calendar.html, I would like the top right section to be populated with a list of events in the selected month. Then, when you click on an event, I would like the event's description to appear in the bottom section. My question is, what can I do so that when you click on the event title in the upper right section, the event description would be called from the database and placed in the bottom right section? Would this be through just variables with a full page refresh? IFRAMES? Any ideas encompassing the whole project would be greatly appreciated.

  2.  

  3. #2
    Senior Member seanmiller's Avatar
    Join Date
    Sep 2003
    Location
    Glastonbury, UK
    Posts
    868
    Member #
    3263
    Liked
    1 times
    If you want to be really ambitious, and impress a few people, you could consider using Ajax :-)

    http://www.adaptivepath.com/publicat...ves/000385.php

    There's a set of libraries called Sajax that make using Ajax fairly simple. You just export your PHP functions and then call them using Javascript.

    Here's Sajax... http://www.modernmethod.com/sajax/

    There's a pretty impressive demo of Ajax here...
    http://projects.backbase.com/RUI/portal.html

    Try dragging the windows around. Also, see the portfolio at the bottom - you can re-order it by clicking on the column headers... cool, eh?

    Sean

  4. #3
    Junior Member
    Join Date
    Aug 2004
    Posts
    5
    Member #
    7247
    Thanks, Sean. I will download and play around with that today. If anyone still has some suggestions, I'd still like to hear them. Also, the link above that leads you to the event input form seems broken because it's attached to the right parenthesis. Here it is again.

    http://www.oasisoo.com/calendar/newevent.html

    thanks

  5. #4
    Senior Member
    Join Date
    Jun 2005
    Location
    Atlanta, GA
    Posts
    4,146
    Member #
    10263
    Liked
    1 times
    You'd probably want to use PHP to generate the files; generating HTML files would be a waste of space and time. Otherwise, it should work. I did something similar at http://www.fulton.k12.ga.us/school/c...04&cat=teacher (login as kents/freestyle). It did take some work as the events could have a lot of stuff on them (see http://www.fulton.k12.ga.us/school/c...Assignment.asp ).

  6. #5
    Junior Member
    Join Date
    Aug 2004
    Posts
    5
    Member #
    7247
    database or php files

    You're right. That's pretty much exactly what I want it to do. So it's not database driven then? I'm wondering this then. Does giving write access to a directory allow someone to submit the form (which is processed by PHP to write a file) also give them permission to write TO THE FILE, because I obviously can't guess what file names are going to be and create them in advance and give them write permissions.

    Should I continue with the database? Or should I generate PHP files? What are you using for your login? I also don't know any java script. Will I need javascript to dynamically change out files in iFrames, or to dynamically load different data from a database into an iFrame? As you said, I'd reallly like to stay away from generating HTML files.

  7. #6
    Senior Member
    Join Date
    Jun 2005
    Location
    Atlanta, GA
    Posts
    4,146
    Member #
    10263
    Liked
    1 times
    This particular thing is done in ASP, though I've ported bits and pieces to PHP. The form processing is still ASP-only, unfortunately.

    Changing files in iframes is completely HTML-based (target="frame" will make links change the contents of that frame); however, I do use JavaScript there since the cells themselves are clickable, which is done via JS.

    It is database-driven, don't get me wrong. But instead of generating raw HTML files from the database, I use ASP to connect to the database and customize the content.

    Note that the system I showed you there represented a very large amount of work. Getting everything to play nice together took forever. The actual calendar part didn't take me as long as I was expecting, since I just sat down and did it.

    But keep in mind that whatever you decide to do, it will probably take a while to get something like this off the ground. Your mileage may vary :-)

  8. #7
    Junior Member
    Join Date
    Aug 2004
    Posts
    5
    Member #
    7247
    So this is definately going to be a combination of PHP, Javascript, and MySQL. And when I think of those 3 together, I'm clueless. I not at a stage where I'm really writing my own stuff yet. I'll have to study up and just use a simple list of events for now. But I really think this project is going to be one that will advance me. I may keep submitting on this thread as I continue to work on this.

  9. #8
    Senior Member
    Join Date
    Jun 2005
    Location
    Atlanta, GA
    Posts
    4,146
    Member #
    10263
    Liked
    1 times
    Well, the JS is trivial and something you shouldn't worry about at all until later. In fact, the JS I used for this may very well be replaceable with good ol' HTML+CSS, I'm not sure.

    But yes, this is an excellent starting point. You'll learn about date functions and a whole lot of other things that will definitely come in useful in later projects. If you need any help, feel free to contact me directly (or, of course, post on the fora).

  10. #9
    Junior Member
    Join Date
    Aug 2004
    Posts
    5
    Member #
    7247
    ok, will do! thanks for the help!


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 11:38 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com