Advertisement
Guest User

Untitled

a guest
Jun 26th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. $id = (int)$_GET["id"];
  2. $banco = $mysqli->query("SELECT os.os_solicitado,os.os_status,cliente.cliente_emailfinanceiro FROM os left join cliente on os.os_razaosocial = cliente.cliente_razaosocial where os.os_id = $id");
  3. while($dados = $banco->fetch_array()) {
  4. $status = $dados["os_status"];
  5. $solicitado = $dados["os_solicitado"];
  6. $emailfin = $dados["cliente_emailfinanceiro"];
  7.  
  8. $stmt = $mysqli->prepare("SELECT os.os_solicitado,os.os_status,cliente.cliente_emailfinanceiro FROM os left join cliente ON os.os_razaosocial=cliente.cliente_razaosocial WHERE os.os_id = ? ");
  9. $stmt->bind_param("s", $_GET['id']);
  10. $stmt->execute();
  11. $stmt->close();
  12. while($dados = $stmt->fetch_array()) {
  13. $status = $dados["os_status"];
  14. $solicitado = $dados["os_solicitado"];
  15. $emailfin = $dados["cliente_emailfinanceiro"];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement