Web Development

<pre><?php require_once('Connections/eam.php'); ?>
<?php 
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}

$colname_rsMaintenanceAsset = "-1";

if (isset($_GET['recordID'])) {
  $colname_rsMaintenanceAsset = $_GET['recordID'];
}
mysql_select_db($database_eam, $eam);
$query_rsMaintenanceAsset = sprintf("SELECT * FROM maintenance_history WHERE maint_id = %s", GetSQLValueString($colname_rsMaintenanceAsset, "int"));
$rsMaintenanceAsset = mysql_query($query_rsMaintenanceAsset, $eam) or die(mysql_error());
$row_rsMaintenanceAsset = mysql_fetch_assoc($rsMaintenanceAsset);
$totalRows_rsMaintenanceAsset = mysql_num_rows($rsMaintenanceAsset);
}

 
$pageTitle="Maintenance History"; ?>



<?php include('includes/header.php'); ?>
    <h3>Maintenance history for  Asset ID: <?php echo $colname_rsMaintenanceAsset; ?></h3>
    <table class="table1">
      <tr>
        <th>Maintenance ID</th>
        <th>Date Completed</th>
        <th>By</th>
        <th>Checklist</th>
        <th>Comments</th>
        <th>SPARE</th>
        <th>View   </th>
      </tr>
      <?php do { ?>
        <tr onmouseover="this.bgColor='#F2F7FF'" onmouseout="this.bgColor='#FFFFFF'";>
          <td> <?php echo $row_rsMaintenanceAsset['id']; ?>  </td>
          <td> <?php echo $row_rsMaintenanceAsset['date_completed']; ?>  </td>
          <td> <?php echo $row_rsMaintenanceAsset['by_staff']; ?>  </td>
          <td> <?php echo $row_rsMaintenanceAsset['maint_checklist']; ?>  </td>
          <td> <?php echo $row_rsMaintenanceAsset['maint_comm']; ?>  </td>
          <td> <?php echo $row_rsMaintenanceAsset['status']; ?>  </td>


          <td> <a href="HardwareDetail.php?recordID=<?php echo $row_rsMaintenanceAssets['maint_id']; ?>">View</a></td>
 
        </tr>
      <?php } while ($row_rsMaintenanceAssets = mysql_fetch_assoc($rsMaintenanceAssets)); ?>
    </table>

'use strict';
app.factory('authInterceptorService', ['$injector', '$q', '$location', 'localStorageService', function ($injector, $q, $location, localStorageService)
{

    var authInterceptorServiceFactory = {};

    function RequiresRefresh(responseURL)
    {
        if (responseURL.indexOf('getcutofftime') > -1)
            return false;
        if (responseURL.indexOf('resources') !== -1)
            return true;
        return false;
    }

    var _request = function (config)
    {
        config.headers = config.headers || {};

        var authData = localStorageService.get('authorizationData');
        if (authData)
        {
            config.headers.Authorization = 'Bearer ' + authData.token;
        }

        return config || q$.when(config);
    };

    //should handle all error responses in here.
    //var _responseError = function (rejection)
    //{
    //    console.log("Intercepted Rejection: " + rejection);

    //    return $q.reject(rejection);
        
    //};

    var _responseSuccess = function (response)
    {
        var responseURL = response.config.url;
        if (responseURL !== null && typeof responseURL !== 'undefined')
        {
            //check to make sure it's actually an interaction with the resourcesAPI - these are the only times it should refresh the token.
            if (RequiresRefresh(responseURL))
            {
                //get a new token!
                var authData = localStorageService.get('authorizationData');

                var JSONdata = {
                    windowsFullName: authData.windowsFullName
                    , windowsUserName: authData.windowsUserName
                    , summitUserName: authData.summitUserName
                    , summitFullName: authData.summitFullName
                    , clientID: 'MatterhornAuthApp'
                };

                $injector.get("$http")
                    .post(serviceBase + 'usermanagement/account/ReissueToken', JSONdata, { headers: { 'Content-Type': 'application/json', 'Authorization': 'Bearer ' + authData.token } })
                    .then(function (response)
                    {
                        response = response.data;
                        localStorageService.set('authorizationData', {
                            token: response.protectedTicket
                            , summitUserName: response.summitUserName
                            , windowsFullName: response.windowsFullName
                            , windowsUserName: response.windowsUserName
                            , summitFullName: response.summitFullName
                            , refreshToken: ""
                            , useRefreshTokens: false
                            , isSummitAuth: authData.isSummitAuth
                            , isWindowsAuth: authData.isWindowsAuth
                            , roles: response.roles
                        });
                    }, function (err)
                    {
                        return $q.reject(err);
                    });
            }
        }

        //request a new token
        var status = response.status;
        return response || $q.when(response);
    };

    authInterceptorServiceFactory.request = _request;
    ////authInterceptorServiceFactory.responseError = _responseError;
    //authInterceptorServiceFactory.response = _responseSuccess;

    return authInterceptorServiceFactory;
}]);

How to use a php $_SERVER['PHP_SELF'] to insert form data into Mysql database and print 
same form data automatically

// check which button was clicked
// perform calculation
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO reservation (`Class of Room`, `Room Number`, `Customer Name`, `Customer Address`, `Phone number`, Occupation, Amount, `Check in Time`, `Date`, Duration, `Name of Receptionist`) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['Class_of_Room'], "text"),
                       GetSQLValueString($_POST['Room_Number'], "text"),
                       GetSQLValueString($_POST['Customer_Name'], "text"),
                       GetSQLValueString($_POST['Customer_Address'], "text"),
                       GetSQLValueString($_POST['Phone_number'], "text"),
                       GetSQLValueString($_POST['Occupation'], "text"),
                       GetSQLValueString($_POST['Amount'], "text"),
                       GetSQLValueString($_POST['Check_in_Time'], "text"),
                       GetSQLValueString($_POST['Date'], "date"),
                       GetSQLValueString($_POST['Duration'], "text"),
                       GetSQLValueString($_POST['Name_of_Receptionist'], "text"));

  mysql_select_db($database_Morrendb, $Morrendb);
  $Result1 = mysql_query($insertSQL, $Morrendb) or die(mysql_error());

  $insertGoTo = "reservation.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
?>

<section id="main">
            <div id="=cont">
                <ul>
                    <li><a href="about.html"> Our Hitory </a>
                        <ul>
                            <li><a href="index.html"> The Foundation </a></li>
                            <li><a href="about.html"> Our Founders </a></li>
                        </ul>
                    </li>
                    <li>
                        <a href="about.html"> Our Company </a>
                        <ul>
                            <li><a href="index.html"> Our Business Practices </a></li>
                            <li><a href="about.html"> Our Brokers </a></li>
                        </ul>
                    </li>

               </ul>
           </div>

<div id="Layer1" style="position:relative; width:840px; height:2500px; margin: 0 auto; background color: #FFFFF; layer-background-color: #FFFFFF">
  <div id="Layer2" style="position:absolute; left:0px; top:0px; width:840px; height:222px; z-index:1; background-color: #00CCFF; layer-background-color: #00CCFF; border: 1px none #000000;"></div>
  <div id="Layer3" class="style1" style="position:absolute; left:0px; top:50px; width:840px; height:136px; z-index:1">
    <div align="center">TITLE</div>
  </div>
  <div id="Layer4" style="position:absolute; left:0px; top:250px; width:440px; height:380px; z-index:1"><img src="SomePhoto.jpg" width="440" height="380"></div>
  <div id="Layer5" style="position:absolute; left:300px; top:720px; width:460px; height:330px; z-index:1">Some Text </div>
</div>