Форма редактирования
else if (isset($_GET[editart])) {
$art=(int)$_GET[editart];
$res22=mysql_query("SELECT * FROM articles WHERE id='$art' LIMIT 1"); $row22=mysql_fetch_assoc($res22);
?>
<form action="index.php?update_art=<?php echo $art;?>" method="POST">
Название <input type="text" size="100" value="<?php echo $row22[title];?>" name="name"><br>
<textarea id="editor1" name="text"><?php echo $row22[info];?></textarea><br>
<select name="place">
<?php
$res=mysql_query("SELECT * FROM category WHERE parent='0' ORDER BY par_id");
while ($row=mysql_fetch_assoc($res)) {
echo '<optgroup label="'.$row[cat_name].'">';
$res2=mysql_query("SELECT * FROM category WHERE par_id='$row[id]'");
while ($row2=mysql_fetch_assoc($res2)) {
echo '<option value="'.$row2[id].'"'; if ($row22[place]==$row2[id]) {echo ' selected ';} echo '> '.$row2[cat_name].'</option>';
}
echo '</optgroup>';
}
?></select><br>
Видео <textarea name="video"><?php echo $row22[video];?></textarea><br>
<input type="submit">
</form>
<script type="text/javascript">
var ckeditor1 = CKEDITOR.replace( 'editor1' );
AjexFileManager.init({
returnTo: 'ckeditor',
editor: ckeditor1
});
</script>
<?php
}
Обновление записи
else if (isset($_GET[update_art])) {
$art=(int)$_GET[update_art];
$place=(int)$_POST[place];
$lastmod=date("Y-m-d H:i:s");
$title=mysql_real_escape_string($_POST[name]);
$info=mysql_real_escape_string($_POST[text]);
$video=mysql_real_escape_string($_POST[video]);
$res=mysql_query("UPDATE articles SET place='$place', title='$title', info='$info', video='$video', lastmod='$lastmod' WHERE id='$art'") or die(mysql_error());
echo '<script>document.location.href="index.php?message=ok";</script>';
}