Function __global->nl_delim_match_sql

Definitions

sources/database_search.php

  • Get special SQL from POSTed parameters for a catalogue search field for a multi-input field that is to be exact-matched.
  • Visibility: public
  • Is abstract?: No
  • Is static?: No
  • Is final?: No
  • Returns: array

Parameters

Name Type Passed by reference? Variadic? Default Set Range Description
$field array No No required parameter N/A N/A The field details
$i integer No No required parameter N/A N/A We're processing for the ith row
$type ID_TEXT No No short short long N/A Table type
$param ?string No No Null N/A N/A Search term (null: lookup from environment)
$table_alias string No No r N/A N/A Table alias for catalogue entry table

Returns

  • Tuple of SQL details (array: extra trans fields to search, array: extra plain fields to search, string: an extra table segment for a join, string: the name of the field to use as a title, if this is the title, extra WHERE clause stuff) (null: nothing special)
  • Type: ?array
  • Set: N/A
  • Range: N/A

Preview

Code (PHP)

/**
 * Get special SQL from POSTed parameters for a catalogue search field for a multi-input field that is to be exact-matched.
 *
 * @param  array $field The field details
 * @param  integer $i We're processing for the ith row
 * @param  ID_TEXT $type Table type
 * @set short long
 * @param  ?string $param Search term (null: lookup from environment)
 * @param  string $table_alias Table alias for catalogue entry table
 * @return ?array Tuple of SQL details (array: extra trans fields to search, array: extra plain fields to search, string: an extra table segment for a join, string: the name of the field to use as a title, if this is the title, extra WHERE clause stuff) (null: nothing special)
 */
function nl_delim_match_sql(array $field, int $i, string $type = 'short', ?string $param = null, string $table_alias = 'r') : ?array