This is a well customized library for MYSQLi and PHP.

Last update: Jul 29, 2022

prepared

This is a well customized library for MYSQLi and PHP. Helps you in writing your procedural PHP with just few lines of codes. This library have prepared functions that will help you connect your database to your application and as well query your database.

Some functions in prepared are:

  • SETUP: This function is to set up the connection from the appication to the database.

  • CHECK_CONNECTION: This function checks if the connection to database was successful.

  • SANITIZE: This function is for sanitizing your inputs, so as to avoid SQL-INJECTIONS.

  • ALLOW_SAFE_SYMBOLS: This function is for allowing safe symbols.

  • CHECK_INPUT: This function is for sanitizing your inputs, so as to avoid SQL-INJECTIONS.

  • REDIRECT: This function is for easy redirections.

  • ACCESS: This function is for granting access to users.

  • FETCH_ASSOC_QUERY: This function is for fetching data from the database.

  • EXECUTE_QUERY: This function is for executing a SQL statement.

  • VALIDATE_QUERY: This function for validating SQL statements.

  • SELECT_ALL: This function is for SELECTING ALL data in ASCENDING ORDER from the database.

  • SELECT_ALL_ORDER: This function is for SELECTING ALL data in your desired order from the database.

  • SELECT_ALL_LIMIT: This function is for SELECTING data in your desired limit.

  • GET_TOTAL: This function is for getting total number of rows from the database.

  • CHECK_DUPLICATE: This function is for checking duplicate data in a specified column from the database.

  • ERROR: This function is for displaying errors to the screen in production stage.

  • SEND_MAIL: This function is for sending emails to users

And many more...

Library Docs @ https://prepared.io

GitHub

https://github.com/World-Brain-Technology/prepared
You might also like...

PHP library providing retry functionality with multiple backoff strategies and jitter support

PHP Backoff Easily wrap your code with retry functionality. This library provides: 4 backoff strategies (plus the ability to use your own) Optional ji

Jun 25, 2022

Currency is a simple PHP library for current and historical currency exchange rates & crypto exchange rates. based on the free API exchangerate.host

Currency Currency is a simple PHP library for current and historical currency exchange rates & crypto exchange rates. based on the free API exchangera

Jul 4, 2022

A high-level machine learning and deep learning library for the PHP language.

Rubix ML A high-level machine learning and deep learning library for the PHP language. Developer-friendly API is delightful to use 40+ supervised and

Aug 15, 2022

PHP library to create and validate html forms

FormManager Note: this is the documentation of FormManager 6.x For v5.x version Click here Installation: This package requires PHP=7.1 and is availab

Jul 4, 2022

A small, modern, PSR-7 compatible PSR-17 and PSR-18 network library for PHP, inspired by Go's net package.

Net A small, modern, PSR-7 compatible PSR-17 and PSR-18 network library for PHP, inspired by Go's net package. Features: No hard dependencies; Favours

Jun 7, 2022

Library for PHP 7.4+ to detect Browsers and Devices

This library requires PHP 7.4+. Also a PSR-3 compatible logger and a PSR-16 compatible cache are required. In

Mar 30, 2022

A small, modern, PSR-7 compatible PSR-17 and PSR-18 network library for PHP, inspired by Go's net package.

Net A small, modern, PSR-7 compatible PSR-17 and PSR-18 network library for PHP, inspired by Go's net package. Features: No hard dependencies; Favours

Jun 7, 2022

This shell script and PHP file create a browseable HTML site from the Zig standard library source.

This shell script and PHP file create a browseable HTML site from the Zig standard library source.

Browseable Zig standard library This shell script and PHP file create a browseable HTML site from the Zig standard library source. The idea is to inve

Mar 20, 2022

A library for reading and writing DNA test kit files in PHP.

php-dna Requirements php-dna 1.0+ requires PHP 8.0 (or later). Installation There are two ways of installing php-dna. Composer To install php-dna in y

Feb 18, 2022
StickWithIt is an online food ordering website created using PHP. You can view and purchase various items as well as remove items from the cart.

StickWithIt (App Name) StickWithIt is an online food ordering website created using PHP. The database used here is MYSQL database. The tool used here

May 11, 2022
The swiss army knife for Magento developers, sysadmins and devops. The tool provides a huge set of well tested command line commands which save hours of work time. All commands are extendable by a module API.

netz98 magerun CLI tools for Magento 2 The n98 magerun cli tools provides some handy tools to work with Magento from command line. Build Status Latest

Aug 9, 2022
SPAM Registration Stopper is a Q2A plugin that prevents highly probable SPAM user registrations based on well-known SPAM checking services and other techniques

SPAM Registration Stopper [by Gabriel Zanetti] Description SPAM Registration Stopper is a Question2Answer plugin that prevents highly probable SPAM us

Jan 23, 2022
Allow players to see how well they are doing while pvping with the help of a combo counter

Combo-Counter Allow players to see how well they are doing while pvping with the help of a combo counter Settngs / Config #set to false if you dont wa

Jun 1, 2022
Uses internet-connectable temperature sensors to provide cooling/heating assist for small buildings, as well as weather data

ambient-hvac Uses internet-connectable temperature sensors to provide cooling/heating assist for houses and other small buildings, as well as weather

Nov 25, 2021
Shows you the current diocese that you're in, as well as the bishop.

Use config.php to create variables $dbuser and $dbpass for the database connection. Run `php -f ./coa/newcheck.php` to update database information fr

Dec 2, 2021
MOP is a php query handling and manipulation library providing easy and reliable way to manipulate query and get result in a fastest way
MOP is a php query handling and manipulation library providing easy and reliable way to manipulate query and get result in a fastest way

Mysql Optimizer mysql optimizer also known as MOP is a php query handling and manipulation library providing easy and reliable way to manipulate query

Nov 20, 2021
:date: The VObject library for PHP allows you to easily parse and manipulate iCalendar and vCard objects

sabre/vobject The VObject library allows you to easily parse and manipulate iCalendar and vCard objects using PHP. The goal of the VObject library is

Aug 10, 2022
JSONFinder - a library that can find json values in a mixed text or html documents, can filter and search the json tree, and converts php objects to json without 'ext-json' extension.

JSONFinder - a library that can find json values in a mixed text or html documents, can filter and search the json tree, and converts php objects to json without 'ext-json' extension.

Jul 31, 2022
PHP Text Analysis is a library for performing Information Retrieval (IR) and Natural Language Processing (NLP) tasks using the PHP language

php-text-analysis PHP Text Analysis is a library for performing Information Retrieval (IR) and Natural Language Processing (NLP) tasks using the PHP l

Aug 1, 2022