Disclosure: This post may contain affiliate links, meaning I get a commission if you decide to make a purchase through my links, at no cost to you. Please read my disclosure for more info.
Hi Guys, welcome back to Codingofcents. Today we will learn how to connect PHP with SAP Hana database because it’s interesting if we can connect our web application with a database that developed by SAP.
SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. Its primary function as a database server is to store and retrieve data as requested by the applications
Before we continue, make sure you had install SAP Hana Client or you can download from SAP website. Make sure you have an account for login too ✌ ✌ ✌ . So bellow is the example connection and how we select data from database.
As you can see we add CHAR_AS_UTF8=true at the end of connection and it will solve issue that no data fetch when run query. And here the result
Therefore, We can use any programming language to connect to SAP Hana Database that supports driver provided by Hana client installation process done.