php表单发送到myadmin实例

	<?php

		$dbc =  mysql_connect('127.0.0.1', 'root', '')//连接数据库
			or die( 'Error querying to MySQL server' );

		$first_name = $_POST['firstname'];
		$last_name = $_POST['lastname'];
		$email = $_POST['email'];

		print_r($_POST);


		$query = " INSERT INTO email_list (first_name, last_name, email)  VALUES ('$first_name', '$last_name', '$email') ";
		print_r($query);
		mysql_select_db("elvis_store", $dbc);//选择数据库
		mysql_query("set names utf8");

		$result = mysql_query($query)//数据库查询
		or die('Error querying database.');
		print_r(mysql_affected_rows());//返回影响行数
//print_r(mysql_fetch_array($result));

		mysql_close($dbc);//关闭数据库连接
	?>