php - Display Datatime-local Datatype in HTL5 Table Without Trailing Text or Zeros -

-

i want display data sql table , datatype datetime(6) data size 6 bytes. when display data in html table input tag andtype text datetime format trailing zeros. want display datetime format without trailing zeroes.i present codes below.

codes on input form data collected.

<li>     <label for="date-time">access date , time</label>     <input name="date-time" type="datetime-local" id="date-time"/>  </li>

this code displaying data.

<?php  include('/templates/header.php');  $host = "localhost"; // host name   $username = "root"; // mysql username   $password = ""; // mysql password   $db_name = "datacentre"; // database name   $tbl_name = "data_centre_users"; // table name   $server_name = "localhost";    // create connection  $con = new mysqli($server_name, $username, $password, $db_name, 3306);  if($con->connect_error){     die("connection failed: ".$con->connect_error);  }    // check connection  if($con->connect_error){   die("connection failed: ".$conn->connect_error);  }    $sql = "select * $tbl_name";  $result = $con->query($sql);  ?>    <section id="sidebar">    </section>    <section id="content">    <div id="scroll-table">  <table >  <caption>             list data mysql              </caption>              <tr>                  <th class="center"><strong>id</strong></th>                  <th class="center"><strong>firstname</strong></th>                  <th class="center"><strong>lastname</strong></th>                  <th class="center"><strong>request</strong></th>                  <th class="center"><strong>purpose</strong></th>                  <th class="center"><strong>description</strong></th>                  <th class="center"><strong>booking time</strong></th>                  <th class="center"><strong>access time</strong></th>                  <th class="center"><strong>exit time</strong></th>                  <th class="center"><strong>approved</strong></th>                  <th class="center"><strong>approved by</strong></th>                  <th class="center"><strong>update</strong></th>                  <th class="center"><strong>delete</strong></th>              </tr>              <?php              if($result->num_rows > 0){                  // output data of each row                  while($rows = $result->fetch_assoc()){ ?>                      <tr>                          <td class="center"><?php echo $rows['id']; ?></td>                          <td class="center"><?php echo $rows['fisrt_name']; ?></td>                          <td class="center"><?php echo $rows['last_name']; ?></td>                          <td class="center"><?php echo $rows['request']; ?></td>                          <td class="center"><?php echo $rows['purpose']; ?></td>                          <td class="center"><?php echo $rows['description']; ?></td>                          <td class="center"><?php echo $rows['booking_time']; ?></td>                          <td class="center"><?php echo $rows['access_time']; ?></td>                          <td class="center"><?php echo $rows['exit_time']; ?></td>                          <td class="center"><?php echo $rows['approved']; ?></td>                          <td class="center"><?php echo $rows['approved_by']; ?></td>                          <td class="center" ><a href="update.php?id=<?php echo $rows['id']; ?>">update</a></td>                          <td class="center" ><a href="delete.php?id=<?php echo $rows['id']; ?>">delete</a></td>                      </tr>                                                <?php                  }              }              ?>   </table>  </div>  </section>      <aside></aside>    <?php  $con->close();    include('/templates/footer.php');  ?>

this web page.

enter image description here

$timestamp = strtotime($rows['booking_time']); echo date('y-m-d h:i:s',$timestamp);

should format date


Comments

Post a Comment

Popular posts from this blog

yii2 - Yii 2 Running a Cron in the basic template -

-
i have seen instructions on running cron in advanced template, cant figure out how on basic template. have following controller in basic controllers folder. <?php namespace app\controllers; use yii\console\controller; /** * cron controller */ class croncontroller extends controller { public function actionindex() { echo "cron service runnning"; } public function actionmail($to) { echo "sending mail " . $to; } } i have navigated root of application , tried these comands yii cron php yii cron im getting unknown comand "cron" i know old question failed find actual answer this. if @ code yii exec file you'll notice requires /common/config/aliases.php file console/config/main.php. can naturally change these or copy on these advanced template. hope solves problem wanting same thing.
Read more

asp.net - 'System.Web.HttpContext' does not contain a definition for 'GetOwinContext' Mystery -

-
i realize question might seem trivial some, it's these types of things find myself fighting quite bit , want make sense of despite seeming losing battle in .net (for me anyway). so, if following: using system.web; ... applicationuser user = system.web.httpcontext.getowincontext().getusermanager<applicationusermanager>().findbyid(system.web.httpcontext.user.identity.getuserid()); that produces error in title , red getowincontext() , error cannot resolve symbol 'getowincontext()' however, if following (remove system.web in front of httpcontext ), works expected (or @ least no errors): using system.web; ... applicationuser user = httpcontext.getowincontext().getusermanager<applicationusermanager>().findbyid(system.web.httpcontext.user.identity.getuserid()); however, if (same line that's working using system.web commented out): //using system.web; ... applicationuser user = httpcontext.getowincontext().getusermana
Read more

php - How do you embed a video into a custom theme on WordPress? -

-
i'm using wordpress 4.2.3 , created custom theme use. when try embed youtube video (pasting http:// link content area), video shows in edit content area, when view site, shows text url instead. i tried sorts of things clear formatting, removing link, unchecking settings in writing area, etc. temporarily switched default wp theme , video shows up, i'm missing in template code, , can't figure out what. here code used outputting content in template. index.php <div class="video"> <?php $post_id = 26; $queried_post = get_post($post_id); echo $queried_post->post_content; ?> </div> thanks - appreciate it!
Read more