Re: [sqlite] SQLite - IIS, PHP and java

gt;>> >>> alexis_ wrote: >>> >>>> Hi there, >>>> >>>> I am at the research stage of a project i have been asked to undertake. >>>> >>>> At the moment the O/S will be windows server 2003 and the web server >>

Re: [sqlite] SQLite - IIS, PHP and java

>>> These are set and i cannot change them. >>> >>> I will be using PHP to deliver the web content to users and also a Java >>> application will be used to integrate to third party product. >>> >>> Both PHP and Java will be accessing a SQ

Re: [sqlite] SQLite - IIS, PHP and java

the moment the O/S will be windows server 2003 and the web server IIS. >> These are set and i cannot change them. >> >> I will be using PHP to deliver the web content to users and also a Java >> application will be used to integrate to third party product. >> >> Both PHP a

Re: [sqlite] SQLite - IIS, PHP and java

lso a Java > application will be used to integrate to third party product. > > Both PHP and Java will be accessing a SQLite db concurrently. SQLite, Java > App and php will all be on one box. So my questing is should this setup work > OK? Is there anything i should be aware off. > >

[sqlite] SQLite - IIS, PHP and java

to integrate to third party product. Both PHP and Java will be accessing a SQLite db concurrently. SQLite, Java App and php will all be on one box. So my questing is should this setup work OK? Is there anything i should be aware off. Thank you for any help, pointers Alexis -- View this message

Re: [sqlite] Sqlite and php

On 15 Dec 2009, at 3:00am, FrankLane wrote: > Hi - I ran across a php script where the data file was created in /tmp, so I > tried that, and it works! Just be aware that it may be deleted when that computer is rebooted. That's what /tmp is for. > I found some errors in my insert command, >

Re: [sqlite] Sqlite and php

atabase file and check to see if > the command had the right result. > > Simon. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this messa

Re: [sqlite] Sqlite and php

Frank, I think you might get things done faster if you take a step back from your own application and try to get a simpler PHP application working. You need to learn how the PDO system works and also what it takes to get Apache to store data on your computer. Test it command by command: make

Re: [sqlite] Sqlite and php

On 13 Dec 2009, at 7:15pm, FrankLane wrote: > Well, I have such a file that I created, because with out it, I would get an > error that reads: > > SQLSTATE[HY000] [14] unable to open database file > > So I created a junk.sqlite file and I got > > SQLSTATE[HY000] [10] disk I/O error > > so

Re: [sqlite] Sqlite and php

> ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Sqlite-and-php-tp26754013p26768798.html Sent from the

Re: [sqlite] Sqlite and php

On 13 Dec 2009, at 5:45pm, FrankLane wrote: > Hi Simon - I don't know how to access the database created by my php program, The database is whatever file you specified when you created the database: try { $dbHandle = new PDO('sqlite:'."/Users/me/junk.sqlite"); } So your database file is the

Re: [sqlite] Sqlite and php

$result,true); and I obtained the following error on the fetchAll() line: Fatal error: Call to a member function fetchAll() on a non-object in … Frank -- View this message in context: http://old.nabble.com/Sqlite-and-php-tp26754013p26768088.html Sent from the SQLite mailing list archive at Nabbl

Re: [sqlite] Sqlite and php

On 13 Dec 2009, at 10:18am, FrankLane wrote: > After the loop that inserts the data > into the databease, I would like to be sure that your INSERT commands work correctly. Once you have executed the code that puts data in the database, please open the same database in the command-line tool

Re: [sqlite] Sqlite and php

using either ->fetch() or > ->fetchObject(). > > (Warning: I haven't actually tried any of the above code.) > > Simon. > _______ > sqlite-users mailing list > sqlite-users@sqlite.org

Re: [sqlite] Sqlite and php

On 13 Dec 2009, at 5:27am, FrankLane wrote: > $data3 = preg_split('/\t/',$data2[$i]); // tab delimited record data into > array > > $sqlcmd = 'INSERT INTO tab (i0) VALUES ('.$data3[0].')'; Good so far. Now you should know that a normal SQL command to insert a record would look something

Re: [sqlite] Sqlite and php

where i0=2'; // select some records $query = $dbHandle->query($sqlcmd,SQLITE_BOTH,$query_error); echo "query=".$query.""; if ($query_error)die("Error: $sqlite query_error"); if (!$query)die("php: Impossible to execute query."); ?> -- View this message in co

[sqlite] SQLite with PHP and Apache C Module

My web application is a mix of PHP code and an Apache C Module. Both access the same SQLite3 database. Because of this, I am using the shared version of the PHP SQLite library and the Apache C module is dynamically linking, as well. The Apache C module only connects to the database during

[sqlite] SQLite with PHP

Hello, This message is only for let know users that I've wrote a class for manage SQL database using the same interface. It supports: - Connect to a database given a connection string - Prepared queries - Caching query results in files - Binding variables to query result columns - Fetch whole

[sqlite] SQLite and PHP 4.3 in windows

hello i want to use php_sqlite.dll in php 4.3, i make this : - i'm working in Win XP pro with IIS - put the php_sqlite.dll in c:\php - edit the php.ini, i change the "extension_dir" to c:\php - restart the iis but when i load a page with sqlite i've an error can load module php_sqlite.dll...