File: autocomplete.php

package info (click to toggle)
phppgadmin 4.2.3-1.1squeeze2
  • links: PTS, VCS
  • area: main
  • in suites: squeeze
  • size: 5,396 kB
  • ctags: 6,174
  • sloc: php: 68,599; makefile: 215; sh: 41; sql: 16; awk: 9
file content (18 lines) | stat: -rw-r--r-- 507 bytes parent folder | download | duplicates (2)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
<?php
	include_once('libraries/lib.inc.php');
	$data->clean($_REQUEST['tb']);
	$data->clean($_REQUEST['fk']);
	$data->clean($_REQUEST['v']);
	
	$szSQL = 'SELECT * FROM ' . $_REQUEST['tb'] . ' WHERE ' . $_REQUEST['fk']
		. "::text LIKE '" . $_REQUEST['v'] . "%' ORDER BY ". $_REQUEST['fk'] ." LIMIT 11";

	$objRes = $data->selectSet($szSQL);
	$arrayRes = array();
	while (!$objRes->EOF) {
		$arrayRes[] = $objRes->fields[$_REQUEST['fk']];
		$objRes->moveNext();
	}

	echo implode('PPA_EOF;|', $arrayRes);
?>