Error while inserting data into database in line 27

Question

So I'm trying to create a simple sign up the program that inserts the data into a MySQL database:

<?php


$first=$_POST['name'];
$last=$_POST['lname'];
$uname=$_POST['uname'];
$pass=$_POST['pass'];

if(empty($first) || empty($last) || empty($uname) || empty($pass))
{
    header('Location: redirect.php');
}
else
{
    $conn=new mysqli("localhost", "root", "", "login");

    if($conn->connect_error)
    {
        die("We've lost the connection because of ".$conn->connect_error);
    }

    $insert="INSERT INTO people (name, lastname, username, pass) VALUES ('$name', '$last', '$uname', '$pass')";
    $conn->query($insert);
}

?>

However when i run the program and insert the data I get the error:

Notice: Undefined variable: name in C:\xampp\htdocs\vtor\sign_up.php on line 27

line 27 is this line:

$insert="INSERT INTO people (name, lastname, username, pass) VALUES 
('$name', '$last', '$uname', '$pass')";

Any ideas?

The error was clear; why did you not Google that? – Funk Forty Niner Feb 03 '18 at 15:43 — Funk Forty Niner, Feb 03 '18 at 15:43

Juakali92 · Accepted Answer · 2018-02-03T15:43:06.953

1

$name should be called $first as set at the top of the script. Change

VALUES ('$name', '$last',

to

VALUES ('$first', '$last',

edited Feb 03 '18 at 15:43

answered Feb 03 '18 at 15:41

Juakali92

1,155
8
20

Oh my god how did I not see that! Thanks very much it solved the problem – David Mathers Feb 03 '18 at 15:43

score 0 · Answer 2 · answered Feb 03 '18 at 15:41

0

You do not define a variable called name, but only a variable called first

answered Feb 03 '18 at 15:41

Briomkez

567
3
17

Error while inserting data into database in line 27

2 Answers2