LiveWhale CMS

Welcome, Guest Login

Support Center

Our documentation is moving: docs.livewhale.com

Please check docs.livewhale.com for the most up-to-date LiveWhale CMS and LiveWhale Calendar documentation. The below legacy documentation will remain available as a reference until the documentation migration is complete.

Long Form (extensive SQL request)

Last Updated: Nov 25, 2015 10:45AM PST

The long form allows you to specify a much more extensive SQL request by utilizing methods that match the SQL commands. Simply chain the needed methods together to complete an entire SQL request.

 

// reasonably complex example
$_LW->dbo  ->select(array('*', 'livewhale_images.id AS image_id'))  ->
from('livewhale_news')  -> join('livewhale_images2any', array('id2' => 'livewhale_news.id'))  ->
join('livewhale_images', array('livewhale_images.id' => 'livewhale_images2any.id1'))  ->
where("livewhale_news.title LIKE '%?%'", $foo);

 

eb8f96c071020d8b0923da726d6cab65@livewhale.desk-mail.com
https://cdn.desk.com/
false
desk
Loading
seconds ago
a minute ago
minutes ago
an hour ago
hours ago
a day ago
days ago
about
false
Invalid characters found
/customer/en/portal/articles/autocomplete?b_id=4256