php中下拉列表能连接数据库吗_PHP下拉框的值怎么存入数据库?

这是前端的代码：

选择你喜欢的种类

跑步鞋

训练鞋

篮球鞋

网球鞋

户外鞋

拖鞋

后端是这样的：

error_reporting(0);

$user_name = $_POST["user_name"];

$user_psd = $_POST["user_psd"];

$product_type = $_POST["product_type"];

$db = new MySQLi("localhost","root","123456","ecshop");

!mysqli_connect_error() or die("连接失败！");

mysqli_query($conn,'SET NAME UTF8');

$sql = "insert into `online_user`(user_name,user_psd,product_type) values('{$user_name}',

'{$user_psd}','{$product_type}')";

echo $sql;

$result = $db->query($sql);

if($result)

{

header("location:index.php");

}

else

{

echo "添加失败！";

}

?>

想问下如何解决乱码问题？？求大神指教一下啊啊啊