Advertisement
Guest User

Untitled

a guest
Oct 21st, 2017
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.46 KB | None | 0 0
  1. function getCustomers($from=0, $records=0, $genderId=0){
  2. $customers = array();
  3. $sql = "SELECT * FROM `customer`";
  4. if($genderId != 0){
  5. $sql .= " WHERE genderId=" . $genderId;
  6. }
  7. $sql .= " ORDER BY company, lastname ";
  8. if($records > 0){
  9. $sql .= " LIMIT $from, $records";
  10. }
  11.  
  12. $res = $this->connection->query($sql);
  13. while($row = mysqli_fetch_assoc($res)){
  14. array_push($customers, new Customer($row, true));
  15. }
  16. return $customers;
  17. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement