Advertisement
Guest User

Untitled

a guest
Aug 30th, 2018
108
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.80 KB | None | 0 0
  1. <?php
  2.  
  3. if(isset($_COOKIE['AGID'])) {
  4.  
  5. $servername = "localhost";
  6. $username = "root";
  7. $password = "";
  8.  
  9. // Create connection
  10. $conn = new mysqli($servername, $username, $password, 'gestion');
  11.  
  12. // Check connection
  13. if ($conn->connect_error) {
  14. die("Connection failed: " . $conn->connect_error);
  15. }
  16.  
  17. // Generate db
  18. if(isset($_POST['nombre']) && isset($_POST['password']) && isset($_POST['idempresa']))
  19. {
  20. $nombre = $_POST['nombre'];
  21. $pass = $_POST['password']; // TODO: Generar esto aleatoriamente
  22. $idempresa = $_POST['idempresa'];
  23. $dbid = strtolower(str_replace(' ', '_', $nombre));
  24.  
  25. $conn->query("INSERT INTO `sucursales` (nombre, dbid, password, id_empresa) VALUES ('$nombre','$dbid','$pass','$idempresa')");
  26.  
  27. //
  28. // Sobreescribimos la conexion para poder crear la base de datos
  29. //
  30. $conn = mysqli_connect($servername, $username, $password);
  31.  
  32. // Check connection
  33. if ($conn->connect_error) {
  34. die("Connection failed: " . $conn->connect_error);
  35. }
  36.  
  37. // Create database
  38. $sql = $conn->query("CREATE DATABASE `$dbid`");
  39.  
  40. // Select new database
  41. $conn->select_db($dbid);
  42.  
  43. if ($sql) {
  44. echo "Database created successfully";
  45.  
  46. // Create connection
  47. $conn = mysqli_connect($servername, $username, $password, $dbid);
  48.  
  49. // Check connection
  50. if ($conn->connect_error) {
  51. die("Connection failed: " . $conn->connect_error);
  52. }
  53.  
  54. $query = $conn->query("CREATE TABLE `proveedores` (
  55. id int NOT NULL AUTO_INCREMENT,
  56. nombre varchar(48) NOT NULL,
  57. telefono varchar(12) NOT NULL,
  58. mail varchar(48) NOT NULL,
  59. PRIMARY KEY (id))");
  60.  
  61. $query = $conn->query("CREATE TABLE `prodcutos` (
  62. id int NOT NULL AUTO_INCREMENT,
  63. nombre varchar(64) NOT NULL,
  64. stock int NOT NULL,
  65. costo float NOT NULL,
  66. precio float NOT NULL,
  67. id_proveedor int,
  68. PRIMARY KEY (id))");
  69.  
  70. $query = $conn->query("CREATE TABLE `pagos` (
  71. id int NOT NULL AUTO_INCREMENT,
  72. id_proveedor int NOT NULL,
  73. num_boleta int NOT NULL,
  74. debito float NOT NULL,
  75. saldo float NOT NULL,
  76. descripcion varchar(64),
  77. PRIMARY KEY (id))");
  78.  
  79. $query = $conn->query("CREATE TABLE `factura` (
  80. id int NOT NULL AUTO_INCREMENT,
  81. fecha date NOT NULL,
  82. total float NOT NULL,
  83. productos varchar(255) NOT NULL,
  84. PRIMARY KEY (id))");
  85.  
  86. } else {
  87. echo "Error creating database: " . $conn->error;
  88. }
  89. }
  90. } else {
  91. header("Location: login.php");
  92. }
  93.  
  94. // Cerramos el modal desde JavaScript
  95.  
  96. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement