PHP - date(time) insert into DB

Question

I'm using a time method: $time= date('h:i:s');

What I want is to put this time into database in mySQL, I used: $query = mysqli_query($conn, "INSERT INTO tab ('ltime') VALUES ($time)"); but it's not working

Where tab is a table and a ltime is a Column with time Type.

What am I doing wrong?

Regards

Possible duplicate of [When to use single quotes, double quotes, and backticks in MySQL](https://stackoverflow.com/questions/11321491/when-to-use-single-quotes-double-quotes-and-backticks-in-mysql) — Carl Binalla, Oct 12 '17 at 07:59

score 1 · Answer 1 · answered Oct 12 '17 at 08:01

1

Your query will goes like this.

$query = mysqli_query($conn, "INSERT INTO tab (ltime) VALUES ('$time')");

answered Oct 12 '17 at 08:01

Subhash Shipu

343
1
4
15

score 0 · Answer 2 · answered Oct 12 '17 at 07:56

0

Your query should be like this

$query = mysqli_query($conn, "INSERT INTO tab (ltime) VALUES ($time)");

answered Oct 12 '17 at 07:56

pravindot17

1,199
1
15
32

check the value in your $time variable it must be $time = date('h:i:s') format – pravindot17 Oct 12 '17 at 08:11
It is $time = date('h:i:s') and still there is 00:00:00 in SQL. – unSkilledProgrammer Oct 12 '17 at 08:15

score 0 · Answer 3 · answered Oct 12 '17 at 07:57

0

Columns and tables should have backticks and not single quotes

INSERT INTO `tab` (`ltime`) VALUES ($time)

answered Oct 12 '17 at 07:57

Carl Binalla

5,393
5
27
46

It's not working, if I'm checking my DB there is still a 00:00:00 – unSkilledProgrammer Oct 12 '17 at 08:18

score 0 · Answer 4 · answered Oct 12 '17 at 07:57

0

$query = mysqli_query($conn, "INSERT INTO tab (ltime) VALUES ($time)");

Don't use '' when assigning the column name

answered Oct 12 '17 at 07:57

pr1nc3

8,108
3
23
36

score 0 · Answer 5 · answered Oct 12 '17 at 08:01

The first way specifies both the column names and the values to be inserted:

INSERT INTO table_name (column1, column2, column3, ...)VALUES (value1, value2, value3, ...);

If you are adding values for all the columns of the table, you do not need to specify the column names in the SQL query

INSERT INTO table_name VALUES (value1, value2, value3, ...);

In your case:

$query = mysqli_query($conn, "INSERT INTO tab (ltime) VALUES ($time)");

there is no need to single quote with column name:

Reference: https://www.w3schools.com/sql/sql_insert.asp

PHP - date(time) insert into DB

5 Answers5