people

[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

[insert_php]
$st_id=$result->stp_idx;
if($result0->fondr_bl ==1){
echo “

“;
if($result->pepl_born!=’0000-00-00′){
echo “

“;
}

if($result->pepl_gndr!=’0′){
echo “

“;
}

if(!empty($result->pepl_locatn)){
echo “

“;
}

if(!empty($result->pepl_facebk)||!empty($result->pepl_twit)||!empty($result->pepl_linkd)){
echo “

“;
}//result8T for
echo “

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 “

“.$format_date.”

“;
}
$title = str_replace(‘$’, “$ “, $result_2->news_title);
echo ‘