help, help, date from MySQL with DB Class

[marceloatmartins]

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

[marceloatmartins]

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

[faguss]

>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.

[karsen]

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

[marceloatmartins]

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

[karsen]

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