Re: DB_Storage examples

On Wed, 2002-03-13 at 08:40, Tobias Nix wrote: > hello, > > can somebody give me an usage example of DB_Storage? > sometimes ago wolfram wrote a mail about this, > but i can't find it again. $dbh = DB::connect("mysql://user:pw@server/database"); // this gives you a DB_Storage object using the table "mytable" // and the "id" column as a key $obj = new DB_Storage("mytable", "id", $dbh); // this reads data from the row where id = 42 $obj->setup(42); This: $obj->set('foo', 'magic'); $obj->store(); is then equivalent to: UPDATE mytable SET foo = 'magic' WHERE id = 42; You don't have to call store() explicitly, it will be called at the end of the request if necessary. - Stig