increment dates

[hardinera]

<?
$start = "2007-02-1";
$end = "2007-02-05";

do{
    
list($y,$m,$d) = explode('-',$start);
$start2 = Date("Y-m-d", mktime(0,0,0,$m,$d+1,$y));

echo "$date2 <br>";
}

while ($start2 < $end);

?>

this doesnt seem to work... its output is 2007-02-02

[zeroradius]

what part of the date are you trying to increment? It is adding 1 to the day like the code told it to.

Edit: NM i just notice the while and the $end. Let me see if i can get it working

Edit 2:

try this,

<?
$start = "2007-02-1";
$end = "2007-02-05";
 
list($y,$m,$d) = explode('-',$start);
while ($start2 < $end){
$start2 = Date("Y-m-d", mktime(0,0,0,$m,$d,$y));
echo $start2 . "<br>";
$d = $d +1;
}
 
 
?>

the out put when i tested it is

2007-02-01
2007-02-02
2007-02-03
2007-02-04
2007-02-05

[hardinera]

zero radius thanks
its working lol -.- im not good at looping

but why it has

Notice: Undefined variable: start2

thanks

[zeroradius]

No problem, glad i could help.

As for the undefined variable it is because i forgot to define it before the for loop as well as redefine it within it.

so the code should actualy be:

<?
$start = "2007-02-1";
$end = "2007-02-05";
 
list($y,$m,$d) = explode('-',$start);
$start2 = Date("Y-m-d", mktime(0,0,0,$m,$d,$y));
while ($start2 < $end){
$start2 = Date("Y-m-d", mktime(0,0,0,$m,$d,$y));
echo $start2 . "<br>";
$d = $d +1;
}
?>

if that does not fix it post the entire page of code and i will see if i can hunt down the problem

[hardinera]

yay! its working hehehehe -.- no unidentified as well

im planning to put this in a field on a database lol.. i dont have any insert query for now .. i just want to do this step by step im just new to this language lol.. i will now test for the insert thanks again

[hardinera]

now i finished the insert form the date "in" and "out" is inserting properly but the "span" field only reads 0000-00-00

<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
  <table align="center">
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Id:</td>
      <td><input type="text" name="id" value="" size="32" readonly="readonly" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">In:</td>
      <td><input size="10" id="fc_1265961698" type="text" name="in"  readonly="READONLY" title="YYYY-MM-DD" />
      <input type="button" value="=" onclick="displayCalendarFor('fc_1265961698');" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Out:</td>
      <td><input size="10" id="fc_1265961699" type="text" readonly="READONLY" name="out" title="YYYY-MM-DD" />
      <input type="button" value="=" onclick="displayCalendarFor('fc_1265961699');" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Span:</td>
      <td>
      
      <input type="text" name="span" value="'<?php echo $span ?>'" size="32" readonly="readonly" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">&nbsp;</td>
      <td><input type="submit" value="Insert record" /></td>
    </tr>
  </table>
  <input type="hidden" name="MM_insert" value="form1" />
</form>
<p>&nbsp;</p>

<?
if($_GET)
{
             $start = "$_GET[in]";
            $end = "$_GET[out]";

            list($y,$m,$d) = explode('-',$start);
            $span = Date("Y-m-d", mktime(0,0,0,$m,$d,$y));

            while ($span < $end){
            $span = Date("Y-m-d", mktime(0,0,0,$m,$d,$y));
            echo $span . "<br>";
            $d = $d +1;
            }   
            
}
            ?>

[zeroradius]

Ok lets take this one step at a time. First you are passing a sting and than trying to use it as a date. The qoutes go inside the [] so its

$start= $_GET["in"];
$end=$_GET["out"]; 

Now the next thing we need to check is the data being passed.

Look up in the address bar that this code is on at the end of the path if you are getting the desired results you will see : ?in=aDate, out=aDate (aDate represents whatever date you submited no the word aDate)

If you do not see that then the dates are not being passed so post the code from the form that submits to this page (or is that the code above it with it passing to self?)

[hardinera]

this is my whole code

problem 1 . the span still not inserting one the dbase its always 0000-00-00
problem 2. undefined variables.

im planning to insert the span date to databse to be able to count the number of reserved dates and group them as one reservation.

database h_reservation
table reservation
fields id,in,out,span

