help, help, date from MySQL with DB Class

The following warnings occurred:

Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.1.2-1ubuntu2.14 (Linux)

File	Line	Function
/global.php(961) : eval()'d code	26	errorHandler->error
/global.php	961	eval
/printthread.php	16	require_once

help, help, date from MySQL with DB Class - Printable Version

+- UserSpice (https://userspice.com/forums)
+-- Forum: Support Center (https://userspice.com/forums/forumdisplay.php?fid=23)
+--- Forum: UserSpice 4.3 and Below (https://userspice.com/forums/forumdisplay.php?fid=26)
+--- Thread: help, help, date from MySQL with DB Class (/showthread.php?tid=642)

help, help, date from MySQL with DB Class - marceloatmartins - 07-14-2017

Hi everybody,

How can I get Date of MySQL with DB Class?

I try something like this:

<?php

require_once '../../users/init.php';
require_once $abs_us_root.$us_url_root.'users/includes/header.php';

$today = $db->query("SELECT NOW()");

echo $today;

?>

But doesn't work:

Recoverable fatal error: Object of class DB could not be converted to string in C:\xamppadm\htdocs\appreq\app\tests\data.php on line 8

Thanks for all help

help, help, date from MySQL with DB Class - marceloatmartins - 07-14-2017

Is possible to implement a method like $db->getDate(); ?

help, help, date from MySQL with DB Class - faguss - 07-14-2017

>How can I get Date of MySQL with DB Class?

$db->query("SELECT CURRENT_TIMESTAMP")->first(true)["CURRENT_TIMESTAMP"];

>Is possible to implement a method like $db->getDate(); ?

Yes, go ahead.

help, help, date from MySQL with DB Class - karsen - 07-15-2017

Faguss posted the solution, but here is why your code didn't work. The problem with your original query is you are trying to use echo, which only prints strings. $today is an object that was returned by $db->query(), so you'd need echo out the object property (or convert it to an array first if you are more comfortable with them).

$db->first() returns the first row as an object, and passing a true value will tell it to return an array instead. This is extremely useful when you know you will only have one row:

Code:
$db->first(true) // this will return an array

Now that it's an object/array of just the first row, you can echo the data as you please:

Code:
$result = $db->query("SELECT NOW() as 'now'")->first();

Code:
echo $result->now; // as an object

Code:
$result = $db->query("SELECT NOW() as 'now'")->first(true);

Code:
echo $result['now']; // as an array

help, help, date from MySQL with DB Class - marceloatmartins - 07-17-2017

Wow Karsen and Faguss,
Really thanks for your explanations.
Understood totally.
Hugs

help, help, date from MySQL with DB Class - karsen - 07-17-2017

Glad to help, I had some trouble myself when I first swapped to UserSpice!