kuvardin / fast-mysqli
There is no license information available for the latest version (1.0.0) of this package.
Simple PHP class for working with MySQL
1.0.0
2019-04-08 05:29 UTC
Requires
- php: >=7.0
This package is auto-updated.
Last update: 2024-11-04 21:58:13 UTC
README
Simple PHP library for working with MySQL
Installing
composer require "kuvardin/fast-mysqli: dev-master"
Using example
<?php use Kuvardin\FastMysqli\Mysqli; require 'vendor/autoload.php'; $db = [ 'host' => 'localhost', 'user' => 'kuvardin', 'pass' => 'qwerty', 'name' => 'testbase', ]; // Connect to MySQL server $mysqli = new Mysqli($db['host'], $db['user'], $db['pass'], $db['name']); // Query $filtered_name = $mysqli->filter($_GET['name']); $mysqli->q("DELETE FROM `users` WHERE `name` = '$filtered_name' LIMIT 1"); // Simple select // SELECT * FROM `users` WHERE `name` = '{$this->filter($_GET['name'])}' AND `surname` IS NOT NULL LIMIT 1 $user = $mysqli->fast_select('users', [ 'name' => $_GET['name'], 'surname' => Mysqli::not_null(), ], 1); // Adding a new row // INSERT INTO `users` SET `name` = 'Maxim', `surname` = 'Kuvardin' $mysqli->fast_add('users', [ 'name' => 'Maxim', 'surname' => 'Kuvardin', ]); // Updating rows // UPDATE `users` SET `name` = 'Jonathan' WHERE `name` = 'John' LIMIT 1 $mysqli->fast_update('users', ['name' => 'Jonathan'], ['name' => 'John'], 1); // Checking row if ($mysqli->fast_check('users', ['name' => 'Jonathan'])) { echo 'Row are exists'; } // Deleting rows // DELETE FROM `users` WHERE `banned` IS NOT NULL LIMIT 3 $mysqli->fast_delete('users', ['banned' => Mysqli::not_null()], 3);