» a PHP class to Create, Read, Update, & Delete from a mysql database table using AJAX

   by loud canvas media

AjaxCRUD Class Documentation / Reference Material

<< Reference overview
<< Home


Most recent/active sql WHERE clause used by the ajaxcrud table.
This is a SESSION variable which can be leveraged in any (other) php page and contains the active WHERE clause used by ajaxCRUD. Introduced in version v8.64. It is set automatically in the addWhereClause method and used for both filtering and manually-defined WHERE conditions. It is stored in a bi-dimentional array, so you need to specify "ajaxcrud_where_clause" as index 0 and then the table name as index 1.

See example file /examples/where_clause_test.php


Requires session_start();
Type variable
Default value


if (isset($_SESSION['ajaxcrud_where_clause']['tblDemo'])){
   $whereClause = $_SESSION['ajaxcrud_where_clause']['tblDemo'];
   echo "ajaxCRUD where clause: " . $whereClause;
   echo "No WHERE clause set (yet)";

New, Edit


"GREEEAT functions! Easily understandable code, I`m loooovving it. Great work! :D "
~Svend Koustrup

What is a business/commercial website?

A commercial website is one created for a business, for which purpose is generating revenue or cash flow of any type (and that isn't under a non-profit organization). So if you're selling a product, selling advertisement, selling a service, or just marketing a commercial business, your site is commercial. A company website is also commercial even if it doesn't sell anything, as it's purpose is to front a commercial company.