Topic: [SOLVED] SQLite - Can't create table (I think?)

[Catfish]

Hi all,

I'm newto SQLite but want to learn howto use it with PHP.

I've been writing a bit of a frontend for it in PHP, currently I make my script look for database files, list them, then the user can choose a database, then it looks for tables in that database, if there's none the user can make one, define the fields etc. and hit submit to create the table.

I am just going off a tutorial I found online:
http://devzone.zend.com/node/view/id/760
and i'm using the OO approach in my code.

My code that sends the table creation query to the database is:

Code: [Select]

case 'submitTable':
{
if (empty($localPostGet['dbName']) || empty($localPostGet['tableName']))
continue;
// build SQL query to send to database
$dbQuery .= 'BEGIN; CREATE TABLE '.$localPostGet['tableName'].'(';
for ($i = 1; $i <= count($localPostGet['fieldName']); $i++)
{
if (!empty($localPostGet['fieldName'][$i]))
$dbQuery .= $localPostGet['fieldName'][$i].' '.$localPostGet['fieldType'][$i].$localPostGet['fieldExtras'][$i];
if (isset($localPostGet['fieldName'][$i + 1]) && !empty($localPostGet['fieldName'][$i + 1]))
$dbQuery .= ', ';
}
$dbQuery .= '); COMMIT;';
$o .= '<pre>Query sent:'."\n".$dbQuery.'</pre><br />'."\n";
if ($db->query($dbQuery))
$o .= 'Successfully made table <i>'.$localPostGet['tableName'].'</i> in database <i>'.$localPostGet['tableName'].'</i><br />'."\n";
else
$o .= 'Problem: Could not make table <i>'.$localPostGet['tableName'].'</i> in database <i>'.$localPostGet['tableName'].'</i><br />'."\n";
$o .= 'Return to <a href="'.$_SERVER['PHP_SELF'].'">select database</a> page.<br/>'."\n";
break;
}

The values that pass to that section of code are as follow:

Code: [Select]

Array ($localPostGet)
(
    [tableName] => testTable
    [action] => submitTable
    [dbName] => testDB.sqlite
    [fieldName] => Array
        (
            [1] => test
            [2] => id
        )

    [fieldType] => Array
        (
            [1] => TEXT
            [2] => INTEGER
        )

    [fieldExtras] => Array
        (
            [1] =>
            [2] =>  PRIMARY KEY
        )

)

The query being sent is:
BEGIN; CREATE TABLE testTable(test TEXT, id INTEGER PRIMARY KEY); COMMIT;

Is my checking the outcome of $db->query with an if() valid enough to test if the query was successful? I know with PHP's mysql_ functions you sometimes need to use certain functions to check things if they worked.

Some help on this would be most appreciated.

[Catfish]

Seem to have fixed this by using $db->queryExec($dbQuery); instead of $db->query();

None of the tutorials I've seen online stress anything about having to use queryExec().