RE: PHP + SQLite - Issues with update

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:pprabhud@xxxxxxxxx] 
Sent: 21 October 2011 04:04
To: php-db@xxxxxxxxxxxxx
Subject:  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




[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux