Re: [nyphp-talk] design question: user self-registration

> that sounds like a > poor idea, basically  allowing anyone to run an update on anyone else's > record in the table. Are you using the email as the only "GET" parameter to do the confirmation? That is a mistake. Do something like: confirm.php?email=...@example.com&checksum=abcdefg123 where ch

Re: [nyphp-talk] What's your favorite shopping cart? Why?

On Tue, Aug 31, 2010 at 02:21:05PM -0400, Mitch Pirtle wrote: > > The big dedicated commerce platform out there is Magento: Uh, "big" doesn't seem to be the right word. Perhaps "ginormous" fits the bill a little better. A note of mine indicates it weighs in at 106MB, though I think that was a

Re: [nyphp-talk] design question: user self-registration

Can you insert the new user, associate it with the existing person, and still make them activate the email address? On Tue, Aug 31, 2010 at 4:03 PM, David Mintz wrote: > > > On Tue, Aug 31, 2010 at 3:13 PM, Chris Snyder wrote: > >> On Tue, Aug 31, 2010 at 12:43 PM, David Mintz >> wrote: >> >>

Re: [nyphp-talk] What's your favorite shopping cart? Why?

goodsie.com On Tue, Aug 31, 2010 at 2:21 PM, Mitch Pirtle wrote: > On Tue, Aug 31, 2010 at 1:58 PM, Robert Kim Wireless Internet Advisor > wrote: > > Hey guys... im doing a blog post about shopping carts because Im > > getting more and more questions recently about ecommerce... prolly > > becaus

Re: [nyphp-talk] design question: user self-registration

On Tue, Aug 31, 2010 at 3:13 PM, Chris Snyder wrote: > On Tue, Aug 31, 2010 at 12:43 PM, David Mintz > wrote: > > > What would you do? > > Gratefully yours > > All interesting, thank you. I think I still might not be explaining the situation

Re: [nyphp-talk] design question: user self-registration

On Tue, Aug 31, 2010 at 12:43 PM, David Mintz wrote: > What would you do? > Gratefully yours One way to handle the duplicate key problem is to append a flag to the key when you mark the record inactive. So chsny...@gmail.com becomes chsny...@gmail.com_20100831. That way your tables are ready

Re: [nyphp-talk] design question: user self-registration

Disqus does something like this. If you run into where there is an email in the system but no "profile" (entry in the "people" table) just bring up a screen and have the user fill out the rest of the information. Then, stick it in the database and you're on your merry way! On 8/31/10, David Mintz

Re: [nyphp-talk] design question: user self-registration

This may very well be a dumb question, but what's wrong with doing the insert and just detecting if it fails? If you get a duplicate key, you know they're in the database and can act accordingly. Otherwise, it inserts. This may be somewhat of a controversial stance, but I'm all in favor of letti

Re: [nyphp-talk] design question: user self-registration

On 8/31/2010 12:43, David Mintz wrote: In some cases, though, there may already be a row in people corresponding to the new user. If I attempt the insert and the email already exists I will get a duplicate email error. But if I instead run an update on the already-existing row, I will have done t

Re: [nyphp-talk] design question: user self-registration

On Tue, Aug 31, 2010 at 12:52 PM, Dan Cech wrote: > On 8/31/2010 12:43 PM, David Mintz wrote: > >> I want to provide a self-service user registration, with an email >> verification thing. They submit their data, we email them a link to verify >> that they control the email address they provided,

Re: [nyphp-talk] What's your favorite shopping cart? Why?

On Tue, Aug 31, 2010 at 1:58 PM, Robert Kim Wireless Internet Advisor wrote: > Hey guys... im doing a blog post about shopping carts because Im > getting more and more questions recently about ecommerce... prolly > because retailers are closing down! UGH! > > But i figure... this is the place to a

[nyphp-talk] What's your favorite shopping cart? Why?

Hey guys... im doing a blog post about shopping carts because Im getting more and more questions recently about ecommerce... prolly because retailers are closing down! UGH! But i figure... this is the place to ask... what's your favorite shopping cart and why? Pros and cons? -- Robert Q Kim 2611

Re: [nyphp-talk] design question: user self-registration

On 8/31/2010 12:43 PM, David Mintz wrote: I want to provide a self-service user registration, with an email verification thing. They submit their data, we email them a link to verify that they control the email address they provided, bla bla, then the account is enabled. So I thought I would go a

[nyphp-talk] design question: user self-registration

[Not PHP-specific, but we all know the greatest minds in town are here, so ---] Here's my dilemma. For reasons a little too boring and involved to go into here, I have split the thing called User into two tables, one called 'people' that holds firstname, lastname, email, and other personal data. T