Forum Moderators: coopster
2016-2017
Dinamo Bucharest (Romania A1)
2015-2016
LP-Vampula (Finland, Champions League)
Highest regular season hitting percentage (56.51%)
2014 - 2015
SATU MARE (Romania)
Michigan State University (2010-2013)
Team USA National A2 Team (2010-2013)
Member of USA Training Team (2014)
USA Professional Volleyball League (PVL) Tournament (2014) Team GEVA, Chesapeake Rising Tide (2015)
-Finished 1st all time in block assists, and single season block assists at MSU
-2nd all time in hitting percentage and total blocks at MSU
2011-2013: 3 NCAA tournament berths (2nd round (2011), back to back NCAA Regional Semifinal appearances (2012 & 2013)
2013: AVCA All-America Honorable Mention
2013: AVCA All-North Region First Team
2013: All-Big Ten Honorable Mention
2013: Hokie Invitational and Butler Invitational All-Tournament Team
2012: COBRA Magazine All-National First Team
2012: Big Ten Defensive Player of the Week (Sept 17)
2012: Charleston Invitational, Spartan Showcase and UCONN Classic All-Tournament Team
2012: Preseason All-Big Ten
2011: COBRA Magazine All-Region First Team
2011: Spartan Showcase, Best Western Falcon Invite and Spartan Invitational All-Tournament Team
2010: Big Ten Freshman of the Week (Nov 22 & Nov 29)
2010: Big Ten Defensive Player of the Week (Nov 29)
Racing Club de Cannes (Pro A France)- 2017/2018
March 2018- French Cup Champion
April 2018- Finished regular season in 2nd place. Currently, in semi-finals of the championship
Canadian Senior National Team (2016-2018)
May 2016- Selected to senior national team
June 2017- Starting reception libero for Pan American Cup (Peru, 6th place)
July 2017- Starting reception libero for Grand Prix
October 2017- Grand Champions of the NORCECA Continental Championship and World Championship Qualification Tournament. Starting reception libero.
VC Tirol (Pro A Austria)- 2016/2017
- October 2017- named co-captain of professional team
- February 2017- Finished 1st in total kills and 3rd in total points in the Austrian league
University- UBC Okanagan 2011-2016
2015/2016
- Named co-captain of university team (UBC-O Heat)
- Canada West- Star of the week award
- Canada West- Second team all star award
- Lead the team in kills, kills/set, points, points/set, aces, and aces/set
- Canada West Silver Medalist
- National Bronze Medalist
- Finalist for UBC- Okanagan's Most Outstanding Athlete of the Year
2014/2015
- Canada West Athlete of the week
- Nominated for UBC Okanagan Most Outstanding athlete of the year
- 6th in Canada West in Kills/set and points/set
- Lead team in kills, kills/set, points, and points/set
Team British Columbia (U-15 to U19)
- 2013- Selected to Team BC for Canada Summer Games (Silver medal)
- 2011- National Champion- tournament all star
<?php include('../../connect.php'); ?>
<?php
$PlayerFirstName = $_POST['PlayerFirstName'];
$PlayerLastName = $_POST['PlayerLastName'];
$PlayerFullName = $_POST['PlayerFullName'];
$Agency = $_POST['Agency'];
$CurrentNumber = $_POST['CurrentNumber'];
$EditedBy = $_POST['EditedBy'];
$EUPassportDetails = $_POST['EUPassportDetails'];
$FacebookCode = $_POST['FacebookCode'];
$FBNumericID = $_POST['FBNumericID'];
$HaveEUPassport = $_POST['HaveEUPassport'];
$headshot = $_POST['headshot'];
$HighLightVideo = $_POST['HighLightVideo'];
$HighLightVideoID = $_POST['HighLightVideoID'];
$InternalNotes = $_POST['InternalNotes'];
$IPField = $_POST['IPField'];
$NameOnPassport = $_POST['NameOnPassport'];
$PassportExpires = $_POST['PassportExpires'];
$PassportNumber = $_POST['PassportNumber'];
$PersonEvaluating = $_POST['PersonEvaluating'];
$PlayerAddress = $_POST['PlayerAddress'];
$PlayerBlockTouch = $_POST['PlayerBlockTouch'];
$PlayerCareerHighlights = $_POST['PlayerCareerHighlights'];
$PlayerCountry = $_POST['PlayerCountry'];
$PlayerCurrentTeam = $_POST['PlayerCurrentTeam'];
$PlayerDateOfBirth = $_POST['PlayerDateOfBirth'];
$PlayerEmail = $_POST['PlayerEmail'];
$PlayerFavCountries = $_POST['PlayerFavCountries'];
$PlayerHeight = $_POST['PlayerHeight'];
$PlayerID = $_POST['PlayerID'];
$PlayerMobile = $_POST['PlayerMobile'];
$PlayerNationality = $_POST['PlayerNationality'];
$PlayerPassword = $_POST['PlayerPassword'];
$PlayerPhone = $_POST['PlayerPhone'];
$PlayerPlaceOfBirth = $_POST['PlayerPlaceOfBirth'];
$PlayerPrimaryPosition = $_POST['PlayerPrimaryPosition'];
$PlayerSalary = $_POST['PlayerSalary'];
$PlayerSecondaryPosition = $_POST['PlayerSecondaryPosition'];
$PlayerSex = $_POST['PlayerSex'];
$PlayerSpikeTouch = $_POST['PlayerSpikeTouch'];
$PlayerStatus = $_POST['PlayerStatus'];
$PlayerWeight = $_POST['PlayerWeight'];
$PlayerWriteUp = $_POST['PlayerWriteUp'];
$PPI = $_POST['PPI'];
$RegisteredOn = $_POST['RegisteredOn'];
$VideoID1 = $_POST['VideoID1'];
$VideoID2 = $_POST['VideoID2'];
$VideoID3 = $_POST['VideoID3'];
$VideoID4 = $_POST['VideoID4'];
$VideoURL1 = $_POST['VideoURL1'];
$VideoURL2 = $_POST['VideoURL2'];
$VideoURL3 = $_POST['VideoURL3'];
$VideoURL4 = $_POST['VideoURL4'];
$Whatsapp = $_POST['Whatsapp'];
$AccompaniedBy = $_POST['AccompaniedBy'];
$UniqueID = $_POST['UniqueID'];
//EUPassportDetails did not work for some reason.
//$result = mysqli_query($dbc, "INSERT INTO `Players`(`PlayerFirstName`, `PlayerLastName`, `PlayerFullName`, `Agency`, `CurrentNumber`, `EditedBy`, `FacebookCode`, `FBNumericID`, `HaveEUPassport`, `headshot`, `HighLightVideo`, `HighLightVideoID`, `InternalNotes`, `IPField`, `NameOnPassport`, `PassportExpires`, `PassportNumber`, `PersonEvaluating`, `PlayerAddress`, `PlayerBlockTouch`, `PlayerCareerHighlights`, `PlayerCountry`, `PlayerCurrentTeam`, `PlayerDateOfBirth`, `PlayerEmail`, `PlayerFavCountries`, `PlayerHeight`, `PlayerID`, `PlayerMobile`, `PlayerNationality`, `PlayerPassword`, `PlayerPhone`, `PlayerPlaceOfBirth`, `PlayerPrimaryPosition`) VALUES ('$PlayerFirstName','$PlayerLastName','$PlayerFullName','$Agency','$CurrentNumber','$EditedBy','$FacebookCode','$FBNumericID','$HaveEUPassport','$headshot','$HighLightVideo','$HighLightVideoID','$InternalNotes','$IPField','$NameOnPassport','$PassportExpires','$PassportNumber','$PersonEvaluating','$PlayerAddress',$PlayerBlockTouch,'$PlayerCareerHighlights','$PlayerCountry','$PlayerCurrentTeam','$PlayerDateOfBirth','$PlayerEmail','$PlayerFavCountries',$PlayerHeight,'$PlayerID','$PlayerMobile','$PlayerNationality','$PlayerPassword','$PlayerPhone','$PlayerPlaceOfBirth','$PlayerPrimaryPosition')");
$result = mysqli_query($dbc, "INSERT INTO `Players`(`PlayerFirstName`, `PlayerLastName`, `PlayerFullName`, `Agency`, `CurrentNumber`, `EditedBy`, `FacebookCode`, `FBNumericID`, `HaveEUPassport`, `headshot`, `HighLightVideo`, `HighLightVideoID`, `InternalNotes`, `IPField`, `NameOnPassport`, `PassportExpires`, `PassportNumber`, `PersonEvaluating`, `PlayerAddress`, `PlayerBlockTouch`, `PlayerCareerHighlights`, `PlayerCountry`, `PlayerCurrentTeam`, `PlayerDateOfBirth`, `PlayerEmail`, `PlayerFavCountries`, `PlayerHeight`, `PlayerID`, `PlayerMobile`, `PlayerNationality`, `PlayerPassword`, `PlayerPhone`, `PlayerPlaceOfBirth`, `PlayerPrimaryPosition`, `PlayerSalary`, `PlayerSecondaryPosition`, `PlayerSex`, `PlayerSpikeTouch`, `PlayerStatus`, `PlayerWeight`, `PlayerWriteUp`, `PPI`, `RegisteredOn`, `VideoID1`, `VideoID2`, `VideoID3`, `VideoID4`, `VideoURL1`, `VideoURL2`, `VideoURL3`, `VideoURL4`, `Whatsapp`, `AccompaniedBy`) VALUES ('$PlayerFirstName','$PlayerLastName','$PlayerFullName','$Agency','$CurrentNumber','$EditedBy','$FacebookCode','$FBNumericID','$HaveEUPassport','$headshot','$HighLightVideo','$HighLightVideoID','$InternalNotes','$IPField','$NameOnPassport','$PassportExpires','$PassportNumber','$PersonEvaluating','$PlayerAddress',$PlayerBlockTouch,'$PlayerCareerHighlights','$PlayerCountry','$PlayerCurrentTeam','$PlayerDateOfBirth','$PlayerEmail','$PlayerFavCountries',$PlayerHeight,'$PlayerID','$PlayerMobile','$PlayerNationality','$PlayerPassword','$PlayerPhone','$PlayerPlaceOfBirth','$PlayerPrimaryPosition','$PlayerSalary','$PlayerSecondaryPosition','$PlayerSex',$PlayerSpikeTouch,'$PlayerStatus',$PlayerWeight,'$PlayerWriteUp',$PPI,'$RegisteredOn','$VideoID1','$VideoID2','$VideoID3','$VideoID4','$VideoURL1','$VideoURL2','$VideoURL3','$VideoURL4','$Whatsapp','$AccompaniedBy')");
echo mysql_errno($result) . ": " . mysql_error($result). "\n";
?>
<html>
<head>
</head>
<body>
<br>The Following information has been added to the database:
<br>Player: <?php echo $PlayerFirstName; ?> <?php echo $PlayerLastName; ?>
</body>
<html>
There is no actual error message.Did you mean: No error message that visibly displays to you when you‘re entering text? Or the site's php error log (php_error.log, unless you've renamed it) shows nothing for the relevant time period? This frankly surprises me, as my impression was that if you so much as look at the monitor cross-eyed, the php log will find something to complain about.
an apostrophe in the original text that caused everything to fail. The word Okanagan's in the second example screwed everything up. Not sure how to fix itI think bhukkel gave you the solution:
You must use the escape
I think bhukkel gave you the solution:
You must use the escape
you must use mysqli_escape_string each time you insert string into a MySQL database.
$PlayerWriteUp = $_POST['PlayerWriteUp']; $PlayerWriteUp = mysql_real_escape_string($_POST['PlayerWriteUp']);
