txtSQL

Hi,

I am trying to use createtale() function like the following -
<?php
include('./txtSQL.class.php');
$sql = new txtSQL('./data');
$sql->connect('root', '');
$sql->selectdb('xpressdb');

$columns = array('id' => array('type' => 'int', 'auto_increment' => 1, 'permanent' => 1),
'name' => array('type' => 'string', 'max' => 50),
'email' => array('type' => 'string', 'max' => 50));

$sql->createtable('table' => 'xpressusers2',
'columns' => $columns);

$sql->disconnect();
?>

However, when I use the execute() function it works -
<?php
include('./txtSQL.class.php');
$sql = new txtSQL('./data');
$sql->connect('root', '');
$sql->selectdb('xpressdb');

$columns = array('id' => array('type' => 'int', 'auto_increment' => 1, 'permanent' => 1),
'name' => array('type' => 'string', 'max' => 50),
'email' => array('type' => 'string', 'max' => 50));

$sql->execute('create table',
array('table' => 'xpressusers',
'columns' => $columns));
$sql->disconnect();
?>

Any idea?

thanks

I think that this might be your error...

inside the call to createtable(), you never put your arguments in an array...

$sql->createtable('table' => 'xpressusers2',
'columns' => $columns);

should be

$sql->createtable(array('table' => 'xpressusers2',
'columns' => $columns));

Hi Faraz,

Thanks for the reply. I think the documentation I downloaded along txtSQL2.2 Final contains incorrect use of createtable(). However the online documentation is correct. Here is what I got in the downloaded version -
Example 21: createtable() Copy to Clipboard
<?php
$columns = array('id' => array('type' => 'int', 'auto_increment' => 1, 'permanent' => 1
'name' => array('type' => 'string', 'max' => 50),
'email' => array('type' => 'string', 'max' => 50)
);

$sql->createtable('db' => 'testDb',
'table' => 'testTable',
'columns' => $columns);
?>

thanks

hmmm.... seems as tho your rite.

I gotta quickly put up an updated version. Thanks for the lookout...

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