Jump to content

Missing syntax, can not find in code

komquat

By komquat
in PHP Coding Help

Recommended Posts

komquat Member

komquat

Posted
Posted
Sorry to post all this code, but I am getting an error:

Parse error: syntax error, unexpected $end in /home/andybour/public_html/admin/master_user_info.php on line 408

Meaning missing syntax.  I have looked for 24 hours and can not find.  Help is appreciated.


[code=php:0]
<?
//Session Starting
session_start();

if ($_SESSION[level] != "full_admin") {
header("location:http://www.andybourdeau.com/");
exit;
}

include("include/connection.php");

//Update the information if needed
if ($run_master_update == "yes") {
$sql_update = "UPDATE users SET
last_name = '$_POST[master_l_name]',
password = '$_POST[master_pass]',
permission = '$_POST[master_per]',
email = '$_POST[master_email]',
fantasy_nascar = '$_POST[master_1st]',
fantasy_nascar_2 = '$_POST[master_2nd]',
fantasy_football = '$_POST[master_FF]'
WHERE user_id = '$_POST[master_user_id]'
";

$result = mysql_query($sql_update, $connection) or die ("Could not Execute query. Reason: ".mysql_error());

//Delete from nascar 1st and Nascar 2nd if user was a member of the Nascar
if (($_POST[master_1st] < 1) and ($_POST[master_2nd] < 1)){

$nvalue = "n_" . $_POST[master_tag];
$dvalue = "d_" . $_POST[master_tag];
$pvalue = "p_" . $_POST[master_tag];

//Insert into nascar_first table
$sql_del_2 = "ALTER TABLE `nascar_first`
DROP `$nvalue`,
DROP `$dvalue`,
DROP `$pvalue`
";

$result_2 = mysql_query($sql_del_2, $connection) or die ("Could not Execute query_2. Reason: ".mysql_error());

//Insert into nascar_second table
$sql_del_second = "ALTER TABLE `nascar_second`
DROP `$nvalue`,
DROP `$dvalue`,
DROP `$pvalue`
";

$result_second = mysql_query($sql_del_second, $connection) or die ("Could not Execute query_second. Reason: ".mysql_error());

//Insert into nascar 1st and 2nd if updated to a yes
} else if (($_POST[master_1st] == 1) or ($_POST[master_2nd] == 1)){
$nvalue = "n_" . $_POST[master_ins_tag];
$dvalue = "d_" . $_POST[master_ins_tag];
$pvalue = "p_" . $_POST[master_ins_tag];


//Insert into nascar_first table
$sql_update_2 = "ALTER TABLE `nascar_first`
ADD `$nvalue` VARCHAR( 10 ) NOT NULL,
ADD `$dvalue` VARCHAR( 30 ) NOT NULL,
ADD `$pvalue` INT( 3 ) NOT NULL
";

$result_2 = mysql_query($sql_update_2, $connection) or die ("Could not Execute query. Reason: ".mysql_error());

//Insert into nascar_second table
$sql_update_second = "ALTER TABLE `nascar_second`
ADD `$nvalue` VARCHAR( 10 ) NOT NULL,
ADD `$dvalue` VARCHAR( 30 ) NOT NULL,
ADD `$pvalue` INT( 3 ) NOT NULL
";

$result_second = mysql_query($sql_update_second, $connection) or die ("Could not Execute query. Reason: ".mysql_error());


//Insert new player name into n_ field
for ($i = 1; $i <= 18; $i++){
//Update first half table
$sql_insert_nvalue = "UPDATE nascar_first SET
$nvalue = '$_POST[master_ins_f_name]'
WHERE week = '$i'
";
//Run Query
$qry_insert_nvalue = mysql_query($sql_insert_nvalue, $connection) or die ("Can not execute insert Query");

$second_i = ($i + 18);
//Update second half table
$sql_insert_nvalue_2 = "UPDATE nascar_second SET
$nvalue = '$_POST[master_ins_f_name]'
WHERE week = '$second_i'
";
//Run Query
$qry_insert_nvalue_2 = mysql_query($sql_insert_nvalue_2, $connection) or die ("Can not execute insert_2 Query");

}//end the add field for NASCAR if

}  //end the update if

//Run Del Comment
if ($del_user == "yes") {

//Delete from nascar first and Nascar 2nd if user was a member of the Nascar
if (($master_1st == 1) or ($master_2nd == 1)){

$nvalue = "n_" . $_POST[master_tag];
$dvalue = "d_" . $_POST[master_tag];
$pvalue = "p_" . $_POST[master_tag];

//Insert into nascar_first table
$sql_del_2 = "ALTER TABLE `nascar_first`
DROP `$nvalue`,
DROP `$dvalue`,
DROP `$pvalue`
";

$result_2 = mysql_query($sql_del_2, $connection) or die ("Could not Execute query_2. Reason: ".mysql_error());

//Insert into nascar_second table
$sql_del_second = "ALTER TABLE `nascar_second`
DROP `$nvalue`,
DROP `$dvalue`,
DROP `$pvalue`
";

$result_second = mysql_query($sql_del_second, $connection) or die ("Could not Execute query_second. Reason: ".mysql_error());
} //end del if in nascar

$sql_del = "
DELETE FROM users WHERE user_id = '$_POST[master_user_id]'
";

$del_result = mysql_query($sql_del, $connection) or die ("Could not Delete query. Reason: ".mysql_error());


} //end del if

//run update
if ($run_master_insert == "new"){
$sql_check = "SELECT user_tag FROM users WHERE user_tag = '$_POST[master_ins_tag]'";
$sql_check_2 = "SELECT first_name FROM users WHERE first_name = '$_POST[master_ins_f_name]'";

$qry_check = mysql_query($sql_check, $connection) or die ("Could not execute check query");
$qry_check_2 = mysql_query($sql_check_2, $connection) or die ("Could not execute check 2 query");

$check_1 = mysql_num_rows($qry_check);
$check_2 = mysql_num_rows($qry_check_2);

if ($check_1 != 0) {
$info_block .= "<tr><td align='center'><font size='5' color='red'><strong>You already have a user with that tag, please select a different tag not taken.</strong></font></td></tr>";
} else if ($check_2 != 0) {
$info_block .= "<tr><td align='center'><font size='5' color='red'><strong>You already have a user with that Name, please select a different name.</strong></font></td></tr>";
} else if ($_POST[master_ins_tag] == NULL) {
$info_block .= "<tr><td align='center'><font size='5' color='red'><strong>You did not enter a User Tag value.  You need to enter a value to move on.</strong></font></td></tr>";
} else {

$sql_update = "INSERT INTO users
(user_tag, first_name, last_name, password, permission, email, fantasy_nascar, fantasy_nascar_2, fantasy_football)
VALUES
('$_POST[master_ins_tag]', '$_POST[master_ins_f_name]', '$_POST[master_ins_l_name]', '$_POST[master_ins_pass]', '$_POST[master_ins_per]', '$_POST[master_ins_email]', '$_POST[master_ins_1st]', '$_POST[master_ins_2nd]', '$_POST[master_ins_FF]')
";

$result = mysql_query($sql_update, $connection) or die ("Could not Execute query. Reason: ".mysql_error());

//Insert into Nascar 1st and 2nd if they want in Nascar
if (($_POST[master_1st] == 1) or ($_POST[master_2nd] == 1)){
$nvalue = "n_" . $_POST[master_ins_tag];
$dvalue = "d_" . $_POST[master_ins_tag];
$pvalue = "p_" . $_POST[master_ins_tag];


//Insert into nascar_first table
$sql_update_2 = "ALTER TABLE `nascar_first`
ADD `$nvalue` VARCHAR( 10 ) NOT NULL,
ADD `$dvalue` VARCHAR( 30 ) NOT NULL,
ADD `$pvalue` INT( 3 ) NOT NULL
";

$result_2 = mysql_query($sql_update_2, $connection) or die ("Could not Execute query. Reason: ".mysql_error());

//Insert into nascar_second table
$sql_update_second = "ALTER TABLE `nascar_second`
ADD `$nvalue` VARCHAR( 10 ) NOT NULL,
ADD `$dvalue` VARCHAR( 30 ) NOT NULL,
ADD `$pvalue` INT( 3 ) NOT NULL
";

$result_second = mysql_query($sql_update_second, $connection) or die ("Could not Execute query. Reason: ".mysql_error());


//Insert new player name into n_ field
for ($i = 1; $i <= 18; $i++){
//Update first half table
$sql_insert_nvalue = "UPDATE nascar_first SET
$nvalue = '$_POST[master_ins_f_name]'
WHERE week = '$i'
";
//Run Query
$qry_insert_nvalue = mysql_query($sql_insert_nvalue, $connection) or die ("Can not execute insert Query");

$second_i = ($i + 18);
//Update second half table
$sql_insert_nvalue_2 = "UPDATE nascar_second SET
$nvalue = '$_POST[master_ins_f_name]'
WHERE week = '$second_i'
";
//Run Query
$qry_insert_nvalue_2 = mysql_query($sql_insert_nvalue_2, $connection) or die ("Can not execute insert_2 Query");
} // end for loop

} //end insert into 1st and 2nd if

} //end check if

} // end the insert new if


//Get information from the table
$sql_get_info = "SELECT *
FROM users
ORDER BY user_id
";

$qry_get_info = mysql_query($sql_get_info, $connection) or die ("Could not get the proper info");

//Start of the display block for this page
$display_block = "<br>
<table align='center' border='1' cellspacing='1' width='770'>
<tr>
<th colspan='11' align='center'>Update Information for Players</th>
</tr>
<tr>
<td align='center'><strong>1st Name</strong></td>
<td align='center'><strong>Last Name</strong></td>
<td align='center'><strong>Last Login</strong></td>
<td align='center'><strong>User Tag</strong></td>
<td align='center'><strong>Pass</strong></td>
<td align='center'><strong>Email</strong></td>
<td align='center'><strong>Per</strong></td>
<td align='center'><strong>1st</strong></td>
<td align='center'><strong>2nd</strong></td>
<td align='center'><strong>FF</strong></td>
<td align='center'><strong>Update</strong></td>
<td align='center'><strong>Delete</strong></td>
</tr>";

while ($info = mysql_fetch_array($qry_get_info)) {
$master_user_id = $info[user_id];
$master_tag = $info[user_tag];
$master_f_name = $info[first_name];
$master_l_name = $info[last_name];
$master_ll = $info[last_login];
$master_pass = $info[password];
$master_email = $info[email];
$master_per = $info[permission];
$master_1st = $info[fantasy_nascar];
$master_2nd = $info[fantasy_nascar_2];
$master_FF = $info[fantasy_football];

//Continue the display block
$display_block .= "
<tr>
<form method='post' action='$_SERVER[PHP_SELF]'>
<td align='center'>
<input type='hidden' name='master_user_id' value='$master_user_id'>
<input type='hidden' name='master_tag' value='$master_tag'>
<input type='hidden' name='run_master_update' value='yes'>
$master_f_name</td>
<td align='center'><input type='text' name='master_l_name' value='$master_l_name' size='8'></td>
<td align='center'>$master_ll</td>
<td align='center'>$master_tag</td>
<td align='center'><input type='text' name='master_pass' value='$master_pass' size='6'></td>
<td align='center'><input type='text' name='master_email' value='$master_email' size='25'></td>
<td align='center'><input type='text' name='master_per' value='$master_per' size='1'></td>
<td align='center'><input type='text' name='master_1st' value='$master_1st' size='1'></td>
<td align='center'><input type='text' name='master_2nd' value='$master_2nd' size='1'></td>
<td align='center'><input type='text' name='master_FF' value='$master_FF' size='1'></td>
<td><input type='submit' name='submit' value='Update' size='10'></td></form>
<form method='post' action='$_SERVER[PHP_SELF]'><td>
<input type='hidden' name='del_user' value='yes'>
<input type='hidden' name='master_user_id' value='$master_user_id'>
<input type='hidden' name='master_tag' value='$master_tag'>
<input type='hidden' name='master_1st' value='$master_1st'>
<input type='hidden' name='master_2nd' value='$master_2nd'>
<input type='submit' name='submit' value='Delete' size='8'></td></form>
</form></tr>";

} // End While loop


//End the display block
$display_block .= "</table>";

$display_block .="<br>
<table align='center' border='1' cellspacing='2' width='770'>
<tr>
<th colspan='9' align='center'>Insert Information for New Players</th>
</tr>
<tr>
<td align='center'><strong>1st Name</strong></td>
<td align='center'><strong>Last Name</strong></td>
<td align='center'><strong>User Tag</strong></td>
<td align='center'><strong>Pass</strong></td>
<td align='center'><strong>Email</strong></td>
<td align='center'><strong>Per</strong></td>
<td align='center'><strong>1st</strong></td>
<td align='center'><strong>2nd</strong></td>
<td align='center'><strong>FF</strong></td>
<td align='center'><strong>Insert</strong></td>
</tr>
<tr><form method='post' action='$_SERVER[PHP_SELF]'>
<input type='hidden' name='run_master_insert' value='new'>
<td align='center'><input type='text' name='master_ins_f_name' size='6'></td>
<td align='center'><input type='text' name='master_ins_l_name' size='8'></td>
<td align='center'><input type='text' name='master_ins_tag' size='3'></td>
<td align='center'><input type='text' name='master_ins_pass' size='6'></td>
<td align='center'><input type='text' name='master_ins_email' size='25'></td>
<td align='center'><input type='text' name='master_ins_per' value='1' size='1'></td>
<td align='center'><input type='text' name='master_ins_1st' value='1'  size='1'></td>
<td align='center'><input type='text' name='master_ins_2nd' value='1'  size='1'></td>
<td align='center'><input type='text' name='master_ins_FF' value='1'  size='1'></td>
<td><input type='submit' name='submit' value='Add Player' size='6'></td>
</form></tr>
</table>";
?>
[/code]
Link to comment
https://forums.phpfreaks.com/topic/28908-missing-syntax-can-not-find-in-code/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.