Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE usuario(
- id_usuario INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
- username VARCHAR(50) NOT NULL,
- nombre VARCHAR(75) NOT NULL,
- apellido VARCHAR(75) NOT NULL,
- correo VARCHAR(200) NOT NULL,
- password VARCHAR(75) NOT NULL,
- rol VARCHAR(75) NOT NULL
- );
- INSERT INTO usuario (username, nombre, apellido, correo, password, rol)
- VALUES ("fsanchez", "Francisco Javier", "Sánchez Fuentes", "fransafu@gmail.com", "5f4dcc3b5aa765d61d8327deb882cf99", "Administrador");
- <?php
- $username = "fsanchez";
- $nombre = "Francisco Javier";
- $apellido = "Sánchez Fuentes";
- $correo = "fransafu@gmail.com";
- $password = "password";
- $password = md5($password);
- $rol = "Administrador";
- $sql = "INSERT INTO usuario (username, nombre, apellido, correo, password, rol)
- VALUES ($username, $nombre, $apellido, $correo, $password, $rol)";
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement