SQLite3 query in PHP not querying?

Question

I have a register page on my site which feeds POST data into a PHP file, which then INSERTs it into a database. The problem is, the query:

class DB extends SQLite3{
    function __construct(){
            $this->open('db/userpass.db');
    }
}

$db = new DB();

$db->query("INSERT INTO userpass VALUES($user, $encrypted_pass)");

isn't querying. Picture book is here: https://i.sstatic.net/GnxFF.jpg

You can see my problem in the album. However, I most definitely query'd.

You don't check the result of $db->query.

Marcel Korpel
– Marcel Korpel

2013-11-10 22:08:03 +00:00
Commented Nov 10, 2013 at 22:08 — Marcel Korpel
– Marcel Korpel, Commented Nov 10, 2013 at 22:08
@MarcelKorpel What do I do then?

SuperCheezGi
– SuperCheezGi

2013-11-10 22:48:13 +00:00
Commented Nov 10, 2013 at 22:48 — SuperCheezGi
– SuperCheezGi, Commented Nov 10, 2013 at 22:48

LS_ᴅᴇᴠ · Accepted Answer · 2013-11-11 10:34:08Z

2

SELECT performs a query, INSERT doesn't. exec must be used instead.

However, because you are merging data in your command, you better use statements:

$stmt = $db->prepare('INSERT INTO userpass VALUES(:user, :encrypted_pass)');
$stmt->bindValue(':user', $user);
$stmt->bindValue(':encrypted_pass', $encrypted_pass);
if ($stmt->execute()==FALSE) {
    //handle errors here!
}

answered Nov 11, 2013 at 10:34

LS_ᴅᴇᴠ

11.2k1 gold badge27 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

SuperCheezGi Over a year ago

Thank you for clarifying, I wasn't aware. query = read data, exec = write data.

Collectives™ on Stack Overflow

SQLite3 query in PHP not querying?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related