Hive Global Leaders Program August 2015

get_results( “SELECT * FROM hive_production.person LEFT JOIN hive_production.program_person ON (person.id = program_person.person_id) WHERE program_id=’5′ AND type=’participant’ ORDER BY fname ASC”, 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);

echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo ““;
echo “
“;
echo “

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

“;
echo “

{$html[‘organization’]}

“;
echo “

{$html[’email’]}

“;
echo “

{$html[‘bio’]}

“;
echo “

“;
}

?>