Filter Search Results

query(“SHOW COLUMNS FROM searches;”);

$clauses = ”;
$key = ”;
$param_arg_list = ”;
$param_arg_list[0] = ”;
$param_arg_values = array();
$input = ”;

if (array_key_exists(‘q’, $_GET) &&
strlen($_GET[‘q’]) > 0)
$input = $_GET[‘q’];

if (array_key_exists(‘search-criteria’, $_GET) &&
strlen($_GET[‘search-criteria’]) > 0)
$input = $_GET[‘search-criteria’];

$input = mysql_real_escape_string($input);
$input = strtoupper($input);
while ($row = $result->fetch_array())
{
if ($key === ”)
$key = $row[0];

$clauses .= “{$row[0]} = ‘{$input}’ OR “;
}
$clauses = substr($clauses, 0, -4);
$sql = “SELECT * FROM searches WHERE {$clauses} GROUP BY {$key} ORDER BY {$key};”;

$result = $conn->query( $sql );
?>

fetch_array(MYSQLI_BOTH))
{
if ( $other_row )
{
echo ”

“;
$other_row = FALSE;
}
else
{
echo ”

“;
$other_row = TRUE;
}

foreach ($row as $k => $v)
{
if ( is_numeric( $k ) )
continue;

if ( strlen( $v ) > 0 && ( empty( $input ) || strpos( $v, $input ) !== FALSE ) )
{
$man_part_number = $v;
$manufacturer = str_replace( ‘__’, ‘&’,$k );
$manufacturer = str_replace( ‘_’, ‘ ‘, $manufacturer );
$manufacturer = str_replace( ‘slash’, ‘/’, $manufacturer );
$manufacturer = str_replace( ‘pound’, ‘#’, $manufacturer );
break;
}
}
$id = strtolower( $row[0] );
if ( strlen($id) === 2 )
$k_p_part = “{$row[0]}“;
else
$k_p_part = “{$row[0]}“;
$found_results = TRUE;
echo ”

“;
echo “

“;
}

if ($found_results === FALSE)
echo “No matches found.”;
?>

Manufacturer Part Number Manufacturer K&P Filter
{$man_part_number} {$manufacturer} {$k_p_part}

Comments are closed.