-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathindex.html
74 lines (69 loc) · 3.54 KB
/
index.html
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
<!doctype HTML>
<html>
<head>
<title>Front-end project</title>
<link rel="stylesheet" href="assets/css/common.css">
<link href="https://fonts.googleapis.com/css?family=Noto+Serif" rel="stylesheet">
</head>
<body>
<header>
<nav>
<span class="nav-title">SQL Observer</span>
<span class="nav-brk"></span>
<a href="#" id="save">save</a>
<span class="nav-brk"></span>
<a href="#" id="reset">reset</a>
<span class="nav-brk"></span>
<a href="#" id="share">share</a>
</nav>
</header>
<div class="flx-container">
<div class="flx-tbl-block">
<div class="tbl-block-h">
<span>Tables</span>
</div>
<div id="tbl-holder" class="tbl-block-b">
<div class="placeholder"><span id="tbl-smp-init" class="beta-link">show/hide sample</span></div>
<div id="tbl-smp-data" class="hidden">
<details>
<summary><span id="db_name_1">books</span> <span id="db_type_1">(TABLE)</span></summary>
<ul>
<li><span id="d_lbl_1_1">id</span>: <span id="d_type_1_1" class="tbl-fld-details">INT UNSIGNED (10)</span></li>
<li><span id="d_lbl_1_2">title</span>: <span id="d_type_1_2" class="tbl-fld-details">VARCHAR (200)</span></li>
<li><span id="d_lbl_1_3">author</span>: <span id="d_type_1_3" class="tbl-fld-details">VARCHAR (40)</span></li>
<li><span id="d_lbl_1_4">publisher</span>: <span id="d_type_1_4" class="tbl-fld-details">INT UNSIGNED (10)</span></li>
</ul>
</details>
</div>
</div>
</div>
<div class="flx-main-block">
<div class="flx-main-view">
<div class="main-view-h">
<span class="tab active">SQL</span>
<span class="tab">Table View</span>
</div>
<textarea id="query" class="main-view-b">This version of "SQL Observer" allows user to select which field of the table should be displayed as the result.
This version is case sensetive, so all directives MUST be in lower case.
Also "SQL Observer" can display all the data using usual syntax as follow: select * from students
Keep in mind that due to restrictions of task user can operate only with "students" table, attempts to use other tables will be denied.
Try this examples:
select * from students
select StudentID, LastName, FirstName from students
select LastName, DP, StartYear from students
select LastName, City from students </textarea>
<div class="control-panel">
<div id="run-script" class="fb fb-run control-button"></div>
</div>
</div>
<div class="flx-main-result">
<div class="result-h">
<span>Result</span>
</div>
<div id="response" class="result-b"></div>
</div>
</div>
</div>
<script src="assets/js/common.js"></script>
</body>
</html>