blob: 80078c90f871d55686241a58d14a10db42024d50 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
<?php
$elements = array();
require_once('db-connect.php');
/* initializing variables */
$chapter_id = 0;
$preference_id = 0;
$category_id = 0;
function get_elements($example_id) {
/* retreving examples */
$query = "SELECT id, caption, number, chapter_id FROM textbook_companion_example
WHERE cloud_err_status=0 AND chapter_id = (
SELECT chapter_id FROM textbook_companion_example WHERE id = {$example_id}
)
";
$result = mysql_query($query);
$data = '<select name="example" id="example">';
$data .= '<option value="">-- Select an example --</option>';
while($row = mysql_fetch_object($result)) {
if($example_id == $row->id) $selected = "selected"; else $selected="";
$data .= "<option value='{$row->id}' {$selected}>" . $row->number . ' - ' . $row->caption . '</option>';
$chapter_id = $row->chapter_id;
}
$data .= '</select>';
$data .= '<span id="example-download"> <a href="#">Download Example</a></span>';
$elements["examples"] = $data;
/* retreving chapters */
$query = "
SELECT id, name, number, preference_id FROM textbook_companion_chapter
WHERE cloud_chapter_err_status=0 AND preference_id = (
SELECT preference_id FROM textbook_companion_chapter WHERE id = {$chapter_id}
)
ORDER BY number ASC
";
$result = mysql_query($query);
$data = '<select name="chapter" id="chapter">';
$data .= '<option value="">-- Select chapter --</option>';
while($row = mysql_fetch_object($result)){
if($chapter_id == $row->id) $selected = "selected"; else $selected="";
$data .= "<option value='{$row->id}' {$selected}>" . $row->number . ' - ' . $row->name . '</option>';
$preference_id = $row->preference_id;
}
$data .= '</select>';
$data .= '<span id="chapter-download"> <a href="#">Download Chapter</a></span>';
$elements["chapters"] = $data;
/* retreving books*/
$query = "
SELECT pre.id, pre.book, author, category FROM textbook_companion_preference pre
WHERE pre.approval_status=1 AND pre.category = (
SELECT category FROM textbook_companion_preference WHERE id = {$preference_id}
) AND cloud_pref_err_status=0 and pre.proposal_id IN (
SELECT id from textbook_companion_proposal where proposal_status=3
) ORDER BY pre.book ASC
";
$result = mysql_query($query);
$data = '<select id="books" name="books">';
$data .= '<option value="">-- Select book --</option>';
$counter = 1;
while($row = mysql_fetch_object($result)){
$counter_str = '';
if($counter < 10) {
$counter_str = ' '.$counter.'. ';
}elseif($counter < 100) {
$counter_str = ' '.$counter.'. ';
}else {
$counter_str = $counter.'. ';
}
if($preference_id == $row->id) $selected = "selected"; else $selected="";
$data .= "<option value='{$row->id}' {$selected}>" . $counter_str . $row->book . ' (' . $row->author . ')</option>';
$counter++;
$category_id = $row->category;
}
$data .= '</select>';
$data .= '<span id="book-download"> <a href="#">Download Book</a></span>';
$elements["books"] = $data;
$elements["category"] = $category_id;
return $elements;
}
?>
|
