Untitled

<?php
session_start();//session starts here

?>


<html>
<head lang="en">
    <meta charset="UTF-8">
    <link type="text/css" rel="stylesheet" href="bootstrap-3.2.0-distcssbootstrap.css">
    <title>Login</title>
</head>

<body>


<div class="container">
    <div class="row">
        <div class="col-md-4 col-md-offset-4">
            <div class="login-panel panel panel-success">
                <div class="panel-heading">
                    <h3 class="panel-title">Sign In</h3>
                </div>
                <div class="panel-body">
                    <form role="form" method="post" action="login.php">
                        <fieldset>
                            <div class="form-group"  >
                                <input class="form-control" placeholder="Card number" name="cardnumber" type="text" autofocus></br>


                                <input class="btn btn-lg btn-success btn-block" type="submit" value="Submit" name="login" >

                            <!-- Change this to a button or input when using this as a form -->
                          <!--  <a href="index.html" class="btn btn-lg btn-success btn-block">Submit</a> -->
                        </fieldset>
                    </form>
                </div>
            </div>
        </div>
    </div>
</div>


</body>

</html>

<?php
$database = 'NOVCO';
$user = 'salman';
$password = 'qwerty123!';
$hostname = '85.132.67.226';
$port = 50000;

$conn_string = "DRIVER={IBM DB2 ODBC DRIVER};DATABASE=$database;" .
  "HOSTNAME=$hostname;PORT=$port;PROTOCOL=TCPIP;UID=$user;PWD=$password;";
$conn = db2_connect($conn_string, '', '');


if(isset($_POST['login']))
{
    $cardnumber=$_POST['cardnumber'];

    $query="SELECT COUNT(*) FROM auidet.cabinet WHERE CARDNUMBER='$cardnumber'";

   $stmt = db2_exec($conn, $query);

    if(db2_num_rows($stmt))
    {
        print "<script>window.open('welcome.php','_self')</script>";

        $_SESSION['cardnumber']=$cardnumber;

    }
    else
    {
        print "<script>alert('Something wrong!')</script>";
    }
}
?>