如何使用前端jQuery更改MySQL日期格式(How to change MySQL date format using front end jQuery) mysql

MySQL数据库具有日期字段，其内容日期格式为2016-02-28 02:11:24 。 以下php代码和j-query在bootstrap模型上显示日期。 我想更改日期格式为28 Feb 2016, 02:11 PM如何使用前端J查询或后端MySQL字段格式？

<?php foreach ($value as $value2) { echo "<div class='well'>"; echo '<p class="target" userRegdate = "' . $value2->added_date . '" >' . $value2->content . '</p>'; echo "</div>"; } ?>

J-query对话框显示日期

//Display dialog box when mouse click $(".target").click(function () { var publish_date = $(this).attr("userRegdate"); BootstrapDialog.show({ title: 'user added date', message: publish_date }); });

MySQL database has date field which contents date format as 2016-02-28 02:11:24. Following php code and j-query displays date on bootstrap model. I want to change the date format as 28 Feb 2016, 02:11 PM How to do it using front end J-query or back end MySQL field format?

<?php foreach ($value as $value2) { echo "<div class='well'>"; echo '<p class="target" userRegdate = "' . $value2->added_date . '" >' . $value2->content . '</p>'; echo "</div>"; } ?>

J-query dialog box to display date

//Display dialog box when mouse click $(".target").click(function () { var publish_date = $(this).attr("userRegdate"); BootstrapDialog.show({ title: 'user added date', message: publish_date }); });

最满意答案

//code added the date function with parameter to format date <?php foreach ($value as $value2) { echo "<div class='well'>"; echo '<p class="target" userRegdate = "' . date("j, F, Y, g:i a",strtotime($value2->added_date)) . '" >' . $value2->content . '</p>'; echo "</div>"; } ?> //code added the date function with parameter to format date <?php foreach ($value as $value2) { echo "<div class='well'>"; echo '<p class="target" userRegdate = "' . date("j, F, Y, g:i a",strtotime($value2->added_date)) . '" >' . $value2->content . '</p>'; echo "</div>"; } ?>如何使用前端jQuery更改MySQL日期格式(How to change MySQL date format using front end jQuery) mysql

MySQL数据库具有日期字段，其内容日期格式为2016-02-28 02:11:24 。 以下php代码和j-query在bootstrap模型上显示日期。 我想更改日期格式为28 Feb 2016, 02:11 PM如何使用前端J查询或后端MySQL字段格式？

<?php foreach ($value as $value2) { echo "<div class='well'>"; echo '<p class="target" userRegdate = "' . $value2->added_date . '" >' . $value2->content . '</p>'; echo "</div>"; } ?>

J-query对话框显示日期

//Display dialog box when mouse click $(".target").click(function () { var publish_date = $(this).attr("userRegdate"); BootstrapDialog.show({ title: 'user added date', message: publish_date }); });

MySQL database has date field which contents date format as 2016-02-28 02:11:24. Following php code and j-query displays date on bootstrap model. I want to change the date format as 28 Feb 2016, 02:11 PM How to do it using front end J-query or back end MySQL field format?

<?php foreach ($value as $value2) { echo "<div class='well'>"; echo '<p class="target" userRegdate = "' . $value2->added_date . '" >' . $value2->content . '</p>'; echo "</div>"; } ?>

J-query dialog box to display date

//Display dialog box when mouse click $(".target").click(function () { var publish_date = $(this).attr("userRegdate"); BootstrapDialog.show({ title: 'user added date', message: publish_date }); });

最满意答案

//code added the date function with parameter to format date <?php foreach ($value as $value2) { echo "<div class='well'>"; echo '<p class="target" userRegdate = "' . date("j, F, Y, g:i a",strtotime($value2->added_date)) . '" >' . $value2->content . '</p>'; echo "</div>"; } ?> //code added the date function with parameter to format date <?php foreach ($value as $value2) { echo "<div class='well'>"; echo '<p class="target" userRegdate = "' . date("j, F, Y, g:i a",strtotime($value2->added_date)) . '" >' . $value2->content . '</p>'; echo "</div>"; } ?>