riverside96

The above alteration as well as the removal of the brackets as follows fixed the problem $stmt->bindValue(':id', $id, SQLITE3_TEXT); instead of $stmt->bindValue(':id', [$id], SQLITE3_TEXT); I am eternally grateful. I asked this question numerous places over the past few days & could not resolve the issue.

Thank you Phil. This was very informative but even with the changes I am still getting null for id in the db. Could this line be the culprit .. $stmt->bindValue(':id', [$id], SQLITE3_TEXT);

I'm new to php & I am trying to use the user input to generate an ID ie first 2 letters of last name + 4 rand number etc. I am unsure of where I'm making mistakes syntax wise & have been stuck with this issue for days & it's starting to look like I'm going to fail the module. Any help at all regarding this issue will be greatly appreciated.