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>