New answers tagged mysql
1
vote
Accepted
How to use NOW() with DatabaseDriver->insertObject()
I ended up using arrays to compose the sql query, as per this alternative mentioned in the joomla docs, which works fine:
$columns = array('update_timestamp');
$values = array('NOW()');
$db = Factory::...
- 243
3
votes
How to use NOW() with DatabaseDriver->insertObject()
If you are going to insert a row into the database using an object, you are going to need to pass in values that do not leverage SQL functions. insertObject() will treat the object's payload as ...
- 4,646
Top 50 recent answers are included
Related Tags
mysql × 272joomla-3.x × 123
php × 91
jdatabase × 46
database × 38
sql × 24
component × 14
pivot × 13
rsform × 12
development × 11
joomla-3.4 × 11
joomla-4.x × 10
phpmyadmin × 10
custom-component × 9
joomla-2.5 × 7
joomla-api × 7
joomla-3.6 × 7
installation × 7
user × 6
php7 × 6
module × 5
extensions × 5
form × 5
view × 5
joomla-4 × 5