/**
* Used to delete data from database
*
* @since 1.2.2
* @param array $connection_information an array with following keys:
* host => the database host name
* user => the database user
* password => the database password
* database => the database name
* debug => the debug level it can be 0,1 or 2
* charset => utf8
*/
function DeleteQuery($connection_information)
{
/** The database connection details */
$parameters = $connection_information;
/** The DatabaseFunctions object is created */
$database = new DatabaseFunctions($parameters);
/** The database table name */
$table_name = "pakphp_cached_data";
/** The table name is set */
$database->df_set_table($table_name);
/** The where clause */
$where_clause = array();
/** The field name in where clause */
$where_clause[0]['field'] = "function_name";
/** The field value */
$where_clause[0]['value'] = "InsertQuery";
/** The operation. e.g =,<,>,!= */
$where_clause[0]['operation'] = "=";
/** The operator. e.g AND, OR, NOT */
$where_clause[0]['operator'] = "";
/** The database query is fetched */
$query = $database->df_build_query(array(), $where_clause, 'd');
echo "<h3>Database query: </h3>";
/** The query is displayed */
echo $query;
/** The database query is run */
$database->df_execute($query);
/** The number of rows affected by the query */
$affected_rows = $database->df_affected_rows($query);
echo "<h3>Affected rows: </h3>";
print_r($affected_rows);
/** The query log is displayed */
echo "<h3>Query Log: </h3>";
$database->df_display_query_log(false);
/** The query log is cleared */
$database->df_clear_query_log();
/** The database connection is closed */
$database->df_close();
}
