Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if(isset($_COOKIE['AGID'])) {
- $servername = "localhost";
- $username = "root";
- $password = "";
- // Create connection
- $conn = new mysqli($servername, $username, $password, 'gestion');
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- // Generate db
- if(isset($_POST['nombre']) && isset($_POST['password']) && isset($_POST['idempresa']))
- {
- $nombre = $_POST['nombre'];
- $pass = $_POST['password']; // TODO: Generar esto aleatoriamente
- $idempresa = $_POST['idempresa'];
- $dbid = strtolower(str_replace(' ', '_', $nombre));
- $conn->query("INSERT INTO `sucursales` (nombre, dbid, password, id_empresa) VALUES ('$nombre','$dbid','$pass','$idempresa')");
- //
- // Sobreescribimos la conexion para poder crear la base de datos
- //
- $conn = mysqli_connect($servername, $username, $password);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- // Create database
- $sql = $conn->query("CREATE DATABASE `$dbid`");
- // Select new database
- $conn->select_db($dbid);
- if ($sql) {
- echo "Database created successfully";
- // Create connection
- $conn = mysqli_connect($servername, $username, $password, $dbid);
- // Check connection
- if ($conn->connect_error) {
- die("Connection failed: " . $conn->connect_error);
- }
- $query = $conn->query("CREATE TABLE `proveedores` (
- id int NOT NULL AUTO_INCREMENT,
- nombre varchar(48) NOT NULL,
- telefono varchar(12) NOT NULL,
- mail varchar(48) NOT NULL,
- PRIMARY KEY (id))");
- $query = $conn->query("CREATE TABLE `prodcutos` (
- id int NOT NULL AUTO_INCREMENT,
- nombre varchar(64) NOT NULL,
- stock int NOT NULL,
- costo float NOT NULL,
- precio float NOT NULL,
- id_proveedor int,
- PRIMARY KEY (id))");
- $query = $conn->query("CREATE TABLE `pagos` (
- id int NOT NULL AUTO_INCREMENT,
- id_proveedor int NOT NULL,
- num_boleta int NOT NULL,
- debito float NOT NULL,
- saldo float NOT NULL,
- descripcion varchar(64),
- PRIMARY KEY (id))");
- $query = $conn->query("CREATE TABLE `factura` (
- id int NOT NULL AUTO_INCREMENT,
- fecha date NOT NULL,
- total float NOT NULL,
- productos varchar(255) NOT NULL,
- PRIMARY KEY (id))");
- } else {
- echo "Error creating database: " . $conn->error;
- }
- }
- } else {
- header("Location: login.php");
- }
- // Cerramos el modal desde JavaScript
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement