<?php

include('dbconfig.php');
	
	 // Подключение БД
	$connect = mysql_connect("$host","$user","$password") or die(mysql_error()); 
	$select = mysql_select_db("$db"); 


if(isset($_POST['submit'])){
		
		$name = $_POST['name'];
		$sirname = $_POST['sirname'];
		$full_name = $sirname." ".$name; 
		$nick = $_POST['nick'];
		$pass = $_POST['pass'];
		$pass_r = $_POST['pass_r'];
		$mail = $_POST['mail'];
		
		

$query = mysql_query("SELECT `id` FROM `people` WHERE `full_name` = '$full_name' ");

$id = $mysql_result($query);

echo 'Полное имя '.$full_name.'ID '.$id." Ник ".$nick." пароль1 ".$pass." пароль2 ".$pass_r." маил ".$mail;
}
?>

<form method="POST">
<input type="text" name="sirname" placeholder="Фамилия" /><br />
<input type="text" name="name" placeholder="Имя" />
<input type="text" name="nick" placeholder="Ник" /> 
<input type="password" name="pass" placeholder="Пароль" /> 
<input type="password" name="pass_r" placeholder="Повтори пароль" />
<input type="email" name="mail" placeholder="Email" /> 
<input type="submit" name="submit" value="Зарегистрироваться" />
</form>