note 16155 added to function.split
| From: | alc at adaptanet dot com dot br | Date: | Thu, 18 Oct 2001 05:05:00 +0000 |
| Subject: | note 16155 added to function.split | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-19080@lists.php.net to get a copy of this message | ||
Sorry me ugly english.
-----------------------
Search engine example.
Searching for any word.
# EXECUTA A BUSCA #
if ($busca != "") {
$select = "SELECT * FROM favoritos WHERE ";
$sub_busca = str_replace(" ", ":-:-:", $busca);
$busca_split = split(":-:-:", $sub_busca);
for ($i = 0; $i < count($busca_split); $i++) {
if ($busca_split[$i] != "") {
$select .= "UPPER(nome) LIKE UPPER('%$busca_split[$i]%')
";
$select .= "OR ";
$select .= "UPPER(descri) LIKE UPPER('%$busca_split[$i]%')
";
$select .= "OR ";
$select .= "UPPER(chave) LIKE UPPER('%$busca_split[$i]%')
";
$select .= "OR ";
}
}
$select = substr_replace ($select, ' ' , -3 );
$select.= " ORDER BY nome";
$select = pg_exec($select);
$rows = pg_numrows($select);
--
http://www.php.net/manual/en/function.split.php
http://master.php.net/manage/user-notes.php?action=edit+16155
http://master.php.net/manage/user-notes.php?action=delete+16155
http://master.php.net/manage/user-notes.php?action=reject+16155