query("SELECT DISTINCT books.id AS id, books.title AS title, SUBSTR(comments.text,0,120) AS excerpt FROM books INNER JOIN comments ON comments.book = books.id INNER JOIN books_tags_link ON books_tags_link.book = books.id INNER JOIN tags ON tags.id = books_tags_link.tag WHERE books.title LIKE '%$keywordsearch%' OR books.author_sort LIKE '%$keywordsearch%' OR comments.text LIKE '%$keywordsearch%' OR tags.name LIKE '%$keywordsearch%' ORDER BY books.timestamp DESC"); $authorquery = $db->query("SELECT DISTINCT books.id AS id, books.title AS title, SUBSTR(comments.text,0,120) AS excerpt FROM books INNER JOIN comments ON comments.book = books.id INNER JOIN books_tags_link ON books_tags_link.book = books.id WHERE books.author_sort LIKE '%$authorsearch%' ORDER BY books.timestamp DESC"); $typequery = $db->query("SELECT DISTINCT books.id AS id, books.title AS title, SUBSTR(comments.text,0,120) AS excerpt FROM books INNER JOIN comments ON comments.book = books.id INNER JOIN books_custom_column_1_link ON books_custom_column_1_link.book = books.id INNER JOIN custom_column_1 ON custom_column_1.id = books_custom_column_1_link.value WHERE custom_column_1.value = '$typesearch' ORDER BY books.timestamp DESC"); $types = $db->query("SELECT value FROM custom_column_1 ORDER BY value ASC"); ?> Infopump - Recently Added - <?php echo $searchtopic; ?> ';?> ';?> '; echo ''; } elseif (!empty($authorsearch)) { echo ''; echo ''; } else { echo ''; echo ''; } ?> ';?> ';?> ';?> ';?>
Close
Infopump Avatar

About the Project

Infopump

A bibliographic management and display system.

A free, open source project from:
The L0WL1F3 Podcast
Neon Dystopia
Cyberpunk Librarian

Recent Additions

    fetchArray()) { $row_value = $row['value']; $row_titlecase = mb_convert_case($row_value, MB_CASE_TITLE, "UTF-8"); echo '
  • '.$row_titlecase.'
    • '; //echo '
  • '.$row_value.'
    • '; } ?>

Search

Recently Added

fetchArray()) { $row_id = $row['id']; $row_title = $row['title']; $row_excerpt = $row['excerpt']; echo '

'.$row_title.' : '.strip_tags($row_excerpt).'...

'; } } elseif ($typesearch != '') { while ($row = $typequery->fetchArray()) { $row_id = $row['id']; $row_title = $row['title']; $row_excerpt = $row['excerpt']; echo '

'.$row_title.' : '.strip_tags($row_excerpt).'...

'; } } else { while ($row = $authorquery->fetchArray()) { $row_id = $row['id']; $row_title = $row['title']; $row_excerpt = $row['excerpt']; echo '

'.$row_title.' : '.strip_tags($row_excerpt).'...

'; } } ?>