Source code of tbs_us_examples_datamysql.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
<?php
include_once('../tbs_class.php');
//Connexion to the database
/* Use the example below.
$cnx_id = mysql_connect('localhost','user','password');
mysql_select_db('dbname',$cnx_id);
*/
$sql_ok = ( isset($cnx_id) && is_resource($cnx_id) ) ? 1 : 0;
if ($sql_ok==0) $cnx_id = 'clear'; // makes the block to be cleared instead of merged with an SQL query.
$TBS = new clsTinyButStrong;
$TBS->LoadTemplate('tbs_us_examples_datamysql.htm');
$TBS->MergeBlock('blk1',$cnx_id,'SELECT * FROM t_tbs_exemples');
$TBS->Show();