PHP表單數(shù)據(jù)寫入MySQL代碼，php表單寫入mysql

<h1>插入操作</h1>  
<?<span>php  
    </span><span>if</span>(!<span>isset</span>(<span>$_POST</span>['submit'<span>])){  
        </span><span>//</span><span>如果沒有表單提交，顯示一個(gè)表單  </span>
?>  
    <form action="" method="post"><span>  
    國家：</span><input type="text" name="country" /><span>  
    動(dòng)物名稱（英文）：</span><input type="text" name="animal" /><span>  
    動(dòng)物名稱（中文）：</span><input type="text" name="cname" />  
    <input type="submit" name="submit" value="提交表單" />  
    </form>  
<?<span>php  
    }  
    </span><span>else</span><span>  
    {  
        </span><span>//</span><span>如果提交了表單  
        //數(shù)據(jù)庫連接參數(shù)  </span>
        <span>$host</span> = "localhost"<span>;  
        </span><span>$user</span> = "root"<span>;  
        </span><span>$pass</span> = "zq19890319"<span>;  
        </span><span>$db</span> = "phpdev"<span>;  
         
        </span><span>//</span><span> 何問起 hovertree.com
        //取得表單中的值，檢查表單中的值是否符合標(biāo)準(zhǔn)，并做適當(dāng)轉(zhuǎn)義，防止SQL注入  </span>
        <span>$country</span> = <span>empty</span>(<span>$_POST</span>['country'])? <span>die</span>("請(qǐng)輸入國家名稱"):  
        <span>mysql_escape_string</span>(<span>$_POST</span>['country'<span>]);  
        </span><span>$animal</span> = <span>empty</span>(<span>$_POST</span>['animal'])? <span>die</span>("請(qǐng)輸入英文名"):  
        <span>mysql_escape_string</span>(<span>$_POST</span>['animal'<span>]);  
        </span><span>$cname</span> = <span>empty</span>(<span>$_POST</span>['cname'])? <span>die</span>("請(qǐng)輸入中文名"):  
        <span>mysql_escape_string</span>(<span>$_POST</span>['cname'<span>]);  
          
        </span><span>//</span><span>打開數(shù)據(jù)庫連接  </span>
        <span>$connection</span> = <span>mysql_connect</span>(<span>$host</span>, <span>$user</span>, <span>$pass</span>) or <span>die</span>("Unable to connect!"<span>);  
          
        </span><span>//</span><span>選擇數(shù)據(jù)庫  </span>
        <span>mysql_select_db</span>(<span>$db</span>) or <span>die</span>("Unable to select database!"<span>);  
          
        </span><span>//</span><span>構(gòu)造一個(gè)SQL查詢  </span>
        <span>$query</span> = "INSERT INTO symbols(country, animal, cname) VALUE('<span>$country</span>', '<span>$animal</span>', '<span>$cname</span>')"<span>;  
          
        </span><span>//</span><span>執(zhí)行該查詢  </span>
        <span>$result</span> = <span>mysql_query</span>(<span>$query</span>) or <span>die</span>("Error in query: <span>$query</span>. ".<span>mysql_error</span><span>());  
          
        </span><span>//</span><span>插入操作成功后，顯示插入記錄的記錄號(hào)  </span>
        <span>echo</span> "記錄已經(jīng)插入， mysql_insert_id() = ".<span>mysql_insert_id</span><span>();  
          
        </span><span>//</span><span>關(guān)閉當(dāng)前數(shù)據(jù)庫連接  </span>
        <span>mysql_close</span>(<span>$connection</span><span>);  
    }  
</span>?> 

參考：http://www.cnblogs.com/roucheng/p/phpmysql.html

上面的代碼用不同格式，不知道哪種格式更好

1. 插入操作

   ??
3. ????if(!isset($_POST['submit'])){??
4. ????????//如果沒有表單提交，顯示一個(gè)表單??
5. ?>??
6. ????
   ""
   ?method="post">??
7. ????國家："text"?name="country"?/>??
8. ????動(dòng)物名稱（英文）："text"?name="animal"?/>??
9. ????動(dòng)物名稱（中文）："text"?name="cname"?/>??
10. ????"submit"?name="submit"?value="提交表單"?/>??
11. ??????
13. ????}??
14. ????else??
15. ????{??
16. ????????//如果提交了表單??
17. ????????//數(shù)據(jù)庫連接參數(shù)??
18. ????????$host?=?"localhost";??
19. ????????$user?=?"root";??
20. ????????$pass?=?"zq19890319";??
21. ????????$db?=?"phpdev";??
22. ??????????
23. ????????//取得表單中的值，檢查表單中的值是否符合標(biāo)準(zhǔn)，并做適當(dāng)轉(zhuǎn)義，防止SQL注入??
24. ????????$country?=?empty($_POST['country'])??die("請(qǐng)輸入國家名稱"):??
25. ????????mysql_escape_string($_POST['country']);??
26. ????????$animal?=?empty($_POST['animal'])??die("請(qǐng)輸入英文名"):??
27. ????????mysql_escape_string($_POST['animal']);??
28. ????????$cname?=?empty($_POST['cname'])??die("請(qǐng)輸入中文名"):??
29. ????????mysql_escape_string($_POST['cname']);??
30. ??????????
31. ????????//打開數(shù)據(jù)庫連接 hovertree.com 何問起??
32. ????????$connection?=?mysql_connect($host,?$user,?$pass)?or?die("Unable?to?connect!");??
33. ??????????
34. ????????//選擇數(shù)據(jù)庫??
35. ????????mysql_select_db($db)?or?die("Unable?to?select?database!");??
36. ??????????
37. ????????//構(gòu)造一個(gè)SQL查詢??
38. ????????$query?=?"INSERT?INTO?symbols(country,?animal,?cname)?VALUE('$country',?'$animal',?'$cname')";??
39. ??????????
40. ????????//執(zhí)行該查詢??
41. ????????$result?=?mysql_query($query)?or?die("Error?in?query:?$query.?".mysql_error());??
42. ??????????
43. ????????//插入操作成功后，顯示插入記錄的記錄號(hào)??
44. ????????echo?"記錄已經(jīng)插入，?mysql_insert_id()?=?".mysql_insert_id();??
45. ??????????
46. ????????//關(guān)閉當(dāng)前數(shù)據(jù)庫連接??
47. ????????mysql_close($connection);??
48. ????}??
49. ?>?