RE: Basic SQLite test failing..

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux