Hilfe bei Suchfunktion

<?php
 class VideosGateway{

public function find($name, $from, $rows){

$sql = "SELECT * FROM kuenstler INNER JOIN kategorien INNER JOIN videos ON k_id = fk_k_id AND a_id= fk_a_id LIMIT :from,:interval WHERE k_name LIKE  %:name%"; 
$params = array(array(':name', $name,  PDO::PARAM_STR), array(':from', $from,  PDO::PARAM_STR), array(':interval', $rows,  PDO::PARAM_STR));
$db = DB::getInstance();
$result = $db->executePreparedStatement($sql, $params);
$videos = null;
if(count($result) > 0){
$videos = self::load($result[0]);
}
return $videos;
}
 


public function find_begin($name, $from, $rows){

$sql = "SELECT * FROM kuenstler INNER JOIN kategorien INNER JOIN videos ON k_id = fk_k_id AND a_id= fk_a_id LIMIT :from,:interval WHERE k_name LIKE  %:name" ;
$params = array(array(':name', $name,  PDO::PARAM_STR), array(':from', $from,  PDO::PARAM_STR), array(':interval', $rows,  PDO::PARAM_STR));
$db = DB::getInstance();
$result = $db->executePreparedStatement($sql, $params);
$videos = null;
if(count($result) > 0){
$videos = self::load($result[0]);
}
return $videos;
}




public static function load($row){
 if(!is_null($row) && is_Array($row)){
 $id = $row['v_id'];
 $kuenstler = $row['k_name'];
 $titel = $row['titel'];
 $genre = $row['a_name'];
 $groesse = $row['dateigroesse'];
 $result = new Videos($id, $kuenstler, $titel, $genre, $groesse);
 return $result;
 }else{
 return null;
 }
 }

 public function size(){
 return DB::getInstance()->sizeOf("kuenstler");
 }
 
  
 public function findRange($from = 0, $numberRows = 15){
 $sql = "SELECT * FROM kuenstler INNER JOIN kategorien INNER JOIN videos ON k_id = fk_k_id AND a_id= fk_a_id LIMIT :from,:interval";
 if(is_numeric($from) && is_numeric($numberRows)){
 $from = (integer)$from;
 $numberRows = (integer)$numberRows;
 }else{
 return array();
 }
 
 $params = array(array(':from', $from, PDO::PARAM_INT),
 array(':interval', $numberRows, PDO::PARAM_INT));
 $db = DB::getInstance();
 $videos = $db->executePreparedStatement($sql, $params);
 $liste = array();
 foreach($videos as $row) {
 $liste[] = self::load($row);
 }
 return $liste;
 
 }
 }
 ?>

 <?php
 require_once("environment.php");

 $videosTable = new VideosGateway();
 $max = $videosTable->size();
 $rows = 15;
 
 if(isset($_REQUEST['direction'])){
$direction = $_REQUEST['direction'];
if($direction == "forward"){
$from = $_REQUEST['oldvalue'] + $rows;
}else{
$from = $_REQUEST['oldvalue'] - $rows;
if($from < 0) $from = 0;
}
}else{
if(isset($_REQUEST['from'])){
$from = $_REQUEST['from'];
}else{
$from = 0;
}
}
$videosListe = $videosTable->findRange($from, $rows);


 
 
 HTML::printPageHeader("Musikvideos");
 HTML::printCaption("Suche nach Musikvideos", 1);
 HTML::printCaption("Mit folgenden Begriffen im Dateinamen", 10);

function printFormsearch(){
print "<form action=" . $_SERVER['PHP_SELF'] . " method='post'>";
print"<p><input type=checkbox name='auswahl' value=''>";
print"Suche am Anfang des Titels</p>";
print"<p><input type=text name='suche' value=''></p>";
print"<p><input type=submit name='eingabe' value='Suchen'></p>";
print "</form>";
print "<br />";
}



 HTML::printTableBegin(5,4,1);
 HTML::printTableHeader(array("ID", "Künstler", "Titel", "Genre", "Dateigroesse"));
 printFormsearch();
 
 foreach($videosListe as $videos){
print "<tr>";
print $videos->toHTMLTableColumns();
print "<td>";
}
 


 HTML::printTableEnd();
 HTML::printPageFoot();
 
 if($from > 0){
HTML::printLink($_SERVER['PHP_SELF'] . "?direction=backward&oldvalue=$from",
"Zurück");
HTML::printBlanks(2);
}
if($from + $rows < $max){
HTML::printLink($_SERVER['PHP_SELF'] . "?direction=forward&oldvalue=$from",
"Vorwärts");
} 

if(isset($_REQUEST['eingabe']) && !empty($_REQUEST['suche'])){
$suche = $_REQUEST['suche'];
}

if(!isset($_REQUEST['auswahl']) && !empty($_REQUEST['suche'])){
$videosListe = $videosTable-> find($suche, $from, $rows);
echo "<left><h1>Sie suchen nach $suche.</h1></left>";
}


print "Seite: ";
$numbers = $max / $rows;
for ($i = 0; $i < $numbers; $i++){
$newFrom = $i * $rows;
HTML::printLink($_SERVER['PHP_SELF'] . "?from=$newFrom",
($i + 1));
HTML::printBlanks(1);
}

print"<p><input type=submit name='newsearch' value='Neue Suche'></p>";

 ?>