This simple query when run in DBExplorer (a DB tool for executing raw SQL queries), returns 5 rows (contents of an invoice). Everything is setup in such a way that an invoice may contain multiple goods of the same ID (but with different prices and procurement prices, printing names – e.g. bucket-white, bucket-blue, bucket-red, etc). Each of the items gets
Tag: odbc
Call to undefined function odbc_connect via command line (cmd) PHP5
I’m using PHP 5, Windows (IIS), and when i try access the file from command line, i get the following error (via browser, everything works great): Fatal error: Uncaught Error: Call to undefined …
Should one use FreeTDS driver instead of MS SQL Driver for compatibility between older PHP and newer SQL Servers?
I was struggling to connect my Drupal (7.43) application (hosted on a PHP 5.4 server) to a Microsoft Azure SQL database. I got really depressed and even found myself arguing with my company’s DBA for …
illegal string offset in php array with odbc/db2 query
I’m running this function which is selecting data and I”m having it thrown into another function for inserting but upon errors and doing a var_dump of my results (which successfully dumped an array) I’…
fetchall returns stdClass object in laravel
I’m executing a query to a db2 ibm database in Laravel. call STOREDPROC.GET(‘leaders’, ‘{“params”: “”}’, ‘lead_management’, ‘FR’); The problem is that the fetchAll() returns an array of stdClass …
Create a DSN for the function odbc_connect for Oracle
The information I have concerning the Oracle database O need to connect to using PHP through EasyPHP is the following: user, password, host, port, service. I’m new to ODBC. I tried to use the function odbc_connect, but I keep getting errors simply because I don’t know how to make a DSN. I tried using this: But I don’t know what
Passing an operator as a parameter to odbc_execute()
I am taking my first tentative steps into prepared statements (and falling flat on my face). Previously, I built the following from $_GET and echoed it back – the code was working fine and it returned what I expected from my simple test database. and when I try to code it using a prepared statement, even if I don’t use