{"repo":"Vasiliy-Makogon/PHP-MySQL-Class","free":true,"listed":false,"github":"https://github.com/Vasiliy-Makogon/PHP-MySQL-Class","clone":"git clone https://github.com/Vasiliy-Makogon/PHP-MySQL-Class.git","description":"PHP class library for simple, convenient, fast and safe work with MySql database, using PHP mysqli extension and imitation of prepared queries.","language":"PHP","stars":39,"topics":["mysql","php","sql","database","mysql-database","mysql-wrapper","prepared-statements","preparedstatement","class-mysql","mysqli"],"license":null,"category":"databases-storage","readme_excerpt":"Other languages: - Русская документация - Documentation française - Deutsche Dokumentation - Documentazione italiana - 日本語ドキュメント - Documentación en español - 한국어 문서 - 简体中文文档 - 繁體中文文件 - Dokumentasi Bahasa Indonesia - Documentação em Português (BR) - हिंदी दस्तावेज़ - التوثيق بالعربية - Türkçe Dokümantasyon - Tài liệu tiếng Việt --- Getting the Library You can download it as an archive, clone it from this site, or install via composer (packagist.org link): What is krugozor/database ? krugozor/database is a PHP = 8.0 class library for simple, convenient, fast, and secure work with MySQL databases, using the PHP extension mysqli. Why do you need a custom class for MySQL when PHP already has PDO abstraction and the mysqli extension? The main drawbacks of all libraries for working with MySQL in PHP are: Verbosity To prevent SQL injections, developers have two options: Use prepared statements. Manually escape parameters going into the SQL query body. Pass string parameters through mysqli real escape string, and cast expected numeric parameters to the appropriate types — int and float . Both approaches have significant drawbacks: Prepared statements are terribly verbose. Using PDO abstraction or the mysqli extension \"out of the box\", without aggregating all methods for retrieving data from the DBMS, is simply impossible — to get a value from a table you need to write at least 5 lines of code! And that's for every single query! Manual escaping of parameters going into the SQL query bo","default_branch":null,"files":null,"tree":[],"storefront":"/r/Vasiliy-Makogon","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Vasiliy-Makogon/PHP-MySQL-Class/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}