ask
where the project part 2?
CREATE TABLE `user` ( `user_id` int(11) NOT NULL, `username` varchar(20) NOT NULL, `password` varchar(12) NOT NULL, `firstname` varchar(30) NOT NULL, `lastname` varchar(30) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
<?php ?>
<?php require 'config.php'; class db_class{ public $host = db_host; public $user = db_user; public $pass = db_pass; public $dbname = db_name; public $conn; public $error; public function __construct(){ $this->connect(); } private function connect(){ $this->conn = new mysqli($this->host, $this->user, $this->pass, $this->dbname); if(!$this->conn){ $this->error = "Fatal Error: Can't connect to database".$this->conn->connect_error; return false; } } public function save($username, $password, $firstname, $lastname){ $stmt = $this->conn->prepare("INSERT INTO `user` (username, password, firstname, lastname) VALUES(?, ?, ?, ?)") or die($this->conn->error); $stmt->bind_param("ssss", $username, $password, $firstname, $lastname); if($stmt->execute()){ $stmt->close(); $this->conn->close(); return true; } } } ?>
<!DOCTYPE html> <html lang = "en"> <head> <meta charset = "UTF-8" name "viewport" content = "width-device=width, initial-scale=1"/> <title>OOP PHP Registrarion and Login Form Using MySQLi</title> </head> <body> <nav class = "navbar navbar-default"> <div class = "container-fluid"> <a class = "navbar-brand" href = "https://www.sourcecodester.com">Sourcecodester</a> </div> </nav> <br /> <br /> <br /> <div class = "row"> <div class = "col-md-4"> </div> <div class = "col-md-4 well"> <h4 class = "text-danger">OOP PHP Registration and Login Form Using MySQLi</h4> <hr style = "border-top:1px dotted #000;"/> <form method = "POST" action = "save_query.php"> <div class="form-group"> <input type = "text" placeholder = "Username" name = "username" class = "form-control"/> </div> <div class="form-group"> <input type = "password" placeholder = "Password" name = "password" class = "form-control"> </div> <div class="form-group"> <input type = "text" placeholder = "Firstname" name = "firstname" class = "form-control"/> </div> <div class="form-group"> <input type = "text" placeholder = "Lastname" name = "lastname" class = "form-control"/> </div> <button class = "btn btn-success" name = "signup"><span class = "glyphicon glyphicon-log-in"></span> Sign up</button> </form> </div> </div> </body> </html>
<?php require_once "class.php"; $conn = new db_class(); $username = $_POST['username']; $password = $_POST['password']; $firstname = $_POST['firstname']; $lastname = $_POST['lastname']; $conn->save($username, $password, $firstname, $lastname); echo '<script>alert("Successfully saved!")</script>'; echo '<script>window.location= "index.php"</script>'; } ?>