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