php_hana
<pre><code>&lt;?php
header(&quot;Content-type: text/html; charset=utf-8&quot;);
putenv('ODBCSYSINI=/etc');
putenv('ODBCINI=/etc/odbc.ini');
$username = &quot;SYSTEM&quot;;
$password = &quot;Apple789&quot;;
try {
$pdo = new PDO(&quot;odbc:HDB&quot;,
&quot;$username&quot;,
&quot;$password&quot;
);
//$pdo-&gt;exec(&quot;set names utf8&quot;);
$pdo-&gt;query(&quot;set names utf8&quot;);
//$pdo-&gt;prepare(&quot;set names utf8&quot;);
//$pdo-&gt;execute();
} catch (PDOException $exception) {
//echo 'error_222';
echo $exception-&gt;getMessage();
exit();
}
print(&quot;-------------- &quot;);
//$sth = $pdo-&gt;prepare(&quot;select n_id,d_id,colorid,colorname from MTEST.COLORTBL&quot;);
//$sth = $pdo-&gt;prepare(&quot;select n_id,d_id,colorid from MTEST.COLORTBL&quot;);
$sth = $pdo-&gt;prepare(&quot;
select c1.companyname as parent
,(case when m.companyid=a.arguname then '直营' else c2.companyname end) as company
,m.gfrom as shopid
,s.shopname
,(case s.n_sangc when 1 then '街铺' when 2 then '商场' when 3 then '商超'
when 4 then '网店' when 5 then '虚拟' else '' end) as leib
,(case s.c_yous when '1' then '直营' when '2' then '联营'
when '0' then '加盟' else '' end) as xinz
,v.c_vipkh as vipkh
,r.c_mingc as viplb
,m.scripno
,substring(m.iodate,1,6) as iomonth
,m.iodate
,d.code
,sp.codename
,sp.c_specialbh as c_spec
,pp.c_pinpmc as pinp
,xl.c_xilmc as xil
,ks.c_kuansmc as kuans
,nf.c_nianfmc as nianf
,jj.c_jijmc as jijie
,d.colorid
,c.colorname
,coalesce(sp.c_sejsxm,'') as cz
,coalesce(sp.item24,'') as jgd
,d.amount as qty
,d.price
,d.sale as amt
,d.rebate*10 as rebate
,d.orgprice
,d.amount*d.orgprice as orgamt
from MTEST.g_inouttbl_zmd m
join MTEST.g_iodetail_zmd d on m.scripno=d.scripno
left join MTEST.s_shopid s on m.gfrom=s.shopid
left join MTEST.s_argutbl a on m.companyid=a.companyid and a.arguid='parentid'
left join MTEST.s_company c1 on a.arguname=c1.companyid
left join MTEST.s_company c2 on m.companyid=c2.companyid
left join MTEST.g_vip v on m.vipno=v.c_vipbh
left join MTEST.r_vipcard r on v.n_leix=r.n_leix
left join MTEST.g_spdm sp on d.code=sp.code
left join MTEST.r_pinp pp on sp.c_pinpbh=pp.c_pinpbh
left join MTEST.r_xilie xl on sp.c_xilbh=xl.c_xilbh
left join MTEST.r_kuans ks on sp.c_kuansbh=ks.c_kuansbh
left join MTEST.r_nianf nf on sp.c_nianfbh=nf.c_nianfbh
left join MTEST.r_jijie jj on sp.c_jijbh=jj.c_jijbh
left join MTEST.colortbl c on d.colorid=c.colorid
where m.iodate&gt;='20171001' and m.iodate&lt;='20171220'
and coalesce(m.c_zuangtm,'') not in ('BC','CD')
order by parent,company,shopid,scripno,code
limit 1000 offset 0;
&quot;);
$sth-&gt;execute();
$result = [];
while($r = $sth-&gt;fetch(PDO::FETCH_NUM)){
$result[]= $r;
}
//var_dump($result);
echo &quot;&lt;table border='1'&gt;&quot;;
foreach($result as $k =&gt; $v){
echo '&lt;tr&gt;';
foreach($v as $key =&gt; $value){
echo '&lt;td&gt;';
//echo $k.' =&gt; '.$value . '&lt;/br&gt;';
echo $value;
echo '&lt;/td&gt;';
}
echo '&lt;/tr&gt;';
}
echo &quot;&lt;/table&gt;&quot;;
</code></pre>