PHP Classes

File: Lou_registo.php

Recommend this page to a friend!
  Classes of António Lourenço  >  Lou Login  >  Lou_registo.php  >  Download  
File: Lou_registo.php
Role: Auxiliary script
Content type: text/plain
Description: An example for Lou_login.class
Class: Lou Login
Authenticate users stored in a MySQL database
Author: By
Last change: changing the cryptographic function
Date: 3 years ago
Size: 2,395 bytes
 

Contents

Class file image Download
<?php

/*
 * Lou_Auth_registo file
 * @author Antonio Lourenco (Antlou) <aftlourenco@gmail.com>
 * version 1.0
 * 19/09/2014
 */
 
if(!empty($_POST)){

   
$email = $_POST['mail'];
   
$senha = SHA1($_POST['senha']);
   
define("HOST", "localhost"); // the host you want to connect
define("USER", "root"); // the username database
define("PASSWORD", "mysql"); // the user's password database
define("DATABASE", "test"); // the name of the database
define("PORT",3306); // port to connect to the database

// if you are connected via TCP/IP rather than a Unix socket, remember to add the port number as a parameter.
$mysqli = new mysqli(HOST, USER, PASSWORD, DATABASE, PORT);
$mysqli->set_charset('utf8');
// Check connection
   
if (mysqli_connect_errno()){
        echo
"Failed to connect to MySQL: " . mysqli_connect_error(); exit();
    }else{
        echo
'Performed db connection<br>';
    }
   
   
//create users table
   
$sql_table = 'CREATE TABLE IF NOT EXISTS users (
    id INT(5) NOT NULL AUTO_INCREMENT,
    password VARCHAR(128) NOT NULL,
    email VARCHAR(255) NOT NULL,
    PRIMARY KEY(id),
    UNIQUE KEY(email)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1'
;
   
   
// Run query
   
if (mysqli_query($mysqli,$sql_table)){
        echo
"Table users created successfully<br>";
       
// use prepared statements
       
$sql_insert = $mysqli->prepare("INSERT INTO users (id, password, email) VALUES (?, ?, ?)");
       
$i = null;
       
$sql_insert->bind_param('iss',$i,$senha,$email);
       
$sql_insert->execute();
        if(
$sql_insert->affected_rows===1){
            echo
'Utilizador registado / User registed<br>';

            echo
'Vai ser redirecionado para a pagina Controlo de Acesso<br>
                Will be redirected to the page of Login'
;
           
header("Refresh: 5, Lou_login.php");
           
        }else{
            echo
'ERRO.<br>';
        }
   
$sql_insert->close();
    }else{
        echo
'Error creating table: ' . mysqli_error($mysqli);
    }
$mysqli->close();
}else{
?>
<h1>REGISTO de UTILIZADOR / SIGN UP</h1>
        <form action="#" method="POST">
       
            <label>Endereco electronico / Email</label>
            <input type="text" name="mail" maxlength="50" >
            <br>
            <label>Senha / Password</label>
            <input type="text" name="senha" maxlength="50" >
            <br>
            <input type="submit" name="registo" value="CONFIRMO / OK">
               
        </form>
        <a href="Lou_login.php">Controlo de Acesso / Login</a>
<?php
}
?>