I am running into some issues trying to update a column in a table in a SQLite database using PHP on Windows and was hoping could get some help on this mailer.
Here is the create and insert statement -
Code: Select all
CREATE TABLE SERVER (
IPAddress varchar(100) not null unique primary key,
Token varchar(100) unique
);
INSERT INTO SERVER (IPAddress, Token) VALUES
('192.168.1.100', '');Code: Select all
$db = new SQLiteDatabase('db/reg.s3db');
$intoken = uniqid();
$db->query("update SERVER set Token = '$intoken'");
$res = $db->query("select * from SERVER");
$row = $res->fecth();
$outtoken = $row['Token'];
echo $outtoken;Interestingly, if I error out the script with a syntax error or some such after the update but before it exits, the value shows up in the Token column.
Any idea what is happening here and I need to do here. Seems like there is some sort of flush that needs to happen which happens only if the script errors out.
Any help is appreciated.
Thanks,
Prashant.