Smarty Template for Courses

smarty

The template (courses.tpl): 

<!DOCTYPE html>
<html>
 <head>
  <title>Departments</title>
  <link rel="stylesheet" href="site.css" type="text/css"/>
 </head>
 <body>
<h1>Faculty of Arts &amp; Sciences</h1>
<p><a href="smarty-dept.php">Return to Department List</a></p>
<h2>Department {$department_code}</h2>
<table cellspacing="0" cellpadding="0">
{foreach from=$courses item=course name=courses}
<tr class="{cycle values="row1,row2,row3,row4"}">
<td class="abbrev">{$course.course_group_long} {$course.num_int}{$course.num_char}</td>
<td class="long">
  <strong>{$course.title}</strong><br/>
  <span class="faculty">{$course.faculty_text}</span>
  <p class="description">
    {$course.description}
  </p>
</td>
</tr>
{/foreach}
</table>
</body>
</html>

Get the Courses for the CHEM department: smarty-courses.php?department_code=CHEM

The SQL:

SELECT course_group_long,
              num_int, num_char, term,
              title, description

smarty-course.php:

<?php
/* ==================================================
    Database Stuff
   ================================================== */
   // Connecting, selecting database
     $mysqli = new mysqli('localhost','class','cscie12','coursecatalog');
     if ($mysqli->connect_errno) {
         echo "Failed to connect to mysql: ".$mysqli->connect_errno." ".$mysqli->connect_error;
     }
   $dept_code = $_GET['department_code'];
   $sqlescaped_dept_code = $mysqli->real_escape_string($dept_code);

   // Performing SQL query
   $query = 'SELECT course_group_long, num_int, num_char, term, title, description, faculty_text';
   $query .= ' from courses where department_code = ';
   $query .= "'".$sqlescaped_dept_code."'";
   $query .= ' order by course_group_long, num_int, num_char, title';

   $result = $mysqli->query($query);

   $i = 0;
   while ($row = $result->fetch_assoc()) {
     $results[$i++] = $row;
   }


/* ==================================================
    Smarty Template Stuff
   ================================================== */
   require('/usr/local/lib/php/Smarty/Smarty.class.php');

   // create object
   $smarty = new Smarty;
   // pass the results to the template
   $smarty->assign('courses', $results);
   $smarty->assign('department_code', $_GET['department_code']);

   $smarty->template_dir = './smarty_templates';
   $smarty->compile_dir = '/tmp/smarty/templates_c';
   $smarty->cache_dir = '/tmp/smarty/cache';
   $smarty->config_dir = './smarty_configs';

   // assign some content. This would typically come from
   // a database or other source, but we'll use static
   // values for the purpose of this example.
   $smarty->assign('dept', $results);

   // display it
   $smarty->display('courses.tpl');

/* ==================================================
    Cleanup
   ================================================== */
   // Free resultset
   $result->free();

   // Closing connection
   $mysql->close();
?>