<?php
@session_start();
@include('condb.php');
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $User = $_POST["User"]; 
    $Pass = $_POST["Pass"];
    $sql = "SELECT * FROM `pta_users` WHERE `user_name` LIKE '$User' AND `user_pass` = '$Pass';";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        $_SESSION['active']=1;
        echo "<script>
                alert('เข้าสู่ระบบสำเร็จแล้ว !');
                window.location.href = 'index.php';
              </script>";
    } else {
        @session_destroy();
        echo "<script>
        alert('ชื่อผู้ใช้งานหรือรหัสผ่านผิดพลาด : " . $conn->error . "');
        window.location.href = 'index.php';
      </script>";
    }
}
$conn->close();
?>