Online PHP editor | refs for 1gI2F

<?php $config['sql_query_logging'] = [ 'enabled' => true, 'exclusions' => [ 'tables' => ['ci_sessions', 'system_log', 'jobs_log', 'error_log'], 'keywords' => ['select', 'show tables'] ] ]; $sqls = [ 'select * from table', 'show tables', 'update ci_sessions set some_col = some_val', 'update test set some_col = some_val', 'insert into test values(23, 45)', 'insert into ci_sessions values(1,2,3)', 'truncate ci_sessions' ]; foreach($sqls as $sql){ $result = array_merge( array_filter($config['sql_query_logging']['exclusions']['keywords'], fn($v) => preg_match('/\b'.$v.'\b/', $sql) === 1), array_filter($config['sql_query_logging']['exclusions']['tables'], function($table) use ($sql){ return preg_match('/\b(from|insert into|update|join|truncate|table)\s+'.$table.'\b/', $sql) === 1; }) ); if(empty($result)){ echo "Can log: ", $sql, PHP_EOL; // log here }else{ echo "Cannot log: ", $sql, PHP_EOL; } }