Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //Conexão com MariaDB
- require_once 'db_connect.php';
- if(isset($_POST['botao-cadastro'])):
- $nome = mysqli_escape_string($connect, $_POST['nome']);
- $autor = mysqli_escape_string($connect, $_POST['autor']);
- $editora = mysqli_escape_string($connect, $_POST['editora']);
- $genero = mysqli_escape_string($connect, $_POST['genero']);
- $paginas = mysqli_escape_string($connect, $_POST['paginas']);
- $sinopse = mysqli_escape_string($connect, $_POST['sinopse']);
- $sql = "CREATE TABLE IF NOT EXISTS '$autor'(
- id int AUTO_INCREMENT,
- nome varchar(232) NOT NULL,
- genero varchar(232) NOT NULL,
- editora varchar(232) NOT NULL,
- paginas int(32) NOT NULL,
- sinopse text(232) NOT NULL,
- PRIMARY KEY ('id')
- )";
- if(mysqli_query($connect, $sql)):
- header('Location: ../index.php?tinha_nao');
- else:
- $sql = "INSERT INTO '$autor'(nome, genero, editora, paginas, sinopse) VALUES (
- '$nome', '$genero', $editora', '$paginas', '$sinopse')";
- mysqli_query($connect, $sql);
- header('Location: ../index.php?ja_tinha');
- endif;
- endif;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement