investor

[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”);

$sql = “SELECT * FROM sdrtbl_investor WHERE invst_idx =$id”;

$sql_2 = “SELECT * FROM sdrtbl_invst_prgrm WHERE invst_idx=$id”;

$sql_3 = “SELECT * FROM sdrtbl_news WHERE news_grp=3 and invst_idx=$id order by news_date DESC limit 5”;

$sql_4 = “SELECT * FROM sdrtbl_news WHERE news_grp=3 and invst_idx=$id order by news_date DESC”;

$sql_5 = “SELECT * FROM sdrtbl_people WHERE invst_idx=$id order by pepl_idx”;

$sql_6 = “SELECT iv.stp_idx stp_idx,ivsm_idx, invst_date,stp_name,invst_amnt , value
FROM sdrtbl_investment iv, sdrtbl_startups st,sdrtbl_common cm
WHERE invst_idx=$id
and st.stp_idx=iv.stp_idx
and cm.category1=iv.invst_categry
and cm.grp=2
order by invst_date DESC”;
$sql_7= “select count(*) Icount FROM sdrtbl_investment where invst_idx=$id group by stp_idx”;
$result = $link->get_row($sql);

$name=$result->invst_name;
echo “

“.$name.”

“;
$logo=$result->invst_logo;
if(!empty($logo)){
echo ““;
}else{
echo ““;
}
[/insert_php]

Overview

[insert_php]
$result7 = $link->get_results($sql_7);
if(!empty($result7)){
$icount=0;
$ccount=count($result7);
foreach ( $result7 as $result_7 ) {
$icount =$icount+ $result_7->Icount;
}
if($icount > 0){
echo “

“;
}
}
$result5 = $link->get_row($sql_5);
if(!empty($result5)){
echo “

“;
}

if(!empty($result->invst_cntry)&&($result->invst_cntry!=0)){
echo “

“;

}

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

“;
}
echo “

“;
echo “Investments
“;
echo $icount.” Investments in “.$ccount.” Companies”;
echo “
“;
echo “Founder
“;
echo $result5->pepl_name;
echo “
“;
echo “Headquarters
“;
if(!empty($result->invst_city)){
echo $result->invst_city.”, “;
}
if(!empty($result->invst_state)){
echo $result->invst_state.”, “;
}

$cnty=$result->invst_cntry;
$sql_9 = “select *
from sdrtbl_common cm
WHERE category1 = $cnty
and grp=4”;
$result9 = $link->get_row($sql_9);
echo $result9->value;
echo “

“;
echo “Website
“;
echo “invst_facebk.” target=’_blank’> “;
}
if(!empty($result->invst_twit)){
echo “invst_linkd.” target=’_blank’> “;
}
echo “

“;
$tmp_d=$result->invst_dscrpt;
preg_replace(“/\s+/”, “”, $tmp_d);
if(!empty($result->invst_emply)||!empty($tmp_d)||!empty($result->invst_email)||($result->invst_fnded!=’0000-00-00’&&!empty($result->invst_fnded))){
echo “Investor Details“;
echo “

“;
if($result->invst_fnded!=’0000-00-00’&&!empty($result->invst_fnded)){
echo “

“;
}
if(!empty($result->invst_email)){
echo “

“;
}
if(!empty($result->invst_emply)){
echo “

“;
}

if(!empty($tmp_d)){
echo “

“;
}
}
echo “

“;
echo “Founded
“;
echo substr($result->invst_fnded,0,4);
echo “
“;
echo “Email
“;
echo $result->invst_email;
echo “
“;
echo “Employees
“;
echo $result->invst_emply;
echo “
“;
echo “Description
“;
echo nl2br($result->invst_dscrpt);
echo “

“;

$result6 = $link->get_results($sql_6);
if(!empty($result6)){
echo “Investment“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
foreach ( $result6 as $result_6 ) {
if(substr($result_6->invst_date,0,4) == 0000){
echo “

“;
}else{
echo “

“;
}
$stp_idx=$result_6->stp_idx;
echo “

“;
$amt = str_replace(‘$’, “$ “, $result_6->invst_amnt);
echo “

“;
echo “

“;
}
}

[/insert_php]

Date
Invested in
Round
Partners
UNKNOWN
“.substr($result_6->invst_date,0,4).” “. $result_6->stp_name.” “.$amt.” / “.$result_6->value.” “;
$ivsm_id= $result_6->ivsm_idx;

$sql_8T=”select iv.invst_idx, invst_name, 1 grp
from sdrtbl_investment iv , sdrtbl_investor ivr
where ivsm_idx=$ivsm_id
and iv.invst_idx!= $id
and iv.invst_idx=ivr.invst_idx
union ALL
SELECT pp.pepl_idx invst_idx,pepl_name invst_name, 2 grp
FROM sdrtbl_investment ivm, sdrtbl_people pp
WHERE ivm.pepl_idx=pp.pepl_idx
and ivm.ivsm_idx=$ivsm_id”;
$result8T = $link->get_results($sql_8T);
if(!empty($result8T)){
$rowt=0;
foreach ( $result8T as $result_8T ) {

if($result_8T->grp == 1){
echo “invst_idx.”>”.$result_8T->invst_name .”“;}
else{
echo “invst_idx.”>”.$result_8T->invst_name .”“;
}
$rowt++;
if(count($result8T)>$rowt){ echo “, “;}
}
}else{ echo ” – “; }
echo “