RE: [PHP-DB] Re: saving data From: Beau Lebens (B.Lebens <email protected>)
Date: 06/19/02

Another alternative (depdending on your form/structure etc) might be to
simply cut the form up into multiple pages. perhaps group personal info on
one page, background on another etc etc (or whatever) and then update the
database at the end of each page (or perhaps use a cookie, with expiry of 1
hr so that if they get cut then reconnect their info is still there?)

i've had to do this with an insurance application which ended up spanning
about 6 pages, because otherwise it was ridiculously huge and as you say,
people bitch and moan - not only about losing data because they get cut, but
also just because it's pretty intimidating!

HTH

Beau

// -----Original Message-----
// From: Adam Royle [mailto:digitalbalance <email protected>]
// Sent: Thursday, 20 June 2002 6:02 AM
// To: Natividad Castro; php-db <email protected>
// Subject: Re: [PHP-DB] Re: saving data
//
//
// Well, if they select a field the have previously updated,
// enter a new value,
// the javascript will run again and update the same field.
// Apart from sending
// new data and having an extra db connection, nothing bad
// happens - this is
// because it is an UPDATE query. The query would have the same
// WHERE clause,
// and update the same column, and only the value would change.
//
// Basically, using this technique, it is bad for the database
// (you might have
// 10 separate queries, instead of 1), but this is the only way
// I see. You
// could program it in a way that the first field they fill in
// does an INSERT
// query and returns a unique row identifier, and all queries
// sent after that
// are UPDATE queries which use the row identifier.
//
// If you need help constructing it, or figuring something out
// - I'm free to
// help.
//
// Adam
//
// ----- Original Message -----
// From: Natividad Castro <ncastro <email protected>>
// To: Adam Royle <digitalbalance <email protected>>
// Sent: Thursday, June 20, 2002 6:05 AM
// Subject: RE: [PHP-DB] Re: saving data
//
//
// > Adan,
// > I think this is a great idea, but what would happen if the
// user wants to
// go
// > back to change fields that he/she already typed in.
// > Don't get me wrong your idea is great and I will try to
// make it work
// >
// > Thank you very much for your help
// > Nato
// >
// >
// > -----Original Message-----
// > From: Adam Royle [mailto:digitalbalance <email protected>]
// > Sent: Wednesday, June 19, 2002 8:08 AM
// > To: Natividad Castro; php-db <email protected>
// > Subject: [PHP-DB] Re: saving data
// >
// >
// > Very interesting question. One way you could do this, is using
// > javascript. Basically, you have two frames - one is the
// form, the other
// > is an invisible frame. Then, create a javascript function
// which sends
// > information about what field to update (and also the value
// to update to)
// > to the invisble frame, and put this function in the onBlur
// bit of your
// > form element.
// >
// > Am I making sense? Basically, what it would do is update
// the database
// > after you click out (or tab or deselect a form element)
// >
// > example...
// >
// > this would be the HTML (depending on form contents and
// database design,
// > you might have to include a few more javascript parameters)
// >
// > <input type="hidden" name="userID" value="<?= $userID ?>">
// >
// > <input type="text" name="first_name"
// > onBlur="updateDB(this.name,this.value,userID.value);">
// >
// > and the javascript might be
// >
// > function updateDB(theName, theValue, userID){
// > top.invisbleFrame.href =
// > "update.php?name="+theName+"&value="+theValue+"&userID="+userID;
// > }
// >
// > of course if you have a complex form/or specific database
// thingys, this
// > might be more complex, but basically this shows the data transfer
// > between pages
// >
// > and in the invisbleFrame (update.php) you might have
// something like this:
// >
// > <?php
// > dbConnect(); //obviously this is the database connection function
// >
// > $sql = "UPDATE tablename SET $name = '$value' WHERE userID
// = $userID";\
// > mysql_query($sql)
// >
// > ?>
// >
// > I hope that helps. If you need further help or explanation, ask!!!
// >
// > Adam
// >
// >
// > > Hi to all,
// > > Is it possible to save information from a form without being
// > > submitted? I
// > > know this question might be a little extrange for some
// of you. The
// > > reason
// > > why I'm asking this question is because I collect
// information from
// > > different
// > > places where users fill out a big form, they're
// complaining because
// > > sometimes they are about to finish filling out the form
// when they lose
// > > connection
// > > I was wondering if there is a way to get this data
// temporaly and then
// > > when
// > > they reconnet to the system display all the fields with
// the information
// > > they
// > > already type in.
// > >
// > > If someone has any idea, please let me know
// > >
// > > Thanks in advanced
// > > Nato
// >
// >
// > --
// > PHP Database Mailing List (http://www.php.net/)
// > To unsubscribe, visit: http://www.php.net/unsub.php
// >
// >
// >
//
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, visit: http://www.php.net/unsub.php
// 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php