PHP,Mysql: Get hour,minutes and Store in Variable

Question

How can I store the actual hour and minute,from a mysql table, in variables?I want to store hour and minute like this:

//Connect database
$con = mysql_connect("localhost","root","ufmg3duc");
  if (!$con)
    die('Could not connect: ' . mysql_error());

  //Select database
  mysql_select_db("stream_net", $con);

  //Read data
  $query_month = $_GET['form_month_tend'];
  $query_day = $_GET['form_day_tend'];
  $query_year = $_GET['form_year_tend'];
  if ($query_mes == NULL)
    $query_mes = date("m");
  if ($query_dia == NULL)
    $query_dia = date("d");
  if ($query_ano == NULL)
    $query_ano = date("Y");

How can i do like i did before but with Hour and MInutes?

Please, stop using mysql_* functions already. The entire extension is deprecated (and not a moment too soon). It's alternatives are far more powerful, reliable and up-to-date. These new extensions are PDO and mysqli_* (the i in mysqli_* stands for improved). — Elias Van Ootegem
– Elias Van Ootegem, Commented Nov 21, 2013 at 10:44

Community · Accepted Answer · 2017-05-23 12:19:13Z

2

storing Time and Dates into an SQL database using php

You should use the datetime datatype for your requirement. It will store both the date and time from your input field based on your query.

For retrieving the datetime you can use the mysql's date_format() function or PHP's date() function. The datetime will always be stored according to the server's time and not on the clients time.

For Hour & Minute

print date('H:i');

$hour = date('H');

$min = date('i');

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Nov 21, 2013 at 10:34

Siraj Khan

2,35818 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Martin Over a year ago

+1 for the important hint: "The datetime will always be stored according to the server's time and not on the clients time."

Collectives™ on Stack Overflow

PHP,Mysql: Get hour,minutes and Store in Variable

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related