Trouble entering data into MySQL database with PHP

Question

I have been checking my syntax all night yet I can't seem to see what is wrong. I'm relatively new to all this and would appreciate nay help that may be provided. The error I'm getting is

"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 ''ID','Name','Option','Sides') VALUES(NULL,'Denise','Chicken','Mashed Potat' at line 1"

My code is below:

<?php
include 'connect.php';

$name = $_POST['inputName'];
$opt = $_POST['inputOption'];
$side = $_POST['inputSides'];

if(!$_POST['Submit']) {
    echo "Please fill out the form.";
    header('Location: index.php');
} else {
    mysql_query("INSERT INTO people ('ID','Name','Option','Sides')
                VALUES(NULL,'$name','$opt','$side')") or die(mysql_error());
    echo "User has been added.";
    header('Location: index.php');
    }
?>

Community · Accepted Answer · 2017-05-23 12:05:32Z

1

You're using the wrong identifiers for your columns:

('ID','Name','Option','Sides')

Either remove the quotes or wrap them in backticks.

(`ID`,`Name`,`Option`,`Sides`)

Plus, your present code is open to SQL injection.
Use mysqli with prepared statements, or PDO with prepared statements, they're much safer.

Another thing; should you want to be entering apostrophes, use stripslashes() including mysql_real_escape_string(). The occasion may very well present itself; an insight.

Otherwise, SQL will throw another error.

edited May 23, 2017 at 12:05

CommunityBot

11 silver badge

answered Sep 26, 2014 at 2:04

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

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

1 Comment

John Moran Over a year ago

Thank you very much. I didn't even realize. Everything works flawlessly now.

Collectives™ on Stack Overflow

Trouble entering data into MySQL database with PHP

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