MySQL changing password
#1

Hi, I want to change my SHA1 password hashing like my register form one.

Can you help?

pawno code

PHP код:
strcat(Query,"INSERT INTO `users` (Username,Password,IP) VALUES ('%s', sha1('%s'),'%s')"); 

register.php

PHP код:
<?php
// Include config file
require_once 'config.php';
 
// Define variables and initialize with empty values
$username $password $confirm_password "";
$username_err $password_err $confirm_password_err "";
 
// Processing form data when form is submitted
if($_SERVER["REQUEST_METHOD"] == "POST"){
 
    
// Validate username
    
if(empty(trim($_POST["username"]))){
        
$username_err "Please enter a username.";
    } else{
        
// Prepare a select statement
        
$sql "SELECT id FROM users WHERE username = ?";
        
        if(
$stmt mysqli_prepare($link$sql)){
            
// Bind variables to the prepared statement as parameters
            
mysqli_stmt_bind_param($stmt"s"$param_username);
            
            
// Set parameters
            
$param_username trim($_POST["username"]);
            
            
// Attempt to execute the prepared statement
            
if(mysqli_stmt_execute($stmt)){
                
/* store result */
                
mysqli_stmt_store_result($stmt);
                
                if(
mysqli_stmt_num_rows($stmt) == 1){
                    
$username_err "This username is already taken.";
                } else{
                    
$username trim($_POST["username"]);
                }
            } else{
                echo 
"Oops! Something went wrong. Please try again later.";
            }
        }
         
        
// Close statement
        
mysqli_stmt_close($stmt);
    }
    
    
// Validate password
    
if(empty(trim($_POST['password']))){
        
$password_err "Please enter a password.";     
    } elseif(
strlen(trim($_POST['password'])) < 6){
        
$password_err "Password must have atleast 6 characters.";
    } else{
        
$password trim($_POST['password']);
    }
    
    
// Validate confirm password
    
if(empty(trim($_POST["confirm_password"]))){
        
$confirm_password_err 'Please confirm password.';     
    } else{
        
$confirm_password trim($_POST['confirm_password']);
        if(
$password != $confirm_password){
            
$confirm_password_err 'Password did not match.';
        }
    }
    
    
// Check input errors before inserting in database
    
if(empty($username_err) && empty($password_err) && empty($confirm_password_err)){
        
        
// Prepare an insert statement
        
$sql "INSERT INTO users (username, password) VALUES (?, ?)";
         
        if(
$stmt mysqli_prepare($link$sql)){
            
// Bind variables to the prepared statement as parameters
            
mysqli_stmt_bind_param($stmt"ss"$param_username$param_password);
            
            
// Set parameters
            
$param_username $username;
            
$param_password password_hash($passwordPASSWORD_DEFAULT); // Creates a password hash
            
            // Attempt to execute the prepared statement
            
if(mysqli_stmt_execute($stmt)){
                
// Redirect to login page
                
header("location: login.php");
            } else{
                echo 
"Something went wrong. Please try again later.";
            }
        }
         
        
// Close statement
        
mysqli_stmt_close($stmt);
    }
    
    
// Close connection
    
mysqli_close($link);
}
?>
Reply


Messages In This Thread
MySQL changing password - by Zeus666 - 18.03.2018, 13:24
Re: MySQL changing password - by Cypress - 18.03.2018, 16:25
Re: MySQL changing password - by Zeus666 - 18.03.2018, 16:30
Re: MySQL changing password - by Cypress - 18.03.2018, 16:32
Re: MySQL changing password - by jasperschellekens - 18.03.2018, 17:45

Forum Jump:


Users browsing this thread: 2 Guest(s)