PageRenderTime 42ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/hsc/hsc-diary.php

https://bitbucket.org/molusc/sma-website
PHP | 147 lines | 126 code | 9 blank | 12 comment | 4 complexity | b2a8eea5e757f7a052a464b11884cdd4 MD5 | raw file
Possible License(s): BSD-3-Clause 
    

  1. <?php session_start();  ?>
    2. 

  2. <?php require_once('../Connections/bryanmadge.php'); ?>
    3. 

  3. 	<?php
    4. 

  4. 	mysql_select_db($database_bryanmadge, $bryanmadge);
    5. 

  5. 

  6. 	$query_Diary = "SELECT schedule.course_id, schedule.course_title_id, catalog.title, UNIX_TIMESTAMP(schedule.course_date) AS course_date, schedule.course_town, schedule.course_venue_id FROM schedule INNER JOIN catalog ON schedule.course_title_id = catalog.catalog_id WHERE (course_date >= NOW()) AND categoryid IN(21) ORDER BY course_date";
    7. 

  7. 

  8. 	$Diary = mysql_query($query_Diary, $bryanmadge) or die(mysql_error());
    9. 

  9. //	$row_Diary = mysql_fetch_assoc($Diary);
    10. 

  10. 	$totalRows_Diary = mysql_num_rows($Diary);
    11. 

  11. ?>
    12. 

  12. <html><!-- InstanceBegin template="/Templates/general.dwt" codeOutsideHTMLIsLocked="false" -->
    13. 

  13. <head>
    14. 

  14. <LINK REL="SHORTCUT ICON" HREF="../favicon.ico">
    15. 

  15. <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
    16. 

  16. <meta name="GENERATOR" content="Dreamweaver MX">
    17. 

  17. <meta name="keywords" content="CDM Regulations, CESMM, civil engineering, construction management, contract administration, contract procedures, courses, environmental awareness, geotechnical, Health and safety, ICE Conditions of Contract, ICE Professional Review, JCT Form of Contract, Method of Measurement for Highway Works, MMHW, NEC New Engineering and Construction Contract, Project management, report writing, site supervision, Standard Forms of Contract, training, AMPR, CET, CPD, TMPR, Eurocodes">
    18. 

  18. <!-- #BeginEditable "doctitle" -->
    19. 

  19. <title>Health &amp; Social Care Course Diary - Symmons Madge Associates Ltd</title>
    20. 

  20. <!-- #EndEditable -->
    21. 

  21. <link rel="stylesheet" href="../bma.css" type="text/css">
    22. 

  22. <link rel="stylesheet" href="../print.css" type="text/css" media="print" />
    23. 

  23. <!-- InstanceParam name="OptionalPageTitle" type="boolean" value="true" --><!-- InstanceParam name="OptionalBreadcrumbs" type="boolean" value="true" --><!-- InstanceParam name="Google Analytics Code" type="boolean" value="true" -->
    24. 

  24. </head>
    25. 

  25. 

  26. <body><div class="printhide"><!-- #BeginLibraryItem "/Library/Masthead.lbi" -->
    27. 

  27. <table width="100%" border="0" cellspacing="0" cellpadding="0">
    28. 

  28.   <tr>
    29. 

  29.     <td width="150" rowspan="2"><a href="../home.html" target="_top">
    30. 

  30.       <!--        	<img src="../images/smalogo_sml_party_hat.gif" ALT="Symmons Madge Associates Ltd home" width="124" height="90" border="0">
    31. 

  31. -->
    32. 

  32.       <img src="../images/smalogo_sml.gif" ALT="Symmons Madge Associates Ltd home" width="124" height="64" border="0"> </a></td>
    33. 

  33.     <td><p class="tagline"><font size="4">Training for a Successful Future</font></p></td>
    34. 

  34.   </tr>
    35. 

  35.   <tr>
    36. 

  36.     <td valign="bottom"><table class="masthead" width="100%" height=25 border="0" cellpadding="0" cellspacing="0">
    37. 

  37.       <tr>
    38. 

  38.         <!--  	<td width="5%" bgcolor="#FFFFFF">&nbsp;</td>-->
    39. 

  39.         <td align="left" valign="top"><img src="/images/corner_TL.gif" width="15" height="25"></td>
    40. 

  40.         <td>&nbsp;&nbsp;<a 		  
    41. 

  41. 						href="../courses/index.php" target="_top">Courses</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
    42. 

  42. 						href="../diary/diary.php" target="_top">Course&nbsp;Diary</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
    43. 

  43. 						href="../training/training-club.php" target="_top">Regional Training</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
    44. 

  44. 						href="../consultancy/index.html" target="_top">Consultancy</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
    45. 

  45. 						href="../search/index.php" target="_top">Search</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
    46. 

  46.                         href="../links.html" target="_top">Links</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
    47. 

  47. 						href="../company/about.html" target="_top">About us</a> &nbsp;<FONT color=#909090>:</FONT>&nbsp;&nbsp;<a 
    48. 

  48. 						href="../contact.html" target="_top">Contact</a>&nbsp;&nbsp;</td>
    49. 

  49.       </tr>
    50. 

  50.     </table></td>
    51. 

  51.   </tr>
    52. 

  52. </table>
    53. 

  53. <!-- #EndLibraryItem --></div>
    54. 

  54. <div class="printonly">
    55. 

  55.   <div align="right"><img src="../images/smalogo_sml.gif" width="124" height="64" class="floatright"></div>
    56. 

  56. </div>
    57. 

  57. <div id="main"> 
    58. 

  58.   <p class="breadcrumbs printhide"><!-- #BeginEditable "breadcrumbs" --><a href="../home.html" target="_top">Home</a>&nbsp;&gt;&nbsp;Health &amp; Social Care &gt; Course Diary <!-- #EndEditable --></p>
    59. 

  59.   <h1 class="bmapagetitle"><!-- #BeginEditable "title" -->Health &amp; Social Care Course Diary<img src="/images/otherlogos/bsi.gif" align=center width="65" height="65" alt="BSI logo" class="bsilogo"><!-- #EndEditable --></h1>
    60. 

  60.   <!-- #BeginEditable "body" -->
    61. 

  61.   <div id="main" class="bmabody">
    62. 

  62.     <p> For further details and bookings please <a href="../booking_form.php" target="_self">click
    63. 

  63. 		here</a> or phone us on (01446) 775959 or e-mail <a href="mailto:natalie.collingham@symmonsmadge.co.uk">natalie.collingham@symmonsmadge.co.uk</a>.</p>
    64. 

  64.     <!-- 	<p>There are <?php echo $totalRows_Diary ?> courses in the table</p>
    65. 

  65.  -->	<table width="90%" border="0" align="center" cellpadding="3" cellspacing="0" class="bmabody">
    66. 

  66. <?php
    67. 

  67. 	while ($row_Diary = mysql_fetch_assoc($Diary)) {
    68. 

  68. 		// set $month
    69. 

  69. 		$dt = $row_Diary['course_date'];
    70. 

  70. 		$month = (int) date('n', $dt);
    71. 

  71. //		echo 'start month: ',$month,'<br>'; //debug
    72. 

  72. //		echo 'start current: ',$current,'<br>'; //debug
    73. 

  73. 		?>
    74. 

  74. 

  75. 		<?php if ($month <> $current) { // if first of new month ?>
    76. 

  76. 			<tr valign="bottom">
    77. 

  77. 				<td height=50 class="diarymonth" colspan="3">
    78. 

  78. 					<?php
    79. 

  79. 						// print month header
    80. 

  80. 						$dt = $row_Diary['course_date'];
    81. 

  81. 						echo date('F Y', $dt);
    82. 

  82. 					?>
    83. 

  83. 				</td>
    84. 

  84. 			</tr>
    85. 

  85. 		<?php
    86. 

  86. 		} ?>
    87. 

  87. 

  88. 		<tr>
    89. 

  89. 			<td width="30" valign=top> <p>
    90. 

  90. 				<?php
    91. 

  91. 					// print course date
    92. 

  92. 					$dt = $row_Diary['course_date'];
    93. 

  93. 					$current = (int) date('n', $row_Diary['course_date']);
    94. 

  94. 					// echo date('jS F Y', $dt);
    95. 

  95. 					echo date('jS', $dt);
    96. 

  96. 				?>
    97. 

  97. 				</p></td>
    98. 

  98. 			<td valign=top> <p>
    99. 

  99. 				<?php echo "<a href=\"/courses/course-details.php?id=",$row_Diary['course_title_id'],"\">",$row_Diary['title'],"</a>";
    100. 

  100. 				?>
    101. 

  101. 				</p></td>
    102. 

  102. 			<td valign=top> <div align="center">
    103. 

  103. 				<?php echo $row_Diary['course_town']; ?>
    104. 

  104. 				</div></td>
    105. 

  105.             <td valign="top" bgcolor="#ffffff"><font SIZE="-1"><?php echo "<a href=\"../booking_form.php?id=",$row_Diary['course_title_id'],"&venue=",rawurlencode($row_Diary['course_town']),"&date=",rawurlencode(date('jS F Y', $dt)),"&title=",rawurlencode($row_Diary['title']),"\">Book</a>"; ?></font></td>
    106. 

  106. 	  </tr>
    107. 

  107. 		<?php
    108. 

  108. //			echo "<td>month: $month</td>"; //debug
    109. 

  109. //			echo "<td>current: ",(int) date('n', $row_Diary['course_date']),"</td>"; //debug
    110. 

  110. 		?>
    111. 

  111. 

  112. 

  113. 		<?php
    114. 

  114. 		$dt = $row_Diary['course_date']; //debug
    115. 

  115. //		$month = date('n', $dt); //debug
    116. 

  116. //		echo 'end month: ',$month,'<br>'; //debug
    117. 

  117. //		echo 'end current: ',$current,'<br>'; //debug
    118. 

  118. 	} ?>
    119. 

  119. 		</table>
    120. 

  120. 	<p>&nbsp;</p>
    121. 

  121.   <p>For further details and bookings please <a href="../booking_form.php" target="_self">click 
    122. 

  122.     here</a> or phone us on (01446) 775959 or e-mail <a href="mailto:natalie.collingham@symmonsmadge.co.uk">natalie.collingham@symmonsmadge.co.uk</a>. 
    123. 

  123. </div>
    124. 

  124. <!-- #EndEditable --></div>
    125. 

  125. <div class="printhide"><!-- #BeginLibraryItem "/Library/Full Footer.lbi" --><hr width="65%">
    126. 

  126. <p align="center"><!-- #BeginLibraryItem "/Library/Footer.lbi" --><!-- #EndLibraryItem --></p>
    127. 

  127. 

  128. <!-- #EndLibraryItem --><!-- #BeginLibraryItem "/Library/Legal footer.lbi" --><div align="center" class="bmabody"><font size="1"><a href="../company/legal.html">Legal
    129. 

  129.       Notice</a><br>
    130. 

  130.   Copyright &copy; Symmons Madge Associates Ltd, All Rights Reserved</font></div>
    131. 

  131. <!-- #EndLibraryItem --><!-- Start of StatCounter Code -->
    132. 

  132. <script type="text/javascript" language="javascript">
    133. 

  133. var sc_project=337750; 
    134. 

  134. var sc_partition=1; 
    135. 

  135. </script>
    136. 

  136. 

  137. <script type="text/javascript" language="javascript" src="http://www.statcounter.com/counter/counter.js"></script><noscript>
    138. 

  138. <a href="http://www.statcounter.com/" target="_blank"><img  src="http://c2.statcounter.com/counter.php?sc_project=337750&amp;java=0" alt="counter stats" border="0"></a>
    139. 

  139. </noscript>
    140. 

  140. <!-- End of StatCounter Code -->
    141. 

  141. <!-- InstanceBeginEditable name="EditRegion1" --><!-- #BeginLibraryItem "/Library/Google Analytics PHP Include.lbi" -->
    142. 

  142. 	<?php include_once($_SERVER['DOCUMENT_ROOT'] . "/analyticstracking.php"); ?><!-- #EndLibraryItem --><!-- InstanceEndEditable --></div>
    143. 

  143. </body>
    144. 

  144. <!-- InstanceEnd --></html>
    145. 

  145. <?php
    146. 

  146. mysql_free_result($Diary);
    147. 

  147. ?>
    148.