[insert_php]
/* LATTICE80 is a Singapore headquartered Fintech Hub */
/* For more information, Visit ‘lattice80.com’ now!*/
/* Always welcome */
/* lattice80.com */
/* LATTICE80 is a Singapore headquartered Fintech Hub */
/* For more information, Visit ‘lattice80.com’ now!*/
/* Always welcome */
/* lattice80.com */
$id = $_GET[‘id’];
$link = new wpdb(“latticee_db_read”, “t3w#LnC=e4XH”, “latticee_startups_db”, “localhost”);
$sql0 =”SELECT * FROM sdrtbl_people WHERE pepl_idx=$id”;
$result0 = $link->get_row($sql0);
$sql=””;
if($result0->fondr_bl ==1){
$sql = “SELECT pp.pepl_idx pepl_idx, pp.pepl_name pepl_name, pp.stp_idx stp_idx, pp.pepl_role pepl_role,
pp.pepl_born pepl_born, pp.pepl_gndr pepl_gndr, pp.pepl_locatn pepl_locatn,
pp.pepl_facebk, pp.pepl_twit, pp.pepl_linkd, pp.pepl_dtail pepl_dtail,
pp.pepl_pic pepl_pic, st.stp_name stp_name
FROM sdrtbl_people pp, sdrtbl_startups st
WHERE pepl_idx=$id and st.stp_idx=pp.stp_idx”;
}
else{
$sql =”SELECT * FROM sdrtbl_people WHERE pepl_idx=$id”;
}
$sql_2 = “SELECT * FROM sdrtbl_news WHERE news_grp=2 and pepl_idx=$id order by news_date DESC limit 5”;
$result = $link->get_row($sql);
$name=$result->pepl_name;
echo “
“.$name.”
“;
$pic=$result->pepl_pic;
if(!empty($pic)){
echo ““;
}else{
echo ““;
}
[/insert_php]
Overview
Primary Role | “; if(!empty($result->pepl_role)){ echo $result->pepl_role. “@” .$result->stp_name.”“; }else{ echo “Member @” .$result->stp_name.”“; } } if($result0->ivstr_bl ==1){ echo “ |
Investment Section | Investor”; } echo “ |
“; echo “Born“; echo “ |
“; echo $result->pepl_born; echo “ |
“; echo “Gender“; echo “ |
“; if($result->pepl_gndr==1){ echo “Male”; }else if($result->pepl_gndr==2){echo “Female”; } echo “ |
“; echo “Nationality“; echo “ |
“; $nation=$result->pepl_locatn; $sql_4 = “SELECT * FROM sdrtbl_common WHERE grp=4 and category1=$nation”; $result_4 = $link->get_row($sql_4); echo $result_4->value; echo “ |
“; echo “Social“; echo “ |
“; if(!empty($result->pepl_facebk)){ echo “pepl_twit.” target=’_blank’>”; echo “ ![]() } if(!empty($result->pepl_linkd)){ echo “invst_idx.”>”.$result_8T->invst_name .”“; }else{ echo “invst_idx.”>”.$result_8T->invst_name .”“; } $rowt++; if(count($result8T)>$rowt){ echo “, “;} } }else{ echo ” – “; } echo “ |
“;
}//result8T empty check
}
[/insert_php]
[insert_php]
//*************************Timeline Activity***************************
$result2 = $link->get_results($sql_2);
if(!empty($result2)){
echo “Timeline Activity“;
$prev_date=1;
foreach ( $result2 as $result_2 ){
$tmp=substr(($result_2->news_date),0,10);
$format_date = date_format(date_create($tmp),”d F Y”);
if($prev_date == $format_date){
}else{
echo “
“;
}
$title = str_replace(‘$’, “$ “, $result_2->news_title);
echo ‘