首先写一个提交表单的HTML页面:

<html>
<form action=\"index.php\" method=\"post\">
<p>Enter the new employee:<br />
FirstName: <input type=\"text\" name=\"name\" size=\"20\" maxlength=\"255\"
  /><br />
Email: <input type=\"text\" name=\"email\" size=\"20\" maxlength=\"255\"
  /><br />
<input type=\"submit\" name=\"submit\" value=\"SUBMIT\" /></p>
</form>
</html>

表单以POST方式提交到服务器index.php页面。

 

接受表单处数据并处理表单数据的index.php代码:

if (isset($_POST[\'submit\'])):
  $dbcnx = mysql_connect(\'mysql153.secureserver.net\', \'root\', \'password\');
  mysql_select_db(\'manongjc\');

  $name = $_POST[\'name\'];
  $email = $_POST[\'email\'];
  $sql = \"INSERT INTO Employee SET FirstName=\'$name\', EMail=\'$email\' , ID = \'3\'\";
          
  if (@mysql_query($sql)) {
    echo(\'<p>数据插入成功</p>\');
  } else {
    echo(\'<p>添加数据出错,错误代码: \' . mysql_error() . \'</p>\');
  }
?>
收藏 打印