Download the PHP package sergeytsalkov/meekrodb without Composer
On this page you can find all versions of the php package sergeytsalkov/meekrodb. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download sergeytsalkov/meekrodb
More information about sergeytsalkov/meekrodb
Files in sergeytsalkov/meekrodb
Package meekrodb
Short Description The Simple PHP/MySQL Library
License LGPL-3.0
Homepage http://www.meekro.com
Informations about the package meekrodb
MeekroDB -- The Simple PHP MySQL Library
Learn more: http://www.meekro.com
MeekroDB is:
- A PHP MySQL library that lets you get more done with fewer lines of code, and makes SQL injection 100% impossible.
- Google's #1 search result for "php mysql library" since 2013, with thousands of deployments worldwide.
- A library with a perfect security track record. No bugs relating to security or SQL injection have ever been discovered.
- Backwards and forwards-compatible, supporting all PHP versions from PHP 5.6 all the way through the latest release of PHP 8.
Installation
When you're ready to get started, see the Quick Start Guide on our website.
Manual Setup
Include the db.class.php
file into your project and set it up like this:
Composer
Add this to your composer.json
Code Examples
Grab some rows from the database and print out a field from each row.
Insert a new row.
Grab one row or field
Use a list in a query
Log all queries and errors
Nested Transactions
Lots More - See: http://meekro.com/docs
How is MeekroDB better than PDO?
Optional Static Class Mode
Most web apps will only ever talk to one database. This means that passing $db objects to every function of your code just adds unnecessary clutter. The simplest approach is to use static methods such as DB::query(), and that's how MeekroDB works. Still, if you need database objects, MeekroDB can do that too.
Do more with fewer lines of code
The code below escapes your parameters for safety, runs the query, and grabs the first row of results. Try doing that in one line with PDO.
Or how about just one field?
Work with list parameters easily
Using MySQL's IN keyword should not be hard. MeekroDB smooths out the syntax for you, PDO does not.
Simple inserts
Using MySQL's INSERT should not be more complicated than passing in an associative array. MeekroDB also simplifies many related commands, including the useful and bizarre INSERT .. ON DUPLICATE UPDATE command. PDO does none of this.
Nested transactions
MySQL's SAVEPOINT commands lets you create nested transactions, but only if you keep track of SAVEPOINT ids yourself. MeekroDB does this for you, so you can have nested transactions with no complexity or learning curve.
Flexible debug logging and error handling
You can log all queries (and any errors they produce) to a file for debugging purposes. You can also add hooks that let you run your own functions at any point in the query handling process.
My Other Projects
A little shameless self-promotion!
- Ark Server Hosting -- Ark: Survival Evolved server hosting by ArkServers.io!
- brooce - Language-agnostic job queue written in Go! Write your jobs in any language, schedule them from any language, run them anywhere!
All versions of meekrodb with dependencies
ext-pdo Version *