Searching

[anevins]

Hi, I want to create a search which uses the 'title' of my 'product' table and matches the terms the user has submitted.

At the moment, my products are displaying one by one.

 

For example,

I have an apple and apricot in my table.

The user searches 'a' and the search results show 'apple' but not apricot.

 

Here's my code:

<?php 
require_once('inc/global.inc.php');

# search.inc.php

/* 
*	This is the search content module.
*	This page is included by index.php.
*	This page expects to receive $_GET['terms'].
*/

// Redirect if this page was accessed directly:
if (!defined('BASE_URL')) {

// Need the BASE_URL, defined in the config file:
require_once ('../includes/config.inc.php');

// Redirect to the index page:
$url = BASE_URL . 'index.php?p=search';

// Pass along search terms?
if (isset($_GET['terms'])) {
	$url .= '&terms=' . urlencode($_GET['terms']);
}

header ("Location: $url");
exit;

} // End of defined() IF.

// Print a caption:
echo '<h2>Search Results</h2>';

// Display the search results if the form
// has been submitted.
if (isset($_GET['terms']) && ($_GET['terms'] != 'Search...') ) {

$terms = $_GET['terms'];
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) or die *('Error connecting to MySQL server');
// Query the database.
$query = "SELECT * FROM product WHERE title LIKE '%$terms%'";
$result = mysqli_query($dbc, $query);

// Fetch the results.
$row = mysqli_fetch_array($result);

// Print the results:


$output[] = '<ul>';
$output[] = '<li>'.$row['title'] .': £'.$row['price'].'<br /><img src="'.$row['img'].'" alt="'.$row['title'].'" /></li>';

$output[] = '</ul>';
echo join('',$output);
	}

else { // Tell them to use the search form.
echo '<p class="error">Please use the search form at the top of the window to search this site.</p>';
}
?>

 

A friend told me I need to use a for-each loop but I can't figure it out.

 

Any help is appreciated,

thanks for reading.

[taquitosensei]

change this

// Fetch the results.
$row = mysqli_fetch_array($result);

// Print the results:


$output[] = '<ul>';
$output[] = '<li>'.$row['title'] .': £'.$row['price'].'<br /><img src="'.$row['img'].'" alt="'.$row['title'].'" /></li>';

$output[] = '</ul>';
echo join('',$output);

to this

$result=mysqli_query($dbc,$query);
while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
        $output[] = '<ul>';
$output[] = '<li>'.$row['title'] .': £'.$row['price'].'<br /><img src="'.$row['img'].'" alt="'.$row['title'].'" /></li>';
        $output[] = '</ul>';
}
echo join('',$output);

[anevins]

I have changed it, to your code, and PHP throws me an error:

 

mysql_fetch_array() expects parameter 1 to be resource, object given

[taquitosensei]

I made a typo and was mixing up mysql and mysqli   

it should be

while($row=mysqli_fetch_assoc($result)) {

}

[anevins]

Thank you so much!

 

Just to let you know, you have been more helpful than my University lecturer.