Giovanni Vallati
Position: Defenseman
Height: 6'1
Height (cm): 185
Weight: 184
Weight (kg): 83
Birthdate: 2/21/2000
Current Age: 21
Original Draft Year: 2018
Year Drafted: 2018
Final Age/Production Score: -0.01
Hockey Prophets Draft Ranking: 92
Weighted Draft Ranking: 90
Actual Draft Position: 153
Draft Team: Winnipeg Jets
Current NHL Rightsholder: Winnipeg Jets
Last Hockey Prophets Prospect Ranking: 168
Hockey Prophets Prospect Status: Active
Player Notes:
Career Stats:
<div style="border-style: solid; border-color: #6578a3; padding: 5px 5px 5px 5px; margin: 1px 1px 1px 1px;">
<p><img src="/images/PlayerPage_Header.png" alt="PlayerPage Header" style="display: block; margin-left: auto; margin-right: auto;" /></p>
<hr style="border: none; height: 9px; background-color: #6578a3; margin: 0 auto 0 0;" />
<p> </p>
<h2 style="text-align: center;">Giovanni Vallati</h2>
<hr />
<p style="text-align: center;"></p>
<hr />
<p>
<?php
$player = "Vallati, Giovanni";
$conn = mysqli_connect("localhost", "hockey16", "Bl4ckP00l", "hockey16_ForecastData");
if (!$conn) {die("Connection failed: " . mysqli_connect_error());}
$sql = "Select Position, Height, Height_cm, Weight, Weight_kg, Birthdate FROM PlayerPages_FlatFile WHERE PlayerName = '$player' ";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {while($row = mysqli_fetch_assoc($result))
{echo "<p><strong>Position: </strong>" . $row["Position"]. "</p>";
echo "<p><strong>Height: </strong>" . $row["Height"]. "</p>";
echo "<p><strong>Height (cm): </strong>" . $row["Height_cm"]. "</p>";
echo "<p><strong>Weight: </strong>" . $row["Weight"]. "</p>";
echo "<p><strong>Weight (kg): </strong>" . $row["Weight_kg"]. "</p>";
echo "<p><strong>Birthdate: </strong>" . $row["Birthdate"]. "</p>";
}}
else {echo "The oracles are keeping their peace just now. Please try again later.";}
mysqli_close($conn);
?><strong>Current Age: </strong><?php function age($birthDate){
//date in mm/dd/yyyy format; or it can be in other formats as well
//explode the date to get month, day and year
$birthDate = explode("/", $birthDate);
//get age from date or birthdate
$age = (date("md", date("U", mktime(0, 0, 0, $birthDate[0], $birthDate[1], $birthDate[2]))) > date("md")
? ((date("Y") - $birthDate[2]) - 1)
: (date("Y") - $birthDate[2]));
return $age;}?><?php echo age('02/21/2000');?>
</p>
<p> </p>
<p><strong> </strong>
<?php
$player = "Vallati, Giovanni";
$conn = mysqli_connect("localhost", "hockey16", "Bl4ckP00l", "hockey16_ForecastData");
if (!$conn) {die("Connection failed: " . mysqli_connect_error());}
$sql = "Select DraftYear, YearDrafted, AP_Score, HP_DraftRank, DraftRankAvg, DraftPosition, TeamDrafted, NHLRights, rank, ProspectStatus FROM PlayerPages_FlatFile WHERE PlayerName = '$player' ";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {while($row = mysqli_fetch_assoc($result))
{echo "<p><strong>Original Draft Year: </strong>" . $row["DraftYear"]. "</p>";
echo "<p><strong>Year Drafted: </strong>" . $row["YearDrafted"]. "</p>";
echo "<p><strong>Final Age/Production Score: </strong>" . $row["AP_Score"]. "</p>";
echo "<p><strong>Hockey Prophets Draft Ranking: </strong>" . $row["HP_DraftRank"]. "</p>";
echo "<p><strong>Weighted Draft Ranking: </strong>" . $row["DraftRankAvg"]. "</p>";
echo "<p><strong>Actual Draft Position: </strong>" . $row["DraftPosition"]. "</p>";
echo "<p><strong>Draft Team: </strong>" . $row["TeamDrafted"]. "</p>";
echo "<p><strong>Current NHL Rightsholder: </strong>" . $row["NHLRights"]. "</p>";
echo "<p><strong>Last Hockey Prophets Prospect Ranking: </strong>" . $row["rank"]. "</p>";
echo "<p><strong>Hockey Prophets Prospect Status: </strong>" . $row["ProspectStatus"]. "</p>";
}}
else {echo " The oracles are keeping their peace just now. Please try again later.";}
mysqli_close($conn);
?></p>
<hr style="border: none; height: 4px; background-color: #6578a3; margin: 0 auto 0 0;" />
<h3> </h3>
<h3>Player Notes: </h3>
<p> </p>
<p>
</p><p> </p>
<hr style="border: none; height: 4px; background-color: #6578a3; margin: 0 auto 0 0;" />
<h3> </h3>
<h3>Career Stats:</h3>
<p> </p>
<p><iframe src="http://www.eliteprospects.com/iframe_player_stats.php?player= 299432" width="100%" height="595" scrolling="yes" frameborder="0" ></iframe></p>
<p> </p>
</div>
You are not authorised to post comments.