Имам проблем с колацията при писането на новини....
Ето всичко :
Таблицата "news"
index.php
addnews.php
news.php
editnews2.php
Моля помогнете
Ето всичко :
Таблицата "news"
Код:
CREATE TABLE `news` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(60) character set latin1 NOT NULL,
`text` text character set latin1 NOT NULL,
`author` varchar(11) character set latin1 NOT NULL default 'Admin',
PRIMARY KEY (`id`),
FULLTEXT KEY `text` (`text`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 COLLATE=cp1251_bulgarian_ci AUTO_INCREMENT=28 ;
index.php
Код:
<?php include("check.php");
if($_GET['a']) {
$page = htmlspecialchars($_GET['a']);
include("".$page.".php"); } else {
include("news.php"); } ?>
addnews.php
Код:
<?
if(isset($_POST['submit'])) {
$namen = htmlspecialchars($_POST['name']);
$text = htmlspecialchars($_POST['text']);
$query = "INSERT INTO `news` (`name` , `text`) VALUES ('$namen', '$text')";
if(mysql_query($query)) { echo 'OK'; } else { echo 'Грешка'; }}
?>
<script type="text/javascript">
function openPopup(url,width,height){
window.open(url,'popup','toolbar=0,location=0,directories=0, statusbar=0,menubar=0,scrollbars=0,resizable=0,width='+width+',height='+height);
}
</script><?php
$link = mysql_connect("localhost", "**", "**");
mysql_select_db("**", $link);
$query = mysql_query("SELECT * FROM `news` ORDER BY id DESC");
if(mysql_num_rows($query)==0){
echo "Няма добавени новини!";
}
else {
while ($r = mysql_fetch_array($query)){
extract($r);
$text = substr($text,0,10);
echo '<tr>';
echo '<td class="ip"><div align="center">'.$name.'</div></td>';
echo '<td class="ip">'.$text.'</td>';
echo '<td class="ip">'.$author.'</td>';
echo "<td class='ip'><a href=\"javascript: openPopup('newsedit2.php?act=del&id=$id',600,100);\">DELETE</a></td>";
echo "<td class='ip'><a href=\"javascript: openPopup('newsedit2.php?act=edit&id=$id',600,700);\">EDIT</td>:";
}
}
?>
news.php
Код:
<?php
if($_SESSION['admin'] > 1) {
echo "<a href=?a=addnews>Напиши новина</a><br><br>"; }
$sql = "SELECT * FROM news ORDER BY id DESC";
$do = mysql_query($sql);
while ($row = mysql_fetch_array($do)) {
echo "".$row['name']."<hr color='black' width='300' align='center' />";
$text = nl2br($row['text']);
echo $text;
if($_SESSION['admin'] > 0) {
echo "<br><a href=?a=editnews&id=".$row['id'].">Редактирай</a>"; }
if($_SESSION['admin'] > 1) {
echo "<br><a href=?a=delnews&id=".$row['id'].">Изтрий</a><br><br>"; }} ?>
editnews2.php
Код:
<?php
if($_GET['act']=="del" AND $_GET['id']){
$idto = htmlspecialchars($_GET['id']);
$link = mysql_connect("localhost", "egyptos3_uzer", "gamebg1234");
mysql_select_db("egyptos3_game", $link);
mysql_query('set names cp1251',$link);
$query1 = mysql_query("SELECT * FROM `news` WHERE `id` = '$idto'");
if(mysql_num_rows($query1)){
$update = mysql_query("DELETE FROM `news` WHERE id='$idto'");
echo "Новината е изтрита успешно!";
}
}
if($_GET['act']=="edit" AND $_GET['id']){
$idto = htmlspecialchars($_GET['id']);
$link = mysql_connect("localhost", "egyptos3_uzer", "gamebg1234");
mysql_select_db("egyptos3_game", $link);
mysql_query('set names cp1251',$link);
$query2 = mysql_query("SELECT * FROM `news` WHERE `id` = '$idto'");
if(mysql_num_rows($query2)){
while ($r = mysql_fetch_array($query2)){
extract($r);
echo "
<center>
<form method='post' action=''>
<input type='text' name='name' value='$name' width='500'><br>
<textarea name='text'>$text</textarea><br>
<input type='submit' name='edit' value='Промени'>
</form>
</center>
";
}
}
}
if($_POST['edit']){
$name = htmlspecialchars($_POST['name']);
$text = htmlspecialchars($_POST['text']);
if(!empty($name) or !empty($text)){
$query33 = mysql_query("UPDATE `news` SET `name` = '$name' , `text` = '$text' where `id` = '$idto'");
echo "Успешно променихте новината";
}
}
?>
Моля помогнете