Hockey Prophets

<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>&nbsp;</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:&nbsp;</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>&nbsp;</p>

<p><strong>&nbsp;</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>&nbsp;</h3>

<h3>Player Notes:&nbsp;</h3>

<p>&nbsp;</p>

<p>

&nbsp;</p>

<p>&nbsp;</p>

<hr style="border: none; height: 4px; background-color: #6578a3; margin: 0 auto 0 0;" />

<h3>&nbsp;</h3>

<h3>Career Stats:</h3>

<p>&nbsp;</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>&nbsp;</p>

</div>