TBS - Query SQL with the new version of TBS using native sql class

108 Views Asked by At

I'm writing here regarding the use of the SQL TBS plugin. I went through the www.tinybutstrong.com web site, guide, forum, etc., but can't figure out the answer.

I used to use the plugin tbssql_mysql.php, but it became obsolete with PHP7. I went on the TBS site to get the new version but realised it was now native with TBS, and wasn't a separate module anymore.

But then, I realised I have actually no idea on how to create a new SQL object and perform queries like I used to. Ie, I used to do this:

include_once('tbssql_mysql.php');
$Db_dev = new clsTbsSQL();
$user = 'root';
$pass = '';
$Db_dev->Connect('localhost:3306',$user,$pass,'ecv');
$query1     = 'SELECT id, page FROM page_menu ORDER BY ordre ASC';
$get_menu   = $Db_dev->GetRows($query1);

But I have no idea how to do all of this with this new TBS version. Could you point me to the documentation regarding connecting to a DB and querying with TBS now?

Kind regards.

0

There are 0 best solutions below