Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // $sql = "SELECT * FROM phpbb_adr_shops_items
- //
- // WHERE item_owner_id = 1
- //
- // AND item_in_shop = 0
- //
- // AND item_duration > 0
- //
- // AND item_name = :name
- //
- // ORDER BY item_name ";
- //
- // $selectObjStmt = $db_pdo->prepare($sql);
- // $selectObjStmt->bindParam(':name', $objet);
- // $selectObjStmt->execute();
- // $rowsObj = $selectObjStmt->fetchAll();
- /**
- * Replace the above SQL query with API call
- */
- $filter_array = array( // An array representing the SQL query
- 'where' => array(
- 'and' => array(
- array('eq' => array('ownerId' => 1)),
- array('eq' => array('inShop' => false)),
- array('gt' => array('duration' => 0)),
- array('eq' => array('name' => $objet))
- )
- ),
- 'orderBy' => 'name'
- );
- $query_parameters = array( // Regroup all query parameters in an array
- 'limit' => 0,
- 'filter' => $filter_array
- );
- $apiSession->request('GET', '/api/shop-items', $query_parameters); // Execute the query
- $rowsObj = $apiSession->getResponse()->getBody(); // Fetch the result
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement