/Class-Base-MySQLi

Extends MySQLi class to perform common SQL queries. Clase PHP para el manejo de la conexión e interacción con la base de datos MySQL. Clase que extiende de MySQLi.

Primary LanguagePHP

Class Base MySQLi

Clase PHP para el manejo de la conexión e interacción con la base de datos MySQL. Clase que extiende de MySQLi.

#Detailed description:

This class can extends MySQLi class to perform common SQL queries. It is a subclass of the MySQLi class built-in class that provides additional functionality like:

  • Executes SELECT queries with results from multiple rows from another query result
  • Executes SELECT queries that result in a single row
  • Retrieves the total number of rows and consulted columns
  • Retrieves an array of values ​​of a given table field
  • Executes SQL statements INSERT, DELETE, UPDATE
  • Inserts records in a table from array values
  • Update records of a table from an array of values and a condition
  • Remove table records
  • Converts an associated a key-value into a string separated by the indicated separator
  • Retrieve the results of a SELECT query in multiple rows mode or in a single row or the first row of multiple rows
  • Assemble a JSON string from the results of value of a query with two columns the first is the key and the second the value