Guest User

Untitled

a guest
Nov 22nd, 2017
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. function pedidoNovembro ($table = null) {
  2. $found = null;
  3. try {
  4. $database = open_database();
  5.  
  6. $sql = "SELECT count(dataPedido) FROM Pedido WHERE dataPedido BETWEEN '2017/11/01' AND '2017/11/30'";
  7. $result = $database->query($sql);
  8. if ($result->num_rows > 0) {
  9. $found = $result->fetch_assoc();
  10. }
  11. } catch (Exception $e) {
  12. $_SESSION['message'] = $e->GetMessage();
  13. $_SESSION['type'] = 'danger';
  14. }
  15. close_database($database);
  16. return $found;
  17.  
  18. }
  19.  
  20. $Novembro = pedidoNovembro(PEDIDO);
  21.  
  22. print_r($Novembro);
  23.  
  24. Array ( [count(dataPedido)] => 2 )
Add Comment
Please, Sign In to add comment