txtSQL

Please, I have a project in txtsql 2,2 and want to migrar for txtsql 4.0. Necessary to know if it had changes in the form to implement in this new version.
a) As access the tables;
b) As to write one query(na new version); At last, it would be good if version 4.0 had some example of new implementation.

Thank you

I'm trying as hard as I can to push for backwards compatibility between versions 2.2 final and 4.0 ... the files should essentially remain untouched, maybe a few small differences that a quick patch could possibly fix.

As an example of 4.0, there is going to be SQL support and anyone can use that. But you can also still use the same old select(), insert() etc. functions.

so

Code: Select all

$results = $sql->query('
SELECT
  `A.id`, `B.name`
FROM
  `db.foo` as `A`, `db.bar`
  as `B`
WHERE
  `A.id` = `B.id`);

You can still use the old functions, however, as well...

Code: Select all

$results = $sql->select(array('db' => 'foo', 'table' => 'bar', 'where' => array('id = $id')));

How much the form of conexao to the bank, as I can make? Before I made thus:

$username = 'root';
$password = '';
define('TXTSQL_CORE_PATH', 'admin/');
include_once('admin/txtSQL.class.php');
$sql = new txtSQL('admin/bd');
$sql->connect($username, $password);
$sql->selectdb('xxx');

$query=array('select' => array('id', 'titulo', 'descricao'),
'db' => 'xxx,
'table' => 'yyyy',
'where' => array('id =~ %'.$arg.'%','or','titulo =~ %'.$arg.'%',
'or','descricao =~ %'.$arg.'%'));

im not sure i quite understand the question -- the English is not really clear...

it forgives me. My English, is not good. my question is: The form with that I access the bank is the same one of the previous version?

it should be nearly identical to the code you posted above

Already exists something as txtSQLAdmin for txtsql 4.0?

not yet, the txtSQLAdmin script should still be able to run with the new 4.0 version, but just not yet. Once it's completed, backwards compatibility shouldn't be a problem

http://www.fashion-products.com [url=http://www.fashion-products.com ]is a sell air force one,
air jordan,bape,kicks,nike,Jerseys,Shoes,Clothing,Bag,Glasses,Caps&Hats,sneakers,sunglasses,
watches,Jewelry,Electronics,NBA,NFL,NHL,MLB[/url]
shoes
clothing
Handbags Wallets
Hat
Sunglasses
Belts
Watches
Jewelry