Build a PHP app connecting to SAP HANA Express Edition #3205
Description
Tutorial URL: https://developers.sap.com/tutorials/hxe-docstore-04-php-app.html
Step 6: Run the PHP file
I get an error when executing the code. The message is:
"Base table not found;259 invalid table name: Could not find table/view FOOD_COLLECTION in schema SYSTEM".
Here's a screenshot:
PLEASE NOTE: The name of the table in the screenshot is not the one I use, btw. This was just another test of mine to check if the name in the eror would change after adapting the code (to see if I was changing the right file). The name I used for the table is correct: FOOD_COLLECTION.
When executing the previous node.js app, it works. Just not the PHP.
Here's more info (WebIDE):
And the code itself (with the correct password, but commented out):
Anybody knows why this is happening? I have tried:
$sql = 'SELECT "name" FROM food_collection';
$sql = 'SELECT "name" FROM FOOD_COLLECTION';
$sql = "SELECT 'name' FROM FOOD_COLLECTION";