<script language="javascript">
    //FOR CHECK IN CALENDAR
    // Flooble Dynamic  Calendar. 
    // Copyright (c) 2004 by Animus Pactum Consulting Inc.
    //---------------------------------------------------------------------
    // You may use this code freely on your site as long as you do not make
    // modifications to it other than editing the stylesheet settings to 
    // make it fit your design. You may not remove this notice or any links
    // to flooble.com.
    // More information about this script is available at
    //    http://www.flooble.com/scripts/calendar.php
    //--Global Stuff-------------------------------------------------------
    var fc_ie = false;
    if (document.all) { fc_ie = true; }
    
    var calendars = Array();
    var fc_months = Array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
    var fc_openCal;

    var fc_calCount = 0;
    
    function getCalendar(fieldId) {
        return calendars[fieldId];
    }
    
    function displayCalendarFor(fieldId) {
        var formElement = fc_getObj(fieldId);
        displayCalendar(formElement);
    }
    
    function displayCalendar(formElement) {
        if (!formElement.id) {
            formElement.id = fc_calCount++;
        } 
        var cal = calendars[formElement.id];
        if (typeof(cal) == 'undefined') {
            cal = new floobleCalendar();
            cal.setElement(formElement);
            calendars[formElement.id] = cal;
        }
        if (cal.shown) {
            cal.hide();
        } else {
            cal.show();
        }
    }
    
    function display3FieldCalendar(me, de, ye) {
        if (!me.id) { me.id = fc_calCount++; }
        if (!de.id) { de.id = fc_calCount++; }
        if (!ye.id) { ye.id = fc_calCount++; }
        var id = me.id + '-' + de.id + '-' + ye.id;
        var cal = calendars[id];
        if (typeof(cal) == 'undefined') {
            cal = new floobleCalendar();
            cal.setElements(me, de, ye);
            calendars[id] = cal;
        }
        if (cal.shown) {
            cal.hide();
        } else {
            cal.show();
        }
    }

    //--Class Stuff--------------------------------------------------
    function floobleCalendar() {
        // Define Methods
        this.setElement = fc_setElement;
        this.setElements = fc_setElements;
        this.parseDate = fc_parseDate;
        this.generateHTML = fc_generateHTML;
        this.show = fc_show;
        this.hide = fc_hide;
        this.moveMonth = fc_moveMonth;
        this.setDate = fc_setDate;
        this.formatDate = fc_formatDate;
        this.setDateFields = fc_setDateFields;
        this.parseDateFields = fc_parseDateFields;
        
        this.shown = false;
    }
    
    function fc_setElement(formElement) {
        this.element = formElement;
        this.format = this.element.title;
        this.value = this.element.value;
        this.id = this.element.id;
        this.mode = 1;
    }
    
    function fc_setElements(monthElement, dayElement, yearElement) {
        this.mElement = monthElement;
        this.dElement = dayElement;
        this.yElement = yearElement;
        this.id = this.mElement.id + '-' + this.dElement.id + '-' + this.yElement.id;
        this.element = this.mElement;
        if (fc_absoluteOffsetLeft(this.dElement) < fc_absoluteOffsetLeft(this.element)) {
            this.element = this.dElement;
        }
        if (fc_absoluteOffsetLeft(this.yElement) < fc_absoluteOffsetLeft(this.element)) {
            this.element = this.yElement;
        }
        if (fc_absoluteOffsetTop(this.mElement) > fc_absoluteOffsetTop(this.element)) {
            this.element = this.mElement;
        }
        if (fc_absoluteOffsetTop(this.dElement) > fc_absoluteOffsetTop(this.element)) {
            this.element = this.dElement;
        }
        if (fc_absoluteOffsetTop(this.yElement) > fc_absoluteOffsetTop(this.element)) {
            this.element = this.yElement;
        }

        this.mode = 2;
    }
    
    function fc_parseDate() {
        if (this.element.value) {
            this.date = new Date();
            var out = '';
            var token = '';
            var lastCh, ch;
            var start = 0;
            lastCh = this.format.substring(0, 1);
            for (i = 0; i < this.format.length; i++) {
                ch = this.format.substring(i, i+1);
                if (ch == lastCh) { 
                    token += ch;
                } else {
                    fc_parseToken(this.date, token, this.element.value, start);
                    start += token.length;
                    token = ch;
                }
                lastCh = ch;
            }
            fc_parseToken(this.date, token, this.element.value, start);


        } else {
            this.date = new Date();
        }
        if ('' + this.date.getMonth() == 'NaN') {
            this.date = new Date();
        }
    }    
    
    function fc_parseDateFields() {
        this.date = new Date();
        if (this.mElement.value) this.date.setMonth(fc_getFieldValue(this.mElement) - 1);
        if (this.dElement.value) this.date.setDate(fc_getFieldValue(this.dElement));
        if (this.yElement.value) this.date.setFullYear(fc_getFieldValue(this.yElement));
        if ('' + this.date.getMonth() == 'NaN') {
            this.date = new Date();
        }
    }
    
    function fc_setDate(d, m, y) {
        this.date.setYear(y);
        this.date.setMonth(m);
        this.date.setDate(d);
        if (this.mode == 1) {
            this.element.value = this.formatDate();
        } else {
            this.setDateFields();
        }
        this.hide();
    }
    
    function fc_setDateFields() {
        fc_setFieldValue(this.mElement, fc_zeroPad(this.date.getMonth() + 1));
        fc_setFieldValue(this.dElement, fc_zeroPad(this.date.getDate()));
        fc_setFieldValue(this.yElement, this.date.getFullYear());
    }
    
    function fc_formatDate() {
        var out = '';
        var token = '';
        var lastCh, ch;
        lastCh = this.format.substring(0, 1);
        for (i = 0; i < this.format.length; i++) {
            ch = this.format.substring(i, i+1);
            if (ch == lastCh) { 
                token += ch;
            } else {
                out += fc_formatToken(this.date, token);
                token = ch;
            }
            lastCh = ch;
        }
        out += fc_formatToken(this.date, token);
        return out;
    }
    
    function fc_show() {
        if (typeof(fc_openCal) != 'undefined') { fc_openCal.hide(); }
    
        if (this.mode == 1) {
            this.parseDate();
        } else {
            this.parseDateFields();
        }
        this.showDate = new Date(this.date.getTime());
        if (typeof(this.div) != 'undefined') {
            this.div.innerHTML = this.generateHTML();
        }
        
        if (typeof(this.div) == 'undefined') {
            this.div = document.createElement('DIV');
            this.div.style.position = 'absolute';
            this.div.style.display = 'none';
            this.div.className = 'fc_main';
            this.div.innerHTML = this.generateHTML();
            this.div.style.left = fc_absoluteOffsetLeft(this.element);
            this.div.style.top = fc_absoluteOffsetTop(this.element) + this.element.offsetHeight + 1;
            document.body.appendChild(this.div);
        }
        this.div.style.display = 'block';
        this.shown = true;
        fc_openCal = this;
    }
    
    function fc_generateHTML() {
        var html = '<TABLE><TR><TD CLASS="fc_head" COLSPAN="6"><DIV STYLE="float: right"><a class="fc_head" href="http://www.flooble.com/scripts/calendar.php" target="_blank">©</a></DIV>CALENDAR:</TD><TD CLASS="fc_date" onMouseover="this.className = \'fc_dateHover\';" onMouseout="this.className=\'fc_date\';" onClick="getCalendar(\'' + this.id + '\').hide();"><B>X</B></TD></TR>';
        html += '<TR><TD CLASS="fc_date" onMouseover="this.className = \'fc_dateHover\';" onMouseout="this.className=\'fc_date\';" onClick="getCalendar(\'' + this.id + '\').moveMonth(-12);"><B><<</B></TD><TD CLASS="fc_date" onMouseover="this.className = \'fc_dateHover\';" onMouseout="this.className=\'fc_date\';" onClick="getCalendar(\'' + this.id + '\').moveMonth(-1);"><B><</B></TD><TD COLSPAN="3" CLASS="fc_wk">' + fc_months[this.showDate.getMonth()] + ' ' + fc_getYear(this.showDate) + '</TD><TD CLASS="fc_date" onMouseover="this.className = \'fc_dateHover\';" onMouseout="this.className=\'fc_date\';" onClick="getCalendar(\'' + this.id + '\').moveMonth(1);"><B>></B></TD><TD CLASS="fc_date" onMouseover="this.className = \'fc_dateHover\';" onMouseout="this.className=\'fc_date\';" onClick="getCalendar(\'' + this.id + '\').moveMonth(12);"><B>>></B></TD></TR>';
        html += '<TR><TD WIDTH="14%" CLASS="fc_wk">Mo</TD><TD WIDTH="14%" CLASS="fc_wk">Tu</TD><TD WIDTH="14%" CLASS="fc_wk">We</TD><TD WIDTH="14%" CLASS="fc_wk">Th</TD><TD WIDTH="14%" CLASS="fc_wk">Fr</TD><TD class="fc_wknd" WIDTH="14%">Sa</TD><TD class="fc_wknd" WIDTH="14%">Su</TD></TR>';
        html += '<TR>';
        var dow = 0;
        var i, style;
        var totald = fc_monthLength(this.showDate);
        for (i = 0; i < fc_firstDOW(this.showDate); i++) {
            dow++;
            html += '<TD> </TD>';
        }
        for (i = 1; i <= totald; i++) {
            if (dow == 0) { html += '<TR>'; }
            if (this.showDate.getMonth() == this.date.getMonth() && this.showDate.getYear() == this.date.getYear() && this.date.getDate() == i) { 
                style = ' style="font-weight: bold;"';
            } else {
                style = '';
            }
            html += '<TD CLASS="fc_date" onMouseover="this.className = \'fc_dateHover\';" onMouseout="this.className=\'fc_date\';" onClick="getCalendar(\'' + this.id + '\').setDate(' + i + ', ' + this.showDate.getMonth() + ', ' + this.showDate.getFullYear() + ');" ' + style + '>' + i + '</TD>';
            dow++;
            if (dow == 7) {
                html += '</TR>';
                dow = 0;
            }
        }
        if (dow != 0) {
            for (i = dow; i < 7; i++) {
                html += '<TD> </TD>';
            }
        }
        html +='</TR>';
        html += '</TABLE>';
        return html;
    }
    
    function fc_hide() {
        if (this.div != false) {
            this.div.style.display = 'none';
        }
        this.shown = false;
        fc_openCal = undefined;
    }
    
    function fc_moveMonth(amount) {
        var m = this.showDate.getMonth();
        var y = fc_getYear(this.showDate);
        if (amount == 1)  {
            if (m == 11)  {
                this.showDate.setMonth(0);
                this.showDate.setYear(y + 1);
            } else {
                this.showDate.setMonth(m + 1);
            }
        } else if (amount == -1)  {
            if (m == 0)  {
                this.showDate.setMonth(11);
                this.showDate.setYear(y - 1);
            } else {
                this.showDate.setMonth(m - 1);
            }
        } else if (amount == 12) {
            this.showDate.setYear(y + 1);
        } else if (amount == -12) {
            this.showDate.setYear(y - 1);
        }
        this.div.innerHTML = this.generateHTML();
    }
    
    //--Utils-------------------------------------------------------------
    function fc_absoluteOffsetTop(obj) {
         var top = obj.offsetTop;
         var parent = obj.offsetParent;
         while (parent != document.body) {
             top += parent.offsetTop;
             parent = parent.offsetParent;
         }
         return top;
     }
     
     function fc_absoluteOffsetLeft(obj) {
         var left = obj.offsetLeft;
         var parent = obj.offsetParent;
         while (parent != document.body) {
             left += parent.offsetLeft;
             parent = parent.offsetParent;
         }
         return left;
     }
     
     function fc_firstDOW(date) {
         var dow = date.getDay();
         var day = date.getDate();
         if (day % 7 == 0) return dow;
         return (7 + dow - (day % 7)) % 7; 
     }
     
     function fc_getYear(date) {
         var y = date.getYear();
         if (y > 1900) return y;
         return 1900 + y;
     }
     
     function fc_monthLength(date) {
        var month = date.getMonth();
        var totald = 30;
        if (month == 0 
            || month == 2
            || month == 4
            || month == 6
            || month == 7
            || month == 9
            || month == 11) totald = 31;
        if (month == 1) {
            var year = date.getYear();
            if (year % 4 == 0 && (year % 400 == 0 || year % 100 != 0))
                 totald = 29;
            else
                totald = 28;
        }
        return totald;
     }
     
     function fc_formatToken(date, token) {
        var command = token.substring(0, 1);
        if (command == 'y' || command == 'Y') {
            if (token.length == 2) { return fc_zeroPad(date.getFullYear() % 100); }
            if (token.length == 4) { return date.getFullYear(); } 
        }
        if (command == 'd' || command == 'D') {
            if (token.length == 2) { return fc_zeroPad(date.getDate()); }
        }
        if (command == 'm' || command == 'M') {
            if (token.length == 2) { return fc_zeroPad(date.getMonth() + 1); }
            if (token.length == 3) { return fc_months[date.getMonth()]; } 
        }
        return token;
     }
     
     function fc_parseToken(date, token, value, start) {
        var command = token.substring(0, 1);
        var v;
        if (command == 'y' || command == 'Y') {
            if (token.length == 2) { 
                v = value.substring(start, start + 2);
                if (v < 70) { date.setFullYear(2000 + parseInt(v)); } else { date.setFullYear(1900 + parseInt(v)); } 
            }
            if (token.length == 4) { v = value.substring(start, start + 4); date.setFullYear(v);} 
        }
        if (command == 'd' || command == 'D') {
            if (token.length == 2) { v = value.substring(start, start + 2); date.setDate(v); }
        }

        if (command == 'm' || command == 'M') {
            if (token.length == 2) { v = value.substring(start, start + 2); date.setMonth(v - 1); }
            if (token.length == 3) { 
                v = value.substring(start, start + 3);
                var i;
                for (i = 0; i < fc_months.length; i++) {
                    if (fc_months[i].toUpperCase() == v.toUpperCase()) { date.setMonth(i); }
                }
            } 
        }
     }
     
     function fc_zeroPad(num) {
        if (num < 10) { return '0' + num; }
        return num;
     }

    function fc_getObj(id) {
        if (fc_ie) { return document.all[id]; } 
        else { return document.getElementById(id);    }
    }

      function fc_setFieldValue(field, value) {
                if (field.type.substring(0,6) == 'select') {
                        var i;
                        for (i = 0; i < field.options.length; i++) {
                                if (fc_equals(field.options[i].value, value)) {
                                        field.selectedIndex = i;
                                }
                        }
                } else {
                        field.value = value;
                }
      }

      function fc_getFieldValue(field) {
                if (field.type.substring(0,6) == 'select') {
                        return field.options[field.selectedIndex].value;
                } else {
                        return field.value;
                }
      }
      
      function fc_equals(val1, val2) {
              if (val1 == val2) return true;              
              if (1 * val1 == 1 * val2) return true;
              return false;
      }
     
