suchen in der DB (alles klein) (lower)

[elexis_linux]

Code: Alles auswählen

if($_POST['in'] == 'Firmenname') { $suche = strtolower($_POST['suche']); $temp = $psql->select("customer", "id_customer", "lower(company_customer) like '%$suche%' and address_flag_customer = false", COLS); $count_array = count($temp['id_customer']); for($i = 0; $i < $count_array; $i++) { $array_id_customer[$i] = $temp['id_customer'][$i]; } }

Der befehl "strtolower()" macht den String klein.

In Postgres kann man einfach die zu suchende Attribute klein machen:
"lower()"