MySQL & PHP - Inserting values Error

Question

When i try to insert data to my MySQL it results in error:

"Connected successfully Error: INSERT INTO login ('nick, pass') VALUES (', ') You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''nick, pass') VALUES (', ')' at line 1"

 <?php
    $servername = "mysql1.000webhost.com";
    $username = "a5287585_login";
    $password = "*****";
    $dbname = "a5287585_login";
    $nickname = $_POST['nick'];
    $pass = $_POST['password'];

    // Vytvorenie pripojenia - Creating connection
    $conn = new mysqli($servername, $username, $password, $dbname);

    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    echo "Connected successfully ";

    // Vloženie dát (Nick,ecc..) - Data inserting
    $sql = "INSERT INTO login (nick, pass)
            VALUES ('$nick, $pass')";

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

    $conn->close();
?>

My MySQL

Thanks for any help.

Plus, that could also have been a duplicate of http://stackoverflow.com/questions/18050071/php-parse-syntax-errors-and-how-to-solve-them because that's what's also going on here. — Funk Forty Niner, Dec 17 '15 at 16:52

Niranjan N Raju · Accepted Answer · 2015-12-17T16:53:06.757

1

This line is wrong

 $sql = "INSERT INTO login (nick, pass) VALUES ('$nick, $pass')";

It should be

 $sql = "INSERT INTO login (nick, pass) VALUES ('$nickname', '$pass')";
                                                        ^     ^// saperate quotes for both the values

edited Dec 17 '15 at 16:53

answered Dec 17 '15 at 16:51

Niranjan N Raju

12,047
4
22
41

2

And $nick needs to be $nickname – KiwiJuicer Dec 17 '15 at 16:52
@KiwiJuicer Thanks buddy:) – Niranjan N Raju Dec 17 '15 at 16:52
But it still doesn´t solve my problem. The worse thing is that i saw all questions about my problem but i can´t find it.. – Jediah Dec 17 '15 at 16:56
what error you r getting now?? – Niranjan N Raju Dec 17 '15 at 16:57
Same think. "Connected successfully Error: INSERT INTO login (nick, pass) VALUES (', ') Column count doesn't match value count at row 1" – Jediah Dec 17 '15 at 17:00
what is your table structure?? – Niranjan N Raju Dec 17 '15 at 17:02
use `$nickname = mysqli_real_escape_string($conn,$_POST['nick']);` – Tanjima Tani Dec 17 '15 at 17:47
@Jediah If you're still getting that error, you didn't save the changes to the server. The answer shows that you should have 4 quotes in the query, you still only have 2. – Barmar Dec 17 '15 at 17:56

MySQL & PHP - Inserting values Error

1 Answers1