Rezultat";
$find=$_POST['valoare'];
//If they did not enter a search term we give them an error
if ($find == "")
{
echo "Nu aţi introdus valoare
";
exit;
}
include("dbconn.php");
$find = strip_tags($find);
$find = trim ($find);
//Now we search for our search term, in the field the user specified
$data = mysql_query("SELECT * FROM publicatii WHERE autor LIKE '%$find%' and tip LIKE '%BREVET%' order by data");
$par=1;
while ($sor = mysql_fetch_array($data))
{
echo ' ' . $par . '. ' . ucwords(strtolower($sor["autor"])) . '
' . $sor["titlu"] . ' , ' . $sor["revista"] . '
';
$par++;
?>
Ne pare rău, nu am găsit înregistrare cu nume introdus de d-voastră!
";
}
}
else{
echo '
2017
';
$sql="SELECT * FROM publicatii WHERE tip like '%BREVET%' and an = 2017 ORDER BY luna DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo ' ' . $par . '. ' . $sor["titlu"] . ' ' . $sor["revista"] . '
' . ucwords(strtolower($sor["autor"])) . '
';
$par++;
}
echo '
2016
';
$sql="SELECT * FROM publicatii WHERE tip like '%BREVET%' and an = 2016 ORDER BY luna DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo ' ' . $par . '. ' . $sor["titlu"] . ' ' . $sor["revista"] . '
' . ucwords(strtolower($sor["autor"])) . '
';
$par++;
}
echo '
2015
';
$sql="SELECT * FROM publicatii WHERE tip like '%BREVET%' and an = 2015 ORDER BY luna DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo ' ' . $par . '. ' . $sor["titlu"] . ' ' . $sor["revista"] . '
' . ucwords(strtolower($sor["autor"])) . '
';
$par++;
}
echo '
2014
';
$sql="SELECT * FROM publicatii WHERE tip like '%BREVET%' and an = 2014 ORDER BY luna DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo ' ' . $par . '. ' . $sor["titlu"] . ' ' . $sor["revista"] . '
' . ucwords(strtolower($sor["autor"])) . '
';
$par++;
}
echo '
2013
';
$sql="SELECT * FROM publicatii WHERE tip like '%BREVET%' and an = 2013 ORDER BY luna DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo ' ' . $par . '. ' . $sor["titlu"] . ' ' . $sor["revista"] . '
' . ucwords(strtolower($sor["autor"])) . '
';
$par++;
}
echo '
2012
';
$sql="SELECT * FROM publicatii WHERE tip like '%BREVET%' and an = 2012 ORDER BY luna DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo ' ' . $par . '. ' . $sor["titlu"] . ' ' . $sor["revista"] . '
' . ucwords(strtolower($sor["autor"])) . '
';
$par++;
}
echo '
2011
';
$sql="SELECT * FROM publicatii WHERE tip like '%BREVET%' and an = 2011 ORDER BY luna DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo ' ' . $par . '. ' . $sor["titlu"] . ' ' . $sor["revista"] . '
' . ucwords(strtolower($sor["autor"])) . '
';
$par++;
}
echo '
2010
';
$sql="SELECT * FROM publicatii WHERE tip like '%BREVET%' and an = 2010 ORDER BY luna DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo ' ' . $par . '. ' . $sor["titlu"] . ' ' . $sor["revista"] . '
' . ucwords(strtolower($sor["autor"])) . '
';
$par++;
}
echo '
2009
';
$sql="SELECT * FROM publicatii WHERE tip like '%BREVET%' and an = 2009 ORDER BY luna DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo ' ' . $par . '. ' . $sor["titlu"] . ' ' . $sor["revista"] . '
' . ucwords(strtolower($sor["autor"])) . '
';
$par++;
}
echo '
2008
';
$sql="SELECT * FROM publicatii WHERE tip like '%BREVET%' and an = 2008 ORDER BY luna DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo ' ' . $par . '. ' . $sor["titlu"] . ' ' . $sor["revista"] . '
' . ucwords(strtolower($sor["autor"])) . '
';
$par++;
}
echo '
2007
';
$sql="SELECT * FROM publicatii WHERE tip like '%BREVET%' and an = 2007 ORDER BY luna DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo ' ' . $par . '. ' . $sor["titlu"] . ' ' . $sor["revista"] . '
' . ucwords(strtolower($sor["autor"])) . '
';
$par++;
}
?>
