RE: [PHP-DB] PHP + SQLite - Issues with update
Try using the query:
$db-query(update SERVER set Token = '$intoken' where IPAddress
='192.168.1.100');
You are trying to update all rows with $intoken, where the column Token is
unique.
Regards,
Neil Morgan
-Original Message-
From: Prashant Prabhudesai [mailto:pprab...@cisco.com]
Sent: 21 October 2011 04:04
To: php-db@lists.php.net
Subject: [PHP-DB] PHP + SQLite - Issues with update
Hello,
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 -
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', '');
I am trying to update the Token field using the following code -
[snip]
$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;
[snip]
After the script exits successfully I inspect the value in the Token column
and its empty. But the echo statement in the snippet above prints the proper
value.
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.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
___
This email has been scanned by MessageLabs' Email Security
System on behalf of the University of Brighton.
For more information see http://www.brighton.ac.uk/is/spam/
___
___
This email has been scanned by MessageLabs' Email Security
System on behalf of the University of Brighton.
For more information see http://www.brighton.ac.uk/is/spam/
___
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] PHP + SQLite - Issues with update
Had already tried that without any success.
What bugs me is that if I error the script out rather than exit it
cleanly the token value shows up in the DB. It's causing me to wonder if
it's some streams issue. Even if it was, I have no idea how to fix it.
Thanks,
Prashant.
-Original Message-
From: n.a.mor...@brighton.ac.uk [mailto:n.a.mor...@brighton.ac.uk]
Sent: Friday, October 21, 2011 2:33 AM
To: Prashant Prabhudesai (pprabhud); php-db@lists.php.net
Subject: RE: [PHP-DB] PHP + SQLite - Issues with update
Try using the query:
$db-query(update SERVER set Token = '$intoken' where IPAddress
='192.168.1.100');
You are trying to update all rows with $intoken, where the column
Token is unique.
Regards,
Neil Morgan
-Original Message-
From: Prashant Prabhudesai [mailto:pprab...@cisco.com]
Sent: 21 October 2011 04:04
To: php-db@lists.php.net
Subject: [PHP-DB] PHP + SQLite - Issues with update
Hello,
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 -
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', '');
I am trying to update the Token field using the following code -
[snip]
$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;
[snip]
After the script exits successfully I inspect the value in the Token
column
and its empty. But the echo statement in the snippet above prints the
proper
value.
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.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
___
This email has been scanned by MessageLabs' Email Security
System on behalf of the University of Brighton.
For more information see http://www.brighton.ac.uk/is/spam/
___
___
This email has been scanned by MessageLabs' Email Security
System on behalf of the University of Brighton.
For more information see http://www.brighton.ac.uk/is/spam/
___
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHP + SQLite - Issues with update
Hello,
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 -
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', '');
I am trying to update the Token field using the following code -
[snip]
$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;
[snip]
After the script exits successfully I inspect the value in the Token column
and its empty. But the echo statement in the snippet above prints the proper
value.
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.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
