HTML提交表單時,只有有中文,都不能正常添加進(jìn)數(shù)據(jù)庫,純數(shù)字可以,在mysql窗口中手動添加又可以添加有中文的信息.

圖片描述

<?php
    header("Content-type:text/html;charset=utf-8");
     
    $stuId=$_POST['stuId'];
    $stuName=$_POST['stuName'];
    $stuChinese=$_POST['stuChinese']; 
    $stuMath=$_POST['stuMath'];
    $stuEnglish=$_POST['stuEnglish']; 
    echo $stuName;
    $con=mysql_connect('localhost','root','');
    echo $con ? '數(shù)據(jù)庫連接成功' : '數(shù)據(jù)庫連接失敗'; 
    
    /*
    if(!$con){
        echo '連接失敗';
        exit;
    }else{
        echo '連接成功';
    }*/
    mysql_select_db('db_student');    
    $sql = "INSERT INTO table_student VALUES($stuId,$stuName,'$stuChinese','$stuMath','$stuEnglish')";
    //$sql = "INSERT INTO table_student(id,name,chinese,math,english)" . "VALUES($stuId,$stuName,$stuChinese,$stuMath,$stuEnglish)";   
   // $sql="insert into moneytb (riqi,item,inout,cost,bz) ". "values '$riqi','$item','$inout','$cost','$bz')";
    $is_ok = mysql_query($sql);
    if($is_ok == true){
        echo '添加成功';
         
    }else{
         
        echo '添加失敗'; 
    }
    echo $sql;
?>

<HTML> 
<HEAD> 
<TITLE>添加學(xué)生成績界面</TITLE> 
<meta charset="utf-8">
 
</HEAD> 
<BODY> 
<h1>添加學(xué)生界面</h1>
    <script type="text/javascript"></script>
    <form action="http://localhost/mysql/insertStudent.php" method="post">
        學(xué)生編號<input type="text" name="stuId"><br>
        學(xué)生姓名<input type="text" name="stuName"><br>
        語文成績<input type="text" name="stuChinese"><br>
        數(shù)學(xué)成績<input type="text" name="stuMath"><br>
        英語成績<input type="text" name="stuEnglish"><br>
        <input type="submit" value="添加成績">
    </form>
</BODY> 
</HTML>

回答

編輯回答