Home  >  Article  >  Backend Development  >  How to implement message board modification in php

How to implement message board modification in php

藏色散人
藏色散人Original
2020-10-05 00:32:023626browse

php method to implement message board modification: first connect to the database and select the specified database; then set the output encoding; then record the modified message board content submitted by the form; and finally execute the corresponding sql statement.

How to implement message board modification in php

Recommended: "PHP Video Tutorial"

The database is the notebook table and the title field of the noteinfo message board is the title message The title of the content is content

The code is as follows:

mysql_connect("数据库地址","数据库用户","数据库密码"); //链接数据库
or die("can not connect to db");
mysql_select_db("noteinfo"); //选择noteinfo数据库
or die("can not select the db ");
mysql_query("set names gb2312"); //设置输出编码
$title = $_POST['title'];//记录表单提交的要修改的标题
$newContent = $_POST[''content];//记录表单提交的的修改过的留言板内容(name = content)
$sql = "update noteinfo set content = '$newContent' where title = ‘$title’ "; //定义sql语句
$myquery = mysql_query($sql);//执行sql语句,也就是修改content为$newContent。
//哦了!

The above is the detailed content of How to implement message board modification in php. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn