Home  >  Article  >  Backend Development  >  PHP录入数据库乱码解决思路

PHP录入数据库乱码解决思路

WBOY
WBOYOriginal
2016-06-13 13:25:26861browse

PHP录入数据库乱码
数据库编码是“utf8_bin”字段的编码也是“utf8_bin”,php向数据库录入中文时总是乱码!php文件也用文本编辑并保存为utf-8的了,问题还是没有解决。下面是代码

PHP code
<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->

<?php require_once('../Connections/internal.php'); ?>
<?php if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO discuss (a, content) VALUES (%s, %s)",
                       GetSQLValueString($_POST['a'], "text"),
                       GetSQLValueString($_POST['content'], "text"));

  mysql_select_db($database_internal, $internal);
  $Result1 = mysql_query($insertSQL, $internal) or die(mysql_error());
}

mysql_select_db($database_internal, $internal);
$query_Recordset1 = "SELECT * FROM discuss";
$Recordset1 = mysql_query($query_Recordset1, $internal) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>


<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>discuss</title>



$result1 = mysql_query("SELECT * FROM discuss where id "; } ?>
WHO 在说什么
$a $content $id

选择你的身份

 

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