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.
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!