Система за новини с PHP

Автор: Break4y

addnews.php

<table width="300" height="10" border="1">
<tr><td><a href="index.php">Новини</a> | <a href="addnews.php">Добави новина</a> | <a href="newsadmin.php">АДМИН Панел</a></td></tr></table>
<form action="" method="post">
Име на новина: <input type="text" name="name" />
<br />
Цялата новина: <input type="text" name="news">
<br />
<input type="submit" name="submit" value="Добави" />
</form>
<?php
if (isset($_POST["submit"])) {
//настройки за база данни
$dbhost = "db host";
$dbuser = "db user";
$dbpass = "db pass";
$dbname = "db name";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());
if (!empty($_POST["name"])) $name = htmlspecialchars($_POST["name"]);
else $errMsg = "Не сте въвели име на новината!<br />";
if (!empty($_POST["news"])) $news = htmlspecialchars($_POST["news"]);
else $errMsg = "Не сте въвели новината!<br />";
if (empty($errMsg)) {
$insert = mysql_query("INSERT INTO news(name, news) VALUES('$name', '$news')")or die(mysql_error());
echo 'Новината е добавена успешно! <a href="index.php">Новини</a>';
} else echo $errMsg;
mysql_close();
}
?>

deletenews.php

<table width="300" height="10" border="1">
<tr><td><a href="index.php">Новини</a> | <a href="addnews.php">Добави новина</a> | <a href="newsadmin.php">АДМИН Панел</a></td></tr></table>

<?PHP
$dbhost = "db host";
$dbuser = "db user";
$dbpass = "db pass";
$dbname = "db name";
$connection = mysql_connect($dbhost, $dbuser, $dbpass) or die("Сайтът не може да се свърже към базата данни1");
$db = mysql_select_db($dbname,$connection)or die("Сайтът не може да се свърже към базата данни2");
$id = $_GET['id'];
if(!$id){echo"Трябва да изберете новина която искате да изтриете!";}else{
$result = mysql_query("DELETE FROM news WHERE id='$id' ",$connection);
echo "Успешно изтрихте новина.<br><a href='index.php'>< Новини </a>";}
?>

editnews.php

<table width="300" height="10" border="1">
<tr><td><a href="index.php">Новини</a> | <a href="addnews.php">Добави новина</a> | <a href="newsadmin.php">АДМИН Панел</a></td></tr></table>

<?php
//настройки за база данни
$dbhost = "db host";
$dbuser = "db user";
$dbpass = "db pass";
$dbname = "db name";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());

if ($_POST['name'] && $_POST['news'])
mysql_query("REPLACE INTO news VALUES(".intval ($_GET['tid']).",'".$_POST['name']."','".$_POST['news']."')");

$select = mysql_query("SELECT * FROM news WHERE id=".intval($_GET['tid']))or die(mysql_error());
if (mysql_num_rows($select)) $red = mysql_fetch_array($select);

mysql_close();
?>

<form action="<?php echo($_SERVER['PHP_SELF']."?tid=".$_GET['tid']);?>" method="post">
Име на новина: <input type="text" name="name" value="<?php echo($red['name']);?>" />
<br />
Цялата новина: <input type="text" name="news" value="<?php echo($red['news']);?>" />
<br />
<input type="submit" name="submit" value="Редактирай" />
</form>

newsadmin.php

<table width="300" height="10" border="1">
<tr><td><a href="index.php">Новини</a> | <a href="addnews.php">Добави новина</a> | <a href="newsadmin.php">АДМИН Панел</a></td></tr></table>

<?php
//настройки за база данни
$dbhost = "db host";
$dbuser = "db user";
$dbpass = "db pass";
$dbname = "db name";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());


$select = mysql_query("SELECT * FROM news")or die(mysql_error());
if (mysql_num_rows($select))
{
while($red = mysql_fetch_array($select))
{
?>
<?php echo $red['name'];?> - <a href="editnews.php?tid=<?php echo $red['id']; ?>">Редактиране</a> | <a href="deletenews.php?id=<?php echo $red['id']; ?>">Изтрий</a><br>
<?php
}
}
mysql_close();
?>

index.php

<table width="300" height="10" border="1">
<tr><td><a href="index.php">Новини</a> | <a href="addnews.php">Добави новина</a> | <a href="newsadmin.php">АДМИН Панел</a></td></tr></table>
<?php
//настройки за база данни
$dbhost = "db host";
$dbuser = "db user";
$dbpass = "db pass";
$dbname = "db name";
$conn = mysql_connect($dbhost, $dbuser, $dbpass)or die(mysql_error());
mysql_select_db($dbname, $conn)or die(mysql_error());

$select = mysql_query("SELECT * FROM news ORDER BY id DESC")or die(mysql_error());
$num = mysql_num_rows($select);
for ($i=0;$i<$num;$i++) {
$name = mysql_result($select, $i, "name");
$news = mysql_result($select, $i, "news");
echo '<table width="300" height="10" border="0">';
echo '<tr><td>Име на новина: <b>'.$name.'</b></td>
<tr><td>Новината: <b>'.$news.'</b></td></tr>
<br /><hr>';
}

mysql_close();
?>

mysql таблица

CREATE TABLE `news` (
`id` INT(8) NOT NULL auto_increment,
`name` VARCHAR(255) NOT NULL,
`news` VARCHAR(255) NOT NULL,
PRIMARY KEY(`id`)
);