Multiple PHP errors. Need serious help!!!

vbcoach · March 9, 2010

I know this is probably not standard on here, but I need some serious help with PHP and MsSQL. I have a registration form that is not working, and I cannot seem to fix the errors.

Is there any way that someone on here knowledgable with PHP and MSSQL on here could contact me and render a few minutes of their time to assist me? I have spent the entire weekendand all day today working on this, only to feel like a first-grader trying to understand trig!

In case my email address does not appear, please write to jim@baltimorebeach.com

Thanks in advance!!!

scarhand · March 9, 2010

How about just posting the code and the errors?

vbcoach · March 9, 2010

Because it's 298 lines long without the errors.

I have two files. One is the registration entry page, the other is the PHP processor page.

How would I do that here?

scarhand · March 9, 2010

open php file in notepad -> CTRL+A -> CTRL+C -> click on reply textarea and press CTRL+V

vbcoach · March 9, 2010

THIS POST IS REGISTRATION ENTRY FORM:

<?php

//Connect to Database

$conn = mssql_connect ("localhost", "*****", "*****") or die ('I cannot connect to the database because: ');

mssql_select_db("baltimorebeach");

$lsql = "SELECT * FROM league WHERE (active = 1) AND ([session] = 'Spring') ORDER BY l_id";

$lres = mssql_query($lsql,$conn);

//This is for a later time when Summer registration begins

// $msql = "SELECT * FROM league WHERE (active = 1) AND ([session] = 'Summer') ORDER BY l_id";

//$mres = mssql_query($msql,$conn);

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Baltimore Beach 2010 "Spring" Session Team Registration Form</title>

function isEmail(str)

{

// are regular expressions supported?

var supported = 0;

if (window.RegExp) {

var tempStr = "a";

var tempReg = new RegExp(tempStr);

if (tempReg.test(tempStr)) supported = 1;

}

if (!supported)

return (str.indexOf(".") > 2) && (str.indexOf("@") > 0);

var r1 = new RegExp("(@.*@)|(\\.\\.)|(@\\.)|(^\\.)");

var r2 = new RegExp("^.+\\@(\\[?)[a-zA-Z0-9\\-\\.]+\\.([a-zA-Z]{2,3}|[0-9]{1,3})(\\]?)$");

return (!r1.test(str) && r2.test(str));

}

function validate (theForm)

{

var errStr = "";

if(theForm.teamname.value == '')

{

errStr += "Team name not entered\n";

}

if(theForm.league.value == -1)

{

errStr += "Please select a league in which to participate\n";

}

if(theForm.tshirt.value == -1)

{

errStr += "Please select a t-shirt color\n";

}

if(!isEmail(theForm.cpt_email.value))

{

errStr += "Please enter a valid e-mail address\n";

}

if(theForm.cpt_first.value=='' || theForm.cpt_last.value=='')

{

errStr += "Captain's name incomplete\n";

}

if(theForm.cpt_address.value=='' || theForm.cpt_city.value==''|| theForm.cpt_state.value== -1 || theForm.cpt_zip.value=='')

{

errStr += "Captain's address incomplete\n";

}

if(theForm.cpt_shirt.value == -1)

{

errStr += "Please select a shirt size for the captain";

}

if(errStr != "")

{

alert("The following problems have occurred\n\n"+errStr);

return false;

}

return true;

}

</script>

<!--

