download92000 2014-10-21 21:07
浏览 75
已采纳

HTML / php表中的MySql datetime字段仅显示使用表单时的日期

I have a datetime MySql field named down_stamp that I have populating an HTML table via php:

<? $sql_el = "SELECT * FROM events WHERE loc_id = '$lid'";
$result_el = mysql_query($sql_el);
while ($row_el = mysql_fetch_array($result_el)) {
?>
<tr>
  <td><?=$row_el['down_stamp']?></td>
</tr>
</form>
<? } ?>

This produces results in the format I'd like: 2013-09-15 08:30:00. However, I'd like to make this field modifiable, so if I just convert it into a form element like this:

<form name="fm_editevent" method="post">
<tr>
  <td><input name="down_stamp_ed" required="required" value=<? echo $row_el['down_stamp']; ?> type="text"></td>
  <td><input value="Update" type="submit" name="update_el"></td>     
</tr>
</form>
<? } ?>

Then the down_stamp field only displays the date: 2013-09-15. I don't think it's a width issue as there's plenty of room in the text box. I tried adding <td width=100> (twas a guess). I also tried to declare the time in php when expanding the variable, which just gave me an error and the date 1970-01-01 01:33:33

<td><input name="down_stamp_ed" required="required" value=<? echo date("Y-m-d H:i:s", $row_el['down_stamp']);?> ></td>

How can I get the full datetime field data to echo in this form text box?

  • 写回答

3条回答 默认 最新

  • dousaoxiancy199896 2014-10-21 21:16
    关注

    You missed the quotation marks...

    Use:

    <td><input name="down_stamp_ed" required="required" value="<? echo $row_el['down_stamp']; ?>" type="text"></td>
    

    (without the quotation marks the result would look like this:

    <td><input name="down_stamp_ed" required="required" value=2013-09-15 01:33:33 type="text"></td>
    

    and just because you're lucky your browser interprets "2013-09-15" as the value of the field ;-)

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(2条)

报告相同问题?

悬赏问题

  • ¥15 这个电路是如何实现路灯控制器的,原理是什么,怎么求解灯亮起后熄灭的时间如图?
  • ¥15 matlab数字图像处理频率域滤波
  • ¥15 在abaqus做了二维正交切削模型,给刀具添加了超声振动条件后输出切削力为什么比普通切削增大这么多
  • ¥15 ELGamal和paillier计算效率谁快?
  • ¥15 file converter 转换格式失败 报错 Error marking filters as finished,如何解决?
  • ¥15 ubuntu系统下挂载磁盘上执行./提示权限不够
  • ¥15 Arcgis相交分析无法绘制一个或多个图形
  • ¥15 关于#r语言#的问题:差异分析前数据准备,报错Error in data[, sampleName1] : subscript out of bounds请问怎么解决呀以下是全部代码:
  • ¥15 seatunnel-web使用SQL组件时候后台报错,无法找到表格
  • ¥15 fpga自动售货机数码管(相关搜索:数字时钟)