How to solve this error PHP Parse error: syntax error, unexpected ';'?

Question

I think the insert query should ends with semicolon as the similar code is working for another form. But it shows this error:

PHP Parse error: syntax error, unexpected ';'

Here is my piece of PHP script for insert data into database from a form.

if((!empty($name) && !empty($location) && !empty($fulladdress) && !empty($ownername) && !empty($ownercontact) && !empty(category) && 
                    ($invalidphflag==true) && ($phoneflag==true) && !empty($size) && !empty($price) )
        {
                $insertquery= "INSERT INTO properties (name, location, address, owner_name, owner_no, size, price, category) 
                VALUES ('$name', '$location', '$fulladdress', '$ownername', '$ownercontact', '$size', '$price', '$category')";

            $query = mysqli_query($db, $insertquery);

            if($query)
            {
             $success= "Details submitted successfully.";
            }   



    }

You're missing a parenthesis at the end of your first IF statement. There's no need for all these answers it's one simple typo. — MinistryOfChaps, Aug 10 '17 at 09:33

score 1 · Answer 1 · answered Aug 10 '17 at 09:35

if(!empty($name) && !empty($location) && !empty($fulladdress) && !empty($ownername) && !empty($ownercontact) && !empty($category) &&
    ($invalidphflag==true) && ($phoneflag==true) && !empty($size) && !empty($price) ) {
    $insertquery= "INSERT INTO properties (name, location, address, owner_name, owner_no, size, price, category) 
                VALUES ('$name', '$location', '$fulladdress', '$ownername', '$ownercontact', '$size', '$price', '$category')";

    $query = mysqli_query($db, $insertquery);

    if($query)
    {
        $success= "Details submitted successfully.";
    }
}

score 1 · Answer 2 · answered Aug 10 '17 at 09:36

You have one bracket in your if statement that's not closed.

So your if statement should be like:

 if ((!empty($name) && !empty($location) && !empty($fulladdress) && !empty($ownername) && !empty($ownercontact) && !empty(category) && 
        ($invalidphflag==true) && ($phoneflag==true) && !empty($size) && !empty($price) 
    ))

Resulting in:

 if ((!empty($name) && !empty($location) && !empty($fulladdress) && !empty($ownername) && !empty($ownercontact) && !empty(category) && 
    ($invalidphflag==true) && ($phoneflag==true) && !empty($size) && !empty($price) 
))
{
    $insertquery= "INSERT INTO properties (name, location, address, owner_name, owner_no, size, price, category) 
        VALUES ('$name', '$location', '$fulladdress', '$ownername', '$ownercontact', '$size', '$price', '$category')";

    $query = mysqli_query($db, $insertquery);

    if ($query)
    {
        $success= "Details submitted successfully.";
    }   
}

score 1 · Answer 3 · answered Aug 10 '17 at 09:38

if((!empty($name)
    && !empty($location)
    && !empty($fulladdress)
    && !empty($ownername)
    && !empty($ownercontact)
    && !empty($category)
   )
&&
   ($invalidphflag == true
   && $phoneflag == true
   && !empty($size)
   && !empty($price)
   )){
        $insertquery= "INSERT INTO properties (name, location, address, owner_name, owner_no, size, price, category) 
                VALUES ('$name', '$location', '$fulladdress', '$ownername', '$ownercontact', '$size', '$price', '$category')";
        $query = mysqli_query($db, $insertquery);
        if($query)
        {
           $success= "Details submitted successfully.";
        }   
   }

you have missed $ sign along !empty(category) in first part of condition

score 0 · Accepted Answer · answered Aug 10 '17 at 09:33

0

if((!empty($name) && !empty($location) && !empty($fulladdress) && !empty($ownername) && !empty($ownercontact) && !empty(category) && ($invalidphflag==true) && ($phoneflag==true) && !empty($size) && !empty($price) )

Has one more opening bracket ( than closing )

answered Aug 10 '17 at 09:33

Scoots

3,048
2
21
33

Or one less as long as it doesn't make sense to have 2 of them :) – Vladislav Aug 10 '17 at 09:36
How it will workable without `$` along !empty(category ) ? – Naveed Ramzan Aug 10 '17 at 09:56

How to solve this error PHP Parse error: syntax error, unexpected ';'?

4 Answers4