Bios
[insert_php]
echo date(‘l, F j, Y\a\t G:i:s’) . “
“;
$table_name = $wpdb->prefix . “cb_frontend_data_table”;
global $wpdb;
print_r(“
“);
$id=0;
$idSubmit=133;
$session = “”;
//$authors = array();
$author = array(5);
$authors = array();
foreach( $wpdb->get_results(“SELECT * FROM oce2019_cb_frontend_data_table WHERE form_id = 8 AND form_submit_id > $idSubmit ORDER BY form_submit_id”) as $key => $row){
$id++;
$my_column = $row->dynamic_frontend_value;
$firstName = “”;
$lastName = “”;
$bio = “”;
if($row->form_submit_id != $idSubmit){
if(strlen($author[2]) >= 2){
$authors[]=$author;
print_r(“
| $author[3] |
“);
print_r(“
| “.$author[5].” “.$author[0].” “.$author[1].” | ” .$author[4].” |
“);
print_r(“
| “.$author[2].” |
“);
}
$idSubmit=$row->form_submit_id;
$author = array();
}
// FirstName
if($row->dynamic_control_id == 95){
$author[0]=$my_column;
}
//BIO
if($row->dynamic_control_id == 99){
$author[2]=$my_column;
$bio = $my_column;
}
// LastName
if($row->dynamic_control_id == 101){
$author[1]=$my_column;
}
// Session
if($row->dynamic_control_id == 88){
$author[3]=$my_column;
}
// Affiliation
if($row->dynamic_control_id == 96){
$author[4]=$my_column;
}
// Tittle
if($row->dynamic_control_id == 100){
$author[5]=$my_column;
}
}
$authors[]=$author;
// Print last author
print_r(“
| $author[3] |
“);
print_r(“
| “.$author[5].” “.$author[0].” “.$author[1].” | ” .$author[4].” |
“);
print_r(“
| “.$author[2].” |
“);
print_r(“
| “.count($authors).” |
“);
print_r(“
“);
[/insert_php]