Recommend this page to a friend! |
![]() ![]() |
Info | ![]() |
![]() |
![]() |
![]() ![]() |
Reputation | Support forum (9) | Blog | Links |
Ratings | Unique User Downloads | Download Rankings | ||||
![]() ![]() ![]() ![]() | Total: 2,200 | All time: 1,769 This week: 347![]() |
Version | License | PHP version | Categories | |||
mysqli-extended 4.0.1 | BSD License | 5.3.0 | PHP 5, Databases, Cache |
Description | Author | ||||||||
This package implements a MySQL database access wrapper using the MySQLi extension. Recommendations What is the best PHP mysqli class? Best Package to Address SQL Injection Vulnerabilities |
|
This class is made by unreal4u (Camilo Sperberg). http://unreal4u.com/. However, the initial idea isn't mine, so I would like to thank Mertol Kasanan, this class is based on his work. See http://www.phpclasses.org/browse/package/5191.html for details.
This package implements a MySQL database access wrapper using the MySQLi extension.
There is class that manages MySQL database access connections so only one connection is established during the same PHP script execution.
Another class implements other database access functions like executing queries with prepared queries, measuring the time the queries take to execute and the memory usage, retrieving query results into arrays, the number of result rows, last inserted record identifier and log executed queries to a valid XML log file or directly into your page.
If the query takes just too long, you can cache the query result into an XML file, and you can also handle errors.
This package has been extensivily tested with xDebug, APC and Suhosin so that no errors are present.
<pre>include('src/unreal4u/config.php'); // Please see below for explanation include('src/unreal4u/dbmysqli.php'); $dbLink = new unreal4u\dbmysqli(); $id_user = 23; $username = 'unreal4u'; $aResult = $dbLink->query('SELECT id,username FROM users WHERE id = ? AND username = ?',$id_user,$username);</pre>
Add this to your composer.json: <pre> { "require": {
"unreal4u/dbmysqli": "@stable"
} } </pre>
Now you can instantiate a new dbmysqli class by executing:
<pre> require('vendor/autoload.php');
$rutverifier = new unreal4u\dbmysqli(); </pre>
Pending --------- * Multiquery support. * Better naming convention to include other RDSMs later on * Convert to PDO (to support :tag type associations)
Screenshots | ||
![]() |
File | Role | Description | ||
---|---|---|---|---|
![]() |
||||
![]() |
||||
![]() ![]() |
Data | Auxiliary data | ||
![]() ![]() |
Doc. | Auxiliary data |
![]() |
/ | documentation |
File | Role | Description |
---|---|---|
![]() ![]() |
Example | Example script |
![]() ![]() |
Example | Example script |
![]() ![]() |
Example | Example script |
![]() ![]() |
Doc. | Documentation |
![]() ![]() |
Example | Example script |
![]() ![]() |
Example | Example script |
![]() |
/ | src | / | unreal4u |
File | Role | Description |
---|---|---|
![]() ![]() |
Aux. | Auxiliary script |
![]() ![]() |
Conf. | Configuration script |
![]() ![]() |
Class | Class source |
Version Control | Unique User Downloads | Download Rankings | |||||||||||||||
73% |
|
|
User Ratings | ||||||||||||||||||||||||||||||
|
Applications that use this package |
Personal home page My (unfinished) personal homepage uses this class |
Looneyfactory.com A client's personal website |
If you know an application of this package, send a message to the author to add a link here.
Related pages |
Live Demo This is a live demo on my test server |
Generated XML Log This is the XML log file auto-generated by the class |
Cache & no-cache Benchmark results A special care was taken with speed. Is caching good or bad? Here the results |
Class on GitHub Class on GitHub |
Pages that reference this package |
Ayuda con "proyecto cms" Lo primero y más importante: tu código es MUY vulnerable a inyecciones SQL, te recomiendo que trabajes con mi class que soluciona eso:... |
Duda son sesiones Duda son sesiones lo más fácil y rápido es crear un campo que se llame id_grupo en la tabla de menú y seleccionas sólo aquellos que le son pertinentes... |
yahoo!! publicaron mi class :D Hoy me levanté y me encontré con la sorpresa de que aprobaron y publicaron mi class en phpclasses.org... |
¿Con escapar los valores basta? ...Recién me di cuenta que cuando hiciste este tema todavía no había publicado mi class xDDDD... |