PHP Classes

Easy Mysqli OO: Execute common SQL queries using MySQLi extension

Recommend this page to a friend!
     
  Info   Example   View files Files   Install with Composer Install with Composer   Download Download   Reputation   Support forum   Blog    
Ratings Unique User Downloads Download Rankings
Not enough user ratingsTotal: 205 All time: 8,434 This week: 455Up
Version License PHP version Categories
easy-mysqli 1GNU General Publi...5.0PHP 5, Databases
Description 

Author

Allan Klaus

This class can execute common SQL queries using MySQLi extension.

It can connect to a MySQL database using the MySQLi extension and can execute common queries.

Currently it can SELECT, INSERT, UPDATE and DELETE queries using parameters that define tables, fields, field values, condition clauses, etc..

Picture of Allan Klaus
  Performance   Level  

Level 2 StarStar

 

Recommendations

PDO SQL server connection and execution of stored procedures
want to connect execute sql queries and stored procedures

Example

<?php
require('EasyMysqli.php');
/*
 * DB TEST
 *
DROP TABLE IF EXISTS `tb_users`;
CREATE TABLE IF NOT EXISTS `tb_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `pass` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ;
 *
*/

$db = new Database();

$table = 'tb_users';
//If you want to debug SQL user the debug true
$debug = false;

$arrayInsert['user'] = 'userName';
$arrayInsert['email'] = 'userEmail';
$arrayInsert['pass'] = 'userPass'; // ENCRYPT IT

//Using insert command
$db->insert($table, $arrayInsert, $debug);
//You can omit $debug like this
//$db->insert($table, $arrayInsert);

//Use simple select command
$result = $db->select($table);

//Using select with WHERE
$whereSelect = 'WHERE id = 1';
$result = $db->select($table, $whereSelect);

//Get result by select
$row = $db->feelArray($result);

//Using update command
$arrayWhere['user'] = 'updateUserName';
$arrayWhere['email'] = 'updateUserEmail';
$arrayWhere['pass'] = 'updateUserPass'; // ENCRYPT IT

$arrayWhere['id'] = 1;
$db->update($table, $arrayUpdate, $arrayWhere);

//Using delete command
$arrayDelete['id'] = 1;
$db->insert($table, $arrayDelete);

Details

easymysqli

Ease way to start the use o mysqli


  Files folder image Files (3)  
File Role Description
Plain text file EasyMysqli.php Class Class file to access database with mysqli
Accessible without login Plain text file README.md Data Auxiliary data
Accessible without login Plain text file sampleEasyMysqli.php Example Example how to use the class

The PHP Classes site has supported package installation using the Composer tool since 2013, as you may verify by reading this instructions page.
Install with Composer Install with Composer
Downloadeasy-mysqli-2015-09-24.zip 2KB
Downloadeasy-mysqli-2015-09-24.tar.gz 2KB
Install with ComposerInstall with Composer
 Version Control Unique User Downloads Download Rankings  
 100%
Total:205
This week:0
All time:8,434
This week:455Up
User Comments (1)
Justo look the delete example and the query method.
9 years ago (André Karell Contreras Jimenez)		7%Star
 

  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.