PHP的POST方法和操作数据库的代码

Question

表名：msg
三个字段：
ID、user和sms

现有一网页使用POST方式提交了一个数据，该网页表单中的两个输入框名称分别为user和sms。

请问，我如何使用PHP来获取这个POST值，并将值以追加的方式添加到数据库中呢？

烦请给出完整的代码。

Answer 1

php获取post参数的几种方式1、$_POST['paramName'] 只能接收Content-Type: application/x-www-form-urlencoded提交的数据&nbsp;2、file_get_contents("php://input") 适用大多数类型的Content-typephp://input 允许读取 POST 的原始数据。和 $HTTP_RAW_POST_DATA&nbsp;比起来，它给内存带来的压力较小，并且不需要任何特殊的&nbsp;php.ini&nbsp;设置。php://input 不能用于&nbsp;enctype="multipart/form-data"。&nbsp;3、$GLOBALS['HTTP_RAW_POST_DATA']; 总是产生&nbsp;$HTTP_RAW_POST_DATA&nbsp;变量包含有原始的 POST 数据。此变量仅在碰到未识别 MIME 类型的数据时产生。$HTTP_RAW_POST_DATA&nbsp;对于&nbsp;enctype="multipart/form-data"&nbsp;表单数据不可用。如果post过来的数据不是PHP能够识别的，你可以用 $GLOBALS['HTTP_RAW_POST_DATA']来接收，比如 text/xml 或者 soap 等等。demo：应用a.htm------------------12345<form&nbsp;action="post.php"&nbsp;method="post"><input&nbsp;type="text"&nbsp;name="user"><input&nbsp;type="password"&nbsp;name="password"><input&nbsp;type="submit"></form>post.php-----------------123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051<?php&nbsp;&nbsp;if&nbsp;(!empty($_POST))&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Array&nbsp;of&nbsp;post&nbsp;values&nbsp;for&nbsp;each&nbsp;different&nbsp;form&nbsp;on&nbsp;your&nbsp;page.&nbsp;&nbsp;&nbsp;&nbsp;$postNameArr&nbsp;=&nbsp;array('F1_Submit',&nbsp;'F2_Submit',&nbsp;'F3_Submit');&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Find&nbsp;all&nbsp;of&nbsp;the&nbsp;post&nbsp;identifiers&nbsp;within&nbsp;$_POST&nbsp;&nbsp;&nbsp;&nbsp;$postIdentifierArr&nbsp;=&nbsp;array();&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;foreach&nbsp;($postNameArr&nbsp;as&nbsp;$postName)&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(array_key_exists($postName,&nbsp;$_POST))&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$postIdentifierArr[]&nbsp;=&nbsp;$postName;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;Only&nbsp;one&nbsp;form&nbsp;should&nbsp;be&nbsp;submitted&nbsp;at&nbsp;a&nbsp;time&nbsp;so&nbsp;we&nbsp;should&nbsp;have&nbsp;one&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;post&nbsp;identifier.&nbsp;&nbsp;The&nbsp;die&nbsp;statements&nbsp;here&nbsp;are&nbsp;pretty&nbsp;harsh&nbsp;you&nbsp;may&nbsp;consider&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;a&nbsp;warning&nbsp;rather&nbsp;than&nbsp;this.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;(count($postIdentifierArr)&nbsp;!=&nbsp;1)&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;count($postIdentifierArr)&nbsp;<&nbsp;1&nbsp;or&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;die("\$_POST&nbsp;contained&nbsp;more&nbsp;than&nbsp;one&nbsp;post&nbsp;identifier:&nbsp;"&nbsp;.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;implode("&nbsp;",&nbsp;$postIdentifierArr));&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;//&nbsp;We&nbsp;have&nbsp;not&nbsp;died&nbsp;yet&nbsp;so&nbsp;we&nbsp;must&nbsp;have&nbsp;less&nbsp;than&nbsp;one.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;die("\$_POST&nbsp;did&nbsp;not&nbsp;contain&nbsp;a&nbsp;known&nbsp;post&nbsp;identifier.");&nbsp;&nbsp;&nbsp;&nbsp;}&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;switch&nbsp;($postIdentifierArr[0])&nbsp;&nbsp;&nbsp;&nbsp;{&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;'F1_Submit':&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;"Perform&nbsp;actual&nbsp;code&nbsp;for&nbsp;F1_Submit.";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;'Modify':&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;"Perform&nbsp;actual&nbsp;code&nbsp;for&nbsp;F2_Submit.";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;case&nbsp;'Delete':&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;"Perform&nbsp;actual&nbsp;code&nbsp;for&nbsp;F3_Submit.";&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;break;&nbsp;&nbsp;&nbsp;&nbsp;}}else&nbsp;//&nbsp;$_POST&nbsp;is&nbsp;empty.{&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;"Perform&nbsp;code&nbsp;for&nbsp;page&nbsp;without&nbsp;POST&nbsp;data.&nbsp;";}?>&nbsp;

Answer 2

<?php$user=$_POST['user'];$sms=$_POST['sms'];?>然后就是数据库连接了。

Answer 3

$setting = array();$setting['mysqlHost'] = 'localhost';$setting['mysqlUser'] = 'root';$setting['mysqlPass'] = '****';$link =&nbsp;mysql_connect($setting['mysqlHost'], $setting['mysqlUser'], $setting['mysqlPass']) or die('Could not connect: ' . mysql_error());mysql_select_db('db', $link) or die('Could not select database');function dbEscape($link, $text){if(get_magic_quotes_gpc()) {$text = stripslashes($text);}return mysql_real_escape_string($text, $link);}function isExistUser($link, $user, $sms) {$user = dbEscape($link, $user);$sms = dbEscape($link, $sms);$result = mysql_query("SELECT * FROM `msg` WHERE `user`='$user' and `sms` = '$sms'", $link);$num =&nbsp;mysql_num_rows($result);mysql_free_result($result);return $num > 0;}//=============code start==================$user = isset($_REQUEST['user']) ? $_REQUEST['user'] : '';$sms = isset($_REQUEST['sms']) ? $_REQUEST['sms'] : '';if (isExistUser($link, $user, $sms)) {echo <<<script<script>alert('Exist the same user');history.back();</script>script;}else {$sql = "INSERT INTO `db`.`msg` (`user`, `sms`) VALUES ('$user', '$sms')";mysql_query($sql, $link) or die('Failur');mysql_close($link);echo 'O le';}&nbsp;