| |
|
|
| |
для: km54
(12.11.2008 в 11:00)
|
| | таблица
CREATE TABLE 'news' ( 'id' tinyint(11) unsigned NOT NULL auto_increment, 'page_title' varchar(255) default NULL, 'page_text' longtext, 'active' char(1) NOT NULL default '', PRIMARY KEY ('id') ) ENGINE=MyISAM;
|
форма
<form name="myForm" method="post" action="add_news_acc.php" enctype="multipart/form-data" onSubmit="submit_form()">
<table width="100%" border="0" cellspacing="1" cellpadding="3" align="center" class="text">
<tr bgcolor="eaeaea">
<td>Theme</td>
<td><input name="thema" size="65" style="color:#707070;">
</td>
</tr><tr bgcolor="eaeaea">
<td align="left">Text</td>
<td align="left"><textarea cols="50" rows="20" name="news_text"></textarea></td>
</tr><tr bgcolor="#eaeaea">
<td valign="top">Activate:</td>
<td class="text_red"><select name="active">
<option value="Y">Yes</option>
<option value="N">No</option>
</select></td>
</tr><TR>
<TD height="15" align="center" bgcolor="ffffff" colspan="2" >
<input type="submit" class="button" style="width:100; border: #000000 1px solid;" value="Save"></TD>
</TR>
</TABLE>
</form>
|
обработчик (проверки данных нет!)
<? include("../config.inc.php"); /// podklyuchenie k baze
$sql = "INSERT INTO news VALUES (
Null,
'".addslashes($_POST["thema"])."',
'".addslashes($_POST["news_text"])."',
'".$_POST["active"]."')";
// run SQL
$result = mysql_query($sql) or die(mysql_error());
if (!$result)
// esli ne zanesli v bazu
header("Location:admin_news.php?msg=-1");
else
header("Location:s.php?msg=1");
exit();
?>
|
| |
| |
|
