PHP - Moved: Php Multiple Date Calender

Hi. Im searching for a way to enter multiple records at once to mysql databased on a date range. Lets say i want to insert from date 2010-11-23 to date 2010-11-25 a textbox with some info and the outcome could look in database like below.

----------------------------------------------------------
| ID   |   date                |   name   |    amount   |
-----------------------------------------------------------
| 1     |   2010-11-23    |   Jhon     |        1         |
| 2     |   2010-11-24    |   Jhon     |        1         |
| 2     |   2010-11-25    |   Jhon     |        1         |
-----------------------------------------------------------

The reason i need the insertion to be like this is because if quering by month and by user to see vacation days then vacations that start in one month and end in another month can be summed by one month. If its in one record then it will pop up in both months.

Help is really welcome.

Hello all

This may seem stupid coming in here with absolutely no code to show. I am in planning of a php event calender for my work place and I am a very PHP rookie  basically i am asking for directions to go with this.

I have written scripts before but not like this. I  currently have a database set up for the events and about to write to that  databases table. I have date as a primary key and in format of date (2012-05-14). what i am  trying to figure out is how do i take this date have it find the correct day on the calender?

I hope someone can help me a little here i know i have asked a lot  but  could use a point in the right direction.

Thank you,
Nis

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=309828.0

This topic has been moved to PHP Regex.

http://www.phpfreaks.com/forums/index.php?topic=353870.0

Hi guys,

I have this code below that selects and display all events from my database table. E.g if an event titled 'PHP' starts 5th March and ends 6th March (03/05/2012 - 03/06/2012)
Code: [Select]
//SQL QUERY for Event
         $sqlCount = mysql_query("select * from eventcalender");
         $noOfEvent = 0;
         while($Event = mysql_fetch_array($sqlCount)){
$startDate = $Event['startDate'];
$endDate = $Event['endDate'];
                      //split date
                      list($smonth, $sday, $syear) = explode('/',$Event['startDate']);
                      list($emonth, $eday, $eyear) = explode('/',$Event['endDate']);

                      //change date to date time format
                      $start = new DateTime($sday.'-'.$smonth.'-'.$syear); // DD-MM-YYYY
                      $endDate= new DateTime($eday.'-'.$emonth.'-'.$eyear); // DD-MM-YYYY
                      $curdate = new DateTime($i.'-'.$month.'-'.$year);
                     
                      if ($start <= $curdate && $curdate <= $endDate) {
                           $noOfEvent++;
                           $eventTitleList = $eventTitleList."<br />".$Event['Title'];
                      }
         }
My question is if I had a drop down and the user selects a half day or partial day for the end date (03/06/2012) how do I get the calender to display the word (Half day) on the end date without displaying it on the start date so as to indicate on the calender that the end date is a half day.

I would appreciate you help and advice.

Thanks

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=342459.0

This topic's house has been seized by the bank and it now lives in MySQL Help until it can get back on its feet.

http://www.phpfreaks.com/forums/index.php?topic=358035.0

This topic has been moved to Ajax Help.

http://www.phpfreaks.com/forums/index.php?topic=313543.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=316616.0

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=320518.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=345631.0

i am looking for simple php mysql base event calender..that shows upcoming events...i would very helpful for your help.any tutorial.video.or helping link..??

i've use php-event-calender for showing event from table.when i click on event date, it's dispay table details for relevent date correctly in localhost.but it's didn't show details in live server.

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=346951.0

This topic has been moved to HTML Help.

http://www.phpfreaks.com/forums/index.php?topic=346367.0