Ето и системата
add.php
index.php
conf.php
db.sql
add.php
Код:
<?php include('conf.php'); ?>
<?php
if(isset($_POST['izprati'])){
$ime = $_POST['ime'];
$ime = htmlspecialchars($ime);
$ime = strip_tags($ime);
$novina = $_POST['novina'];
$snimka = $_POST['snimka'];
$snimka = htmlspecialchars($snimka);
$snimka = strip_tags($snimka);
$iztochnik = $_POST['iztochnik'];
$iztochnik = htmlspecialchars($iztochnik);
$iztochnik = strip_tags($iztochnik);
$author = $_POST['author'];
$author = htmlspecialchars($author);
$author = strip_tags($author);
if($ime== NULL){ //proverqvame dali sa prazni poletata
echo "Попълнете име!";
exit;
}
elseif($novina==NULL){
echo "Попълнете описание!";
exit;
}
else {
$zapis = mysql_query("INSERT INTO news(ime, novina, snimka, iztochnik, author) VALUES('$ime','$novina','$snimka','$iztochnik','$author')");
echo "Новината е добавена!";
}
}
?>
<form action="" method="POST">
Заглавие:<br><input type="text" class="textbox" name="ime" size="80">
<br><br>
Снимка:<br><input type="text" class="textbox" name="snimka" size="80">
<br><br>
Новина:<br><textarea name="novina" class="ckeditor" name="editor1" class="textbox" cols="95" rows="20"></textarea>
<br><br>
Източник:<br><input type="text" class="textbox" name="iztochnik">
<br><br>
Автор:<br><input type="text" class="textbox" name="author">
<br><br>
<input type="submit" name="izprati" value="Добави!">
</form>index.php
Код:
<?php
include ('conf.php'); //???????? config ?????
$our = mysql_query("SELECT * FROM news ORDER BY id DESC LIMIT 10"); //???????? ??? ???? ?? ?????? ?? ??
while($r=mysql_fetch_array($our)){
if (strlen($r['nowina'])>$broi)
{$totchki='...';}
else
{$totchki='';}
$kratko = substr($r['nowina'],0,$broi); //?????? ???????? ?? ?? ? ?????? ?? ??????? ???? ???????
}
/* ?????????? ?? ????? ????????? ?? ?? ???????? ?? ???????? */
$pp = "10";
// ???????? ??????? ????? ?????? ?? ????????
$table = "news";
$total = mysql_result(mysql_query("SELECT COUNT(id) FROM $table"),0);
$numofpages = $total / $pp;
if (!isset($_GET['page'])) {
$page = 1;
}
else {
$page = $_GET['page'];
}
$limitvalue = $page * $pp - ($pp);
/* ???????? ????????, ? ???? ?????? ?? ???????? ???? [username] */
$query = "SELECT * FROM $table ORDER BY id DESC LIMIT $limitvalue, $pp";
$result = mysql_query($query);
while($r=mysql_fetch_array($result))
{
echo "<div class='tbtitle'>$r[ime]<br></div>";
echo "Upload: $r[awtor]<br><br>";
echo "Снимка: $r[snimka]<br><br>";
echo "Източник: $r[iztochnik]<br><br>";
}
function per_page($link, $offset) {
global $numofpages, $page;
$numofpages = round($numofpages);
$pagesstart = round($page-$offset);
$pagesend = round($page+$offset);
/* ????????? ?? ??????? « ?? ???????? ???????? */
if ($page != "1" && round($numofpages) != "0") {
echo str_replace("%page", round($page-1), '<a href="'.$link.'"><font face="Trebuchet MS">«</font></a> ');
}
for($i = 1; $i <= $numofpages; $i++) {
if ($pagesstart <= $i && $pagesend >= $i) {
if ($i == $page) {
echo "<b>[$i]</b> ";
}
else {
echo str_replace("%page", "$i", '<a href="'.$link.'">'.$i.'</a> '); //????????? ?? ??????????
}
}
}
if (round($numofpages) == "0") {
echo "[$i]";
}
/* ????????? ?? ??????? » ?? ???????? ???????? */
if ($page != round($numofpages) && round($numofpages) != "0") {
echo str_replace("%page", round($page+1), '<a href="'.$link.'"><font face="Trebuchet MS">»</font></a>');
}
}
/* ????????? ?? ????? ???? ???????? ? ????? ?? ???????? */
echo '<br>';
echo '???? ????????: '.round($numofpages).'<br>';
per_page("?page=%page", "5");
?>conf.php
Код:
<?php
$hostname = "mysql7.000webhost.com";
$dbuser = "ain";
$dbpass = "";
$dbname = "a_new";
$connect = mysql_connect($hostname, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname,$connect);
mysql_query("SET NAMES utf8");
mysql_query("SET CHARACTERS utf8");
?>db.sql
Код:
CREATE TABLE `news` ( `nowina` text NOT NULL, `ime` varchar(255) NULL, `awtor` varchar(255) NULL, `id` int(11) NOT NULL auto_increment,`iztochnik` varchar(255) NULL, `snimka` varchar(255) NULL, PRIMARY KEY (`id`) );