Advertisement
Guest User

Untitled

a guest
May 23rd, 2019
131
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. /**
  2. * Insere um registro no BD
  3. */
  4. function save($table = null, $data = null) {
  5.  
  6. $database = open_database();
  7.  
  8. $columns = null;
  9. $values = null;
  10.  
  11. //print_r($data);
  12.  
  13. foreach ($data as $key => $value) {
  14. $columns .= trim($key, "'") . ",";
  15. $values .= "'$value',";
  16. }
  17.  
  18. // remove a ultima virgula
  19. $columns = rtrim($columns, ',');
  20. $values = rtrim($values, ',');
  21.  
  22. $sql = "INSERT INTO " . $table . "($columns)" . " VALUES " . "($values);";
  23.  
  24. try {
  25. $database->query($sql);
  26.  
  27. $_SESSION['message'] = 'Registro cadastrado com sucesso.';
  28. $_SESSION['type'] = 'success';
  29.  
  30. } catch (Exception $e) {
  31.  
  32. $_SESSION['message'] = 'Nao foi possivel realizar a operacao.';
  33. $_SESSION['type'] = 'danger';
  34. }
  35.  
  36. close_database($database);
  37. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement