not understanding error

[mindapolis]

Hi, can someone please help me understand why I'm getting this error

 

Parse error: syntax error, unexpected ';' in /web/html/mediaservicesunlimited.com/contactTest.php on line 12

<?php 
require_once('functions.php');
databaseConnection();
	/*if(isset($_POST['submit'])) {
		
	} */
$stmt = $mysqli ->prepare("INSERT INTO clients fname,lname,orgName,address,city,state,zipcode,phone,fax,email,confirmEmail,projectOptions,projectOverview,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
$stmt -> bind_param('sssssssssssssi', 
$_POST[fname],$_POST[lname],$_POST[orgName],$_POST[address],$_POST[city],$_POST[state],$_POST[zipcode],$_POST[phone],$_POST[fax],$_POST[email],$_POST[confirmEmail], $_POST[projectOptions],$_POST[projectOverview],$_POST[year] ); 
$stmt -> execute();
$stmt -> close(); 
?>

[cyberRobot]

You're missing a parenthesis here (before the semi-colon):

 

$stmt = $mysqli ->prepare("INSERT INTO clients fname,lname,orgName,address,city,state,zipcode,phone,fax,email,confirmEmail,projectOptions,projectOverview,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

[cyberRobot]

Are you getting any errors for the $_POST variables? The array indexes should be enclosed in quotes. For example:

 

$_POST['fname']

[mindapolis]

Right now I'm just trying to figure out why I'm getting this error message. 

Parse error: syntax error, unexpected T_VARIABLE in /web/html/mediaservicesunlimited.com/contactTest.php on line 13

<?php 
require_once('functions.php');
databaseConnection();
	/*if(isset($_POST['submit'])) {
		
	} */
$stmt = $mysqli ->prepare("INSERT INTO clients fname,lname,orgName,address,city,state,zipcode,phone,fax,email,confirmEmail,projectOptions,projectOverview,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)"
$stmt -> bind_param('sssssssssssssi', 
$_POST[fname],$_POST[lname],$_POST[orgName],$_POST[address],$_POST[city],$_POST[state],$_POST[zipcode],$_POST[phone],$_POST[fax],$_POST[email],$_POST[confirmEmail], $_POST[projectOptions],$_POST[projectOverview],$_POST[year] ); 
$stmt -> execute();
$stmt -> close(); 
?>

[Jacques1]

Did you read what cyberRobot told you?

 

By the way, I strongly recommend you use a proper IDE (like PHPStorm or Netbeans) instead of a plain editor. This will immediately warn you when you make syntax errors so that you don't end up with a whole bunch of broken code.

[cyberRobot]

Right now I'm just trying to figure out why I'm getting this error message. 

Parse error: syntax error, unexpected T_VARIABLE in /web/html/mediaservicesunlimited.com/contactTest.php on line 13

 

Change this

$stmt = $mysqli ->prepare("INSERT INTO clients fname,lname,orgName,address,city,state,zipcode,phone,fax,email,confirmEmail,projectOptions,projectOverview,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)"

To this

$stmt = $mysqli ->prepare("INSERT INTO clients fname,lname,orgName,address,city,state,zipcode,phone,fax,email,confirmEmail,projectOptions,projectOverview,year) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?)");