Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 15 of 15
  1. #1
    New to the CF scene
    Join Date
    Nov 2008
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Question how to make a scheduler system

    hello to you all....

    ive been given this project that ive got to do..

    what i have to do basically is this..

    i have a system where people can login. on their home page there is a link where when clicked <my query starts here> will go to a calender like page where the person can specify the days and the times that he is available.... this is for a system for an educational institution where they want to know when their lecturers will be free and then assign their lectures accordingly... they should be able to edit the info that they have entered also at later times if needed....

    and the worst part is, that this is not for one lecturer... these guys have around 200 lecturers... and i need to create a system where these guys can login and do what i have said above.....

    can anybody tell me how to do this??? i cant figure out a way to do this coz im still a beginner in the mySQL and php thing altho ive been doing basic database systems, this is my first largescale DB system....

    thanks a trillion times in advance to you guys!!

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    Before you worry about the calendar interface (which would be handled in the front end), you would have to properly design your tables and know which information goes in them and how they should be structured.

    Legitimate question here, I see stuff like this posted all the time ... how do people with absolutely no experience get handed projects like this? Do people want it done for free and thus they'll take what they get?

  • #3
    Senior Coder
    Join Date
    Dec 2005
    Location
    Slovenia
    Posts
    1,960
    Thanks
    120
    Thanked 76 Times in 76 Posts
    how do people with absolutely no experience get handed projects like this
    mybe OP said:"oh, yeah this is peace of cake", to the customer, and others like me and you don't tell that, so here we are, at upper post.
    Found a flower or bug and don't know what it is ?
    agrozoo.net galery
    if you don't spot search button at once, there is search form:
    agrozoo.net galery search

  • #4
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,155
    Thanks
    75
    Thanked 4,338 Times in 4,304 Posts
    Or maybe this is homework.
    this is for a system for an educational institution
    I've noticed that many professors can't "think outside the box", so their homework assignments use examples from their own school. This seems like a really typical 2nd or 3rd year homework project.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #5
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    Could be homework, but I've seen some I'm sure aren't homework, same thing "gee i don't know how to do any of this at all so please help me out".

    I work with people like that. <sigh>

  • #6
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,155
    Thanks
    75
    Thanked 4,338 Times in 4,304 Posts
    Yeah, you do have to wonder how some people keep their jobs.

    I helped one woman in Australia maybe once every two weeks over a period of about 3 years. And I swear that after 3 years she still had no more idea how to even *approach* a problem than she did at the beginning. Can't tell you how many times I said to her "What are the STEPS you need here? How would you do this by hand?" She finally went silent, and I'm guessing that her employer finally gave up on her.

    That may have been most extreme case, but there are so many others. They are asking the same questions over and over again, and can't see that they are the same questions.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #7
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    When my 12-yr-old has trouble with math, I always tell him to stop looking at the specific question and explain in English what it is he is trying to solve. Mostly so I don't go insane, but also so that he understands that if he breaks down the process into steps the light will go on eventually.

    I wish we could do that with adults and get them to understand it the same.

  • #8
    UE Antagonizer Fumigator's Avatar
    Join Date
    Dec 2005
    Location
    Utah, USA, Northwestern hemisphere, Earth, Solar System, Milky Way Galaxy, Alpha Quadrant
    Posts
    7,691
    Thanks
    42
    Thanked 637 Times in 625 Posts
    It's all too common I'm afraid. My current place of employment has one single DB2 DBA in charge of everything related to DB2... she has no idea how to write even the simplest of queries. She makes us the application developers write the queries and she runs them. If I wanted to I could have her drop every database in the system just by telling her where the query was to run. She wouldn't even bother looking at the query before she ran it.

    I could probably convince her to scratch all of the backup tapes first! Haha.. (cry) It's hard to deal with... I've had the good fortune of working with some really great DBAs in my career so to see this state of affairs is depressing.
    Last edited by Fumigator; 02-18-2010 at 06:16 AM.

  • #9
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,155
    Thanks
    75
    Thanked 4,338 Times in 4,304 Posts
    How do people like that *become* DBAs??? I guess the real question is: Who is dumb enough to promote them into that kind of position?? *sigh*
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #10
    Regular Coder jfreak53's Avatar
    Join Date
    May 2004
    Location
    Guatemala
    Posts
    477
    Thanks
    19
    Thanked 10 Times in 10 Posts
    Ok I'm going to be a little nice than the rest, since I always had to learn on my own. But I did learn on my own, I bought PHP book and a mySQL sheet and have been learning ever since then. I'm not the best at SQL but I'm learning, much better at PHP and I can now call myself a professional after 10 years of working on web pages, just started PHP 6 or 7 years ago. My PHP is probably close to professional level but SQL lacks a lot

    At any rate, I do agree, you accepted this project so it's on you to finish it. It would be one thing to come in here and say I have this project and I have all this part done and this one query has me stumped, everyone would jump in and help. But dude, you came in and said hey I need you to tell me how to do this??

    I really do hate that myself, I have owned a web business for 10 years. And I hate that there are all these small startup companies where I live that say they will make a great web page for you for $50!!! And they download hacked templates from TM or BoxedArt and sell these people pre-packaged sites and call themselves professionals. All they do is take business away from real professionals. At any rate, sorry a little venting there ha ha.

    No one in their right mind would help you now. I am going to little help you, I will steer you in a starting direction with dates in MySQL. I made a script about 5 years ago that I used on my hosting site, I used it to keep track of when my clients expired and needed to be renewed. Very simple script, one file that took up 2KB in size. It compares the date of expire in the DB and finds when 30 days is close. So I am posting this since it has something to do with dates, have a look and decompile it, which is like 2 seconds worth of work ha ha

    Then using it as a base build off of it to make it bigger. Don't be afraid to play man, go into SQL like pedant told me awhile back and just play with select queries till it turns up.

    Here is the DB print out:

    Code:
    CREATE TABLE IF NOT EXISTS `reminder1` (
      `id` int(11) NOT NULL auto_increment,
      `date` date NOT NULL default '0000-00-00',
      `name` text NOT NULL,
      `email` text NOT NULL,
      `lang` text NOT NULL,
      PRIMARY KEY  (`id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
    Very simple there is a one field date field, that's it and this is how it's read:

    Code:
    $db1 = mysql_query("SELECT * from `reminder1` where DATE_SUB(date, INTERVAL 30 DAY) < now()",$con);
    
    while ($r = mysql_fetch_array($db1)){
    if($r['date'] < date("Y-m-d") == FALSE){
    Very simple coding man, basically if the date is less than 30 days away it sends the email to them with the rest of the code.

    Now write your own using the date system and go to town!

    Or you could just hire someone to do this for you, there are a lot of sites for that, rentacoder to be one. And I think there is a forum here for hire work. At any rate, have fun getting someone to give you the code for that system, you basically asked for the complete system for free.

  • #11
    Supreme Master coder! Old Pedant's Avatar
    Join Date
    Feb 2009
    Posts
    25,155
    Thanks
    75
    Thanked 4,338 Times in 4,304 Posts
    I really don't think that jfreak's answer fits the original poster's question very well.

    I think one of the hard parts about creating the system that is needed here will be the actual GUI of the calendar itself and creating the behind the scenes code that will update the calendar, etc.

    Granted, the DB behind it can be pretty simple. But that's only the tip of the iceberg.

    Just as a simple "for instance": How do you create a "sparse calendar" that shows all possible "slots" (days and times), shows which are already "busy" for a given person, and allows the person to click on a slot to mark it as "busy" or maybe to un-mark one that shows him busy.

    And then how do you create a "master page" that shows all the lecturers who *are* available at a given time slot??

    No, none of that is hard, but it does mean you have to plan it out and not just slap it together.

    As Guelph said: "I always tell him to stop looking at the specific question and explain in English what it is he is trying to solve." So in this case, the original poster needs to explain in English (or his native language) how he would solve this problem *without* using a computer. And then creating a computerized solution isn't really as hard as it first looks.
    An optimist sees the glass as half full.
    A pessimist sees the glass as half empty.
    A realist drinks it no matter how much there is.

  • #12
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    by the way jfreak (and of course you are free to post as you have done), I'm always leery of posting replies to generalized questions like this when it is the posters first time in a forum.

    I moderate in 3 other forums as well. Often people will post something this general and expect others to do the work for them, or as Old Pedant says, do their homework for them.

    I'm always willing to roll up the sleeves and help someone who helps themselves.

    Note the original poster hasn't returned?

  • #13
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    Quote Originally Posted by Old Pedant View Post
    "Old age and cunning win out over youth and enthusiasm every time."
    Two bulls standing at the top of the hill looking down on a herd of cows below.

    Young bull to old bull: "Hey what do you say we run down the hill and each have one of those cows!"

    Wise old bull to young bull: "No son, let's walk down and have them all!"

  • #14
    Regular Coder jfreak53's Avatar
    Join Date
    May 2004
    Location
    Guatemala
    Posts
    477
    Thanks
    19
    Thanked 10 Times in 10 Posts
    guelphdad: Yeah I noticed, he's long gone now. Oh well, just thought I'd put my two cents worth in ha ha.

  • #15
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    Yup no worries. And though I do see your way of thinking as less off-putting than my own, i've learned through experience that those who want to share some of the work (i.e. post what things they've tried or where they've searched to find a solution) are those who deserve help. Those that don't, don't.


  •  

    Tags for this Thread

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •