Download the PHP package panique/pdo-debug without Composer
On this page you can find all versions of the php package panique/pdo-debug. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package pdo-debug
pdo-debug
Shows the SQL query constructed by PDO. Seriously. The magic behind: A simple function that combines your parameters and the raw query. Please note that this is just an emulation, not the "real" result of PDO, but it does the job for nearly all common daily tasks. Way better than NOTHING!
Features
- one simple global function
debugPDO($sql, $parameters) - works with named parameters (like ':param_1') and question-mark-parameters (like '?')
- this repo also contains a demo .sql file for easily testing the example below
Big thanks to
Taken from here: http://stackoverflow.com/questions/210564/getting-raw-sql-query-string-from-pdo-prepared-statements, big big big thanks to bigwebguy (http://stackoverflow.com/users/168256/bigwebguy) and Mike (http://stackoverflow.com/users/1083889/mike) for creating the debugQuery() function!
How to add to a project
As usual, require this via Composer (require-dev might be more useful as you definitely don't need this in production):
How to use
Your PDO block probably looks like this:
and this, right ?
To use this PDO logger, you'll have to rebuild the param array a little bit: Create an array that has the identifier as the key and the parameter as the value, like below: WARNING: write this WITHOUT the colon! The keys need to be 'xxx', not ':xxx'!
Your full PDO block would then look like:
Now you can debug / log the full SQL statement by using the static method show() of the PdoDebugger class. Make sure
to pass the raw SQL statement and the parameters array that contains proper keys and values. Future releases might have
a more professional way of handling this.
The result of this example will be:
Yeah!
Support the project (and others)
Support the project by renting a server at DigitalOcean or just tipping a coffee at BuyMeACoffee.com. Thanks! :)
