php - Updating mysql table (UTF8) using form method
问题描述
I am trying to update a table query UTF8 using a form. Its displays in form but not able to edit. Please let me know what the fault in query?
<?php
error_reporting(E_ERROR | E_WARNING | E_PARSE);
require_once("./includeadmin/membersite_config.php");
require_once("./includeadmin/membersite_config_editorial.php");
include("database1.php");
if(!$fgmembersite->CheckLogin())
{
$fgmembersite->RedirectToURL("index.php");
exit;
}
$idi = $_POST['id2'];
$sql = mysql_connect("localhost","username","password");
if (!$sql) {
die ('Could not connect!: ' . mysql_error());
}
mysql_select_db("nam33_articles", $sql);
mysql_query("UPDATE editorial SET date = '$_POST[date]', tag =
'$_POST[tag]', title = '$_POST[title]', small = '$_POST[small]', image =
'$_POST[image]', smallimage = '$_POST[smallimage]', english =
'$_POST[english]', full = '$_POST[full]') WHERE id_user = '$idi'");
?>
解决方案
更新您的查询参数并设置 utf8。
mysql_query("set names 'utf8'",$sql);
$query = "UPDATE editorial SET date = '".$_POST['date']."', tag = '".$_POST['tag']."', title = '".utf8_encode($_POST['title'])."', small = '".utf8_encode($_POST['small'])."', image = '".$_POST['image']."', smallimage = '".$_POST['smallimage']."', english = '".$_POST['english']."', full = '".utf8_encode($_POST['full'])."' WHERE id_user = '$idi'";
mysql_query($query);
推荐阅读
- mysql - 如何在 MySQL 数据库中设置州和城市之间的关系?
- python - Python3:从新数据源更新散景数据表
- reactjs - 将管理员(用户名和密码)保存到反应应用程序中是否安全
- javascript - 是否可以访问在 wdio.conf 中声明的变量?
- python - 带有多索引和 parse_date 的 pandas read_excel;如何?
- java - 加工中的平稳运动
- laravel - 路线 [products.all] 未定义。(\resources\views\product\cart.blade.php)
- c++ - C ++ - 错误:未在此范围内声明“睡眠”
- c - 编写一个函数来返回节点的位置
- javascript - 即使设备锁定也继续播放 iframe