Database query in view file/template in CodeIgniter 4

Admin

1 day ago

$db = \Config\Database::connect();
$orderid = $order_resultval->userid;            		
$builder = $db->table('tb_customer');
$builder->select('*');
$builder->where('id', $orderid);					
$query = $builder->get();
$details = $query->getResult();

$db = \Config\Database::connect();

$orderid = $order_resultval->userid;

$builder = $db->table('tb_customer');

$builder->select('*');

$builder->where('id', $orderid);

$query = $builder->get();

$details = $query->getResult();