RE: Basic SQLite test failing..
| From: | JeRRy | Date: | Sun, 30 Oct 2005 17:36:13 +0000 |
| Subject: | RE: Basic SQLite test failing.. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-40571@lists.php.net to get a copy of this message | ||
Hi,
Errors are more than likely not being produced because of the '@' symbol. Try removing
this and see how you go. Also check your code for syntax errors. These will be produced within the
errors.
J
---------------------------------------------start of
message-------------------------------------------
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 nevercomes out, i.e. none of the rest of the code is hit. When running viaapache and mod_php, it
gets out of 'sqlite_open' with a validconnection but never comes out of the first
'sqlite_query' call.It does this without any errors or warnings. The database file
ispresent 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.5Any ideas where things are going wrong? Or perhaps tips on
improvingdebug output. Any help would be
appreciated,Eoin.
------------------------end of message-------------------
---------------------------------
Do you Yahoo!?
Find a local business fast with Yahoo! Local Search