Source code of tbs_us_examples_datasqlite.htm
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
<!DOCTYPE HTML>
<html lang="en">
<head>
<title>TinyButStrong - Example of SQLite data merge</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="./tbs_us_examples_styles.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="main-body">
<h1>Example of SQLite data merge</h1>
<div class="w3cinfo"> this TBS template is W3C compliant <a href="http://validator.w3.org/check?uri=referer"><img src="http://www.w3.org/Icons/valid-xhtml11" alt="Valid XHTML 1.1" height="31" width="88" style="border:none;" /></a> </div>
<div id="example">
<p style="text-align:center; color:#F00">This example is not working because there is no MySQL connection available. See the corresponding PHP script in order to configure the connection.<br />
[onshow;block=p;when [var.sql_ok]=0]</p>
<table border="1" cellpadding="2" cellspacing="0" style="margin-left:auto; margin-right:auto;">
<tr class="title-section2" style="background-color:#CACACA;">
<th align="left">Position</th>
<th align="left">Nickname</th>
<th align="center">Score</th>
<th align="center">Date</th>
</tr>
<tr style="background-color:#F0F0F0;">
<td>[blk1.#]</td>
<td>[blk1.res_name;block=tr]</td>
<td align="center">[blk1.res_score]</td>
<td align="center">[blk1.res_date;frm='mm-dd-yyyy']</td>
</tr>
<tr style="background-color:#E6E6E6;">
<td>[blk1.#]</td>
<td>[blk1.res_name;block=tr]</td>
<td align="center">[blk1.res_score]</td>
<td align="center">[blk1.res_date;frm='mm-dd-yyyy']</td>
</tr>
<tr style="background-color:#FFCFB9;">
<td colspan="4">[blk1;block=tr;nodata]There is no data. </td>
</tr>
</table>
<p style="text-align:center;">There are [blk1.#] displayed lines.</p>
</div>
</div>
</body>
</html>