Advertisement
Guest User

Seriais

a guest
Mar 19th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.03 KB | None | 0 0
  1. $dbh1 = mysql_connect("179.188.16.199", "gestao_aos", "lae66141");
  2.  
  3.         mysql_select_db('gestao_aos', $dbh1);
  4.         $result = mysql_query('select * from serial_trigger where cliente_id = ' . $usuario_cliente->clienteId, $dbh1);
  5.         var_dump($result);die();
  6.         $seriais = [];
  7.         while($row = mysql_fetch_assoc($result)){
  8.             $serialTrigger = new SerialTrigger();
  9.  
  10.             $serialTrigger->id = $row['id'];
  11.             $serialTrigger->cnpj = $row['cnpj'];
  12.             $serialTrigger->dataValidade = $row['data_validade'];
  13.             $serialTrigger->serialV = $row['serial_v'];
  14.             $serialTrigger->clienteId = $row['cliente_id'];
  15.             $serialTrigger->status = $row['status'];
  16.             $serialTrigger->created = $row['created'];
  17.  
  18.             array_unshift($seriais, $serialTrigger);
  19.         }
  20.  
  21.         if(!$result){
  22.             throw new Exception(mysql_error());
  23.         }
  24.  
  25.         var_dump($seriais);die();
  26.         mysql_close($dbh1);
  27.         $this->dados->seriais_cliente = $seriais;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement