How to save date into custom table

[arek1]

Hi,

I struggling with saving date into custom Joomla table. This code creating error for me:

Code: Select all

$db = JFactory::getDbo();
$date = new JDate('now');
$query = $db->getQuery(true);
$columns = array('user_id', 'last_czytanie');
$values = array('15', $date); //this line create error
			
$query
    ->insert($db->quoteName('custom_czytane'))
    ->columns($db->quoteName($columns))
    ->values(implode(',', $values));
			
$db->setQuery($query);
$db->execute();

I am marked with comment line which in my opinion creating error. I suppose it is something related to date format.

I was trying:

Code: Select all

$values = array('15', '2018-01-01');

and this:

Code: Select all

$values = array('15', '2018-01-01 01:01:01');

and this does not work too.

What I am doing wrong?

Best regards
Arek

[reviewermo]

You may try this code

Code: Select all

$values = array('15', 'Y/m/d');

[SharkyKZ]

Use $db->quote() to escape strings. For date you should also use $date->toSql() to make sure it's formatted correctly. So change the erroneous line to this:

Code: Select all

$values = array(15, $db->quote($date->toSql()));

[arek1]

It is working, Thank you.