- $user_name = "test";
- $user_pass = "test";
- $log = "";
- if ($conn = mysql_connect("localhost", "root", "000"))
- {
- mysql_select_db("A7r", $conn);
- mysql_query ('SET NAMES utf8', $conn);
- $query = "SELECT * FROM logpas WHERE `Login` =".$user_name;
- if ($result = mysql_query($query, $conn))
- {
- while($mydata = mysql_fetch_array($result))
- {
- if ($user_name == $mydata['Login']&& $user_pass == $mydata['Password']) $log = "yes";
- else $log = "no";
- }
- } else {
- $log = "no";
- }
- }
- else
- {
- $err = "Ошибка соединения с базой данных";
- }
- MYSQL_CLOSE();
- ?>