Система за новини – Част Първа

започваме с ДБ:

CREATE TABLE `cat` (
`id_cat` int(10) NOT NULL auto_increment,
`cats` varchar(250) default NULL,
PRIMARY KEY (`id_cat`)
);



CREATE TABLE `comments` (
`id_com` int(50) NOT NULL auto_increment,
`id_news` varchar(250) NOT NULL,
`username` varchar(16) NOT NULL,
`email` varchar(70) NOT NULL,
`minuti` varchar(50) NOT NULL,
`chas` varchar(50) NOT NULL,
`den` varchar(50) NOT NULL,
`mesec` varchar(50) NOT NULL,
`godina` varchar(50) NOT NULL,
`ip` varchar(160) NOT NULL,
`comment` text NOT NULL,
`title` varchar(250) NOT NULL,
PRIMARY KEY (`id_com`)
);


CREATE TABLE `ip` (
`ip_id` int(11) NOT NULL auto_increment,
`v_id` varchar(10) NOT NULL,
`uip` varchar(250) NOT NULL,
PRIMARY KEY (`ip_id`)
);


CREATE TABLE `news` (
`id_news` int(50) NOT NULL auto_increment,
`title` varchar(250) default NULL,
`cats` varchar(250) default NULL,
`newstext` text,
`minuti` varchar(50) default NULL,
`chas` varchar(50) default NULL,
`den` varchar(50) default NULL,
`mesec` varchar(50) default NULL,
`godina` varchar(50) default NULL,
PRIMARY KEY (`id_news`)
);


CREATE TABLE `otgovori` (
`o_id` int(11) NOT NULL auto_increment,
`v_id` varchar(5) NOT NULL,
`otgovor` varchar(250) NOT NULL,
`rezultat` varchar(10) NOT NULL,
PRIMARY KEY (`o_id`)
);


CREATE TABLE `vaprosi` (
`v_id` int(11) NOT NULL auto_increment,
`vapros` varchar(250) NOT NULL,
PRIMARY KEY (`v_id`)
);

следващия файл е config.php

<?php
//server connfigure
$server = "localhost";
$dbusername = "ime";
$dbpassword = "parola";
$db_name = "db";

//anketa connfigure

$link=mysql_connect($server,$dbusername,$dbpassword);
$db=mysql_select_db($db_name);

//site connfigure
$TITLE = "Новини";
$TITLEADMIN = "Admin";
$CHARSET = "windows-1251";
$SEARCH = "Търсене";
$MENU = "Меню";
$HOME = "Начало";
$ARCHIVE = "Архив";
$CATEGORIES = "Категории";
$NEWS = "Новини:";
$ANKETA = "Анкета";
$ADDCOMMENT = "Добави коментар";

//search configure
$tarsene = $_GET[Search];

//settings coment

$broicom = "250"; // broi simwoli na komentara
$broinastranicacom = "10"; //broi komentari na stranica


?>

ето го и index.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">

<?php


mysql_connect($server, $dbusername, $dbpassword)or die("Сайтът не може да се свърже към базата данни");
@mysql_select_db($db_name) or die("Грешна база данни");
$jor="SELECT * FROM news ORDER BY id_news DESC LIMIT 0,10";
$roj=mysql_query($jor);

$num=mysql_numrows($roj);

mysql_close();

$i=0;
while ($i < $num) {

$id_news=mysql_result($roj,$i,"id_news");
$title=mysql_result($roj,$i,"title");
$chas=mysql_result($roj,$i,"chas");
$minuti=mysql_result($roj,$i,"minuti");
$den=mysql_result($roj,$i,"den");
$mesec=mysql_result($roj,$i,"mesec");
$godina=mysql_result($roj,$i,"godina");
$cats=mysql_result($roj,$i,"cats");
$newstext=mysql_result($roj,$i,"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>";
$i++;
}

?>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="2"> </td>
</tr>
</table>
</body>
</html>

Следете частите да не пропуснете някоя 🙂