Re: [sqlite] Porting a simple logon script to SQLite3 from MySQL

2011-10-05 Thread David Garfield
C Lindgren writes: > $sql=$db->exec("INSERT INTO users(ID,username,password) > VALUES > ('0','".$username."','".$password."')"); In MYSQL, null and 0 are magic for a INTEGER PRIMARY KEY AUTO_INCREMENT column. In SQLite,

Re: [sqlite] Porting a simple logon script to SQLite3 from MySQL

2011-10-05 Thread C Lindgren
Quoting Stephan Beal : On Wed, Oct 5, 2011 at 6:56 PM, C Lindgren wrote: if (isset ($_post ['submit'] )) { Aside from this use of POST being a huge security hole, $_post is spelled wrong: it whould be $_POST (or $_REQUEST if you want to treat GET/POST the same). $

Re: [sqlite] Porting a simple logon script to SQLite3 from MySQL

2011-10-05 Thread Simon Slavin
On 5 Oct 2011, at 5:56pm, C Lindgren wrote: > I'm trying to port a simple logon script that was originally for MySQL to > SQLite3. MySQL uses connections to a server with a password. SQLite accesses a file on a hard disk. Make sure your web app (probably apache or httpd) has enough access

Re: [sqlite] Porting a simple logon script to SQLite3 from MySQL

2011-10-05 Thread Stephan Beal
On Wed, Oct 5, 2011 at 6:56 PM, C Lindgren wrote: > if (isset ($_post ['submit'] )) { Aside from this use of POST being a huge security hole, $_post is spelled wrong: it whould be $_POST (or $_REQUEST if you want to treat GET/POST the same). >$sql=$db->exec("INSERT INT