简易php博客(6)_后台修改

最新推荐文章于 2021-03-21 01:35:16 发布

shareinfo2018

最新推荐文章于 2021-03-21 01:35:16 发布

阅读量610

点赞数

CC 4.0 BY-SA版权

分类专栏： web

本文链接：https://blog.csdn.net/chenyefei/article/details/51685904

web 专栏收录该内容

26 篇文章

订阅专栏

本文介绍了一个基于PHP的简单博客编辑器实现方案，包括了编辑器的基本功能如文本格式化、颜色选择等，并通过实例代码展示了如何从数据库中读取及更新文章内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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" onchange=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="修改" onclick='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"); 
?>

效果：