search_physicians.php at TherapyDoc

<?php
session_start();
if(!$_SESSION['myusername']){
	header("location:../../index.php");
}
header("Cache-Control: no-cache");
header("Pragma: no-cache");
header("Expires: ".gmdate("D, d M Y H:i:s",time()+(-1*60))." GMT");
header('Content-type: text/html; charset=utf-8');

include 'globals.inc';
require_once "include_b.php";

$_SESSION['phys']="SELECT p.physician_id,CONCAT(p.lname,', ',p.fname),p.phone,s.specialty,p.city
FROM tbl_physician AS p 
LEFT JOIN tbl_specialty AS s ON p.specialty_id=s.specialty_id
order by lname";
?>
<html>
<head>
<script type="text/javascript" src="../../classes/therapydoc/menu.js"></script>
<script src="../../classes/rico21/src/prototype.js" type="text/javascript"></script>
<script src="../../classes/rico21/src/rico.js" type="text/javascript"></script>
<script type="text/javascript">
Rico.loadModule('LiveGridAjax','LiveGridMenu','greenHdg.css');
	Rico.onLoad(function() {
	  var phys_buffer = new Rico.Buffer.AjaxSQL('../../classes/therapydoc/physician/xml_maker.php');
	  

//---- Context Menu----
	  function drsMenu(grid,r,c,onBlankRow) {
		  var id=phys_buffer.getWindowValue(r,0)
		  if (phys_buffer.getWindowValue(r,c) !== null)
		    grid.menu.addMenuItem("View Details", detail);
		    
		    function detail() {
		    	window.location = "physician_detail.php?physician_id="+id;
		    }
		 }
		
	  var grid_options = { prefetchBuffer: true,
			  			   hdrIconsFirst: true,
			  			   FilterLocation: -1,  
			  			   sortAscendImg: 'sort_asc.gif',
			  			   sortDescendImg: 'sort_desc.gif',
			  			   highlightElem: 'cursorRow',
			  			   scrollBarWidth: 20,
			  			   minPageRows: 15,
			  			   maxPageRows: 20,
			  			   columnSpecs: [{width:50},{filterUI:'t',width:200},{width:100},{filterUI:'t',width:200},{filterUI:'t',width:180},{width:50},{width:50}],
			  			   menuEvent: 'contextmenu'
			  };
	   
	  var grid = new Rico.LiveGrid('phys', phys_buffer, grid_options);
		grid.menu=new Rico.GridMenu();
		grid.menu.options.dataMenuHandler=drsMenu;
	});
</script>
<link href="../../CSS/main.css" rel="stylesheet" type="text/css">
</head>
<body>
<div id="wrapper"><?php include '../../classes/therapydoc/menu.php';?>
<div class="txt">
<h1>Physician Lookup</h1>
</div>
<table id="wrapper_table" class="plain">
	<tr>
	<td><table id="table1" class="plain" width="800"><tr><td class="center">
	<?php
				echo "<p class='ricoBookmark'><span id='phys_bookmark'> </span></p>		
				<table width='1024' id='phys'><tr>
				<th>ID</th>
				<th>Name</th>
    			<th>Phone No.</th>
    			<th>Specialty</th>
    			<th>City</th><th></th></tr></table></td></tr></table></td></tr></table></td></tr>";
				?>
</table>
</div>
</body>
</html>