<?php

//get the parameter from URL
$contact=$_GET["contact"];
$company=$_GET["company"];

$username="input.USER";
$password="input.PASSWORD";
$userdatabase="input.DATABASE";
$companydatabase="input.DATABASE";
$servername="input.SERVERNAME";
mssql_connect($servername,$username,$password);

    //lookup all hints from array if length of q>0
    if (strlen($contact) > 0)
    {
        @mssql_select_db($userdatabase) or die( "Unable to select database");
        $user = utf8_decode($contact);
        $query="SELECT * FROM dbo.employee WHERE dbo.employee.name = '" . $user . "'";
        $result=mssql_query($query) or die("MS Query error");
        $total_rows=mssql_num_rows($result);
        $resultArray=mssql_fetch_array($result);

        header("Cache-Control: no-cache, must-revalidate");
        header('Content-Type: text/html; charset=UTF-8');
        // Date in the past
        header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");

        $rs = "'id': '$resultArray[id]','Sími': '$resultArray[office_phone]','GSM': '$resultArray[mobile_phone]','Email': '$resultArray[email]','user': '$resultArray[username]','MSN': '$resultArray[msn]'";
        $rs = utf8_encode($rs);
        echo $rs;
    }

    if (strlen($company) > 0)
    {
        @mssql_select_db($companydatabase) or die( "Unable to select database");
        $company = utf8_decode($company);
        $query="SELECT * FROM dbo.Companies WHERE dbo.Companies.CompanyName = '" . $company . "'";
        $result=mssql_query($query) or die("MS Query error");
        $total_rows=mssql_num_rows($result);
        $resultArray=mssql_fetch_array($result);

        header("Cache-Control: no-cache, must-revalidate");
        header('Content-Type: text/html; charset=UTF-8');
        // Date in the past
        header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");

        echo utf8_encode("'Viðskiptastjóri': '$resultArray[AccountManagerId]','Nánari Upplýsingar': '$resultArray[Notes]','Warning': '$resultArray[Warning]','Varúð': '$resultArray[WarningInfo]'");
    }

mssql_close();

?>