Welcome Guest, Not a member yet? Register   Sign In
Rewriting query in query builder
#3

(02-08-2019, 08:53 AM)php_rocs Wrote: Thanks for reply, I was looking to use CI query builder Smile

Thanks

@roland,

Why not do it this way (documentation: https://codeigniter.com/user_guide/datab...y-bindings )...

PHP Code:
$sql "SELECT p_pedestal.*,
        ev.dev_name AS device,
        p_port.title AS port,
        UNIX_TIMESTAMP(p_pedestal.created) AS created_t,
        UNIX_TIMESTAMP(p_pedestal.updated) AS updated_t 
FROM p_pedestal 
LEFT JOIN p_port ON p_pedestal.port_id = p_port.id
JOIN p_port_user_rel ON (p_port_user_rel.username = ? ) AND p_port_user_rel.port_id = p_pedestal.port_id
INNER JOIN dev ON p_pedestal.dev_id = dev.dev_id
ORDER BY p_pedestal.formatted_address ASC"
;
$this->db->query($sql, [strtolower($_SESSION['user']['username'])]); 
Reply


Messages In This Thread
Rewriting query in query builder - by roland - 02-08-2019, 05:47 AM
RE: Rewriting query in query builder - by roland - 02-28-2019, 05:47 AM



Theme © iAndrew 2016 - Forum software by © MyBB