PageRenderTime 44ms CodeModel.GetById 9ms RepoModel.GetById 0ms app.codeStats 0ms

/courses/course-details.php

https://bitbucket.org/molusc/sma-website
PHP | 158 lines | 151 code | 4 blank | 3 comment | 10 complexity | f9cbe8adfa72e41a5c7b89c6ee5e8cee MD5 | raw file
Possible License(s): BSD-3-Clause 
    

  1. <?php session_start();  ?>

    2. 

  2. <?php //setup and error-check database connection

    3. 

  3. $location = "localhost"; 

    4. 

  4. $username = "wf-c32a-0dfcce"; 

    5. 

  5. $password = "bma"; 

    6. 

  6. $database = "wf-c32a-0dfcce"; 

    7. 

  7. $conn = mysql_connect("$location","$username","$password"); 

    8. 

  8. if (!$conn) die ("Could not connect MySQL"); 

    9. 

  9. mysql_select_db($database,$conn) or die ("Could not open database");

    10. 

  10. $courseidnum = $_GET["id"];

    11. 

  11. $query = "SELECT * 

    12. 

  12. FROM catalog 

    13. 

  13. WHERE (catalog_id=$courseidnum);";

    14. 

  14. //echo $query;

    15. 

  15. if ($result = mysql_query($query)) {

    16. 

  16. $row = mysql_fetch_array($result); 

    17. 

  17. ?>

    18. 

  18. <html>

    19. 

  19. <head>

    20. 

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

    21. 

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

    22. 

  22. <meta name="GENERATOR" content="Dreamweaver MX">

    23. 

  23. <meta name="keywords" content="<?php echo "$row[keywords]"; ?>">

    24. 

  24. 

    25. 

  25. <title><?php echo "$row[title]"; ?></title>

    26. 

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

    27. 

  27. 

    28. 

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

    29. 

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

    30. 

  30. </head>

    31. 

  31. 

    32. 

  32. <body>

    33. 

  33. <a href="index.php?catid=6#5">Training Courses - Symmons Madge Associates Ltd</a>

    34. 

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

    35. 

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

    36. 

  36.   <tr>

    37. 

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

    38. 

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

    39. 

  39. -->

    40. 

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

    41. 

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

    42. 

  42.   </tr>

    43. 

  43.   <tr>

    44. 

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

    45. 

  45.       <tr>

    46. 

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

    47. 

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

    48. 

  48.         <td>&nbsp;&nbsp;<a 		  

    49. 

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

    50. 

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

    51. 

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

    52. 

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

    53. 

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

    54. 

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

    55. 

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

    56. 

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

    57. 

  57.       </tr>

    58. 

  58.     </table></td>

    59. 

  59.   </tr>

    60. 

  60. </table>

    61. 

  61. <!-- #EndLibraryItem --></div>

    62. 

  62. <div class="printonly">

    63. 

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

    64. 

  64. </div>

    65. 

  65. <div id="main"> 

    66. 

  66.   <p class="breadcrumbs printhide"><a href="../home.html" target="_top">Home</a>&nbsp;&gt;&nbsp;<a href="../training/index.html" target="_top">Training</a>&nbsp;&gt;&nbsp;<a href="index.php">Courses</a>&nbsp;&gt;&nbsp; <?php echo "$row[title]"; ?></p>

    67. 

  67.   <h1 class="bmapagetitle"> <strong><font face="arial" size="4">&nbsp;</font></strong>

    68. 

  68.     </h1>

    69. 

  69.   <div class="bmabody" id="main">

    70. 

  70.   <h1 class="coursetitle"><a name="top"></a><?php echo "$row[title]"; ?> <span class="bmapagetitle"><strong><font face="arial" size="4">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </font></strong></span><span class="bmapagetitle"><strong><font face="arial" size="4">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;	 <strong><font face="arial" size="4"><strong><font face="arial" size="4"><font face="arial" size="1"></font></font></strong></font></strong></font></strong></span></h1>

    71. 

  71.     <h2 class="coursesubtitle"><?php echo "$row[subtitle]"; ?></h2>

    72. 

  72.     <?php echo "$row[description]"; ?> <?php echo "$row[objectives]"; ?>

    73. 

  73.   <?php echo "$row[outline]"; ?>

    74. 

  74.   <?php echo "$row[modeofdelivery]"; ?>

    75. 

  75.   <?php echo "$row[benefitsperceived]"; ?>

    76. 

  76.   <?php echo "$row[intended_for]"; ?>

    77. 

  77.   <?php echo "$row[precourserequirements]"; ?>

    78. 

  78.   <?php echo "$row[duration]"; ?>

    79. 

  79.   <h3>Locations:</h3> 

    80. 

  80.    <?php

    81. 

  81. $query2 = "SELECT course_title_id, UNIX_TIMESTAMP(schedule.course_date) AS course_date, course_town

    82. 

  82. FROM schedule

    83. 

  83. WHERE (course_title_id=$courseidnum) and (course_date >= NOW()) ORDER BY course_date;";

    84. 

  84. // echo $query2;

    85. 

  85. if ($result2 = mysql_query($query2)) {

    86. 

  86.   	$numrows2 = mysql_num_rows($result2);

    87. 

  87. //	echo "<p>The course is scheduled $numrows2 times:</p>"; 

    88. 

  88. 	if ($numrows2 < 1) {

    89. 

  89. 		echo "<p>This course is currently only being provided on an In-house basis but will 

    90. 

  90.     be offered as an open course immediately sufficient numbers have registered 

    91. 

  91.     their interest.</p>

    92. 

  92.   <p>To register your interest go to <a href=/contact.html>Contact Us</a> and 

    93. 

  93.     fill in the email form or telephone 01446 775959<br>

    94. 

  94.   </p>";

    95. 

  95. 	} else {

    96. 

  96. ?>

    97. 

  97.     <table BORDER="0" CELLPADDING="2" CELLSPACING="3">

    98. 

  98.       <tr bgcolor="#000066"> 

    99. 

  99.         <td width="90"><div align="left"><font color="#FFFFFF" SIZE="-1"><strong>Date</strong></font></div></td>

    100. 

  100.         <td width="90"><div align="left"><font color="#FFFFFF" SIZE="-1"><strong>Venue</strong></font></div></td>

    101. 

  101.       </tr>

    102. 

  102.       <?php 

    103. 

  103. 		While ($row2 = mysql_fetch_array($result2)) { ?>

    104. 

  104.       <tr bgcolor="#CCCCCC"> 

    105. 

  105.         <td> <font SIZE="-1"> 

    106. 

  106.           <?php 

    107. 

  107. 						$dt = $row2[course_date];

    108. 

  108. 						$dt = date('jS F Y', $dt);

    109. 

  109. 						echo $dt;

    110. 

  110. 					?>

    111. 

  111.         &nbsp;&nbsp;</font> </td>

    112. 

  112.         <td><font SIZE="-1"><?php echo "$row2[course_town]"; ?></font></td>

    113. 

  113.         <td bgcolor="#ffffff"><font SIZE="-1"><?php echo "<a href=\"../booking_form.php?id=",$row2['course_title_id'],"&venue=",rawurlencode($row2[course_town]),"&date=",rawurlencode($dt),"&title=",rawurlencode($row[title]),"\">Book</a>"; ?></font></td>

    114. 

  114.       </tr>

    115. 

  115.       <?php

    116. 

  116. 		}

    117. 

  117. 		?>

    118. 

  118.     </table>

    119. 

  119.     <p>

    120. 

  120.       <?php

    121. 

  121. 	}

    122. 

  122. ?>

    123. 

  123.       <?php

    124. 

  124. 	} else {

    125. 

  125. 	echo "Sorry, there was a Database error - cannot display course schedule.<br>  Please contact us for information.";

    126. 

  126. 	}

    127. 

  127. } else {

    128. 

  128. echo "<p>Sorry, there was a Database error - cannot display course details.</p><p>Please contact us</a> for information.</p>";

    129. 

  129. }

    130. 

  130. ?>	

    131. 

  131.       <?php echo "$row[fee]"; ?>

    132. 

  132. </p>

    133. 

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

    134. 

  134.       Notice</a><br>

    135. 

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

    136. 

  136.     <!-- #EndLibraryItem -->

    137. 

  137.     <!-- Start of StatCounter Code -->

    138. 

  138. </p>

    139. 

  139.   </div>

    140. 

  140. </div>

    141. 

  141. <div class="printhide">

    142. 

  142.   <script type="text/javascript" language="javascript">

    143. 

  143. var sc_project=337750; 

    144. 

  144. var sc_partition=1; 

    145. 

  145. </script>

    146. 

  146. 

    147. 

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

    148. 

  148. <noscript>

    149. 

  149. <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>

    150. 

  150. </noscript>

    151. 

  151. <!-- End of StatCounter Code -->

    152. 

  152. </div>

    153. 

  153. <!-- #BeginLibraryItem "/Library/Google Analytics PHP Include.lbi" -->

    154. 

  154. 	<?php include_once($_SERVER['DOCUMENT_ROOT'] . "/analyticstracking.php"); ?><!-- #EndLibraryItem --></body>

    155. 

  155. </html>

    156. 

  156. <?php

    157. 

  157. mysql_free_result($result);

    158. 

  158. ?>
    159.