Advertisement
Guest User

Untitled

a guest
Oct 19th, 2019
93
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.17 KB | None | 0 0
  1. //    $sql = "SELECT * FROM phpbb_adr_shops_items
  2. //
  3. //              WHERE item_owner_id = 1
  4. //
  5. //              AND item_in_shop = 0
  6. //
  7. //              AND item_duration > 0
  8. //
  9. //              AND item_name = :name
  10. //
  11. //              ORDER BY item_name ";
  12. //
  13. //    $selectObjStmt = $db_pdo->prepare($sql);
  14. //    $selectObjStmt->bindParam(':name', $objet);
  15. //    $selectObjStmt->execute();
  16. //    $rowsObj = $selectObjStmt->fetchAll();
  17.  
  18.     /**
  19.      * Replace the above SQL query with API call
  20.      */
  21.     $filter_array = array(  // An array representing the SQL query
  22.         'where' => array(
  23.             'and' => array(
  24.                 array('eq' => array('ownerId' => 1)),
  25.                 array('eq' => array('inShop' => false)),
  26.                 array('gt' => array('duration' => 0)),
  27.                 array('eq' => array('name' => $objet))
  28.             )
  29.         ),
  30.         'orderBy' => 'name'
  31.     );
  32.     $query_parameters = array(  // Regroup all query parameters in an array
  33.         'limit' => 0,
  34.         'filter' => $filter_array
  35.     );
  36.     $apiSession->request('GET', '/api/shop-items', $query_parameters);  // Execute the query
  37.     $rowsObj = $apiSession->getResponse()->getBody();  // Fetch the result
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement