Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
custom_source_code [2015/03/15 17:37]
127.0.0.1 created
custom_source_code [2018/05/04 21:40] (current)
Line 31: Line 31:
  
 Since the code entered here is generally intended to perform database queries , the following variables are available Since the code entered here is generally intended to perform database queries , the following variables are available
-$_pdo+ 
 + 
 +1. **$_pdo**
  
 A connection to your database. This is used to execute SQLs, to create and populate temporary tables and to perform other preparatory work like filtering, reformatting etc. Can also be used to perform database maintenance operations such as deletes and updates. This is a PDO type connection and so can be used as documented in the PHP PDO documentation at http://​php.net/​manual/​en/​book.pdo.php. A connection to your database. This is used to execute SQLs, to create and populate temporary tables and to perform other preparatory work like filtering, reformatting etc. Can also be used to perform database maintenance operations such as deletes and updates. This is a PDO type connection and so can be used as documented in the PHP PDO documentation at http://​php.net/​manual/​en/​book.pdo.php.
Line 67: Line 69:
 </​code>​ </​code>​
  
-$_criteria+2. **$_criteria**
  
 This array variable contains an entry for each criteria item on the prepare screen and gives access to the relevant selected criteria values. This allows query statements to be executed in the custom code that incorporate the user's selected criteria. This is advantageous in several ways. For example, reports that use queries selecting from many large tables will be faster if some of the data meeting the entered criteria is first selected into temporary tables which can then be linked into the main query at the end. Also data can be selected into temporary tables and further filtered or modified before the final report query runs. This array variable contains an entry for each criteria item on the prepare screen and gives access to the relevant selected criteria values. This allows query statements to be executed in the custom code that incorporate the user's selected criteria. This is advantageous in several ways. For example, reports that use queries selecting from many large tables will be faster if some of the data meeting the entered criteria is first selected into temporary tables which can then be linked into the main query at the end. Also data can be selected into temporary tables and further filtered or modified before the final report query runs.
  • custom_source_code.txt
  • Last modified: 2018/05/04 21:40
  • (external edit)