PHP rocks on SAP HANA too!

<?php

$conn = odbc_connect(“HANA_KT_SYS”,”SYSTEM”,”manager”, SQL_CUR_USE_ODBC);

if (!($conn)) {

          echo “<p>Connection to DB via ODBC failed: “;

          echo odbc_errormsg ($conn );

          echo “</p>\n”;

}

else{

          if(isset($_POST[“CARRID”]) == false)

          {

                    $sql = “SELECT CARRID, CARRNAME FROM SFLIGHT.SCARR WHERE MANDT = 300”;

                    $rs = odbc_exec($conn,$sql);

                    print(“<DIV ALIGN=’CENTER’>”);

                    print(“<H1>SAP HANA from PHP</H1>”);

                    print(“<FORM NAME=’Get_Data’ ACTION=’$_SERVER[PHP_SELF]’ METHOD=’POST’>”);

                    print(“<SELECT NAME=’CARRID’>”);

                    while($row = odbc_fetch_array($rs)){

       $carrid = $row[“CARRID”];

       $carrname = $row[“CARRNAME”];

       print(“<OPTION VALUE=’$carrid’>$carrname”);

                    }

              print(“</SELECT>”);

    print(“<INPUT TYPE=’SUBMIT’ VALUE=’Get Data’>”);

    print(“</FORM>”);

    print(“</DIV>”);

          }

          else{

                    $carrid_param = $_POST[“CARRID”];

                    $sql = “SELECT * FROM \”_SYS_BIC\”.\”blag/AV_FLIGHTS\”

             WHERE CARRID = ‘$carrid_param'”;

                    $rs = odbc_exec($conn,$sql);

                    print(“<DIV ALIGN=’CENTER’><TABLE BORDER=1>”);

                    print(“<TR><TH>MANDT</TH><TH>CARRID</TH><TH>CONNID</TH>

                   <TH>COUNTRYFR</TH><TH>CITYFROM</TH>

                   <TH>AIRPFROM</TH><TH>COUNTRYTO</TH>

                   <TH>CARRNAME</TH><TH>DISTANCE</TH></TR>”);

                    while($row = odbc_fetch_array($rs)){

       $mandt = $row[“MANDT”];

       $carrid = $row[“CARRID”];

       $connid = $row[“CONNID”];

       $countryfr = $row[“COUNTRYFR”];

       $cityfrom = $row[“CITYFROM”];

       $airpfrom = $row[“AIRPFROM”];

       $countryto = $row[“COUNTRYTO”];

       $carrname = $row[“CARRNAME”];

       $distance = $row[“DISTANCE”];

       print(“<TR><TD>$mandt</TD><TD>$carrid</TD>

               <TD>$connid</TD><TD>$countryfr</TD>

               <TD>$cityfrom</TD><TD>$airpfrom</TD>

               <TD>$countryto</TD><TD>$carrname</TD>

               <TD>$distance</TD></TR>”);

                    }

                    print(“</TABLE>”);

                    print(“<A HREF=’PHP_SAPHANA.php’>Go Back</A></DIV>”);

          }

}

?>