");
echo(" Lütfen aranacak anahtarı giriniz.
\n");
echo("  ");
echo(" |
");
exit(1);
}
$query = "select * from eserler";
$sub_query = " where ";
$control = 0;
if ($name != "") {
if ($control)
$sub_query .= $select . "(yazar like '%" . TLower($name) . "%' or yazar like '%" . TUpper($name) . "%') ";
else
$sub_query .= "(yazar like '%" . TLower($name) . "%' or yazar like '%" . TUpper($name) . "%') ";
$control = 1;
}
if ($ceviren != "") {
if ($control)
$sub_query .= $select . "(ceviren like '%" . TLower($ceviren) . "%' or ceviren like '%" . TUpper($ceviren) . "%') ";
else
$sub_query .= "(ceviren like '%" . TLower($ceviren) . "%' or ceviren like '%" . TUpper($ceviren) . "%') ";
$control = 1;
}
if ($eser != "") {
if ($control)
$sub_query .= $select . "(eseradi like '%" . TLower($eser) . "%' or eseradi like '%" . TUpper($eser) . "%') ";
else
$sub_query .= "(eseradi like '%" . TLower($eser) . "%' or eseradi like '%" . TUpper($eser) . "%') ";
$control = 1;
}
if ($yer != "") {
if ($control)
$sub_query .= $select . "(yayinyeri like '%" . TLower($yer) . "%' or yayinyeri like '%" . TUpper($yer) . "%') ";
else
$sub_query .= "(yayinyeri like '%" . TLower($yer) . "%' or yayinyeri like '%" . TUpper($yer) . "%') ";
$control = 1;
}
if ($tarih != "") {
if ($control)
$sub_query .= $select . "(yayintarihi like '%" . TLower($tarih) . "%' or yayintarihi like '%" . TUpperChar($tarih) . "%') ";
else
$sub_query .= "(yayintarihi like '%" . TLower($tarih) . "%' or yayintarihi like '%" . TUpperChar($tarih) . "%') ";
$control = 1;
}
if ($yayinci != "") {
if ($control)
$sub_query .= $select . "(kurum like '%" . TLower($yayinci) . "%' or kurum like '%" . TUpper($eser) . "%') ";
else
$sub_query .= "(kurum like '%" . TLower($yayinci) . "%' or kurum like '%" . TUpper($eser) . "%') ";
$control = 1;
}
$query1 = $query . $sub_query;
if ($tur == "Hepsi") {
$query = $query . $sub_query . "limit $start, $step";
}
else {
$query = $query . $sub_query . "and tur='$tur' limit $start, $step";
$query1 = $query1 . "and tur='$tur'";
}
$result = mysql_query($query1) or die("Cannot execute query");
$num_results = mysql_num_rows($result);
mysql_free_result($result);
// echo ("
query=$query |
");
if (!$num_results) {
echo(" ");
echo(" Arama sonucunda hiçbir kayıt bulunamamıştır.
\n");
echo(" ");
echo(" |
");
exit(1);
}
$result = mysql_query($query) or die("Cannot execute query");
echo(" | Arama sonucunda " .$num_results. " adet kayıt bulundu. \n |
");
echo(" | Sıra | Eser |
");
if (!isset($onum))
$onum = 0;
$i = $onum;
//while( $row = mysql_fetch_array($result, MYSQL_ASSOC) )
while( $row = mysql_fetch_row($result) )
{
echo ("");
else
echo(" bgcolor='#666699'>");
echo (" ".($i+1).". | ");
echo (" ");
$j = 0; // Tur (1. sutun) sutununu yazdirmamak icin
foreach ( $row as $col ) {
if ($j++)
echo $col;
}
echo (" | ");
++$i;
}
mysql_free_result($result);
mysql_close($dblink);
$onum = $i;
echo("\n");
echo("
\n");
echo("");
echo("
|
");
if ( $start == 0 ) {
echo("| | ");
}
if ( $start > 0 ) {
echo(" | ");
}
echo(" | ");
if ( ($start + $step) <= $num_results ) {
echo(" | ");
}
if ( ($start + $step) > $num_results ) {
echo(" | ");
}
echo("
");
echo("
