web-touristСистема за новини – Част Четвърта
следва файл mounth.php
<?php include ("config.php"); ?>
<!--
Web-Journal By jooorooo@data.bg
-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo $CHARSET ?>">
<title><?php echo $TITLE ?></title>
<LINK href="css/css.css" type=text/css rel=stylesheet>
</head>
<body>
<table width="900" border="0" cellspacing="3" cellpadding="0">
<tr>
<td><img src="img/logo.jpg" width="180" height="60"></td>
<td align="center"></td>
</tr>
<tr>
<td colspan="2">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class=text height="19" background="img/h_gr2.gif"> </td>
<td height="19" align="right" background="img/h_gr2.gif" class=text> </td>
</tr>
<tr>
<td align="right" colspan="2" class="nav" id="lineLRBs">
<table cellpadding="10" cellspacing="0" width="100%">
<tr>
<td width="55%"> </td>
<td align="right" width="45%">
<form method="GET" action="search.php">
<table cellpadding="0" cellspacing="0" width="300px" >
<tr>
<td align="right" width="200px"><input class=commentbox type="text" name="Search" size="30"></td>
<td align="right" width="100px"><input class=commentbox type="submit" value="<?php echo $SEARCH ?>" name="Submit"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="15" colspan="2"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top" width="199">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class=text height="19" background="img/h_gr2.gif"> <?php echo $MENU ?></td>
</tr>
<tr>
<td id="lineLRBs" class="nav"> <strong><a href="index.php"><?php echo $HOME ?></a></strong></td>
</tr>
<tr>
<td id="lineLRBs" class="nav"> <strong><a href="archive.php"><?php echo $ARCHIVE ?></a></strong></td>
</tr>
</table>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class=text height="19" background="img/h_gr2.gif"> <?php echo $CATEGORIES ?></td>
</tr>
<?php
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$query="SELECT * FROM cat ORDER BY cats ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$cats=mysql_result($result,$i,"cats");
echo "<tr><td id=lineLRBs class=nav> <strong><a href=catview.php?cats=$cats>$cats</a></strong></td></tr>";
$i++;
}
?>
</table>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class=text height="19" background="img/h_gr2.gif"> <?php echo $ANKETA ?></td>
</tr>
<tr>
<td id="lineLRBs" class="nav">
<?php
$ip= getenv("REMOTE_ADDR");
$sql="SELECT * FROM vaprosi ORDER BY v_id DESC LIMIT 0 , 1";
$rez=mysql_query($sql,$link);
$red=mysql_fetch_array($rez);
$vapros=$red['vapros'];
$v_id=$red['v_id'];
$sql1="SELECT * FROM ip WHERE `uip` LIKE '$ip' AND `v_id` LIKE '$v_id' ";
$rez1=mysql_query($sql1,$link);
$chekip=mysql_num_rows($rez1);
$sql1="SELECT * FROM ip WHERE `v_id` LIKE '$v_id'";
$rez1=mysql_query($sql1,$link);
$broiip=mysql_num_rows($rez1);
echo $vapros."<br /><br />";
if($chekip==0){
$sql="SELECT * FROM otgovori WHERE v_id LIKE '$v_id'";
$rez=mysql_query($sql,$link);
echo"<form action=\"sendvote.php\" method=\"POST\" >";
while($red=mysql_fetch_array($rez)){
echo "<input type=\"radio\" name=\"vote\" value=\"".$red['o_id']."\" />".$red['otgovor']."<br />";
}
echo"<center><br><input type=\"submit\" value=\"Гласувай\" /></center></form>";
}
else{
$sql="SELECT * FROM otgovori WHERE v_id LIKE '$v_id'";
$rez=mysql_query($sql,$link);
while($red=mysql_fetch_array($rez)){
echo "<table width=100%><tr>
<td width=130px>".$red['otgovor']."</td>
<td width=30px>".$red['rezultat']."</td>
</tr>
</table>";
}
}
mysql_close($link);
?>
</td>
</tr>
</table>
</td>
<td valign="top" width="692">
<table width=100% border=0 cellpadding=0 cellspacing=0>
<tr>
<td class=text height=19 background=img/h_gr2.gif> <strong>Архив:</strong></td>
</tr>
<tr>
<td>
<table id=lineLRBs class=nav border=0 cellpadding=0 cellspacing=0 width=100%>
<?php
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$godina = $_GET['godina'];
$mesec = $_GET['mesec'];
$archive="SELECT DISTINCT godina,mesec,den FROM news WHERE godina = '$godina' AND mesec = '$mesec' ORDER BY godina DESC";
$godinass=mysql_query($archive);
$num=mysql_numrows($godinass);
mysql_close();
$i=0;
while ($i < $num) {
$mesec=mysql_result($godinass,$i,"mesec");
$godina=mysql_result($godinass,$i,"godina");
$den=mysql_result($godinass,$i,"den");
echo "<tr>
<td height=25px id=lineBottom width=33%> Ден: <strong><a href=day.php?godina=$godina&mesec=$mesec&den=$den>$den</a></strong></td>
</tr>";
$i++;
}
?>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
</body>
</html>файл search.php
<?php include ("config.php"); ?>
<!--
Web-Journal By jooorooo@data.bg
-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo $CHARSET ?>">
<title><?php echo $TITLE ?></title>
<LINK href="css/css.css" type=text/css rel=stylesheet>
<style type="text/css">
.hilite {color: #f00; font-weight: bold;}
</style>
</head>
<body>
<table width="900" border="0" cellspacing="3" cellpadding="0">
<tr>
<td><img src="img/logo.jpg" width="180" height="60"></td>
<td align="center"></td>
</tr>
<tr>
<td colspan="2">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class=text height="19" background="img/h_gr2.gif"> </td>
<td height="19" align="right" background="img/h_gr2.gif" class=text> </td>
</tr>
<tr>
<td align="right" colspan="2" class="nav" id="lineLRBs">
<table cellpadding="10" cellspacing="0" width="100%">
<tr>
<td width="55%"> </td>
<td align="right" width="45%">
<form method="GET" action="search.php">
<table cellpadding="0" cellspacing="0" width="300px" >
<tr>
<td align="right" width="200px"><input class=commentbox type="text" name="Search" size="30"></td>
<td align="right" width="100px"><input class=commentbox type="submit" value="<?php echo $SEARCH ?>" name="search"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="15" colspan="2"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top" width="199">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class=text height="19" background="img/h_gr2.gif"> <?php echo $MENU ?></td>
</tr>
<tr>
<td id="lineLRBs" class="nav"> <strong><a href="index.php"><?php echo $HOME ?></a></strong></td>
</tr>
<tr>
<td id="lineLRBs" class="nav"> <strong><a href="archive.php"><?php echo $ARCHIVE ?></a></strong></td>
</tr>
</table>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class=text height="19" background="img/h_gr2.gif"> <?php echo $CATEGORIES ?></td>
</tr>
<?php
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$query="SELECT * FROM cat ORDER BY cats ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$cats=mysql_result($result,$i,"cats");
echo "<tr><td id=lineLRBs class=nav> <strong><a href=catview.php?cats=$cats>$cats</a></strong></td></tr>";
$i++;
}
?>
</table>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class=text height="19" background="img/h_gr2.gif"> <?php echo $ANKETA ?></td>
</tr>
<tr>
<td id="lineLRBs" class="nav">
<?php
$ip= getenv("REMOTE_ADDR");
$sql="SELECT * FROM vaprosi ORDER BY v_id DESC LIMIT 0 , 1";
$rez=mysql_query($sql,$link);
$red=mysql_fetch_array($rez);
$vapros=$red['vapros'];
$v_id=$red['v_id'];
$sql1="SELECT * FROM ip WHERE `uip` LIKE '$ip' AND `v_id` LIKE '$v_id' ";
$rez1=mysql_query($sql1,$link);
$chekip=mysql_num_rows($rez1);
$sql1="SELECT * FROM ip WHERE `v_id` LIKE '$v_id'";
$rez1=mysql_query($sql1,$link);
$broiip=mysql_num_rows($rez1);
echo $vapros."<br /><br />";
if($chekip==0){
$sql="SELECT * FROM otgovori WHERE v_id LIKE '$v_id'";
$rez=mysql_query($sql,$link);
echo"<form action=\"sendvote.php\" method=\"POST\" >";
while($red=mysql_fetch_array($rez)){
echo "<input type=\"radio\" name=\"vote\" value=\"".$red['o_id']."\" />".$red['otgovor']."<br />";
}
echo"<center><br><input type=\"submit\" value=\"Гласувай\" /></center></form>";
}
else{
$sql="SELECT * FROM otgovori WHERE v_id LIKE '$v_id'";
$rez=mysql_query($sql,$link);
while($red=mysql_fetch_array($rez)){
echo "<table width=100%><tr>
<td width=130px>".$red['otgovor']."</td>
<td width=30px>".$red['rezultat']."</td>
</tr>
</table>";
}
}
mysql_close($link);
?>
</td>
</tr>
</table>
</td>
<td valign="top" width="692">
<?php
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$broinastranica = 10;
$pageNum = 1;
if(isset($_POST['Search']))
{
$tarsene = $_POST['Search'];
} elseif (isset($_GET['Search'])){
$tarsene = $_GET['Search'];
}
if(isset($_POST['Search']))
{
$keywords = explode(" ", $tarsene);
}
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$query = "SELECT COUNT(id_news) AS numrows FROM news WHERE title LIKE '%$keywords%' OR newstext LIKE '%$keywords%'";
$result = mysql_query($query) or die('Error, query failed1');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
if ($numrows<1)
{echo "<center><b>Няма намерени резултати за ".$search."</b></center><br><br>";}
$redove = ($pageNum - 1) * $broinastranica;
$querys = " SELECT * FROM news WHERE title LIKE '%$tarsene%' OR newstext LIKE '%$tarsene%' ORDER BY id_news DESC LIMIT $redove, $broinastranica";
$results = mysql_query($querys) or die('Error, query failed2');
while($row = mysql_fetch_array($results))
{
$id_news=$row[id_news];
$title=$row[title];
$cats=$row[cats];
$chas=$row[chas];
$minuti=$row[minuti];
$den=$row[den];
$mesec=$row[mesec];
$godina=$row[godina];
$newstext=$row[newstext];
$start=strlen($str);
$text=substr($newstext,$start ,$broinews);
echo "<table width=100% border=0 cellpadding=0 cellspacing=0>
<tr>
<td class=text height=19 background=img/h_gr2.gif> <strong><a href=fullnews.php?id_news=".$id_news.">".$title."</a></strong></td>
</tr>
<tr>
<td>
<table id=lineLRBs class=nav border=0 cellpadding=0 cellspacing=0 width=100%>
<tr>
<td height=25px id=lineBottom width=33%> Категория: <strong><a href=catview.php?cats=".$cats.">".$cats."</a></strong></td>
<td height=25px id=lineBottom width=33%> </td>
<td height=25px id=lineBottom width=34%> <strong>".$chas.":".$minuti." - ".$den."/".$mesec."/.".$godina."</strong></td>
</tr>
<tr>
<td id=lineBottom width=100% colspan=3><div><table cellpadding=5 width=100%>
<tr>
<td width=100%><p align=justify>$text...</p></td>
</tr>
</table></div></td>
</tr>
<tr>
<td height=25px width=33%> <strong><a href=addcomment.php?id_news=$id_news>Коментари</a></strong></td>
<td height=25px width=33%> </td>
<td height=25px width=34%> <a href=fullnews.php?id_news=".$id_news."><strong>Прочети цялата новина</strong></a></td>
</tr>
</table>";
echo "<br>";
}
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
echo '<center><font face="Tahoma" style="font-size: 8pt">Страници:</font> ';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= "<font face=\"Tahoma\" style=\"font-size: 8pt\">$page</font>";
}
else
{
$nomeranastranici .= " <font face=\"Tahoma\" style=\"font-size: 8pt\"><a href=\"$self?page=$page\">$page</a> </font>";
}
}
// създаване на ликовете [предишна] [следваща]
// както и линковете [първа] и [последна]
if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = "<font face=\"Tahoma\" style=\"font-size: 8pt\"><a href=\"$self?page=$page\">[<<<<<]</a> </font>";
$parva = "<font face=\"Tahoma\" style=\"font-size: 8pt\"><a href=\"$self?page=1\">[първа]</a> </font>";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = "<font face=\"Tahoma\" style=\"font-size: 8pt\"><a href=\"$self?page=$page\">[>>>>>]</a> </font>";
$posledna = "<font face=\"Tahoma\" style=\"font-size: 8pt\"><a href=\"$self?page=$maxPage\">[последна]</a></font>";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
// показваме всички страници
echo $parva . $predishna . $nomeranastranici . $sledvashta . $posledna;
?>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
</body>
</html>файл sendvote.php – служи за анкетата. която е от урок от WT с малки корекции
<?php
$vote=$_POST['vote'];//Присвояваме стойноста на въпроса
$ip= getenv("REMOTE_ADDR"); //Взимаме ИП адреса на потребителя
include('config.php');//Инклудваме конфиг файла
$sql="SELECT * FROM otgovori WHERE o_id LIKE '$vote'";//Селектираме от таблицата с отговори отговора които съответства на $vote ( на изпратения отговор )
$rez=mysql_query($sql,$link);
$red=mysql_fetch_array($rez);
$v_id=$red['v_id'];
$tvote=$red['rezultat'];
$tvote++ ;
$sql1="SELECT * FROM ip WHERE `uip` LIKE '$ip' AND `v_id` LIKE '$v_id' ";//Проверяваме дали този потребител вече не е гласувал
$rez1=mysql_query($sql1,$link);
$chekip=mysql_num_rows($rez1);//Проверяваме дали този потребител вече не е гласувал
//Ако не е гласувал записваме в полето с ИД които сме приели от $vote стоиноста на $tvote
if($chekip==0){
$sql="UPDATE otgovori SET rezultat='$tvote' WHERE o_id='$vote'";
$rez=mysql_query($sql,$link);
$sql="INSERT ip (v_id , uip) VALUES ('$v_id', '$ip')";
$rez=mysql_query($sql,$link);
}
//Ако потребителя вече е гласувал ...
else {echo "Вие вече сте гласували!";}
mysql_close($link);
//Пренасочваме го към страницата от която идва
$refe=getenv("HTTP_REFERER");
header("Location: $refe");
?>
ето го и year.php
<?php include ("config.php"); ?>
<!--
Web-Journal By jooorooo@data.bg
-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo $CHARSET ?>">
<title><?php echo $TITLE ?></title>
<LINK href="css/css.css" type=text/css rel=stylesheet>
</head>
<body>
<table width="900" border="0" cellspacing="3" cellpadding="0">
<tr>
<td><img src="img/logo.jpg" width="180" height="60"></td>
<td align="center"></td>
</tr>
<tr>
<td colspan="2">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class=text height="19" background="img/h_gr2.gif"> </td>
<td height="19" align="right" background="img/h_gr2.gif" class=text> </td>
</tr>
<tr>
<td align="right" colspan="2" class="nav" id="lineLRBs">
<table cellpadding="10" cellspacing="0" width="100%">
<tr>
<td width="55%"> </td>
<td align="right" width="45%">
<form method="GET" action="search.php">
<table cellpadding="0" cellspacing="0" width="300px" >
<tr>
<td align="right" width="200px"><input class=commentbox type="text" name="Search" size="30"></td>
<td align="right" width="100px"><input class=commentbox type="submit" value="<?php echo $SEARCH ?>" name="Submit"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td height="15" colspan="2"> </td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top" width="199">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class=text height="19" background="img/h_gr2.gif"> <?php echo $MENU ?></td>
</tr>
<tr>
<td id="lineLRBs" class="nav"> <strong><a href="index.php"><?php echo $HOME ?></a></strong></td>
</tr>
<tr>
<td id="lineLRBs" class="nav"> <strong><a href="archive.php"><?php echo $ARCHIVE ?></a></strong></td>
</tr>
</table>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class=text height="19" background="img/h_gr2.gif"> <?php echo $CATEGORIES ?></td>
</tr>
<?php
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$query="SELECT * FROM cat ORDER BY cats ASC";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
$i=0;
while ($i < $num) {
$cats=mysql_result($result,$i,"cats");
echo "<tr><td id=lineLRBs class=nav> <strong><a href=catview.php?cats=$cats>$cats</a></strong></td></tr>";
$i++;
}
?>
</table>
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td class=text height="19" background="img/h_gr2.gif"> <?php echo $ANKETA ?></td>
</tr>
<tr>
<td id="lineLRBs" class="nav">
<?php
$ip= getenv("REMOTE_ADDR");
$sql="SELECT * FROM vaprosi ORDER BY v_id DESC LIMIT 0 , 1";
$rez=mysql_query($sql,$link);
$red=mysql_fetch_array($rez);
$vapros=$red['vapros'];
$v_id=$red['v_id'];
$sql1="SELECT * FROM ip WHERE `uip` LIKE '$ip' AND `v_id` LIKE '$v_id' ";
$rez1=mysql_query($sql1,$link);
$chekip=mysql_num_rows($rez1);
$sql1="SELECT * FROM ip WHERE `v_id` LIKE '$v_id'";
$rez1=mysql_query($sql1,$link);
$broiip=mysql_num_rows($rez1);
echo $vapros."<br /><br />";
if($chekip==0){
$sql="SELECT * FROM otgovori WHERE v_id LIKE '$v_id'";
$rez=mysql_query($sql,$link);
echo"<form action=\"sendvote.php\" method=\"POST\" >";
while($red=mysql_fetch_array($rez)){
echo "<input type=\"radio\" name=\"vote\" value=\"".$red['o_id']."\" />".$red['otgovor']."<br />";
}
echo"<center><br><input type=\"submit\" value=\"Гласувай\" /></center></form>";
}
else{
$sql="SELECT * FROM otgovori WHERE v_id LIKE '$v_id'";
$rez=mysql_query($sql,$link);
while($red=mysql_fetch_array($rez)){
echo "<table width=100%><tr>
<td width=130px>".$red['otgovor']."</td>
<td width=30px>".$red['rezultat']."</td>
</tr>
</table>";
}
}
mysql_close($link);
?>
</td>
</tr>
</table>
</td>
<td valign="top" width="692">
<table width=100% border=0 cellpadding=0 cellspacing=0>
<tr>
<td class=text height=19 background=img/h_gr2.gif> <strong>Архив:</strong></td>
</tr>
<tr>
<td>
<table id=lineLRBs class=nav border=0 cellpadding=0 cellspacing=0 width=100%>
<?php
mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$godina = $_GET['godina'];
$archive="SELECT DISTINCT mesec,godina FROM news WHERE godina = '$godina' ORDER BY godina DESC";
$godinass=mysql_query($archive);
$num=mysql_numrows($godinass);
mysql_close();
$i=0;
while ($i < $num) {
$mesec=mysql_result($godinass,$i,"mesec");
$godina=mysql_result($godinass,$i,"godina");
echo "<tr>
<td height=25px id=lineBottom width=33%> Месец: <strong><a href=mounth.php?godina=$godina&mesec=$mesec>$mesec</a></strong></td>
</tr>";
$i++;
}
?>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
</body>
</html>следва админ панела и CSS и JS файловете.
