How to insert a new row into table where values are variables?

Question

I am trying to INSERT a new row into table using variables, like this-

$name = $_POST['name'];
$surname = $_POST['surname'];
$email = $_POST['email'];
$password = $_POST['password'];
$gender = $_POST['gender'];
if($name && $surname && $email && $password){
    $dbhost = 'localhost';
    $dbuser = 'root';
    $dbpass = '';
    $db = '_erica';
    $conn = new mysqli($dbhost, $dbuser, $dbpass,$db);
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    };

    $sql = 'INSERT INTO login(id, name, surname, email, sex, password) VALUES (Null,$name,$surname,$email,$gender,$password)';

    if ($conn->query($sql) === TRUE) {
        echo "New record created successfully";
    }else {
        echo "Error: " . $sql . "<br>" . $conn->error;
    }

}else{
    die('All fields requiret!');
};

But it does not work, I have tried to add quotes around variables like this

 $sql = 'INSERT INTO login(id, name, surname, email, sex, password) VALUES(Null,"$name","$surname","$email","$gender","$password")';

still nothing... what could I do?

Consult these following links http://php.net/manual/en/mysqli.error.php and http://php.net/manual/en/function.error-reporting.php and apply that to your code. — Funk Forty Niner, Feb 23 '16 at 13:51
If the ID is an auto-increment field you should just omit it — Asur, Feb 23 '16 at 13:57

Mohammed Safeer · Answer 1 · 2016-02-23T14:04:39.463

1

Try this,

$sql = 'INSERT INTO login(id, name, surname, email, sex, password) VALUES(NULL,"'.$name.'","'.$surname.'","'.$email.'","'.$gender.'","'.$password.'")';

Or (use double quotes outside instead of single quotes)

$sql = "INSERT INTO login(id, name, surname, email, sex, password) VALUES(NULL,$name,$surname,$email,$gender,$password)";

edited Feb 23 '16 at 14:04

answered Feb 23 '16 at 13:50

Mohammed Safeer

20,751
8
75
78

and if id is auto increment than? – devpro Feb 23 '16 at 13:55
Id has to be primary key, auto increment. on inserting NULL it will auto increment the value. – Mohammed Safeer Feb 23 '16 at 14:04
auto increament not NULL ??? – devpro Feb 23 '16 at 14:04
no need to use NULL brother. – devpro Feb 23 '16 at 14:05
It has to be set in the database. The id field as AUTO_INCREMENT. – Mohammed Safeer Feb 23 '16 at 14:06

score 1 · Answer 2 · answered Feb 23 '16 at 13:52

1

Use this. Just change single quotes with double quotes

$sql = "INSERT INTO login(id, name, surname, email, sex, password) VALUES (Null,$name,$surname,$email,$gender,$password)";

answered Feb 23 '16 at 13:52

Apoorv

231
1
8

and if id is auto increment than? – devpro Feb 23 '16 at 13:55
1

Remove `id` and `NULL` `$sql = "INSERT INTO login(name, surname, email, sex, password) VALUES ($name,$surname,$email,$gender,$password)";` – Apoorv Feb 24 '16 at 08:24
than my vote for you .... – devpro Feb 24 '16 at 08:24
Thanks! Just set id as auto increment in DB – Apoorv Feb 24 '16 at 08:25

How to insert a new row into table where values are variables?

2 Answers2