Search form doesn't work

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

Perfect! Thank you so much.