修改逻辑05

正式进入到修改的逻辑界面new_upd.php

代码如下：

<?php
/**
 * Created by PhpStorm.
 * User: Administrator
 * Date: 2017/3/18
 * Time: 18:19
 * 接收从new_ed.php页面传过来的数据，将新修改的数据保存到数据库
 */
header("content-type:text/html;charset=utf8");
date_default_timezone_set('PRC');
//接收编辑界面传入过来的数据

$id = $_GET['id'];
$title = $_POST['title'];
$content = $_POST['content'];
echo "title=" . $title . ",content=" . $content, ",id=" . $id;
//更新时间
$time = date("y-m-d h:i:s");
//插入数据库
$conn = mysqli_connect("localhost", "root", "root");
mysqli_set_charset($conn, "utf8");
if ($conn) {
    //连接数据库成功
    //执行修改操作
    //执行update操作
    //提示
    $updateSql = "update mynews.mynews set title='$title',content='$content',cre_time='$time' where _id ='$id'";
    echo $updateSql;
    $result = mysqli_query($conn, $updateSql);
    if ($result) {
        echo "<script>alert('修改数据成功');location.href='new_list.php';</script>";
    } else {
        echo "<script>alert('修改失败，请检查后在提交');Location.href='new_list.php';</script>";
    }

} else {
    //连接数据库失败
    echo "连接数据库失败";
}