Web Development

<link rel="stylesheet" type="text/css" media="screen and (max-device-width: 320px)" href="style320.css" />
<link rel="stylesheet" type="text/css" media="screen and (max-device-width: 544px)" href="style544.css" />
<link rel="stylesheet" type="text/css" media="screen and (max-device-width: 768px)" href="style768.css" />
<link rel="stylesheet" type="text/css" media="screen and (max-device-width: 992px)" href="style992.css" />
<link rel="stylesheet" type="text/css" media="screen and (max-device-width: 1200px)" href="style1200.css" />

    <form id="FormToValidate" method="POST" action="verify_login.php">
      <table width="560px" align="center">
        <tr>
         <td width="100%"><img id="Img2" src="images/welcome.gif" alt="" runat="server" /></td>
        </tr>
        <tr>
         <td>
          <span style="color:red;font-weight:bold;">INSTRUCTIONS:</span> To log into the screen, you will need to sign in with your .....</span>.
          </td></tr><tr><td> </td></tr>
          <td>
           <span style="background-color:Yellow;"> eg: *****</span>
         </td>
       </tr>
       <tr>
         <td width="100%"><img id="Img1" src="images/line.gif" alt="" runat="server" /></td>
       </tr>
      </table>
      <table>
       <tr>

         <td nowrap>
                 <div class="input text">
            <label>User Name:</label>
            <input  maxlength="40" class="required" name="user" id="user" size="20" placeholder="Enter username!" type="text" title="Please enter a username." tabindex="2" value="" style="width:400px;color:#000;font-size:10pt;height:20px;" />
          </div>
        </td>
          </tr>
          <tr>
            <td nowrap>
             <div class="input text">
              <label>Password:</label>
              <input  maxlength="40" class="required" name="pass" id="pass" size="20" placeholder="Enter password!" type="password" tabindex="3" title="Please enter a password." value="" style="width:400px;color:#000;font-size:10pt;height:20px;" />
             </div>
            </td>

       </tr>

       <tr>
          <td></td>
            <td>
            <div class="buttonSubmit">
            <input type="submit" id="btnValidate" style="width:80px; margin-left:-152px;" value="Log in >>" />
           </div><br clear="all"/>
      </td>
    </tr>
  </table>

</form>

$('#GetEmployee').click(function () {
            var id = $('#employeeidget').val();
            $.ajax({
                url: 'http://localhost:56811/api/Values/Get?id=' + id,
                type: 'GET',
                dataType: 'jsonp',
                success: function (data) {
                    var items = '';
                    $.each(data, function (i, item) {
                        var rows = "<tr>"
                        + "<td>" + data.EmployeeID + "</td>"
                        + "<td>" + data.Name + "</td>"
                        + "<td>" + data.ManagerID + "</td>"
                        + "</tr>";
                        $('#tblEmployee tbody').append(rows);
                    });
                },
                error: function (jqXHR, exception) {
                    if (jqXHR.status == 404) {
                        alert('Requested page not found. [404]');
                    } else if (jqXHR.status === 0) {
                        alert('Not connect.\n Verify Network.');
                    } else if (jqXHR.status == 500) {
                        alert('Internal Server Error [500].');
                    } else if (exception === 'parsererror') {
                        alert('Requested JSON parse failed.');
                    } else if (exception === 'timeout') {
                        alert('Time out error.');
                    } else if (exception === 'abort') {
                        alert('Ajax request aborted.');
                    } else {
                        alert('Uncaught Error.\n' + jqXHR.responseText);
                    }
                }
            });

<?php
$con = new mysqli('localhost', 'root', 'cookie', 'homedb');
if ($con->connect_error)
    { echo 'Cannot Connect to mySQL: ', $con->connect_error(); } 
else
 { 
if (isset($_POST['url']))
 { 
	$stmt = $con->prepare('
    SELECT url, username, password, purpose, emailused, date-time, count, saved
			FROM emailtbl
			WHERE url = ? ');
		$stmt->bindValue(1, $_POST['url']);
		$stmt->execute();		
		if ($row = $stmt->fetch())
 {		
	echo '
		<table class="emailResults">
	<caption>
	Email Activity for ', htmlspecialchars($_POST['url']), '
		</caption>
		<thead>
		<tr>
<th scope="col">url</th>							
 <th scope="col">Username</th>
  <th scope="col">Password</th>
   <th scope="col">Purpose</th>
    <th scope="col">E-Mail Used</th>
      <th scope="col">date-time</th>
      <th scope="col">count</th>  
          <th scope="col">Saved</th>
  </tr>
          </thead><tbody>';					
		do
 {			
	echo '
	<tr>';						
  foreach ($row as $value) echo '
		<td>', $value, '</td>';						
	echo '
   </tr>';
 } 
    while ($row = $stmt->fetch());			
	echo '
	</tbody></table>';			
 } 
else echo '<div class="error">No Results Found</div>';		
 } 
else echo '<div class="error">No valid "url" for Query</div>';	
}
$stmt = $con->prepare('
	UPDATE emailtbl
	SET date-time=DATE();
             count=count + 1'
	WHERE url = ? ');
    $stmt->bindParam(s, $_POST['url']); 
      $stmt->execute();
   echo $stmt->error ? '
	<div class="error">
  url update query error: ' . $stmt->error . '
	</div>
' : ( $stmt->affected_rows > 0 ? '
	<div class="success">
		Success! Updated ' . $stmt->affected_rows . ' records.
	</div>
' : '
	<div class="error">
	FAILED! No records updated.
	<div>
');
?>