从PHP / SQLite中的Query返回字符串

Question

I am attempting to create a cookie with the return string of this query:

$id = $database -> query("SELECT id FROM accounts WHERE username = '$username' AND password = '$password'");

However, it is returning an object rather than a string. I am trying to return the "id" of the row. How do I do this?

Answer 1

You need to extract the array object so that you can access the id string!

$id = $this->db->get()->row_array()->('id');

then you can use $id and set it in a cookie:

setcookie("session", "$id", time()+3600);