.style2 {color: #3E3E3E}

.style3 {

font-family: "Comic Sans MS";

font-size: 11px;

}

body {

background-color: #FFFFFF;

}

.style10 {font-family: "Comic Sans MS"; font-size: 14px; color: #FFCC33; }

.style11 {

color: #FFCC33;

font-size: 36px;

}

.style15 {font-size: 13px; color: #FFFFFF; font-family: "Comic Sans MS";}

.style18 {font-family: "Comic Sans MS"; font-size: 12px; color: #FFCC33; }

.style22 {font-size: 10px}

.style37 {color: #FFCC33; font-size: 14px; }

.style38 {

font-family: Verdana, Arial, Helvetica, sans-serif;

font-size: 12px;

}

.style40 {color: #009999; font-size: 14px; }

.style45 {

color: #FFCC33;

font-size: 18px;

font-family: "Comic Sans MS";

}

.style46 {font-size: 12px}

-->

</style>

</head>

<body>

<tr>

</tr>

<tr>

<p><span class="style11">Baltimore Beach Volleyball

Leagues 2010 <br />

"Spring" Session

Team Registration</span></p>

</div></td>

</tr>

<tr>

<td colspan="2" valign="bottom" bordercolor="#000000" bordercolorlight="#000000" bgcolor="#000000"><div align="center" class="style45">Team Information</div></td>

<td colspan="5" valign="bottom" bordercolor="#000000" bordercolorlight="#000000" bgcolor="#000000"><div align="center"><span class="style45">Player Information</span></div></td>

</tr>

<tr>

<td colspan="2" bgcolor="#006666"><p align="center"> <span class="style3"><em> (</em><em>fields marked * are required)</em></span></p></td>

<td colspan="5" bgcolor="#990000"><div align="center" class="style15">**Note: do not add team captain also as a player or you will be double-billed**</div></td>

</tr>

<tr>

<td width="144" rowspan="2" bgcolor="#3E3E3E"><div align="center" class="style10">Email</div></td>

<td width="140" rowspan="2" bgcolor="#3E3E3E"><div align="center" class="style10">T-Shirt Size </div>

<div align="center">Under Armour Shirt</span></span> <span class="style22"><em>(optional)</em></span></div>

</div> <div align="center" class="style10"></div></td>

</tr>

<tr>

<td width="137" align="right" bgcolor="#3E3E3E"><span class="style37"> *League </span></td>

<option value="" selected="selected">-- Select League --</option>

<?php while ($lrow = mssql_fetch_assoc($lres)) { ?>

<?php

}

?>

</select></td>

</tr>

<tr>

<td width="137" height="24" align="right" bgcolor="#3E3E3E"><span class="style37"> *Shirt Color </span></td>

<option value="-1">-- Select Color --</option>

<option value="white">White</option>

<option value="orange">Orange</option>

<option value="yellow">Yellow</option>

<option value="purple">Purple</option>

<option value="green">Green</option>

<option value="black">Black</option>

</select>

</span></td>

<td width="66" bgcolor="#3E3E3E"><div align="center"><span class="style18" style="width: 25%">Player 1</span></div></td>

<option value="-1" selected="selected">-- Select Size --</option>

<option value="MS">Men's Small</option>

<option value="MM">Men's Medium</option>

<option value="ML">Men's Large</option>

<option value="WS">Women's Small</option>

<option value="WM">Women's Medium</option>

<option value="WL">Women's Large</option>

<option value="WXL">Women's XL</option>

<option value="W2XL">Women's 2XL</option>

<option value="W3XL">Women's 3XL</option>

</select>

</span></td>

<option value="-1" selected="selected">-- Option --</option>

</select></td>

</tr>

<tr>

<td align="right" bgcolor="#3E3E3E"><span class="style40">Returning Team? </span></td>

<option value="-1">-- Select Choice --</option>

</select>

</span></td>

<td bgcolor="#3E3E3E"><div align="center"><span class="style18" style="width: 25%">Player 2</span></div>

</span></td>

</span></td>

<option value="-1" selected="selected">-- Select Size --</option>

<option value="MS">Men's Small</option>

<option value="MM">Men's Medium</option>

<option value="ML">Men's Large</option>

<option value="WS">Women's Small</option>

<option value="WM">Women's Medium</option>

<option value="WL">Women's Large</option>

<option value="WXL">Women's XL</option>

<option value="W2XL">Women's 2XL</option>

<option value="W3XL">Women's 3XL</option>

</select>

</span></td>

<option value="-1" selected="selected">-- Option --</option>

</select></td>

</tr>

<tr>

<td align="right" bgcolor="#3E3E3E"><div align="center"><span class="style18" style="width: 25%">Player 3</span></div></td>

</span></td>

</span></td>

<option value="-1" selected="selected">-- Select Size --</option>

<option value="MS">Men's Small</option>

<option value="MM">Men's Medium</option>

<option value="ML">Men's Large</option>

<option value="WS">Women's Small</option>

<option value="WM">Women's Medium</option>

<option value="WL">Women's Large</option>

<option value="WXL">Women's XL</option>

<option value="W2XL">Women's 2XL</option>

<option value="W3XL">Women's 3XL</option>

</select>

</span></td>

<option value="-1" selected="selected">-- Option --</option>

</select></td>

</tr>

<tr>

<td colspan="2" align="right"><div align="center" class="style45">Captain's Information</div></td>

<td width="66" bgcolor="#3E3E3E"><div align="center"><span class="style18" style="width: 25%">Player 4</span></div></td>

</span></td>

<option value="-1" selected="selected">-- Select Size --</option>

<option value="MS">Men's Small</option>

<option value="MM">Men's Medium</option>

<option value="ML">Men's Large</option>

<option value="WS">Women's Small</option>

<option value="WM">Women's Medium</option>

<option value="WL">Women's Large</option>

<option value="WXL">Women's XL</option>

<option value="W2XL">Women's 2XL</option>

<option value="W3XL">Women's 3XL</option>

</select>

</span></td>

<option value="-1" selected="selected">-- Option --</option>

</select></td>

</tr>

<tr>

<td width="137" align="right" bgcolor="#3E3E3E"><span class="style37"> *First Name </span></td>

<td width="66" bgcolor="#3E3E3E"><div align="center" class="style18">Player 5</div></td>

</span></td>

<option value="-1" selected="selected">-- Select Size --</option>

<option value="MS">Men's Small</option>

<option value="MM">Men's Medium</option>

<option value="ML">Men's Large</option>

<option value="WS">Women's Small</option>

<option value="WM">Women's Medium</option>

<option value="WL">Women's Large</option>

<option value="WXL">Women's XL</option>

<option value="W2XL">Women's 2XL</option>

<option value="W3XL">Women's 3XL</option>

</select>

</span></td>

<option value="-1" selected="selected">-- Option --</option>

</select></td>

</tr>

<tr>

<td width="66" bgcolor="#3E3E3E"><div align="center" class="style18">Player 6</div></td>

</span></td>

<option value="-1" selected="selected">-- Select Size --</option>

<option value="MS">Men's Small</option>

<option value="MM">Men's Medium</option>

<option value="ML">Men's Large</option>

<option value="WS">Women's Small</option>

<option value="WM">Women's Medium</option>

<option value="WL">Women's Large</option>

<option value="WXL">Women's XL</option>

<option value="W2XL">Women's 2XL</option>

<option value="W3XL">Women's 3XL</option>

</select>

</span></td>

<option value="-1" selected="selected">-- Option --</option>

</select></td>

</tr>

<tr>

<td width="137" align="right" bgcolor="#3E3E3E"><span class="style37"> *Address </span></td>

<td width="66" bgcolor="#3E3E3E"><div align="center" class="style18">Player 7</div></td>

</span></td>

<option value="-1" selected="selected">-- Select Size --</option>

<option value="MS">Men's Small</option>

<option value="MM">Men's Medium</option>

<option value="ML">Men's Large</option>

<option value="WS">Women's Small</option>

<option value="WM">Women's Medium</option>

<option value="WL">Women's Large</option>

<option value="WXL">Women's XL</option>

<option value="W2XL">Women's 2XL</option>

<option value="W3XL">Women's 3XL</option>

</select>

</span></td>

<option value="-1" selected="selected">-- Option --</option>

</select></td>

</tr>

<tr>

<td width="66" bgcolor="#3E3E3E"><div align="center" class="style18">Player 8</div></td>

</span></td>

<option value="-1" selected="selected">-- Select Size --</option>

<option value="MS">Men's Small</option>

<option value="MM">Men's Medium</option>

<option value="ML">Men's Large</option>

<option value="WS">Women's Small</option>

<option value="WM">Women's Medium</option>

<option value="WL">Women's Large</option>

<option value="WXL">Women's XL</option>

<option value="W2XL">Women's 2XL</option>

<option value="W3XL">Women's 3XL</option>

</select>

</span></td>

<option value="-1" selected="selected">-- Option --</option>

</select></td>

</tr>

<tr>

<td width="137" align="right" bgcolor="#3E3E3E"><span class="style37"> *State </span></td>

<option value="-1" selected="selected">--Choose State--</option>

<option value="AL">Alabama</option>

<option value="AK">Alaska</option>

<option value="AZ">Arizona</option>

<option value="AR">Arkansas</option>

<option value="CA">California</option>

<option value="CO">Colorado</option>

<option value="CT">Connecticut</option>

<option value="DE">Delaware</option>

<option value="DC">Dist. of Columbia</option>

<option value="FL">Florida</option>

<option value="GA">Georgia</option>

<option value="HI">Hawaii</option>

<option value="ID">Idaho</option>

<option value="IL">Illinois</option>

<option value="IN">Indiana</option>

<option value="KS">Kansas</option>

<option value="KY">Kentucky</option>

<option value="LA">Louisiana</option>

<option value="ME">Maine</option>

<option value="MD">Maryland</option>

<option value="MA">Massachusetts</option>

<option value="MI">Michigan</option>

<option value="MN">Minnesota</option>

<option value="MS">Mississippi</option>

<option value="MO">Missouri</option>

<option value="MT">Montana</option>

<option value="NE">Nebraska</option>

<option value="NV">Nevada</option>

<option value="NH">New Hampshire</option>

<option value="NJ">New Jersey</option>

<option value="NM">New Mexico</option>

<option value="NC">North Carolina</option>

<option value="ND">North Dakota</option>

<option value="OK">Oklahoma</option>

<option value="OR">Oregon</option>

<option value="PA">Pennsylvania</option>

<option value="RI">Rhode Island</option>

<option value="SC">South Carolina</option>

<option value="SD">South Dakota</option>

<option value="TN">Tennessee</option>

<option value="TX">Texas</option>

<option value="VT">Vermont</option>

<option value="VA">Virginia</option>

<option value="WA">Washington</option>

<option value="WV">West Virginia</option>

<option value="WI">Wisconsin</option>

<option value="WY">Wyoming</option>

</select></td>

<td width="66" bgcolor="#3E3E3E"><div align="center" class="style18">Player 9</div></td>

</span></td>

<option value="-1" selected="selected">-- Select Size --</option>

<option value="MS">Men's Small</option>

<option value="MM">Men's Medium</option>

<option value="ML">Men's Large</option>

<option value="WS">Women's Small</option>

<option value="WM">Women's Medium</option>

<option value="WL">Women's Large</option>

<option value="WXL">Women's XL</option>

<option value="W2XL">Women's 2XL</option>

<option value="W3XL">Women's 3XL</option>

</select>

</span></td>

<option value="-1" selected="selected">-- Option --</option>

</select></td>

</tr>

<tr>

<td width="66" bgcolor="#3E3E3E"><div align="center" class="style18">Player 10</div></td>

</span></td>

<option value="-1" selected="selected">-- Select Size --</option>

<option value="MS">Men's Small</option>

<option value="MM">Men's Medium</option>

<option value="ML">Men's Large</option>

<option value="WS">Women's Small</option>

<option value="WM">Women's Medium</option>

<option value="WL">Women's Large</option>

<option value="WXL">Women's XL</option>

<option value="W2XL">Women's 2XL</option>

<option value="W3XL">Women's 3XL</option>

</select>

</span></td>

<option value="-1" selected="selected">-- Option --</option>

</select></td>

</tr>

<tr>

<td align="right" bgcolor="#3E3E3E"><span class="style37"> *Phone </span></td>

</span></td>

<td width="66" bgcolor="#3E3E3E"><div align="center" class="style18">Player 11</div></td>

</span></td>

<option value="-1" selected="selected">-- Select Size --</option>

<option value="MS">Men's Small</option>

<option value="MM">Men's Medium</option>

<option value="ML">Men's Large</option>

<option value="WS">Women's Small</option>

<option value="WM">Women's Medium</option>

<option value="WL">Women's Large</option>

<option value="WXL">Women's XL</option>

<option value="W2XL">Women's 2XL</option>

<option value="W3XL">Women's 3XL</option>

</select>

</span></td>

<option value="-1" selected="selected">-- Option --</option>

</select></td>

</tr>

<tr>

<td width="137" align="right" bgcolor="#3E3E3E"><span class="style37"> *Email </span></td>

</div></td>

</tr>

<tr>

<td align="right" bgcolor="#3E3E3E"><span class="style37"> *T-Shirt Size </span></td>

<option value="-1" selected="selected">-- Select Size --</option>

<option value="MS">Men's Small</option>

<option value="MM">Men's Medium</option>

<option value="ML">Men's Large</option>

<option value="WS">Women's Small</option>

<option value="WM">Women's Medium</option>

<option value="WL">Women's Large</option>

<option value="WXL">Women's XL</option>

<option value="W2XL">Women's 2XL</option>

<option value="W3XL">Women's 3XL</option>

</select>

</span></td>

</tr>

<tr>

<td align="right" bgcolor="#3E3E3E"><span class="style37">*Under Armour </span></td>

<option value="-1" selected="selected">-- Option --</option>

</select></td>

</tr>

</table>

<br />

<tr>

<?= date("Y") ?>

<span class="style38">Revised: March 7th, 2010 </span></div></td>

</tr>

</table>

</form>

</body>

</html>

vbcoach · March 9, 2010

THIS IS WHAT I CALL THE REGISTRATION PROCESSOR PAGE - WHICH INCLUDES OUTPUT TO A RECEIPT PAGE

<?php

if($_POST)

{

foreach ($_POST as $k=>$v)

{

$t = stripslashes($v);

$t = str_replace("'",'′',$t);

$vals[$k] = $t;

}

//Connect to Database

$conn = mssql_connect ("localhost", "*****", "*****") or die ('I cannot connect to the database because: ');

mssql_select_db("baltimorebeach");

$teamname = "SELECT t_id FROM team WHERE league = '$vals[league]' AND teamname='$vals[teamname]'";

$tres = mssql_query($teamname);

if(mssql_rows_affected($conn) != 0)

{

$lsql = "SELECT * FROM league WHERE active = 1 AND [session] = 'Spring' ORDER BY l_id";

$lres = mssql_query($lsql,$conn);

?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>2010 Team Registration Complete</title>

function isEmail(str)

{

// are regular expressions supported?

var supported = 0;

if (window.RegExp) {

var tempStr = "a";

var tempReg = new RegExp(tempStr);

if (tempReg.test(tempStr)) supported = 1;

}

if (!supported)

return (str.indexOf(".") > 2) && (str.indexOf("@") > 0);

var r1 = new RegExp("(@.*@)|(\\.\\.)|(@\\.)|(^\\.)");

var r2 = new RegExp("^.+\\@(\\[?)[a-zA-Z0-9\\-\\.]+\\.([a-zA-Z]{2,3}|[0-9]{1,3})(\\]?)$");

return (!r1.test(str) && r2.test(str));

}

function validate (theForm)

{

var errStr = "";

if(theForm.teamname.value == '')

{

errStr += "Team name not entered\n";

}

if(theForm.league.value == -1)

{

errStr += "Please select a league in which to participate\n";

}

if(theForm.shirtsize.value == -1)

{

errStr += "Please select a t-shirt color\n";

}

if(!isEmail(theForm.cpt_email.value))

{

errStr += "Please enter a valid e-mail address\n";

}

if(theForm.cpt_first.value=='' || theForm.cpt_last.value=='')

{

errStr += "Captain's name incomplete\n";

}

if(theForm.cpt_address.value=='' || theForm.cpt_city.value==''|| theForm.cpt_state.value== -1 || theForm.cpt_zip.value=='')

{

errStr += "Captain's address incomplete\n";

}

if(theForm.cpt_shirtsize.value == -1)

{

errStr += "Please select a shirt size for the captain";

}

if(errStr != "")

{

alert("The following problems have occurred\n\n"+errStr);

return false;

}

return true;

}

</script>

<!--

.style8 {

color: #FF0000;

font-size: 18px;

}

.style9 {color: #000000}

-->

</style>

</head>

<body>

<h4 align="center" class="style5"><span class="style4">Team name </span><strong><em>"<span class="style7 style8"><?= $vals['teamname'] ?></span>"</em> already taken for this league! Please selecet a different name</strong>. </h4>

<h4 align="center"><p align="center" class="style9">Please press <a href="javascript:history.back()">Back</a> on your browser and choose a different team name </p>

</h4>

</body>

</html>

<?php

mssql_close($conn);

exit;

echo "teamname is $vals[teamname]";

echo "shirtcolor is '$vals[shirtcolor]";

}//if team name already exists

//League Info

$leagueId = $vals['league'];

$leagueRes = mssql_query("SELECT * FROM league WHERE l_id = $leagueId",$conn);

$lSize = mssql_fetch_assoc($leagueRes);

//Create the captain

$ln = strtolower(substr($vals['cpt_first'],0,1).str_replace("'","",$vals['cpt_last']));

$loginSQL = "SELECT COUNT(*) FROM captain WHERE username LIKE '$ln%'";

$lres = mssql_query($loginSQL,$conn);

$count = mssql_fetch_row($lres);

//login is first initial + last name

$login = strtolower(substr($vals['cpt_first'],0,1).str_replace("'","",$vals['cpt_last'])).substr($lSize['type'],0,1).$lSize['size'].$lSize['division'];

if($count[0] > 0)

{

$login = strtolower(substr($vals['cpt_first'],0,1).str_replace("'","",$vals['cpt_last']).$count[0].substr($lSize['type'],0,1).$lSize['size'].$lSize['division']);

}

$password = strtolower(substr($vals['cpt_first'],0,1).substr($vals['cpt_last'],0,1).substr($vals['cpt_phone'],-4));

$cpt_sql = "INSERT INTO captain (username,password,firstname,lastname,address,city,state,zip,email,phone,shirtsize,returningteam,rteamname) VALUES ('$login','$password','$vals[cpt_first]','$vals[cpt_last]','$vals[cpt_address]','$vals[cpt_city]','$vals[cpt_state]','$vals[cpt_zip]','$vals[cpt_email]','$vals[cpt_phone]','$vals[cpt_shirtsize]','$vals[returningteam]','$vals[rteamname]')";

//run captain query

$query = mssql_query($cpt_sql,$conn);

//Find the captains id # for the team information

$query = mssql_query("SELECT c_id FROM captain ORDER BY c_id DESC;",$conn);

$qRes = mssql_fetch_assoc($query);

$cptId = $qRes['c_id'];

//$cptId = 1;

//----------

//Create the team

$team_sql = "INSERT INTO team (teamname,shirtcolor,league,captain) VALUES ('$vals[teamname]','$vals[shirtcolor]','$leagueId','$cptId',)";

//echo $team_sql;

//run team query

$query = mssql_query($team_sql,$conn);

//find team id for players

$query1 = mssql_query("SELECT t_id FROM team ORDER BY t_id DESC;",$conn);

$qRes = mssql_fetch_assoc($query1);

$teamId = $qRes['t_id'];

//------------------

//build players

/*

loop through all ten possible players listed and check to see if the name field has at least 2 characters.

If it does then we will grab the other 3 bits of information and add the player to the database.

*/

$players = '';

$pCount = 1;

$members = $leagueId == 31 ? 6:11;

for($i =1; $i <= $members; $i++)

{

if(strlen($vals['player'.$i.'_name']) > 2)

{

$pName = $vals['player'.$i.'_name'];

$pEmail = $vals['player'.$i.'_email'];

$ppShirt = $vals['player'.$i.'_shirt'];

$pp_ua = $vals['player'.$i.'_ua'];

$pCount ++;

$p_sql = "INSERT INTO player (name,email,team,pshirt,p_ua) VALUES ('$pName','$pEmail','$teamId','$ppShirt','$pp_ua')";

$query = mssql_query($p_sql,$conn);

$players .= "$pName - $ppShirt $pp_ua<br />\n";

}

//-------------

mssql_close($conn);

//calculate Fees

$size = $lSize['size'];

switch($size)

{

case 2:

$base = 150;

$size = 3;

break;

case 4:

$base = 330;

$size = 6;

break;

case 6:

$base = 550;

$size = 10;

break;

default: die ("invalid league size");

};

$earlyTeam = $base;

{

$e_each = $earlyTeam / $pCount;

$lateTeam = $earlyTeam * 1.10;

$l_each = $lateTeam / $pCount;

}

//POST everything else - time to display more variables

echo '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"

"http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>2010 Summer Session Team Registration Confirmation</title>

</head>

<body>

';

echo "

<h3>Team $vals[teamname] Registered for \"Spring\" Leagues 2010!</h3>

<p <font face=\"Comic Sans MS\">Thank you for registering with Baltimore Beach. Please be sure to <strong><a href=\"javascript:window.print()\">PRINT</a></strong> this page for your own records. Please remember that <strong>Registration is not considered complete until team fees have been paid</strong>. As captain of the team this responsibility falls to you. We encourage you to send in one </font>check for the entire fee.</p><br>To view all other teams that have registered in your league <a href=\"http://www.baltimorebeach.com/summerleagueinfo.php?l=$lSize[l_id]\">click here</a>

<h2><b><u>Team Captain Info:</u></b></h2>

<strong>Name</strong>: $vals[cpt_first] $vals[cpt_last]<br>

<strong>Address</strong>: $vals[cpt_address] $vals[cpt_city], $vals[cpt_state] $vals[cpt_zip]<br>

<strong>Email</strong>: $vals[cpt_email]<br>

<strong>Shirt</strong>: $vals[cpt_shirtsize] $vals[c_ua]<br>

<strong>Login</strong>: $login<br>

<strong>Password</strong>: $password<br>

Captain's web page is: <a href=\"http://www.baltimorebeach.com/cp\">http://www.baltimorebeach.com/cp</a>

<strong>BBV League</strong>: Spring $lSize[night] $lSize[type] $lSize $lSize[division]<br>

<strong>Team Name</strong>: $vals[teamname]<br>

<strong>T-Shirt Color</strong>: $vals[shirtcolor]<br>

<strong>No. of Players</strong>: $pCount<br>

<strong>Team Fees Due</strong>: \$$earlyTeam<br>

</p>

<p>

<h2><b><u>Players / Shirt Sizes:</u></b></h2>

$players

</p>

<p>

<p><span class=\"style99\">Make (one) team registration check payable to</span><strong>:</strong> <span class=\"style34\">Baltimore Beach Volleyball</span> <br />

<span class=\"style98\">*Please enter team name, league night & division on memo line</span></p>

<p align=\"left\"><span class=\"style99\">Send to</span><strong>:</strong> <span class=\"style33\">Baltimore Beach<br />

1317 S. Hanover Street <br />

Baltimore, MD 21230</span></p>

<p align=\"left\"><span class=\"style33\">*** League payments now accepted via PayPal ***</span><br>

</div>

</body>

</html>

";

}

/* */

?>

vbcoach · March 9, 2010

Ok, here are the errors:

Warning: mssql_query(): message: Line 1: Incorrect syntax near ')'. (severity 15) in E:\Web Server\baltimorebeach_com\htdocs\registration\regproc2010.php on line 169

Warning: mssql_query(): Query failed in E:\Web Server\baltimorebeach_com\htdocs\registration\regproc2010.php on line 169

Warning: mssql_query(): message: INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK__player__team__3F466844'. The conflict occurred in database 'baltimorebeach', table 'team', column 't_id'. (severity 16) in E:\Web Server\baltimorebeach_com\htdocs\registration\regproc2010.php on line 199

Warning: mssql_query(): Query failed in E:\Web Server\baltimorebeach_com\htdocs\registration\regproc2010.php on line 199

+++++++++++++++++++++++++++++++++++++++++++++++++++

The crazy thing is, all the variables are echoed properly in the receipt page. In the Captain's table and Player's table, the information is inserted into the tables properly. It's the TEAM table that is giving me fits. Anyone have any thoughts?

scarhand · March 9, 2010

All those errors are coming from your reg process script.

Both of them are coming from lines 169 and 199. All you have to do is pinpoint the issues within those 2 lines.

On line 169 you are simply using incorrect syntax.

On line 199 your INSERT statement is causing conflicts with t_id column, being a foreign key.

Get notepad2 and start using that for your PHP programming.

vbcoach · March 9, 2010

Thanks for the prompt reply.

First you said:On line 169 you are simply using incorrect syntax. Can you help me here?

On line 199 your INSERT statement is causing conflicts with t_id column, being a foreign key. Ok, I have no idea why this is happening. Can you assist at all?

Get notepad2 and start using that for your PHP programming? I can do that, but I use Dreamweaver CS3 for my PHP programming.

gizmola · March 9, 2010

So line 169:

 $team_sql = "INSERT INTO team (teamname,shirtcolor,league,captain) VALUES ('$vals[teamname]','$vals[shirtcolor]','$leagueId','$cptId',)";

See that dangling comma at the end of the VALUES list?

vbcoach · March 9, 2010

Um, forgive me, but what you wrote is exactly what I have in my code. Am I missing something else? Yes I see that dangling comma. Is it not supposed to be there? HELP!

gizmola · March 9, 2010

No it's not. I thought that was obvious, although that's a SQL or in your case MS SQL syntax issue, and has nothing to do with PHP.

vbcoach · March 9, 2010

OH GEEZ! It's always the little stuff that gets you in the end. Let me try this...

OMG! I spent how many hours working on this? My friend, you are GREAT!

Hey mind if I ask you a couple more questions? Much simpler this time?

What does this do exactly?

if($_POST)

{

foreach ($_POST as $k=>$v)

{

$t = stripslashes($v);

$t = str_replace("'",'′',$t);

$vals[$k] = $t;

}

trq · March 9, 2010

Can you please use

tags when posting code? Sheesh...

vbcoach · March 9, 2010

Forgive me, but I am new on here. What are the

tags you refer to?

Is that was you input before that colorized the code?

vbcoach · March 9, 2010

 if($_POST)
{
  foreach ($_POST as $k=>$v)
{
   $t = stripslashes($v);
   $t = str_replace("'",'′',$t);
   $vals[$k] = $t;
}

gizmola · March 9, 2010

[code=php:0]  Code here

[/code]

Is basically what you want to use for any php code.

The code you posted basically goes through the $_POST superglobal array, which is a php standard array that will contain the contents of the a form that used the post method which targetted the executing script. The names of the form elements will be associative keys.

That snippet goes through that array one element at a time, runs stripslashes() on the value, and replaces any ' characters with the html entity ′

It stores this new, stripped and replaced value in a $val[] array where the keyname is the same as the original $_POST[].

It's not a real sophisticated script, and it appears to assume that magic_quotes_gpc() is on. What magic_quotes_gpc() does is automagically run the addslashes() command on any input coming from external sources. This is not helpful behavior, and is deprecated now. Slashes to escape quotes is not helpful at all for mssql, so it's understandable you don't want them, but before running stripslashes() you want to make sure it's needed.

With mssql, as far as I understand you need to be concerned about the ' character as well as the [] characters in input. I'd highly recommend that you investigate the matter further. Here's an article that talks about the issue a bit.

http://www.techtamasha.com/escape-single-quotes-and-wild-cards-_-in-ms-sql/20

I don't know that I would use html entities to solve this problem... it seems that the correct answer is that single quotes should be escaped by doubling them and the entire string needs to be contained within single quotes.

Just my 2 cents, but hopefully this gives you an idea of what is going on with your code snippet.

I don't know where the code is from, but in essence it's trying to solve the problem of escaping special sql characters so that they can be safely stored in a database.

vbcoach · March 9, 2010

Hey that's an outstanding reply. This registration form is a culmination of years of tweaks and different "hands in the pot". It's now dumped in my lap as the original programm(ers) who were volunteers(?) are now long past gone. So I am trying to understand a bit of what they had in here and why, and fixing up others.

For example, there is a javascript function call that validates the form that is no longer working, and I have no idea why.

Another thing I wanted (and needed) to do with this for is an IF - else statement. Our league has a Spring session and a Summer session. I wanted to create a drop-down menu that gave you those two options. If Spring was selected, it would pull the Spring info as below

$lsql = "SELECT * FROM league WHERE (active = 1) AND ([session] = 'Spring') ORDER BY l_id";

but if Summer was selected, it would conversely pull the 'Summer' leagues information.

Any thoughts on how I could do this with an "If" statement?

trq · March 9, 2010

$season = $_POST['nameofseasondropdown'];
$lsql = "SELECT * FROM league WHERE (active = 1) AND ([session] = '$season') ORDER BY l_id";

vbcoach · March 9, 2010

It can't be that easy? :'(

trq · March 9, 2010

Why?

gizmola · March 9, 2010

Hey thorpe is the closest thing that we have at phpfreaks to a superhero. The man spits out more working jquery code while he's drinking his coffee than most mere mortals will be able to develope in a week.

You have to come up with something really crazy if you want the guy to break a sweat: something like "hey thorpe can you write a quick 8088 disassembler in javascript for me" or "how do I stop these chinese crackers from getting into gmail?"

Anyways, if we've got your initial questions worked out, we like to close up threads and have people mark em "solved" for posterity. We like to try and localize threads to a specific set of problems rather than have long rambling threads that change directions a bunch of times.

Good luck with the code pickup --- it's often a challenge to adopt a bunch of legacy code that isn't commented, and is lacking structure, and try and figure out how and why it works or not. PHP is one of the best languages in terms of documentation, thanks to php.net. A decent editor with color syntax highlighting and function inspection also goes a long way. Cheers!

vbcoach · March 9, 2010

GREAT! I was being silly with the can't be that easy comment. I racked my brain out trying to figure that one out. His code was so simple! ::) Ok, can I mark the topic as completed, or is this something that you need to do?

Thanks gang for all of your help. I can pretty much guarantee I will be back! I love working with PHP. There is just so much to learn. I have had to learn by viewing previous examples and attempting to append their work. Not the best way to learn. I will take any and all tips to learn this stuff.

gizmola · March 9, 2010

You do it... at the very bottom you should see a Green button that says "MARK SOLVED".

Sign In

Multiple PHP errors. Need serious help!!!

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information