edit.php
<?php
include("head.php");
//引入连接数据库
include("../connect.php");
//获取数据库表数据
if (!empty($_GET['id'])) {
$edit = $_GET['id'];
$sql = "select * from ".DB_TBNAME." where id='$edit'";
mysql_query('set names utf8');
$query = mysql_query($sql);
$rs = mysql_fetch_array($query);
}
$flag = false;
//更新数据库表数据
if (!empty($_POST['sub'])) {
$title = $_POST['title']; //获取title表单内容
$con = $_POST['con']; //获取contents表单内容
$hid = $_POST['hid'];
$sql= "update ".DB_TBNAME." set title='$title', contents='$con' where id='$hid' ";
mysql_query('set names utf8');//必须设置不然会出现乱码
if(mysql_query($sql)){
echo "<script>alert('update success.');location.href='index.php'</script>";
}else{
echo "<script>alert('update failure.');</script>";
$flag = true;
}
}
if( !$flag ){
$hid = $rs['id'];
$title = $rs['title'];
$con = $rs['contents'];
}
echo <<<HTML
<form action="edit.php" method="post">
<div id='editControls' class='span9' style='margin-left: 1px; width: 720px;'>
<input type="hidden" name="hid" value="{$hid}">
title:<br><input type="text" name="title" style="height: 26px;" value="{$title}"><br>
<div class='btn-group'>
<a class='btn' data-role='bold' href='#'><b>Bold</b></a>
<a class='btn' data-role='italic' href='#'><em>Italic</em></a>
<a class='btn' data-role='underline' href='#'><u><b>U</b></u></a>
<a class='btn' data-role='strikeThrough' href='#'><strike>abc</strike></a>
</div>
<div class='btn-group'>
<a class='btn' data-role='justifyLeft' href='#'><i class='icon-align-left'></i></a>
<a class='btn' data-role='justifyCenter' href='#'><i class='icon-align-center'></i></a>
<a class='btn' data-role='justifyRight' href='#'><i class='icon-align-right'></i></a>
<a class='btn' data-role='justifyFull' href='#'><i class='icon-align-justify'></i></a>
</div>
<div class='btn-group'>
<a class='btn' data-role='insertUnorderedList' href='#'><i class='icon-list-ul'></i></a>
<a class='btn' data-role='insertOrderedList' href='#'><i class='icon-list-ol'></i></a>
</div>
<div class='btn-group'>
<a class='btn' data-role='h1' href='#'>h<sup>1</sup></a>
<a class='btn' data-role='h2' href='#'>h<sup>2</sup></a>
<a class='btn' data-role='h3' href='#'>h<sup>3</sup></a>
<a class='btn' data-role='p' href='#'>p</a>
</div>
<div style="float: right">
<select style="width: 80px" οnchange=document.execCommand('ForeColor',false,this.value)>
<option value=#000000>黑色</option>
<option value=#ff0000>红色</option>
<option value=#0000ff>蓝色</option>
<option value=#00ff00>绿色</option>
<option value=#ffff00>黄色</option>
<option value=#00ffff>浅蓝</option>
<option value=#ff00ff>紫色</option>
</select>
</div>
</div>
<div id='editor' name="con" class='span9' style='margin-bottom: 20px; margin-top: 10px; margin-left: 1px; width: 720px;' contenteditable>
{$con}
</div>
<input type="hidden" name="con" value="">
<input type="submit" name="sub" value="修改" οnclick='con.value = editor.innerHTML;'>
<script src="../assets/js/jquery.min.js"></script>
<script src="../assets/js/bootstrap.min.js"></script>
<script>
$(function() {
$('#editControls a').click(function(e) {
switch($(this).data('role')) {
case 'h1':
case 'h2':
case 'h3':
case 'p':
document.execCommand('formatBlock', false, '<' + $(this).data('role') + '>');
break;
default:
document.execCommand($(this).data('role'), false, null);
break;
}
})
});
</script>
</form>
</div>
HTML;
include("foot.php");
?>
效果: