Advertisement
fransafu

usuario sql

Aug 2nd, 2015
307
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.84 KB | None | 0 0
  1. CREATE TABLE usuario(
  2.     id_usuario INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  3.     username VARCHAR(50) NOT NULL,
  4.     nombre VARCHAR(75) NOT NULL,
  5.     apellido VARCHAR(75) NOT NULL,
  6.     correo VARCHAR(200) NOT NULL,
  7.     password VARCHAR(75) NOT NULL,
  8.     rol VARCHAR(75) NOT NULL
  9. );
  10.  
  11. INSERT INTO usuario (username, nombre, apellido, correo, password, rol)
  12. VALUES ("fsanchez", "Francisco Javier", "Sánchez Fuentes", "fransafu@gmail.com", "5f4dcc3b5aa765d61d8327deb882cf99", "Administrador");
  13.  
  14. <?php
  15.     $username = "fsanchez";
  16.     $nombre = "Francisco Javier";
  17.     $apellido = "Sánchez Fuentes";
  18.     $correo = "fransafu@gmail.com";
  19.     $password = "password";
  20.     $password = md5($password);
  21.     $rol = "Administrador";
  22.  
  23.     $sql = "INSERT INTO usuario (username, nombre, apellido, correo, password, rol)
  24.     VALUES ($username, $nombre, $apellido, $correo, $password, $rol)";
  25. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement