[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 “ ){<br />
echo “<a href=) “;} 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 ‘
Follow us on Instagram @lattice80hub
;<br />
if(!empty($tmp_d) && $result->pepl_dtail!=’ ‘){<br />
echo “<span style='color: red;'><strong>Person Details</strong></span>“;<br />
echo “</p>
<table>“;<br />
echo “</p>
<tr>
<td>“;<br />
echo nl2br($result->pepl_dtail);<br />
echo “</td>
</tr>
<p>“;<br />
echo “</table>
<p>“;<br />
}<br />
[/insert_php]</p>
<p>[insert_php]<br />
//*************************Experience***************************<br />
$sql_his=”select *<br />
from User_his ur<br />
left join sdrtbl_startups st<br />
on st.stp_idx=ur.stp_idx<br />
where ur.pepl_idx=$id order by his_title desc, his_start desc”;<br />
$result_his = $link->get_results($sql_his);<br />
if(!empty($result_his)){<br />
echo “<span style='color: red;'><strong>Experience</strong></span>“;<br />
echo “</p>
<table>“;</p>
<p> foreach ( $result_his as $resulthis ){<br />
echo “</p>
<tr>
<td>“;<br />
echo “<b>“.$resulthis->pepl_role;<br />
echo “</b><br />“;<br />
if(!empty($resulthis->stp_idx)){<br />
echo “<a href='../company/?id=$resulthis->stp_idx’>”;<br />
echo $resulthis->stp_name;<br />
echo “</a>“;<br />
}else{<br />
echo $resulthis->stp_tmp_name;<br />
}<br />
echo “<br />“;<br />
echo $resulthis->his_start;<br />
if(empty($resulthis->his_end)){<br />
echo ” ~ Present”;<br />
}else{<br />
echo ” ~ ” .$resulthis->his_end;<br />
}<br />
echo “</td>
</tr>
<p>“;<br />
}<br />
echo “</table>
<p>“;<br />
}<br />
[/insert_php]</p>
<p>[insert_php]<br />
//*************************Fund Rasied***************************<br />
if($result0->ivstr_bl ==1){<br />
$sql_6=”SELECT iv.stp_idx stp_idx,ivsm_idx, invst_date,stp_name,invst_amnt , value<br />
FROM sdrtbl_investment iv, sdrtbl_startups st,sdrtbl_common cm<br />
WHERE pepl_idx=$id<br />
and st.stp_idx=iv.stp_idx<br />
and cm.category1=iv.invst_categry<br />
and cm.grp=2<br />
order by invst_date DESC”;<br />
$result6 = $link->get_results($sql_6);<br />
if(!empty($result6)){<br />
echo “<span style='color: red;'><strong>Investment</strong></span>“;<br />
echo “</p>
<table>“;<br />
echo “</p>
<tr>“;<br />
echo “</p>
<th width=10%><center>Date</th>
<p>“;<br />
echo “</p>
<th width=20%><center>Invested in</th>
<p>“;<br />
echo “</p>
<th width=30%><center>Round</th>
<p>“;<br />
echo “</p>
<th width=40%><center>Partners</th>
</tr>
<p>“;</p>
<p>foreach ( $result6 as $result_6 ) {<br />
if(substr($result_6->invst_date,0,4) == 0000){<br />
echo “</p>
<tr>
<td>UNKNOWN</td>
<p>“;<br />
}else{<br />
echo “</p>
<tr>
<td>“.substr($result_6->invst_date,0,4).”</td>
<p>“;<br />
}<br />
$stp_idx=$result_6->stp_idx;<br />
echo “</p>
<td><a href='../company?id=$stp_idx' target=_self>“. $result_6->stp_name.”</a></td>
<p>“;<br />
$amt = str_replace(‘$’, “$ “, $result_6->invst_amnt);<br />
echo “</p>
<td>“.$amt.” / “.$result_6->value.”</td>
<p>“;<br />
echo “</p>
<td>“;<br />
$ivsm_id= $result_6->ivsm_idx;</p>
<p> $sql_8T=”select iv.invst_idx, invst_name, 1 grp<br />
from sdrtbl_investment iv , sdrtbl_investor ivr<br />
where ivsm_idx=$ivsm_id<br />
and iv.invst_idx=ivr.invst_idx<br />
union ALL<br />
SELECT pp.pepl_idx invst_idx,pepl_name invst_name, 2 grp<br />
FROM sdrtbl_investment ivm, sdrtbl_people pp<br />
WHERE ivm.pepl_idx=pp.pepl_idx<br />
and ivm.pepl_idx!= $id<br />
and ivm.ivsm_idx=$ivsm_id”;<br />
$result8T = $link->get_results($sql_8T);<br />
if(!empty($result8T)){<br />
$rowt=0;<br />
foreach ( $result8T as $result_8T ) {</p>
<p>if($result_8T->grp == 1){<br />
echo “<a href=../investor?id=){kind=link}