PHP_index.php2

<?php

$realm = 'Restricted area';

//user => password
$users = array('admin' => 'mypass', 'guest' => 'guest');


if (empty($_SERVER['PHP_AUTH_DIGEST'])) {
    header('HTTP/1.1 401 Unauthorized');
    header('WWW-Authenticate: Digest realm="'.$realm.
           '",qop="auth",nonce="'.uniqid().'",opaque="'.md5($realm).'"');

    die('Text to send if user hits Cancel button');
}


// analyze the PHP_AUTH_DIGEST variable
if (!($data = http_digest_parse($_SERVER['PHP_AUTH_DIGEST'])) ||
    !isset($users[$data['username']]))
    die('Wrong Credentials!');


// generate the valid response
$A1 = md5($data['username'] . ':' . $realm . ':' . $users[$data['username']]);
$A2 = md5($_SERVER['REQUEST_METHOD'].':'.$data['uri']);
$valid_response = md5($A1.':'.$data['nonce'].':'.$data['nc'].':'.$data['cnonce'].':'.$data['qop'].':'.$A2);

if ($data['response'] != $valid_response)
    die('Wrong Credentials!');

// ok, valid username & password
echo '<div  class="container"><div class="alert alert-success">You are logged in as: ' . $data['username'].'</div></div>';
session_start();
$_SESSION['loggedin'] = true;
$_SESSION['username'] = $data['username'];


//phpinfo();
$dbhost = 'localhost';
$dbuser = 'db4133414';
$dbpass = 'db4133414';
$dbname = 'db4133414';
$conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);
if ($conn->connect_error) {
    echo "Connection failed<br/>";
    die("Connection failed: " . $conn->connect_error);
}

echo "<div class='container'><h1>Current Names</h1></div>";

echo "<div class='container'><table class='table table-bordered'><tr><th>First Name</th><th>Surname</th><th>Date of B</th><th>Salary</th><th>Sex</th><th>Department</th><th>Supervisor</th><th>Button</th   ></tr>";


$sql = 'SELECT e.fname, e.ssn, e.lname, e.bdate, e.salary, e.sex, d.dname, concat(f.fname," ", f.lname) AS supervisor FROM employee e LEFT JOIN employee f ON (e.superssn = f.ssn), department d WHERE (e.dno = d.dnumber)';
$result = $conn->query($sql);
$return_arr = array();

while($row = $result->fetch_assoc())
{
    echo "<tr><td>";
    echo $row['fname']."</td><td>";
    echo $row['lname']."</td><td>";
    echo $row['bdate']."</td><td>";
    echo $row['salary']."</td><td>";
    echo $row['sex']."</td><td>";
    echo $row['dname']."</td><td>";
    echo $row['supervisor']."</td><td><button class='btn btn-dark' onclick='displaySSN(" . $row['ssn'] . ")'>Click</button>";
    echo "</td></tr>";
}


echo "</table><br><br>";

echo "<script type='text/javascript'>
        function displaySSN(ssn){
            alert(ssn);
        }

    </script>";

echo "<h1>Add a new name:</h1><br>";
echo "<form action='other.php' method='post'>
  First Name: <input type='text' name='fname' class='form-control'> <br> <br>
  Surname: <input type='text' name='sname' class='form-control'> <br> <br>
  <button type='submit' type='button' class='btn btn-primary' onclick='displaySSN()'>Submit</button>
</form></div>";

// function to parse the http auth header
function http_digest_parse($txt)
{
    // protect against missing data
    $needed_parts = array('nonce'=>1, 'nc'=>1, 'cnonce'=>1, 'qop'=>1, 'username'=>1, 'uri'=>1, 'response'=>1);
    $data = array();
    $keys = implode('|', array_keys($needed_parts));

    preg_match_all('@(' . $keys . ')=(?:([\'"])([^\2]+?)\2|([^\s,]+))@', $txt, $matches, PREG_SET_ORDER);

    foreach ($matches as $m) {
        $data[$m[1]] = $m[3] ? $m[3] : $m[4];
        unset($needed_parts[$m[1]]);
    }

    return $needed_parts ? false : $data;
}
?>

<!DOCTYPE html>
<html>
<head>
    <style>
        table,td,tr { border:1px solid #021ff9;
            //background-color:#9ec2d3;
            background-color:#eaf1f2;
            padding:4px;
            }
        td { color:#002156;}
        body { background-color:#cee4ef;}
    </style>
    <body>


    </body>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">

</head>


</html>