Advertisement
Guest User

Untitled

a guest
Jun 15th, 2019
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. <?php
  2. if($_POST["nombre"]!="" && $_POST["id_proveedor"]!=""){
  3. include "../../php/conexion.php";
  4. $params = array_filter($_POST);
  5.  
  6. $id_proveedor = "SELECT id FROM proveedores WHERE nombre = "$_POST[id_proveedor]"";
  7.  
  8. $result_id_proveedor = $con->query($id_proveedor);
  9. $obj = $result_id_proveedor->fetch_object();
  10. $params['id_proveedor'] = $obj->id_proveedor;
  11.  
  12. $params['created_at'] = date("Y-m-d H:i:s");
  13.  
  14. $fields = implode(',', array_keys($params));
  15. $values = '"'. implode('","',array_values ($params)) . '"';
  16.  
  17. $sql = "INSERT INTO marcas ($fields) VALUES ($values)";
  18. $query = $con->query($sql);
  19. echo $sql;
  20. print "<script>alert("Registro exitoso.");window.location='../marcas.php';</script>";
  21. }
  22.  
  23. ?>
  24.  
  25. <label for="id_proveedor">Proveedor:</label>
  26. <select class="form-control" name="id_proveedor" id="id_proveedor" required
  27. <option value="">Seleccione:</option>
  28. <?php
  29. include_once "../php/conexion.php";
  30. $query = $con -> query("SELECT * FROM proveedores");
  31. while ($valores = mysqli_fetch_array($query)) {
  32. echo '<option id="id_proveedor" value="'.$valores['id'].'">'.$valores['nombre'].'</option>';
  33. }
  34. ?>
  35. </select>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement