<?php
// Get Autocompleter class
$library = dirname(dirname(__FILE__));
require_once $library . '/autocompleter.php';
// Get URLs
$urls = MijosefAutocompleter::loadResultArray("SELECT url_sef FROM", "mijosef_urls", "WHERE params LIKE '%\"notfound\":0%' ORDER BY url_sef");
if (!empty($urls)) {
$q = $_REQUEST['q'];
$added = array();
foreach ($urls as $index => $url) {
if (!isset($added[$url]) && strpos(strtolower($url), $q) === 0) {
echo $url . "\n";
$added[$url] = "a";
}
}
}
<?php
// Get Autocompleter class
$library = dirname(dirname(__FILE__));
require_once $library . '/autocompleter.php';
// Get rows
$rows = MijosefAutocompleter::loadResultArray("SELECT title FROM", "mijosef_tags", "WHERE published = '1' ORDER BY title");
if (!empty($rows)) {
$q = $_REQUEST['q'];
foreach ($rows as $index => $row) {
if (strpos(strtolower($row), $q) === 0) {
echo $row . "\n";
}
}
}
<?php
// Get Autocompleter class
$library = dirname(dirname(__FILE__));
require_once $library . '/autocompleter.php';
// Get rows
$rows = MijosefAutocompleter::loadResultArray("SELECT keywords FROM", "mijosef_metadata", "WHERE keywords != '' ORDER BY url_sef");
if (!empty($rows)) {
$q = $_REQUEST['q'];
$added = array();
foreach ($rows as $index => $row) {
$keywords = explode(',', $row);
foreach ($keywords as $key) {
$key = trim($key);
if (!isset($added[$key]) && strpos(strtolower($key), $q) === 0) {
echo $key . "\n";
$added[$key] = "a";
}
}
}
}
