Chart Formulae Used Per Sura - warwickfoster/qurantools GitHub Wiki

File: app/ajax/ajax_instant_list_formulae.php

Purpose

The PHP script you have provided is designed to power a Instant Details Formulae Lister. It retrieves and displays a list of formulae based on user-specified criteria.

Functionality

  • Session Management The script starts a session and regenerates the session ID to enhance security.
  • User Authentication It checks if the user is logged in by verifying the existence of a session variable. If not, it exits the script.
  • Database Connection and Functions The script includes necessary database configuration and functions for accessing and querying the database.
  • Input Parameters It accepts GET parameters for formula length, type, and global word number.
  • Database Query It executes a SQL query to retrieve formulae matching the specified criteria.
  • Formula Display For each retrieved formula, the script displays its details in a table, including the formula, length, type, occurrences, and a link to a chart.

Key Features

  • Formula Search Users can search for formulae based on length, type, and global word number.
  • Formula Details The script provides details such as formula, length, type, occurrences, and a chart link for each formula.
  • User Interface The results are displayed in a formatted table with clear headings and links.

Additional Notes

  • The script uses the db_query(), db_rowcount(), and db_return_row() functions to interact with the database.
  • The FORMULA-LIST table is assumed to exist in the database.
  • The script includes links to other pages, such as the formula list and charts.
  • The script uses HTML, CSS, and PHP to render the output.