Search form doesn't work

Search form doesn't work after first search

Wed, 30 Sep 2020 14:30:15 -0700

Perfect! Thank you so much.

Search form doesn't work after first search

Wed, 30 Sep 2020 14:28:19 -0700

Try this

$query = @$_REQUEST['query']; // this will hold the keyword

  // load records from 'homepage_insets'
  list($homepage_insetsRecords, $homepage_insetsMetaData) = getRecords(array(
    'tableName'   => 'homepage_insets',
    'perPage'     => '10',
    'loadUploads' => true,
    'allowSearch' => true,
    'where'       => " title LIKE '%".mysql_escape($query)."%' OR content LIKE '%".mysql_escape($query)."%' ",
  ));

Search form doesn't work after first search

Wed, 30 Sep 2020 14:26:23 -0700

I'm afraid not; I'm getting this error message when I run a search:

MySQL Error: Unknown column 'title_keyword' in 'where clause'

http://wilmotpost.ca/demo/index.php

Search form doesn't work after first search

Wed, 30 Sep 2020 14:19:46 -0700

Yes, it would search only one field. If you know the names of the other fields, you can do something like

$query = @$_REQUEST['query']; // this will hold the keyword

  // load records from 'homepage_insets'
  list($homepage_insetsRecords, $homepage_insetsMetaData) = getRecords(array(
    'tableName'   => 'homepage_insets',
    'perPage'     => '10',
    'loadUploads' => true,
    'allowSearch' => true,
    'where'       => " title_keyword LIKE '%".mysql_escape($query)."%' OR content_keyword LIKE '%".mysql_escape($query)."%' ",
  ));

and you can add all the fields you want to search using that format.

Search form doesn't work after first search

Wed, 30 Sep 2020 14:10:49 -0700

Would this only search one field? i.e. the title field, which contains the headline? I'd like it to search author, content, main_article as well as title.

Search form doesn't work after first search

Wed, 30 Sep 2020 13:59:41 -0700

Disclaimer: I haven't tested this yet.

After that, on search.php I would change this:

  // load records from 'homepage_insets'
  list($homepage_insetsRecords, $homepage_insetsMetaData) = getRecords(array(
    'tableName'   => 'homepage_insets',
    'perPage'     => '10',
    'loadUploads' => true,
    'allowSearch' => true,
  ));

to something similar:

$query = @$_REQUEST['query']; // this will hold the keyword

  // load records from 'homepage_insets'
  list($homepage_insetsRecords, $homepage_insetsMetaData) = getRecords(array(
    'tableName'   => 'homepage_insets',
    'perPage'     => '10',
    'loadUploads' => true,
    'allowSearch' => true,
    'where'       => " title_keyword LIKE '%".mysql_escape($query)."%' ",
  ));

Let me know if that works.

Search form doesn't work after first search

Wed, 30 Sep 2020 13:38:03 -0700

Hi, Carl.

For some reason, it seems to pick up my last name, as I wrote some of the articles, but it doesn't catch anything else!

http://wilmotpost.ca/demo/search.php?title_keyword%2Ccontent_keyword%2Cmain_article_keyword%2Cauthor_keyword=gordijk&submit=Search

I've attached the search results page.

Search form doesn't work after first search

Wed, 30 Sep 2020 13:30:24 -0700

Hi,
Do you have any examples of keywords that do work? The keywords I tried didn't show any results. Can you share the search.php file? You should use a single word without any commas in your input name and you can use the value from that variable to query the database for any item in your database you wish to query.

Search form doesn't work

Wed, 30 Sep 2020 12:39:31 -0700

I have a search form on my site, which doesn't seem to be picking up some keywords. http://wilmotpost.ca/demo/index.php

Searching for the word "indigenous" doesn't show any results, even though there are clearly at least two articles that contain it. That's just one example, but there are others, too. Any idea what might be causing this, please?