[cyberfolli]

HI I have found alot of timestamp to date functions and solutions but none that convert a date like 01/01/2009 to a timestamp

Basically I have a from that a user is choosing the date from a drop down menu day / month / year.. but once they choose that I need to take the date they have chosen and convert it to a timestamp..

I have found the reverse for display but not for converting.

Any help would be greatly appreciated.

[Nico]

If the days and months come from separate drop downs, check mktime(). If it's all one string, check strtotime().

[cyberfolli]

So if I define the drop downs as month day year

when if goes to process the data I would use something like this? I have tried it it doesn't give me an error but the data is missing

$stamp = $_POST['Y-m-d H:i:s, mktime($hour, $minutes, $seconds, $month, $day, $year)'];

[wirehopper]

The $stamp code you posted won't work.

Please post the HTML and PHP code.

[cyberfolli]

PHP Code:

<form action="" method="post" name="verify" onsubmit="return ValidateRequiredFields();">





  <div align="center">

    <table width="500"  border="0" cellpadding="2" cellspacing="0" bgcolor="#FFFFFF">

              <tr>

                               <td colspan="2">Please submit the following information.</td>

                    </tr>

                       <tr bgcolor="#CCCCCC">

                         <td>Date</td>

                         <td><select name="month">

<option value="1" selected="selected">January</option>

<option value="2">February</option>

<option value="3">March</option>

<option value="4">April</option>

<option value="5">May</option>

<option value="6">June</option>





</select> 

                           <select name="day">

<option value="1" selected="selected">1</option>

<option value="2">2</option>



<option value="3">3</option>



</select><select name="year">

<option value="2009" selected="selected">2009</option>

<option value="2010">2010</option>

<option value="2011">2011</option>

<option value="2012">2012</option>



<option value="2013">2013</option>

<option value="2014">2014</option>

<option value="2015">2015</option>

<option value="2016">2016</option>

<option value="2017">2017</option>

<option value="2018">2018</option>

<option value="2019">2019</option>

</select></td>

      </tr>

                       <tr bgcolor="#CCCCCC">

                               <td bgcolor="#FFFFFF"><strong>Reoccurring</strong></td>

                               <td bgcolor="#FFFFFF"><input name="reoccurr" type="checkbox" id="reoccurr" value="yes" /></td>

                    </tr>

                       <tr bgcolor="#CCCCCC">

                         <td>DaySpan</td>

                         <td><select name="day" id="day">

                           <option value="1" selected="selected">1</option>

                       

                         </select></td>

      </tr>

                       <tr bgcolor="#CCCCCC">

                         <td><strong>Title</strong></td>

                         <td><input name="title" type="text" id="title" size="80" /></td>

      </tr>

                       <tr bgcolor="#CCCCCC">

                         <td bgcolor="#FFFFFF"><strong>department</strong></td>

                         <td bgcolor="#FFFFFF"><select name="department" id="department">

               

       

            

              <?php

$sql = "SELECT * FROM categories order by fullName";

$query = mysql_query($sql);

while($row = mysql_fetch_array($query)) {



    

echo "    <option value=".$row['ID']."> ".$row['fullName']."</option>";

 

}

?>

  </select>

  

  

</td>

      </tr>

                       <tr bgcolor="#CCCCCC">

                         <td><strong>Description</strong></td>

                         <td><textarea name="notes" cols="80" rows="10" id="notes"></textarea></td>

      </tr>

                       <tr bgcolor="#CCCCCC">

                               <td>&nbsp;</td>

                               <td><input type="submit" name="submit" value="Submit!" /></td>

                    </tr>

    </table>

  </div>

       

</form>

<?php

} else {

    

    $stamp = $_POST['Y-m-d H:i:s, mktime($hour, $minutes, $seconds, $month, $day, $year)'];

$reoccurr = $_POST['reoccurr'];

$title = $_POST['title'];

$department = $_POST['department'];

$notes = $_POST['notes'];







mysql_query("INSERT INTO `events` (stamp, reoccurr, title, department, notes) VALUES ('$stamp','$reoccurr','$title','$department','$notes')");

echo "<center> <a href=index.php>Return to calendar</a>";

}

?>

[wirehopper]

$stamp will probably have to be something like:

PHP Code:

$stamp=$_POST['month'].'/'.$_POST['day'].'/'.$_POST['year']; 

[Jcbones]

You want at timestamp or a datestamp?

Timestamp includes the Time (example: 2009-09-10 23:13:51)<-pulled from MySQL database.
Date stamp does not include time (example: 2009-12-19)<- pulled from MySQL database.

PHP Code:

$month = $_POST['month'];

$day = $_POST['day'];

$year = $_POST['year'];



//Date stamp (type: Date) would be.

$stamp = $year . '-' . $month . '-' . $day;



//Timestamp (type:Timestamp) would be.

$stamp = date("Y-m-d H:i:s", mktime(0,0,0,$month,$day,$year));



//output of date = 2009-12-19

//output of timestamp = 2009-12-19 00:00:00 

I don't see any reason why you would want a timestamp which the user selects, unless you ask them to pass the Hour, Minute, and Second as well.

[cyberfolli]

THanks a bunch.. I will try it out and see if it pans out.. One of these days I will understand this stuff..

[cyberfolli]

OK I am one step closer .. it works now and is entering the data..

Now i need to convert it to a unix date stamp "1252595920" instead of just a date in one field

Code:

$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year'];

//Date stamp (type: Date) would be.
$stamp = $year . '-' . $month . '-' . $day; 
$month = $_POST['month'];
$day = $_POST['day'];
$year = $_POST['year']; 
$reoccurr = $_POST['reoccurr'];
$title = $_POST['title'];
$department = $_POST['department'];
$notes = $_POST['notes'];

[Nico]

PHP Code:

$stamp = mktime(0, 0, 0, $month, $day, $year);