</script>


<script language="javascript">
    //FOR CHECK OUT CALENDAR
    // Flooble Dynamic  Calendar. 
    // Copyright (c) 2004 by Animus Pactum Consulting Inc.
    //---------------------------------------------------------------------
    // You may use this code freely on your site as long as you do not make
    // modifications to it other than editing the stylesheet settings to 
    // make it fit your design. You may not remove this notice or any links
    // to flooble.com.
    // More information about this script is available at
    //    http://www.flooble.com/scripts/calendar.php
    //--Global Stuff-------------------------------------------------------
    var fc_ie = false;
    if (document.all) { fc_ie = true; }
    
    var calendars = Array();
    var fc_months = Array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec');
    var fc_openCal;

    var fc_calCount = 0;
    
    function getCalendar(fieldId) {
        return calendars[fieldId];
    }
    
    function displayCalendarFor(fieldId) {
        var formElement = fc_getObj(fieldId);
        displayCalendar(formElement);
    }
    
    function displayCalendar(formElement) {
        if (!formElement.id) {
            formElement.id = fc_calCount++;
        } 
        var cal = calendars[formElement.id];
        if (typeof(cal) == 'undefined') {
            cal = new floobleCalendar();
            cal.setElement(formElement);
            calendars[formElement.id] = cal;
        }
        if (cal.shown) {
            cal.hide();
        } else {
            cal.show();
        }
    }
    
    function display3FieldCalendar(me, de, ye) {
        if (!me.id) { me.id = fc_calCount++; }
        if (!de.id) { de.id = fc_calCount++; }
        if (!ye.id) { ye.id = fc_calCount++; }
        var id = me.id + '-' + de.id + '-' + ye.id;
        var cal = calendars[id];
        if (typeof(cal) == 'undefined') {
            cal = new floobleCalendar();
            cal.setElements(me, de, ye);
            calendars[id] = cal;
        }
        if (cal.shown) {
            cal.hide();
        } else {
            cal.show();
        }
    }

    //--Class Stuff--------------------------------------------------
    function floobleCalendar() {
        // Define Methods
        this.setElement = fc_setElement;
        this.setElements = fc_setElements;
        this.parseDate = fc_parseDate;
        this.generateHTML = fc_generateHTML;
        this.show = fc_show;
        this.hide = fc_hide;
        this.moveMonth = fc_moveMonth;
        this.setDate = fc_setDate;
        this.formatDate = fc_formatDate;
        this.setDateFields = fc_setDateFields;
        this.parseDateFields = fc_parseDateFields;
        
        this.shown = false;
    }
    
    function fc_setElement(formElement) {
        this.element = formElement;
        this.format = this.element.title;
        this.value = this.element.value;
        this.id = this.element.id;
        this.mode = 1;
    }
    
    function fc_setElements(monthElement, dayElement, yearElement) {
        this.mElement = monthElement;
        this.dElement = dayElement;
        this.yElement = yearElement;
        this.id = this.mElement.id + '-' + this.dElement.id + '-' + this.yElement.id;
        this.element = this.mElement;
        if (fc_absoluteOffsetLeft(this.dElement) < fc_absoluteOffsetLeft(this.element)) {
            this.element = this.dElement;
        }
        if (fc_absoluteOffsetLeft(this.yElement) < fc_absoluteOffsetLeft(this.element)) {
            this.element = this.yElement;
        }
        if (fc_absoluteOffsetTop(this.mElement) > fc_absoluteOffsetTop(this.element)) {
            this.element = this.mElement;
        }
        if (fc_absoluteOffsetTop(this.dElement) > fc_absoluteOffsetTop(this.element)) {
            this.element = this.dElement;
        }
        if (fc_absoluteOffsetTop(this.yElement) > fc_absoluteOffsetTop(this.element)) {
            this.element = this.yElement;
        }

        this.mode = 2;
    }
    
    function fc_parseDate() {
        if (this.element.value) {
            this.date = new Date();
            var out = '';
            var token = '';
            var lastCh, ch;
            var start = 0;
            lastCh = this.format.substring(0, 1);
            for (i = 0; i < this.format.length; i++) {
                ch = this.format.substring(i, i+1);
                if (ch == lastCh) { 
                    token += ch;
                } else {
                    fc_parseToken(this.date, token, this.element.value, start);
                    start += token.length;
                    token = ch;
                }
                lastCh = ch;
            }
            fc_parseToken(this.date, token, this.element.value, start);



        } else {
            this.date = new Date();
        }
        if ('' + this.date.getMonth() == 'NaN') {
            this.date = new Date();
        }
    }    
    
    function fc_parseDateFields() {
        this.date = new Date();
        if (this.mElement.value) this.date.setMonth(fc_getFieldValue(this.mElement) - 1);
        if (this.dElement.value) this.date.setDate(fc_getFieldValue(this.dElement));
        if (this.yElement.value) this.date.setFullYear(fc_getFieldValue(this.yElement));
        if ('' + this.date.getMonth() == 'NaN') {
            this.date = new Date();
        }
    }
    
    function fc_setDate(d, m, y) {
        this.date.setYear(y);
        this.date.setMonth(m);
        this.date.setDate(d);
        if (this.mode == 1) {
            this.element.value = this.formatDate();
        } else {
            this.setDateFields();
        }
        this.hide();
    }
    
    function fc_setDateFields() {
        fc_setFieldValue(this.mElement, fc_zeroPad(this.date.getMonth() + 1));
        fc_setFieldValue(this.dElement, fc_zeroPad(this.date.getDate()));
        fc_setFieldValue(this.yElement, this.date.getFullYear());
    }
    
    function fc_formatDate() {
        var out = '';
        var token = '';
        var lastCh, ch;
        lastCh = this.format.substring(0, 1);
        for (i = 0; i < this.format.length; i++) {
            ch = this.format.substring(i, i+1);
            if (ch == lastCh) { 
                token += ch;
            } else {
                out += fc_formatToken(this.date, token);
                token = ch;
            }
            lastCh = ch;
        }
        out += fc_formatToken(this.date, token);
        return out;
    }
    
    function fc_show() {
        if (typeof(fc_openCal) != 'undefined') { fc_openCal.hide(); }
    
        if (this.mode == 1) {
            this.parseDate();
        } else {
            this.parseDateFields();
        }
        this.showDate = new Date(this.date.getTime());
        if (typeof(this.div) != 'undefined') {
            this.div.innerHTML = this.generateHTML();
        }
        
        if (typeof(this.div) == 'undefined') {
            this.div = document.createElement('DIV');
            this.div.style.position = 'absolute';
            this.div.style.display = 'none';
            this.div.className = 'fc_main';
            this.div.innerHTML = this.generateHTML();
            this.div.style.left = fc_absoluteOffsetLeft(this.element);
            this.div.style.top = fc_absoluteOffsetTop(this.element) + this.element.offsetHeight + 1;
            document.body.appendChild(this.div);
        }
        this.div.style.display = 'block';
        this.shown = true;
        fc_openCal = this;
    }
    
    function fc_generateHTML() {
        var html = '<TABLE><TR><TD CLASS="fc_head" COLSPAN="6"><DIV STYLE="float: right"><a class="fc_head" href="http://www.flooble.com/scripts/calendar.php" target="_blank">©</a></DIV>CALENDAR:</TD><TD CLASS="fc_date" onMouseover="this.className = \'fc_dateHover\';" onMouseout="this.className=\'fc_date\';" onClick="getCalendar(\'' + this.id + '\').hide();"><B>X</B></TD></TR>';
        html += '<TR><TD CLASS="fc_date" onMouseover="this.className = \'fc_dateHover\';" onMouseout="this.className=\'fc_date\';" onClick="getCalendar(\'' + this.id + '\').moveMonth(-12);"><B><<</B></TD><TD CLASS="fc_date" onMouseover="this.className = \'fc_dateHover\';" onMouseout="this.className=\'fc_date\';" onClick="getCalendar(\'' + this.id + '\').moveMonth(-1);"><B><</B></TD><TD COLSPAN="3" CLASS="fc_wk">' + fc_months[this.showDate.getMonth()] + ' ' + fc_getYear(this.showDate) + '</TD><TD CLASS="fc_date" onMouseover="this.className = \'fc_dateHover\';" onMouseout="this.className=\'fc_date\';" onClick="getCalendar(\'' + this.id + '\').moveMonth(1);"><B>></B></TD><TD CLASS="fc_date" onMouseover="this.className = \'fc_dateHover\';" onMouseout="this.className=\'fc_date\';" onClick="getCalendar(\'' + this.id + '\').moveMonth(12);"><B>>></B></TD></TR>';
        html += '<TR><TD WIDTH="14%" CLASS="fc_wk">Mo</TD><TD WIDTH="14%" CLASS="fc_wk">Tu</TD><TD WIDTH="14%" CLASS="fc_wk">We</TD><TD WIDTH="14%" CLASS="fc_wk">Th</TD><TD WIDTH="14%" CLASS="fc_wk">Fr</TD><TD class="fc_wknd" WIDTH="14%">Sa</TD><TD class="fc_wknd" WIDTH="14%">Su</TD></TR>';
        html += '<TR>';
        var dow = 0;
        var i, style;
        var totald = fc_monthLength(this.showDate);
        for (i = 0; i < fc_firstDOW(this.showDate); i++) {
            dow++;
            html += '<TD> </TD>';
        }
        for (i = 1; i <= totald; i++) {
            if (dow == 0) { html += '<TR>'; }
            if (this.showDate.getMonth() == this.date.getMonth() && this.showDate.getYear() == this.date.getYear() && this.date.getDate() == i) { 
                style = ' style="font-weight: bold;"';
            } else {
                style = '';
            }
            html += '<TD CLASS="fc_date" onMouseover="this.className = \'fc_dateHover\';" onMouseout="this.className=\'fc_date\';" onClick="getCalendar(\'' + this.id + '\').setDate(' + i + ', ' + this.showDate.getMonth() + ', ' + this.showDate.getFullYear() + ');" ' + style + '>' + i + '</TD>';
            dow++;
            if (dow == 7) {
                html += '</TR>';
                dow = 0;
            }
        }
        if (dow != 0) {
            for (i = dow; i < 7; i++) {
                html += '<TD> </TD>';
            }
        }
        html +='</TR>';
        html += '</TABLE>';
        return html;
    }
    
    function fc_hide() {
        if (this.div != false) {
            this.div.style.display = 'none';
        }
        this.shown = false;
        fc_openCal = undefined;
    }
    
    function fc_moveMonth(amount) {
        var m = this.showDate.getMonth();
        var y = fc_getYear(this.showDate);
        if (amount == 1)  {
            if (m == 11)  {
                this.showDate.setMonth(0);
                this.showDate.setYear(y + 1);
            } else {
                this.showDate.setMonth(m + 1);
            }
        } else if (amount == -1)  {
            if (m == 0)  {
                this.showDate.setMonth(11);
                this.showDate.setYear(y - 1);
            } else {
                this.showDate.setMonth(m - 1);
            }
        } else if (amount == 12) {
            this.showDate.setYear(y + 1);
        } else if (amount == -12) {
            this.showDate.setYear(y - 1);
        }
        this.div.innerHTML = this.generateHTML();
    }
    
    //--Utils-------------------------------------------------------------
    function fc_absoluteOffsetTop(obj) {
         var top = obj.offsetTop;
         var parent = obj.offsetParent;
         while (parent != document.body) {
             top += parent.offsetTop;
             parent = parent.offsetParent;
         }
         return top;
     }
     
     function fc_absoluteOffsetLeft(obj) {
         var left = obj.offsetLeft;
         var parent = obj.offsetParent;
         while (parent != document.body) {
             left += parent.offsetLeft;
             parent = parent.offsetParent;
         }
         return left;
     }
     
     function fc_firstDOW(date) {
         var dow = date.getDay();
         var day = date.getDate();
         if (day % 7 == 0) return dow;
         return (7 + dow - (day % 7)) % 7; 
     }
     
     function fc_getYear(date) {
         var y = date.getYear();
         if (y > 1900) return y;
         return 1900 + y;
     }
     
     function fc_monthLength(date) {
        var month = date.getMonth();
        var totald = 30;
        if (month == 0 
            || month == 2
            || month == 4
            || month == 6
            || month == 7
            || month == 9
            || month == 11) totald = 31;
        if (month == 1) {
            var year = date.getYear();
            if (year % 4 == 0 && (year % 400 == 0 || year % 100 != 0))
                 totald = 29;
            else
                totald = 28;
        }
        return totald;
     }
     
     function fc_formatToken(date, token) {
        var command = token.substring(0, 1);
        if (command == 'y' || command == 'Y') {
            if (token.length == 2) { return fc_zeroPad(date.getFullYear() % 100); }
            if (token.length == 4) { return date.getFullYear(); } 
        }
        if (command == 'd' || command == 'D') {
            if (token.length == 2) { return fc_zeroPad(date.getDate()); }
        }
        if (command == 'm' || command == 'M') {
            if (token.length == 2) { return fc_zeroPad(date.getMonth() + 1); }
            if (token.length == 3) { return fc_months[date.getMonth()]; } 
        }
        return token;
     }
     
     function fc_parseToken(date, token, value, start) {
        var command = token.substring(0, 1);
        var v;
        if (command == 'y' || command == 'Y') {
            if (token.length == 2) { 
                v = value.substring(start, start + 2);
                if (v < 70) { date.setFullYear(2000 + parseInt(v)); } else { date.setFullYear(1900 + parseInt(v)); } 
            }
            if (token.length == 4) { v = value.substring(start, start + 4); date.setFullYear(v);} 
        }
        if (command == 'd' || command == 'D') {
            if (token.length == 2) { v = value.substring(start, start + 2); date.setDate(v); }
        }

        if (command == 'm' || command == 'M') {
            if (token.length == 2) { v = value.substring(start, start + 2); date.setMonth(v - 1); }
            if (token.length == 3) { 
                v = value.substring(start, start + 3);
                var i;
                for (i = 0; i < fc_months.length; i++) {
                    if (fc_months[i].toUpperCase() == v.toUpperCase()) { date.setMonth(i); }
                }
            } 
        }
     }
     
     function fc_zeroPad(num) {
        if (num < 10) { return '0' + num; }
        return num;
     }

    function fc_getObj(id) {
        if (fc_ie) { return document.all[id]; } 
        else { return document.getElementById(id);    }
    }

      function fc_setFieldValue(field, value) {
                if (field.type.substring(0,6) == 'select') {
                        var i;
                        for (i = 0; i < field.options.length; i++) {
                                if (fc_equals(field.options[i].value, value)) {
                                        field.selectedIndex = i;
                                }
                        }
                } else {
                        field.value = value;
                }
      }

      function fc_getFieldValue(field) {
                if (field.type.substring(0,6) == 'select') {
                        return field.options[field.selectedIndex].value;
                } else {
                        return field.value;
                }
      }
      
      function fc_equals(val1, val2) {
              if (val1 == val2) return true;              
              if (1 * val1 == 1 * val2) return true;
              return false;
      }
     
