Submitting form to database error

Question

I'm trying to add a simple form data to a mysql databse and it seems to not work.

It gives me this error

Parse error: syntax error, unexpected ';' in portfolio-add-website.php on line 7

and portfolio-add-website.php looks like this:

<?php
include 'connect_db.php';

$connect = mysqli_connect(HOST,USERNAME,PASSWORD,DB);

mysqli_query($connect,"INSERT INTO portfolio_websites 
                       (name, link, description, profile_img_name, 
                        cover_img_name, client_name, donedate) 
                VALUES ('$_POST[name]', '$_POST[link]', 
                        '$_POST[description]', 
                        '$_POST[profile_img_name]', 
                        '$_POST[cover_img_name]', '$_POST[client_name]', 
                        '$_POST[donedate]')";
?>

I don't see any unexpected ";". Can anyone help me? I'm sure it's something small.

your paranthesis and quotation marks are somewhere in wrong order. The first opening paranthesis is at least not closed. But the quotation marks are somewhere wrong as well (I don't know the expected syntax, so can't give more detailed hint) — planetmaker, Sep 30 '15 at 09:00

score 2 · Answer 1 · answered Sep 30 '15 at 09:00

You missed a closing brace

mysqli_query($connect,"INSERT INTO portfolio_websites (name, link, description, profile_img_name, cover_img_name, client_name, donedate) 
VALUES ('$_POST[name]', '$_POST[link]', '$_POST[description]', '$_POST[profile_img_name]', '$_POST[cover_img_name]', '$_POST[client_name]', '$_POST[donedate]')");

Submitting form to database error

1 Answers1