Привет!
Решил для своей практики, заняться созданием Рекдактора Новостей.
В процессе создания, уже ни раз проверял Код, пытался найти ошибку, но не нашел! 
Прошу помочь мне, в создании Редактора Новостей! 
newslist.php
| Код |
<html>
<head>
<title>newslist.php</title>
</head>
<body>
<?
$db_name = "dbnews";
$table = "news";
$host = "localhost";
$user = "root";
$pass = "";
$link = mysql_connect($host, $user, $pass) or
die(mysql_errno($link).mysql_error($link));
$db = mysql_select_db($db_name, $link) or
die(mysql_errno($link).mysql_error($link));
$result = mysql_query($link) or
die(mysql_errno($link).mysql_error($link));
echo("<table border = 1>");
$th = explode("#", "ID#Text#Date#Change#Delete");
echo("<tr><th>");
echo implode("</th><th>", $th);
echo("</th></tr>");
while($data = mysql_fetch_row($result))
{
echo("<tr><td>");
echo implode("</td></td>", $th);
echo("</td><td><a href = 'changeview.php?id=". $data[0]. "'>Change</a>");
echo("</td><td><a href = 'changeview.php?id=". $data[0]. "'>Change</a>");
echo("</td><tr>");
}
mysql_free_result($result);
mysql_close($link);
echo("</table>");
echo("<a href = 'addnews.php'>Add One News!</a>");
?>
</body>
</html>
|
addnews.php
| Код |
<html>
<head>
<title>addnews.php</title>
</head>
<body>
News Body:<br>
<form method = "post" action = "savenews.php">
<textarea rows = "5" cols = "20" name = "newsbody"></textarea><br>
<input type = "submit" value = "Save">
<input type = "reset" value = "Clear">
</form>
<br>
<a href = "newslist.php">Back to the "NewsList"</a>
</body>
</html>
|
changenews.php
| Код |
<html>
<head>
<title>Change One News</title>
</head>
<body>
"Body News"<br>
<?php
//Configuration.Connect
/* begin Config */
$db_name = "dbnews";
$table = "news";
$host = "localhost";
$user = "root";
$pass = "";
/* end Config */
$link = mysql_connect($host, $user, $pass) or
die(mysql_errno($link).mysql_error($link));
$db = mysql_select_db($db_name, $link) or
die(mysql_errno($link).mysql_error($link));
$newsid = $_REQUEST['id'];
$sql_query = "SELECT * FROM news WHERE id = \"$newsid\"";
$result = mysql_query($sql_query, $link) or
die(mysql_errno($link).mysql_error($link));
$data = mysql_fetch_row($result);
// Show
echo("<form method = \"post\" action = \"updatenews.php?id=$newsid\">");
echo("<textarea rows = \"5\" name = \"newsbody\" cols = \"20\">$data[1]</textarea><br>");
// Show
mysql_free_result($result);
mysql_close($link);
?>
<input type = "submit" value = "Save! :)">
<input type = "reset" value = "Reset! :)">
</form>
<br>
<a href = "newslist.php">Back to the "NewsList"! ;)</a>
</body>
</html>
|
deletenews.php
| Код |
<?php
//Configuration.Connect
/* begin Config */
$db_name = "dbnews";
$table = "news";
$host = "localhost";
$user = "root";
$pass = "";
/* end Config */
$link = mysql_connect($host, $user, $pass) or
die(mysql_errno($link).mysql_error($link));
$db = mysql_select_db($db_name, $link) or
die(mysql_errno($link).mysql_error($link));
$newsid = $_REQUEST['id'];
$sqlquery = "DELETE FROM news WHERE id = \"$newsid\"";
$result = mysql_query($sql_query, $link) or
die(mysql_errno($link).mysql_error($link));
mysql_close($link);
header('Location: newslist.php');
?>
|
savenews.php
| Код |
<?php
//Configuration.Connect
/* begin Config */
$db_name = "dbnews";
$table = "news";
$host = "localhost";
$user = "root";
$pass = "";
/* end Config */
$link = mysql_connect($host, $user, $pass) or
die(mysql_errno($link).mysql_error($link));
$db = mysql_select_db($db_name, $link) or
die(mysql_errno($link).mysql_error($link));
$newsbody = $_POST['newsbody'];
$sql_query = "INSERT INTO news (date, text) VALUES (NOW(), \"$newsbody\")";
$result = mysql_query($sql_query, $link) or
die(mysql_errno($link).mysql_error($link));
mysql_close($link);
header('Location: newslist.php');
echo($newsdata);
?>
|
updatenews.php
| Код |
<?php
//Configuration.Connect
/* begin Config */
$db_name = "dbnews";
$table = "news";
$host = "localhost";
$user = "root";
$pass = "";
/* end Config */
$link = mysql_connect($host, $user, $pass) or
die(mysql_errno($link).mysql_error($link));
$db = mysql_select_db($db_name, $link) or
die(mysql_errno($link).mysql_error($link));
$newsbody = $_POST['newsbody'];
$newsid = $_REQUEST['id'];
$sql_query = "UPDATE news SET text = \"$newsid\"";
$result = mysql_query($sql_squery, $link) or
die(mysql_errno($link).mysql_error($link));
mysql_close($link);
header('Location: newslist.php');
?>
|
SQL-запрос в MySQL:
| Код |
CREATE TABLE `news` (
`id` int NOT NULL auto_increment,
`text` varchar(255) NOT NULL,
`date` datetime NOT NULL,
PRIMARY KEY (`id`)
)
|
Проблема в том, что новости в MySQL добавляются (я проверил это с помощью phpMyAdmin), НО в Браузере - отображается только ошибка, когда я собираюсь редактировать!
1064 - У меня ошибка в Синтаксисе SQL!
Прошу помочь в Создании! |
