How to get raw query results? about pixie HOT 4 CLOSED

Hi,

Have you tried this?

var_dump($query->first());
// or
var_dump($query->get());

from pixie.

I did, and it complained about not having a table to use.

I ended up realizing I could get the pdo object from $query and handled it that way:

$query = $this->db->pdo()->query("SHOW TABLES LIKE '$table'");
return (bool)($query->rowCount() >  0);

from pixie.

I did this and it gave me first row if there is any matching table, null if there is no matching table.

$table = 'prefix_%';
var_dump(DB::query("SHOW TABLES LIKE ?", [$table])->first());

Glad that you got it working though :).

from pixie.

Didn't think of trying first(). That's a much cleaner way. :)

thanks! Enjoying the library so far. Good job.

from pixie.