Untitled

<html>
	<head>
	<title> Данные о клиентах! </title>
	</head>
	<body>
	<?php
	$login = $_POST['login'];
	$password = $_POST['password'];
	try{
		$pdo = new PDO("mysql:host=LocalHost;dbname=hospital_rk", "hospitalgroup", "password");
		$pdo->SetAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	}
	catch(PDOException $e){
		echo"Error of open!!!".$e->getmessage();
		exit();
	}
	$sql="SELECT * FROM `hospital_rk`.`users` WHERE username = '".$login."' AND userpassword = '".$password."';";
	$result=$pdo->query($sql);
	$rows = $result->fetchall();
	foreach ($rows as $row) {
	$group = $row['group'];
	$grouppassword = $row['grouppassword'];
	}

	try{
		$pdo = new PDO("mysql:host=LocalHost;dbname=hospital_rk", $group, $grouppassword);
		$pdo->SetAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	}
	catch(PDOException $e){
		echo "Error password";
		exit();
	}

	printf("Вы успешно авторизовались в группе %s", $group);
	?>
</html>