SQL syntax error and undefine index error

Question

After a long search not able to find the solution

Undefined index: coursename in C:\wamp\www\StudentInformationProject\Student_new\courseinsert.php on line 17

Error: 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 '1'>

Here is the code

if(isset($_POST["button"]))
{
    $sql="INSERT INTO course(courseid, coursename, comment, coursekey)
    VALUES('".$_POST['courseid']."','".$_POST['coursename']."',
    '".$_POST['comment']."','".$_POST['coursekey']."')";

    if (!mysql_query($sql,$con))
    {
        die('Error: ' . mysql_error());
    }
    else
    {
        echo "1 record Inserted Successfully...";
    }
 }

"Undefined index: coursename" - you don't seem to be POSTing the course name. Also, I hope you learn about SQL injection soon! — Blorgbeard
– Blorgbeard, Commented Jun 25, 2013 at 20:26
Try echoing $sql and see if you can see what's wrong with it — Blorgbeard
– Blorgbeard, Commented Jun 25, 2013 at 20:29

Bohemian · Accepted Answer · 2013-06-25 20:28:54Z

1

One of your substituting variables has a double quote in it. Given the error message, it probably looks like:

foo "1" bar

You should escape such characters by doubling them, so it looks like:

foo ""1"" bar

answered Jun 25, 2013 at 20:28

Bohemian♦

427k103 gold badges604 silver badges750 bronze badges

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

Comments

Sparky · Accepted Answer · 2013-06-25 20:31:28Z

0

It is possible that your value in comment contains a single quote, which would invalidate the SQL syntax...

answered Jun 25, 2013 at 20:31

Sparky

15.1k2 gold badges34 silver badges45 bronze badges

Collectives™ on Stack Overflow

SQL syntax error and undefine index error

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related