mysql新闻发布_php+mysql新闻发布系统（七）

action.php

/**

* Created by PhpStorm.

* User: Administrator

* Date: 2019/7/8

* Time: 16:07

*/

require ("dbconfig.php"); //导入配置文件

header("Content-Type:text/html;charset=utf-8");

$link = mysqli_connect(HOST,USER,PASS) or die("数据库连接失败！");

mysqli_select_db($link,DB_NAME);

//mysqli_set_charset($link,"utf8");

//if($link->connect_errno){

// die("连接失败：".$link->connect_errno);

//}

//$_GET["action"]; //传值变量

switch ($_GET["action"]){

case "add":

$title = $_POST["title"];

$keywords = $_POST["keywords"];

$author = $_POST["author"];

$content = $_POST["content"];

$addtime = time();

$sql = "insert into news values (null,'{$title}','{$keywords}','{$author}','{$content}','{$addtime}')";

echo "$sql";

//执行sql语句

mysqli_query($link,$sql);

$id=mysqli_insert_id($link); //获得自增id的值

if($id>0){

echo "

新闻信息添加成功

";

}else{

echo "

新闻信息添加失败

"; //有的时候添加失败是因为添加内容太长

}

echo "返回  ";

echo "浏览新闻";

break;

// case "search":

// $title = $_GET["title"];

// $keywords = $_GET["keywords"];

// $author = $_GET["author"];

// $content = $_GET["content"];

// $addtime = time();

// $sql = "insert into news values (null,'{$title}','{$keywords}','{$author}','{$content}','{$addtime}')";

// echo "$sql";

// break;

case "del":

$id=$_GET['id'];

$sql = "delete from news where id={$id}";

mysqli_query($link,$sql);

header("Location:index.php");

break;

case "update":

$title = $_POST["title"];

$keywords = $_POST["keywords"];

$author = $_POST["author"];

$content = $_POST["content"];

$addtime = time();

$id = $_POST['id'];

$sql = "update news set title='{$title}',keywords='{$keywords}',author='{$author}',content='{$content}',addtime={$addtime} where id={$id}";

echo "$sql";

mysqli_query($link,$sql);

header("Location:index.php");

break;

}

//musqli_close($link);

?>

作者纯属小白，各位大佬有问题可以找我，大家一起探讨哦，附加联系方式

Q Q：1799158338

微信：1903486297

标签：author,新闻,mysql,content,sql,keywords,title,php,id

来源： https://blog.csdn.net/qq_41285360/article/details/96592580