Manual database query
Source
<?php
$sql = "SELECT * FROM customer WHERE id = 1";
// stdClass as result
$this->view->result1 = $this->db->doquery($sql);
// customer Activerecord as result
$this->view->result2 = $this->db->doquery($sql1, [], 'customer');
Result
stdClass Object
(
[id] => 1
[username] => Tester
[password] => c098c977b6c9242f738ed521a63cb7e8
[email] => test@example.com
[created] => 2024-12-07
)
Database\Barebone_me\Activerecords\customer Object
(
[tablename:Barebone\Activerecord:private] => customer
[primary_key:Barebone\Activerecord:private] => id
[pdo:Barebone\Activerecord:private] => Barebone\Database\Connectors\PDO Object
(
)
[debug:protected] =>
[joins:protected] => Array
(
)
[selected_columns:protected] => Array
(
)
[id] => 1
[username] => Tester
[password] => c098c977b6c9242f738ed521a63cb7e8
[email] => test@example.com
[created] => 2024-12-07
)