Location: PHPKode > projects > Clinical Handover Database > output/Current_Jobs_view.php
<?php 
ini_set("display_errors","1");
ini_set("display_startup_errors","1");
set_magic_quotes_runtime(0);

include("include/dbcommon.php");
include("include/Current_Jobs_variables.php");


//	check if logged in
if(!@$_SESSION["UserID"] || !CheckSecurity(@$_SESSION["OwnerID"],"Search"))
{ 
	$_SESSION["MyURL"]=$_SERVER["SCRIPT_NAME"]."?".$_SERVER["QUERY_STRING"];
	header("Location: login.php?message=expired"); 
	return;
}

$filename="";	
$message="";

//connect database
$conn = db_connect();

$keys=array();
$keys["Primary"]=postvalue("editid1");

//	get current values and show edit controls

$strSQL=$gstrSQL;
$where = KeyWhere($keys);
$strSQL = AddWhere($strSQL,$where);



LogInfo($strSQL);
$rs=db_query($strSQL,$conn);
$data=db_fetch_array($rs);


include('libs/Smarty.class.php');
$smarty = new Smarty();

	$smarty->assign("show_key1", htmlspecialchars(GetData($data,"Primary", "")));

$keylink="";
$keylink.="&key1=".htmlspecialchars(urlencode($data["Primary"]));

////////////////////////////////////////////
//	Patient Name - 
	$value="";
		$value = htmlspecialchars(GetData($data,"Patient Name", ""));
	$smarty->assign("show_Patient_Name",$value);
////////////////////////////////////////////
//	Consultant - 
	$value="";
		if(strlen($data["Consultant"]))
	{
		$strdata = make_db_value("Consultant",$data["Consultant"]);
		$LookupSQL="SELECT ";
					$LookupSQL.="`Consultant`";
		$LookupSQL.=" FROM `consultants` WHERE `Consultant` = " . $strdata;
					LogInfo($LookupSQL);
		$rsLookup = db_query($LookupSQL,$conn);
		if($lookuprow=db_fetch_numarray($rsLookup))
			$value=ProcessLargeText($lookuprow[0],"","",MODE_VIEW);
		else
			$value=ProcessLargeText(GetData($data,"Consultant", ""),"field=Consultant".$keylink,MODE_VIEW);
	}
	else
		$value="";
	$smarty->assign("show_Consultant",$value);
////////////////////////////////////////////
//	Date - Short Date
	$value="";
		$value = htmlspecialchars(GetData($data,"Date", "Short Date"));
	$smarty->assign("show_Date",$value);
////////////////////////////////////////////
//	Type - 
	$value="";
		$value = htmlspecialchars(GetData($data,"Type", ""));
	$smarty->assign("show_Type",$value);
////////////////////////////////////////////
//	Status - 
	$value="";
		$value = htmlspecialchars(GetData($data,"Status", ""));
	$smarty->assign("show_Status",$value);
////////////////////////////////////////////
//	Name - 
	$value="";
		$value = htmlspecialchars(GetData($data,"Name", ""));
	$smarty->assign("show_Name",$value);
////////////////////////////////////////////
//	Result - 
	$value="";
		$value = htmlspecialchars(GetData($data,"Result", ""));
	$smarty->assign("show_Result",$value);
////////////////////////////////////////////
//	Notes - 
	$value="";
		$value = htmlspecialchars(GetData($data,"Notes", ""));
	$smarty->assign("show_Notes",$value);

$smarty->display("Current_Jobs_view.htm");

?>
Return current item: Clinical Handover Database