How to change SQL Query to MXAPI

Example of basic  and advance query.

1. BASIC

SQL  :  Select * from rm_res_new where room = $id;

MXAPI :

$programObj = $_mxPub->factory("rm_res_new", MX_OBJECT_PROGRAM);

$criteria = array('room' => $id);

$articleObj = $programObj->getArticles($criteria);

2. ADVANCE

a)    Query “LIKE”

SQL  :  Select * from rm_res_new where submit_by LIKE '%'.$staffID.'%';

MXAPI :

$programObj = $_mxPub->factory("rm_res_new", MX_OBJECT_PROGRAM);

$criteria = array('submit_by' => array('%'.$staffID.'%', 'LIKE'));

$articleObj = $programObj->getArticles($criteria);

b)    Query for operator  “<=” OR “>=”

SQL  :  Select * from rm_res_new where flag_withdraw <= $flag_withdraw;

MXAPI :

$programObj = $_mxPub->factory("rm_res_new", MX_OBJECT_PROGRAM);

$criteria = array('flag_withdraw' => array($flag_withdraw, '<='));

$articleObj = $programObj->getArticles($criteria);

c)    Query “AND”

SQL  :  Select * from rm_res_new where floor =$pg AND room = $id;

MXAPI :

$programObj = $_mxPub->factory("rm_res_new", MX_OBJECT_PROGRAM);

$criteria = array('floor' => $pg, 'room' => $id);

$articleObj = $programObj->getArticles($criteria);

d)    Query “OR”

SQL  :  Select * from rm_res_new where host_empid = ‘$empid’ OR submit_by LIKE  ‘%‘.$empid.’%‘  OR attendee_int LIKE ‘%‘.$empid.’%‘ ;

MXAPI :

$programObj = $_mxPub->factory("rm_res_new", MX_OBJECT_PROGRAM);

$criteria = array('(OR)01' => array('host_empid' => $empid,  'submit_by' => array( ‘%’.$empid.'%', 'LIKE'),'attendee_int' => array( $empid, 'LIKE')));

$articleObj = $programObj->getArticles($criteria); 

e)    Query “OR + AND”

SQL  : Select * from rm_res_new where ((timestart >= ‘$time_start’ AND time start >= ‘$time_end’) OR(timeend>=‘$time_start’ AND timeend >= ‘$time_end));

MXAPI :

$programObj = $_mxPub->factory("rm_res_new", MX_OBJECT_PROGRAM);

$criteria = array('(OR)01' => array( 'timestart' => array( array($time_start, '>=', 'AND'), array($time_end, '<=', 'AND')) , '(OR)02' =>  array('timeend' => array(array($time_start, '>=', 'AND'), array($time_end, '<=', 'AND')))), 'orderby' => "<id" );

$articleObj = $programObj->getArticles($criteria);