File Source for KeyWord.php

<?php
/**
* MediaSearch
*
* LICENSE
*
* "THE BEER-WARE LICENSE" (Revision 42):
* "Sven Strittmatter" <ausserirdisch@sven-space.de> wrote this file.
* As long as you retain this notice you can do whatever you want with
* this stuff. If we meet some day, and you think this stuff is worth it,
* you can buy me a beer in return.
*
* $Author$
* $Revision$
*
* @category MediaSearch
* @package MediaSearch_Model_DbTable
* @copyright Copyright (c) 2009 Sven Strittmatter
*/
/**
* KeyWord table database access object.
*
* @abstract
* @category MediaSearch
* @package MediaSearch_Model_DbTable
* @copyright Copyright (c) 2009 Sven Strittmatter
*/
class MediaSearch_Model_DbTable_KeyWord extends MediaSearch_Model_DbTable_Abstract {
/**
* Sets the database name to KeyWord.
*
* @see Zend_Db_Table_Abstract::__construct()
*
* @access public
* @param array $config
*/
public function __construct($config = array()) {
$this->_name = 'KeyWord';
parent::__construct($config);
}
/**
* Finds rows by multiple keywords.
*
* @access public
* @param array $keywords
* @return array
*/
public function findByKeyWords(array $keywords) {
$sql = "SELECT * FROM " . $this->_name . " ";
$sql .= "WHERE ";
$count = count($keywords);
for ($i = 0; $i < $count; $i++) {
$sql .= "keyWord LIKE '{$keywords[$i]}' ";
if ($i < $count - 1) {
$sql .= ' OR ';
}
}
<a href="../MediaSearch/MediaSearch_Log.html">MediaSearch_Log</a>::info('Doing SQL: ' . $sql);
$adapter = $this->getAdapter();
$statement = $adapter->query($sql);
$statement->execute();
return $statement->fetchAll();
}

Source for file KeyWord.php