How to display related search terms on a search page result?

Post by kingzjeans » Fri Mar 15, 2019 9:49 pm

Hi,

I want to be able to be able to display related search terms on a search result's page. My website runs on opencart 3.0.2
Example: I have this page: https://www.kingzjeans.ro/index.php?rou ... ur%20lasat
The search term here is this: PANTALONI BARBATI CU TUR LASAT

I want to display at the bottom of this page, underneath the results (the products) a list of let's say 10 related (similar) search terms already existing in the database like: pantaloni cu tur lasat, pantaloni cu tur, pantaloni barbati

How can I do this? I searched everywhere and there is nothing like this. I want to do this as it is a very good method to do internal linking between the search terms pages.

I was thinking of a query of this sort:
$sql = "SELECT *, MATCH keyword AGAINST ('%$search%' IN BOOLEAN MODE) AS relevance FROM oc_customer_search
WHERE MATCH keyword AGAINST ('%$search%' IN BOOLEAN MODE)
HAVING Relevance > 0.2 Order by Relevance
DESC LIMIT 8";
$result = mysqli_query($mysqli, $sql);

I don't know how to do this automatically... Any help is much appreciated

Post by thekrotek » Fri Mar 15, 2019 11:51 pm

Professional OpenCart extensions, support and custom work.
Contact me via email or Skype by support@thekrotek.com

Post by joakimcom » Sat Mar 16, 2019 1:22 am

Post by straightlight » Sat Mar 16, 2019 4:27 am

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester

Post by letxobnav » Sat Mar 16, 2019 8:16 am

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

Post by letxobnav » Sat Mar 16, 2019 8:44 am

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

Post by kingzjeans » Mon Mar 18, 2019 6:50 pm

The idea is not the code (php query) but the actual way to have this displayed at the bottom of a search result page... I don't know how to implement the php code in a twig file... I searched the internet and I saw that you can't include a php file inside a twig file...

So, how should I do that without breaking the code of the search.twig file?

I am not concerned about the query itself but more on the way to actually include the results...

Basically what I need is something like this:
Let's say I am on a search result page like this: https://www.kingzjeans.ro/index.php?rou ... aca%20alba
The query used here is: geaca alba
The php file would search inside the already inserted keywords in the database for something like geaca or alba or both...

But that is not what concerns me but the actual way to implement this feature...

Thank you all for being so kind and answering to my topic

Post by kingzjeans » Mon Mar 18, 2019 6:59 pm

Post by OSWorX » Mon Mar 18, 2019 7:53 pm

Full Stack Web Developer :: Dedicated OpenCart Development & Support DACH Region
Contact for Custom Work / Fast Support.

Post by kingzjeans » Mon Mar 18, 2019 10:36 pm

That's the thing... I didn't do anything of those... It would really help me if you or anybody else would provide me a controller, a model and a way to output the code... This is what I don't know how to do

I will edit the php code but I need the exact steps of what I should do I don't know too much about opencart and how it works...

Post by letxobnav » Wed Mar 20, 2019 2:05 pm

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

Post by kingzjeans » Wed Mar 20, 2019 6:53 pm

@letxobnav : can you please pm to me the files you use for this mod? It would really help me

You can also send them on my email contact@kingzjeans.ro

I would be really thankful for that as I really don't know how to do what you already say you managed to do... This thing is incredibly useful SEO wise for internal linking between search terms pages... as they don't receive internal backlinks from elsewhere... That is why I want to do that...

My website is running on opencart 3.0.2.0

Post by joakimcom » Thu Mar 21, 2019 6:09 pm

Human

Post by letxobnav » Fri Mar 22, 2019 9:53 am

	public function getSearchSuggestion($keywords,$language_id = 1) {
		$parts = explode(' ',$keywords);
		$new_parts = array();
		foreach($parts as $part) {
			$query = $this->db->query("select sws_replacement from searchword_swap where sws_word = '".$this->db->escape($part)."' and language_id = '".$language_id."'");
			$result = $query->row['sws_replacement'];
			if ($result) {
				$new_parts[] = $result;
			} else {
				$new_parts[] = $part;
			}
		}
		$suggestion = implode(' ',$new_parts);
		if ($suggestion != $keywords) {
			return $suggestion;
		} else {
			return false;
		}
	}

			$search_replacement = false;
			if (!$results) {
					// misspelled words perhaps
					$correction = $this->model_catalog_search->getSearchSuggestion($search,$this->config->get('config_language_id'));
					if ($correction) $search_replacement = $correction;
			}

			$repl_url = '';
			if ($search_replacement) {
				$repl_term = urlencode(html_entity_decode($search_replacement, ENT_QUOTES, 'UTF-8'));
				$repl_url = str_replace($search_term,$repl_term,$url);
			}

$data['href'] = $this->url->link('product/search', $url);

$data['repl_url'] = $this->url->link('product/search', $repl_url);

<h3>{{ heading_title }}{% if search_replacement %}{{ text_search_instead }} <a href="{{ repl_url }}"><i><strong>{{ search_replacement }}</strong></i></a>?{% endif %}</h3>

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

Post by kingzjeans » Fri Mar 22, 2019 8:58 pm

Post by kingzjeans » Fri Mar 22, 2019 11:03 pm

Post by letxobnav » Sat Mar 23, 2019 12:45 am

$keywords = $this->request->get['search'];
$parts = explode(' ',$keywords);
foreach($parts as $part) {
$query = $this->db->query("select keyword from oc_customer_search where match keyword against ('%$part%' in boolean mode) order by customer_search_id desc limit 5");
$result = $query->row['keyword'];
if ($result) {
$new_parts[] = $result;
} else {
$new_parts[] = $part;
}
}

// remove duplicates
$new_parts = array_unique($new_parts);
// create the link array
foreach ($new_parts as $part) {
	$data['related_searches'][] = array(
	'text'  => $part,
	'href'  => $this->url->link('product/search', '&search=' . $part)
	);

	{% if related_searches %}
		{% for related_search in related_searches %}
			<h3><a href="{{ related_search.href }}">{{ related_search.text }}</a></h3>
		{% endfor %}
	{% endif %}

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

Post by letxobnav » Sat Mar 23, 2019 2:22 pm

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

Post by letxobnav » Sat Mar 23, 2019 10:43 pm

Crystal Light Centrum Taiwan
Extensions: MailQueue | SUKHR | VBoces

“Data security is paramount at [...], and we are committed to protecting the privacy of anyone who is associated with our [...]. We’ve made a lot of improvements and will continue to make them.”
When you know your life savings are gone.

Post by straightlight » Sun Mar 24, 2019 1:59 am

Dedication and passion goes to those who are able to push and merge a project.

Regards,
Straightlight
Programmer / Opencart Tester