</script>



<?php require_once('Connections/hotelreservation.php'); ?>
<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO reservation (id, `in`, `out`, span) VALUES (%s, %s, %s, %s)",
                       GetSQLValueString($_POST['id'], "int"),
                       GetSQLValueString($_POST['in'], "date"),
                       GetSQLValueString($_POST['out'], "date"),
                       GetSQLValueString($_POST['span'], "date"));

  mysql_select_db($database_hotelreservation, $hotelreservation);
  $Result1 = mysql_query($insertSQL, $hotelreservation) or die(mysql_error());
}


?>


            
<form action="<?php echo $editFormAction; ?>" method="post" name="form1" id="form1">
  <table align="center">
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Id:</td>
      <td><input type="text" name="id" value="" size="32" readonly="readonly" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">In:</td>
      <td><input size="10" id="fc_1265961698" type="text" name="in"  readonly="READONLY" title="YYYY-MM-DD" />
      <input type="button" value="=" onclick="displayCalendarFor('fc_1265961698');" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Out:</td>
      <td><input size="10" id="fc_1265961699" type="text" readonly="READONLY" name="out" title="YYYY-MM-DD" />
      <input type="button" value="=" onclick="displayCalendarFor('fc_1265961699');" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">Span:</td>
      <td>
      
      <input type="text" name="span" value="<?php echo $span; ?>" size="32" readonly="readonly" /></td>
    </tr>
    <tr valign="baseline">
      <td nowrap="nowrap" align="right">&nbsp;</td>
      <td><input type="submit" value="Insert record" /></td>
    </tr>
  </table>
  <input type="hidden" name="MM_insert" value="form1" />
</form>
<p>&nbsp;</p>


                                
<?php 
echo "CHECK in : " . " " . $_POST['in'];
echo "<br>";
echo "<br>";

echo "CHECK OUT : " . " " . $_POST['out'];
echo "<br>";
echo "<br>";

$start = $_POST['in'];
$end = $_POST['out']; 

if($_POST){
            list($y,$m,$d) = explode('-',$start);
            $span = Date("Y-m-d", mktime(0,0,0,$m,$d,$y));            
            while ($span < $end)
            {
                
            $span = Date("Y-m-d", mktime(0,0,0,$m,$d,$y));
            echo $span . "<br>";
            $d = $d +1;
            }   
}            
?>

[SoN9ne]

For starters. You are declaring the same js code twice.

[hardinera]

For starters. You are declaring the same js code twice.

if you try to run this code you will see why im calling the two js code.. actually its for 2 callender which is named "in" and "out" so i dont see any problem with that.. what my question is in my php code.. when i try to insert the "span" (between) dates of the "in" and "out" its not inseerting to my databsse but im sure that im getting the values from the fields.

any help