LLMS_Database_Query

Database Query abstract class


Description Description


Source Source

File: includes/abstracts/abstract.llms.database.query.php


			

Top ↑

Changelog Changelog

Changelog
Version Description
3.8.0
3.34.0 Sanitizes sort parameters.
3.30.3 Introduced.


Top ↑

Methods Methods

  • __construct — Constructor
  • escape_and_quote_string — Escape and add quotes to a string, useful for array mapping when building queries
  • get — Retrieve a query variable with an optional fallback / default
  • get_default_args — Retrieve default arguments for the query
  • get_filter — Get a string used as filter names unique to the extending query
  • get_results — Retrieve an array of results for the given query
  • get_skip — Get the number of results to skip for the query based on the current page and per_page vars
  • has_results — Determine if the query has at least one result
  • is_first_page — Determine if we're on the first page of results
  • is_last_page — Determine if we're on the last page of results
  • parse_args — Parse arguments needed for the query
  • preprare_query — Prepare the SQL for the query
  • query — Execute a query
  • sanitize_id_array — Sanitize input to ensure an array of absints
  • sanitize_sort — Removes any invalid sort fields before preparing a query.
  • set — Sets a query variable
  • set_found_results — Set variables related to total number of results and pages possible with supplied arguments
  • setup_args — Setup arguments prior to a query
  • sql_limit — Retrieve the prepared SQL for the LIMIT clause
  • sql_orderby — Retrieve the prepared SQL for the ORDER BY clause
  • sql_select_columns — Retrieve the prepared SQL for the SELECT clause

Top ↑

User Contributed Notes User Contributed Notes

You must log in before being able to contribute a note or feedback.