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

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

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

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

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

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). >

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

I'm trying to port a simple logon script that was originally for MySQL to SQLite3. Everything seems to work but won't post data to the database and won't return the else statements if no data is entered or "user added" when submitted. New and trying to learn PDO with SQLite3... Can