Mercurial > hg > extraction-interface
diff interface/check_sections.php @ 1:ef6d0c6a13d7
(1)Add 'sort_by' time entry in main page. (check_sections.php)
Modify check_sections_details page to have level3 option.
(2)Modify map to have default dataset loaded.
| author | Zoe Hong <zhong@mpiwg-berlin.mpg.de> |
|---|---|
| date | Wed, 21 Jan 2015 10:49:44 +0100 |
| parents | b12c99b7c3f0 |
| children | 883ad980a43b |
line wrap: on
line diff
--- a/interface/check_sections.php Mon Jan 19 17:13:49 2015 +0100 +++ b/interface/check_sections.php Wed Jan 21 10:49:44 2015 +0100 @@ -66,8 +66,41 @@ echo "</table>"; } + +// sorting by the $sort_by parameter +function checkSections_sort_by($sort_by){ + switch ($sort_by) { + case 'time': + $query="(SELECT name AS book_name,level1,level2,period,start_year,id from books ORDER BY start_year)"; + $result = mysql_query($query); + echo mysql_num_rows($result)." result(s)<br><br>"; + echo "<table>"; + echo "<tr>"; + echo "<td class='bookName'>book name<td class='level1'>level1<td class='level2'>level2<td class='period'>period<td class='start_year'>start_year"; + while ($row = mysql_fetch_assoc($result)) { + $str="<tr>"; + $str.="<td>".$row['book_name']; + $str.="<td>".$row['level1']; + $str.="<td>".$row['level2']; + $str.="<td>".$row['period']; + $str.="<td>".$row['start_year']; + $str.="<td><a href='check_sections_details.php?book_id=".$row['id']."&count=100"."' target='_blank'>"."click here"."</a>"; + echo $str; + } + echo "</table>"; + break; + + default: + # code... + echo "no sorting parameter set"; + break; + } +} + ?> + + <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> @@ -87,6 +120,9 @@ if(isset($_GET['find']) && $_GET['count']!='' && is_numeric($_GET['count'])){ checkSections($_GET['count']); } + else if(isset($_GET['sort_by'])){ + checkSections_sort_by($_GET['sort_by']); + } ?> </div> </body>