Connect( 'username', 'password', 'host', 'database' );
$search = mysql_real_escape_string( htmlspecialchars( str_replace( ' ', '%', $_GET['search'] ) ) );
if( empty( $search ) )
{
$db->Disconnect();
echo 'Must supply search query.';
die();
}
$sql = 'SELECT
*
FROM
torrents
WHERE
filename LIKE \'%'.$search.'%\'
ORDER BY
data DESC';
$res = $db->Query( $sql );
$shows = $db->GetAll( $res );
echo 'Results matching: "'.$search.'" ('.$db->GetCount($res).' result found)
';
if( $db->GetCount($res) > 0 )
{
foreach( $shows as $show )
{
$mirrors = explode( ';', $show['mirror_list'] );
echo $show['data'] . ' - ' . preg_replace( '/('.$search.')/i', '${1}', $show['filename'] );
$i = 0;
foreach( $mirrors as $mirror )
{
if( $mirror )
{
$i++;
echo ' ['.$i.']';
}
}
echo '
';
}
}
$db->Disconnect();
}