Hive Global Leaders Program December 2016

get_results( “SELECT * FROM wp_hiveglp.hive_alumni WHERE class=’dec2016′ ORDER BY fname”, ARRAY_A );

foreach ($participants as $participant) {

//this makes sure there are not html injection issues, and it fixes all of the special characters
$html = array_map(function ($e) { return htmlentities($e, ENT_NOQUOTES, ‘UTF-8’);}, $participant);

$city = $html[‘city’];
$state = $html[‘state’];
$country = $html[‘country’];
$title = $html[‘title’];
$organization = $html[‘organization’];

echo “

“;
echo “

{$html[‘fname’]} {$html[‘lname’]}

“;

if ($title != ” && $organization != ”){
echo “

{$html[‘title’]}, {$html[‘organization’]}

“;
} else if ($title != ” && $organization == ”){
echo “

{$html[‘title’]}

“;
} else if ($title == ” && $organization != ”){
echo “

{$html[‘organization’]}

“;
}

if ($state != ” && $country == ‘United States’){
echo “

” . $city . “, ” . $state . “, ” . $country . “

“;
} else {
echo “

” . $city . “, ” . $country . “

“;
}
echo “

{$html[’email’]}

“;
echo “

{$html[‘bio’]}

“;
echo “

“;
}