PHP获取客户端数据保存到MySQL数据库出现中文乱码解决方案

<?php
/**
 * 添加电子优惠券 联系人信息
 *
 1.连接数据库 $conn=mysql_connect("localhost","user","password") or die("数据库连接出错".mysql.error());
 2.选择数据表 mysql_select_db("db_database",$conn) or die ("数据库访问出错".mysql.error());
 3.设置数据库格式 mysql_query("set names gb2312");
 4.写SQL语句 $sql="select * from tb_admin where id=$id";
 5.执行SQL语句 $query=mysql_query($query);
 6.获取执行结果 $info=mysql_fetch_array($query);
 7.关闭记录集 mysql_free_result($info);
 8.关闭记录结果 mysql_close($conn);
 */

//获取客户端数据
add();
//demo();


//添加
function add(){
	/*
	 mobile:mobile,uname:uname,amount:amount,
	 intime:intime,explain:explain
	 $in_sql = "insert into shopnc_coupon_contacter (memberId,
		contactName,mobile,couponId,couponName,bookTime,bookNum,mark,
		merchantId,merchantName) values(-1,
		'天街店','15123316303',-1,'电子优惠券名称','说的',1,'http://localhost:7788/jcshh/index.php?act=coupon_store&op=detail&coupon_id=5&id=6',
		-1,'商户名称' )";
	 */
	$memberId =-1;
	$contactName ='联系人姓名';
	$mobile ='15123316303';
	$couponId =-1;
	$couponName ='电子优惠券名称';
	$bookTime ='';
	$bookNum =1;
	$merchantId =-1;
	$merchantName ='商户名称';
	$mark ='暂无其他说明';
	
	$contactName =$_POST["uname"];
	$mobile =$_POST["mobile"];
	$couponId =-1;
	$couponName ='电子优惠券名称';
	$bookTime = $_POST["intime"];
	$bookNum = $_POST["amount"];
	$merchantId =-1;
	$merchantName ='商户名称';
	$mark = $_POST["explain"];
	$mark = str_replace("\'"," ",$mark);
	/*
	$contactName =$_GET["uname"];
	$mobile =$_GET["mobile"];
	$couponId =-1;
	$couponName ='电子优惠券名称';
	$bookTime = $_GET["intime"];
	$bookNum = $_GET["amount"];
	$merchantId =-1;
	$merchantName ='商户名称';
	$mark = $_GET["explain"];
	$mark = str_replace("\'"," ",$mark);
	*/
	$mark = iconv("UTF-8", "UTF-8", $mark);
	$couponName =iconv("UTF-8", "UTF-8", $couponName);
	$couponName =iconv("UTF-8", "UTF-8", $merchantName);
	$in_sql="insert into shopnc_coupon_contacter (memberId,
	contactName,mobile,couponId,couponName,bookTime,bookNum,mark,
	merchantId,merchantName) values($memberId,
	'$contactName','$mobile',$couponId,'$couponName','$bookTime',$bookNum,'$mark',
	$merchantId,'$merchantName' )";
	$conn = openCon();
	mysql_query("SET NAMES 'utf8'");//通知服务器客户端传递过去的语句的编码
	mysql_query("SET CHARACTER_SET_CLIENT=utf8"); //服务器设置客户端编码
	mysql_query("SET CHARACTER_SET_RESULTS=utf8");//设置查询结果的编码
	$in_result=mysql_query($in_sql);
	if(mysql_affected_rows()<1){
		echo "[\"您的信息保存失败,请重试!\"]";
	}else
	{
		echo "[\"您的信息已经保存成功!\"]";
	}
	mysql_close();

}
//获取数据库链接对象
function openCon(){
	$conn=mysql_connect('localhost','root','root') or die ("数据库连接出错".mysql.error());
	mysql_select_db("shopnc",$conn) or die ("数据库访问出错".mysql.error());
	return $conn;
}

function demo(){
	$conn= mysql_connect('localhost','root','root') or die('连接失败');
	mysql_select_db('shopnc', $conn) or die('选择数据库失败');
	mysql_query("SET NAMES utf8");
	$sql="select * from shopnc_coupon_contacter";
	$result=mysql_query($sql);
	if($row=mysql_fetch_row($result)){
		print_r($row);
	}
}

只需要在执行操作前执行如下设置即可:

mysql_query("SET NAMES 'utf8'");//通知服务器客户端传递过去的语句的编码
	mysql_query("SET CHARACTER_SET_CLIENT=utf8"); //服务器设置客户端编码
	mysql_query("SET CHARACTER_SET_RESULTS=utf8");//设置查询结果的编码

posted on 2012-04-24 16:17 txf2004 阅读(269) 评论(0) 编辑收藏举报

会员力量，点亮园子希望

刷新页面返回顶部

网站开发与移动开发

公告