Re: Basic SQLite test failing..
| From: | Micah Stevens | Date: | Sun, 30 Oct 2005 17:18:47 +0000 |
| Subject: | Re: Basic SQLite test failing.. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-40570@lists.php.net to get a copy of this message | ||
Take out the @ symbols so you can get some errors?
On Sunday 30 October 2005 3:03 am, Eoin Hennessy wrote:
> Hello, I have the following very basic sqlite test harness:
>
> <?php
> $dbconn = @sqlite_open('testdb');
>
> if ($dbconn) {
> @sqlite_query($dbconn, "CREATE TABLE test_table (test_id INT);");
> @sqlite_query($dbconn, "INSERT INTO test_table VALUES (100)");
>
> $result = @sqlite_query($dbconn, "SELECT test_id FROM test_table");
> var_dump(@sqlite_fetch_array($result, SQLITE_ASSOC));
> } else {
> print "Connection to database failed!\n";
> }
> ?>
>
> When running via CLI the script goes into 'sqlite_open', but never
> comes out, i.e. none of the rest of the code is hit. When running via
> apache and mod_php, it gets out of 'sqlite_open' with a valid
> connection but never comes out of the first 'sqlite_query' call.
>
> It does this without any errors or warnings. The database file is
> present with correct permissions. I'm running a standard php install.
>
> I am using:
> php 4.4.0
> sqlite 3.2.7
> sqlite-php 0.0.5
>
> Any ideas where things are going wrong? Or perhaps tips on improving
> debug output. Any help would be appreciated,
>
> Eoin.