php mysql query not being sent to database

Question

Hi i have written this function to register users on my site. it was all working fine until recently the only change i have done is added extra columns into the table could this have an effect on the way i need to write this function?

function register($link){
    $username = mysqli_real_escape_string($link, $_POST['username']);
    $email = mysqli_real_escape_string($link, $_POST['email']);
    $password = mysqli_real_escape_string($link, $_POST['password']);
    $password2 = mysqli_real_escape_string($link, $_POST['password2']);
    if($password == $password2){
        $password= md5($password);
        $sql = "INSERT INTO users(UserName,email,password)VALUES('$username','$email','$password')";
        mysqli_query($link,$sql);
        $_SESSION['message'] = "You are now registered";
        $_SESSION['username'] = $username;
        header("location: index.php");
    }else{
        $_SESSION['message'] = "Passwords do not match";
    }
}

from this '$username','$email','$password' I would like you to suggest php manual before doing this . — Prafulla Kumar Sahu
– Prafulla Kumar Sahu, Commented Sep 10, 2016 at 16:07
look at the answer here stackoverflow.com/questions/3446216/… — Prafulla Kumar Sahu
– Prafulla Kumar Sahu, Commented Sep 10, 2016 at 17:25

alaric · Accepted Answer · 2016-09-10 15:57:33Z

1

It will have an effect if the columns are set-up to be NON NULL. If you aren't sure, you can check the table definition with describe in a mysql console.

answered Sep 10, 2016 at 15:57

alaric

9875 silver badges10 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

alaric Over a year ago

Or change the column definitions to accept null values; depending on what is appropriate for your situation.

Collectives™ on Stack Overflow

php mysql query not being sent to database

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related