Search form doesn't work

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.

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.

Disclaimer: I haven't tested this yet.

<form action="search.php" method="post">
    <div class="row no-gutters mt-3">
        <div class="col">
            <input type="text" name="query">
            <input type="submit" name="submit" value="Search">
        </div>
    </div>
</form>

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.

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.

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.

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

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)."%' ",
  ));