World

[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 */

$link = new wpdb(“latticee_db_read”, “t3w#LnC=e4XH”, “latticee_startups_db”, “localhost”);
$sql1 = ” select * from sdrtbl_common where grp=5 and category1=0 and category2=1″;
$stp = $link->get_row($sql1);
$cnt=$stp->value;
echo $cnt;
[/insert_php]

Average Valuation

[insert_php]
$sql1 = ” select * from sdrtbl_common where grp=5 and category1=0 and category2=2″;
$stp = $link->get_row($sql1);
$cnt=$stp->value;
echo $cnt;
[/insert_php]

GDP per capita

[insert_php]
$sql1 = ” select * from sdrtbl_common where grp=5 and category1=0 and category2=3″;
$stp = $link->get_row($sql1);
$cnt=$stp->value;
echo $cnt;
[/insert_php]

GDP

[insert_php]
$sql1 = ” select count(*) cnt from sdrtbl_startups”;
$stp = $link->get_row($sql1);
$cnt=$stp->cnt;
echo $cnt;
[/insert_php]

Total no. of Start-ups

[insert_php]
$sql1 = ” select * from sdrtbl_common where grp=5 and category1=0 and category2=5″;
$stp = $link->get_row($sql1);
$cnt=$stp->value;
echo $cnt;
[/insert_php]

Female/Male
Entrepreneur Ratio

About


[insert_php]
$sql1 = ” select * from sdrtbl_common where grp=6 and category1=0″;
$stp = $link->get_row($sql1);
$cnt=$stp->value;
echo $cnt;
[/insert_php]

 

NEWS

[insert_php]

$sql4=”SELECT * FROM sdrtbl_news order by news_date desc limit 5″;
$news = $link->get_results($sql4);

foreach ( $news as $new )
{
$title = str_replace(‘$’, “$ “, $new->news_title);
if($new->news_grp ==’1′){
$st_id=$new->stp_idx;
$sql4_D=”select * from sdrtbl_startups where stp_idx=$st_id”;
$logo = $link->get_row($sql4_D);
echo “

“;
}else if($new->news_grp ==’2′){
$pp_id=$new->pepl_idx;
$sql4_D=”select * from sdrtbl_people where pepl_idx=$pp_id”;
$logo = $link->get_row($sql4_D);
echo “

“;

}else if($new->news_grp ==’3′){
$iv_id=$new->invst_idx;
$sql4_D=”select * from sdrtbl_investor where invst_idx=$iv_id”;
$logo = $link->get_row($sql4_D);
echo “

“;
}else{
echo “

“;
echo ““;
if(empty( $logo->stp_logo)){
echo ““;
}else{
echo “news_link.'”target=_blank>’.$title.’
‘;
echo “
“;
if(empty($logo->pepl_pic)){
echo ““;
}else{
echo “news_link.'”target=_blank>’.$title.’‘;
echo “
“;
if(empty($logo->invst_logo)){
echo ““;
}else{
echo “news_link.'”target=_blank>’.$title.’‘;
echo “
“;
echo $new->news_pblsh.’ –Interactive World Map

[insert_php]
$sql9 = ” SELECT * FROM country_rank order by sm desc limit 10″;
$results9 = $link->get_results($sql9);
$datas=”[‘Country’,’Startups’,’county_idx’]”;
foreach ( $results9 as $result9 )
{
$datas.=”,[‘”.$result9->value.”‘,”.$result9->cnt.”,”.$result9->stp_cntry.”]”;

}
[/insert_php]

[geoChart displaymode=”markers” width=”700px” height=”388px” colorstart=”#4db2ec” colorend=”#10a69f” ]
[insert_php]
echo $datas;
[/insert_php]
[/geoChart]

 

CATEGORIES

[insert_php]
$sql2=”SELECT cm.category1 ct1, cm.category2 ct2, cm.value vlu, count(*) cnt
FROM sdrtbl_category ct ,sdrtbl_common cm
WHERE ct.grp=cm.grp
and ct.category1=cm.category1
and ct.category2=cm.category2
and ct.grp=1 group by ct.category1, ct.category2
order by cnt desc LIMIT 10″;

$categories = $link->get_results($sql2);
$i=1;
foreach ( $categories as $category )
{
echo “

“;
$i++;
}
[/insert_php]

“.$i.” “;
echo “ct1.”&ct2=”.$category->ct2.”>”.$category->vlu.”(“.$category->cnt.”)

TOP COMPANIES

[insert_php]
$sql3=”SELECT stp_idx, stp_name
from sdrtbl_startups
where stp_point!=0
order by stp_rank
limit 10″;
$companies = $link->get_results($sql3);
$i=1;
foreach ( $companies as $company )
{
echo “

“;
$i++;
}
[/insert_php]

“.$i.” “;
echo “stp_idx.”>”.$company->stp_name.”


TOP COUNTRIES

[insert_php]
$sql7=”SELECT * FROM country_rank order by sm desc limit 10″;
$countries = $link->get_results($sql7);
$i=1;
foreach ( $countries as $country )
{
echo “

“;
$i++;
}
[/insert_php]

“.$i.” “;
echo “stp_cntry.”>”.$country->value.”(“.$country->cnt.”)


TOP INVESTORS

[insert_php]
$sql5=”SELECT ivt.invst_idx iv_idx, invst_name, count(*) cnt
FROM sdrtbl_investment ivm, sdrtbl_investor ivt
where ivm.invst_idx=ivt.invst_idx
and ivt.invst_idx!=16
group by ivt.invst_idx
order by cnt desc ,invst_name
limit 10″;
$investors = $link->get_results($sql5);
$i=1;
foreach ( $investors as $investor )
{
echo “

“;
$i++;
}
[/insert_php]

“.$i.” “;
echo “iv_idx.”>”.$investor->invst_name.”