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 '%INTERN%' 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 '
';
echo '
';
$sql="SELECT * FROM publicatii WHERE tip like '%INTERN%' and an = 2017 ORDER BY tip ASC, luna, autor DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo '
' . $par . '. ' . ucwords(strtolower($sor["autor"])) . '
' . $sor["titlu"] . ', ' . $sor["revista"] . '
';
$par++;
}
echo '
';
$sql="SELECT * FROM publicatii WHERE tip like '%INTERN%' and an = 2016 ORDER BY tip ASC, luna, autor DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo '
' . $par . '. ' . ucwords(strtolower($sor["autor"])) . '
' . $sor["titlu"] . ', ' . $sor["revista"] . '
';
$par++;
}
echo '
';
$sql="SELECT * FROM publicatii WHERE tip like '%INTERN%' and an = 2015 ORDER BY tip ASC, luna, autor DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo '
' . $par . '. ' . ucwords(strtolower($sor["autor"])) . '
' . $sor["titlu"] . ', ' . $sor["revista"] . '
';
$par++;
}
echo '
';
$sql="SELECT * FROM publicatii WHERE tip like '%INTERN%' and an = 2014 ORDER BY tip ASC, luna, autor DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo '
' . $par . '. ' . ucwords(strtolower($sor["autor"])) . '
' . $sor["titlu"] . ', ' . $sor["revista"] . '
';
$par++;
}
echo '
';
$sql="SELECT * FROM publicatii WHERE tip like '%INTERN%' and an = 2013 ORDER BY tip ASC, luna, autor DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo '
' . $par . '. ' . ucwords(strtolower($sor["autor"])) . '
' . $sor["titlu"] . ', ' . $sor["revista"] . '
';
$par++;
}
echo '
';
$sql="SELECT * FROM publicatii WHERE tip like '%INTERN%' and an = 2012 ORDER BY tip ASC, luna, autor DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo '
' . $par . '. ' . ucwords(strtolower($sor["autor"])) . '
' . $sor["titlu"] . ', ' . $sor["revista"] . '
';
$par++;
}
echo '
';
$sql="SELECT * FROM publicatii WHERE tip like '%INTERN%' and an = 2011 ORDER BY tip ASC, luna, autor DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo '
' . $par . '. ' . ucwords(strtolower($sor["autor"])) . '
' . $sor["titlu"] . ', ' . $sor["revista"] . '
';
$par++;
}
echo '
';
$sql="SELECT * FROM publicatii WHERE tip like '%INTERN%' and an = 2010 ORDER BY tip ASC, luna, autor DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo '
' . $par . '. ' . ucwords(strtolower($sor["autor"])) . '
' . $sor["titlu"] . ', ' . $sor["revista"] . '
';
$par++;
}
echo '
';
$sql="SELECT * FROM publicatii WHERE tip like '%INTERN%' and an = 2009 ORDER BY tip ASC, luna, autor DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo '
' . $par . '. ' . ucwords(strtolower($sor["autor"])) . '
' . $sor["titlu"] . ', ' . $sor["revista"] . '
';
$par++;
}
echo '
';
$sql="SELECT * FROM publicatii WHERE tip like '%INTERN%' and an = 2008 ORDER BY tip ASC, luna, autor DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo '
' . $par . '. ' . ucwords(strtolower($sor["autor"])) . '
' . $sor["titlu"] . ', ' . $sor["revista"] . '
';
$par++;
}
echo '
';
$sql="SELECT * FROM publicatii WHERE tip like '%INTERN%' and an = 2007 ORDER BY tip ASC, luna, autor DESC, autor";
$result=mysql_query($sql);
$par=1;
while ($sor = mysql_fetch_array($result))
{
echo '
' . $par . '. ' . ucwords(strtolower($sor["autor"])) . '
' . $sor["titlu"] . ', ' . $sor["revista"] . '
';
$par++;
}
echo '
