将字符串从 HTML 表单转换为日期


Converting String into Date from HTML Form

我收集这样的日期格式:

<select id="DOBDay" name = "DOBDay" class="pure-input-1-4">
<option>Date Of Birth Day</option>
<option value="01">01</option>

<select id="DOBMonth" name = "DOBMonth" class="pure-input-1-4">
<option>Date Of Birth Month</option>
<option value="06">06</option>

<select id="DOBYear" name = "DOBYear" class="pure-input-1-4">
<option>Date Of Birth Year</option>
<option value="2000">2000</option>

表单发布后,它会像这样收集:

$DOBDay = $_POST['DOBDay'];
$DOBMonth = $_POST['DOBMonth'];
$DOBYear = $_POST['DOBYear'];

如何将其转换为要存储到 MySQL 日期字段中的日期格式。我已经在网上搜索过,但在任何地方都找不到这个例子来寻求帮助。

试试这个:

$DOBDay = '21';
$DOBMonth = '09';
$DOBYear = '1986';  
$full_date = $DOBYear.'-'.$DOBDay.'-'.$DOBMonth;
echo $full_date;`

很多可能性.. 例如 mktime。

// if you need a timestamp
$timestamp = mktime(0,0,0,$DOBMonth, $DOBDay, $DOBYear);
// or datetime
$datetime = date("Y-m-d", $timestamp);

mysql 使用 yyyy-mm-dd 格式。 所以你应该将值存储在类似的东西中:

$DOBDay = '21';
$DOBMonth = '09';
$DOBYear = '1986';  
$date = $DOBYear.'-'.$DOBMonth.'-'.$DOBDay;
echo $date;
$date= $_POST['DOBDay']."/". $_POST['DOBMonth']."/".$_POST['DOBYear'];