[sqlite] php/sqlite

2018-07-24 Thread David Burgess
I have an issue with the php sqlite3 interface where it returns a fail on bindValue(), yet lastErrorCode() lastErrorMsg() return "no error". I am using sqlite 3.24. and php 7.2 Does anyone know if this is a php issue or is it an sqlite issue? ___ sqlite

Re: [sqlite] PHP + SQLite + NFS = No go?

2013-12-03 Thread Simon Slavin
On 3 Dec 2013, at 4:23pm, Scott Baker wrote: > My VPS provider mounts my /home partition via NFSv3 and it's causing me > all kinds of headaches. I have my website served from ~/html/ using > SQLite as the DB and I'm constantly seeing hung Apache processes that > are threads with an open connecti

[sqlite] PHP + SQLite + NFS = No go?

2013-12-03 Thread Scott Baker
My VPS provider mounts my /home partition via NFSv3 and it's causing me all kinds of headaches. I have my website served from ~/html/ using SQLite as the DB and I'm constantly seeing hung Apache processes that are threads with an open connection to my SQLite DB. I've read all the caveats about doin

Re: [sqlite] PHP & SQLite examples

2011-11-14 Thread David Garfield
Please, be correct. There are no secure ways to communicate. Period. Neither "persistent SQL datastores" or "websockets" will get you secure communication. Nor will SSL, or anything else. Paranoia is essential in writing communication software. (Of course, paranoia is important in writing any

Re: [sqlite] PHP & SQLite examples

2011-11-14 Thread Simon Slavin
On 14 Nov 2011, at 5:53pm, Dotan Cohen wrote: > I recommend against formulating the SQL statements in Javascript. > Because if I find that page, I _will_ try to inject my own SQL. My code on the PHP side executes only the first SQL command. And there a hash. But yes, people should be careful

Re: [sqlite] PHP & SQLite examples

2011-11-14 Thread Dotan Cohen
On Mon, Nov 14, 2011 at 13:43, Simon Slavin wrote: > > On 14 Nov 2011, at 10:45am, Gert Van Assche wrote: > >> I would like to understand how a PHP web page communicates with  SQLite. > > All my responses to this are general, with a little hand-waving and > simplification.  And other posters to t

Re: [sqlite] PHP & SQLite examples

2011-11-14 Thread Simon Slavin
On 14 Nov 2011, at 10:45am, Gert Van Assche wrote: > I would like to understand how a PHP web page communicates with SQLite. All my responses to this are general, with a little hand-waving and simplification. And other posters to this list may have other points of view. I'm just trying to p

Re: [sqlite] PHP & SQLite examples

2011-11-14 Thread Stephan Beal
On Mon, Nov 14, 2011 at 11:45 AM, Gert Van Assche wrote: > I would like to understand how a PHP web page communicates with SQLite. I > know something about SQLite, but nothing or not a lot about PHP. I have > questions like this: - How does one take input from an input field or a check box and

[sqlite] PHP & SQLite examples

2011-11-14 Thread Gert Van Assche
All, I would like to understand how a PHP web page communicates with SQLite. I know something about SQLite, but nothing or not a lot about PHP. I have questions like this: - How does one take input from an input field or a check box and use it for doing an "INSERT" for instance? - How

Re: [sqlite] PHP + SQLite - Issues with update

2011-10-21 Thread Simon Slavin
On 21 Oct 2011, at 12:05am, Prashant Prabhudesai wrote: > $db = new SQLiteDatabase('db/reg.s3db'); This is the old-style SQLite2 interface. I strongly suggest you switch to the new SQLite3 interface as documented here: http://www.php.net/manual/en/book.sqlite3.php In that your line would be

Re: [sqlite] PHP + SQLite - Issues with update

2011-10-21 Thread Stephan Beal
On Fri, Oct 21, 2011 at 1:05 AM, Prashant Prabhudesai < prashantprabhude...@gmail.com> wrote: > $row = $res->fecth(); > ... After the script exits successfully I inspect the value in the Token column > Are you 100% sure the above command executes correctly? -- - stephan beal http://wanderi

[sqlite] PHP + SQLite - Issues with update

2011-10-21 Thread Prashant Prabhudesai
Hello, I am running into some issues trying to update a column in a table in a SQLite database using PHP on Windows and was hoping could get some help on this mailer. Here is the create and insert statement - CREATE TABLE SERVER ( IPAddress varchar(100) not null unique primary key, Token varchar

Re: [sqlite] php sqlite compliance

2007-01-22 Thread C.Peachment
On Mon, 22 Jan 2007 17:17:35 +0100, anis chaaba wrote: >Can you please tell me what version of sqlite is supported by php5? >Thanks in advance if you use the following php script then you can determine this at anytime: There is a great amount of configuration detail displayed in your browser

[sqlite] php sqlite compliance

2007-01-22 Thread anis chaaba
Can you please tell me what version of sqlite is supported by php5? Thanks in advance