Well, finally suceeding to get by activation page
working, where the 0 is flipped to 1 to mean actived,
I'm stuck on the login page.
Unfortunately I'm stuck :) with what I have below.
It's part of an authentication system. This code
doesn't include the includes, but I thought maybe
significant en
$_GET['activation_hash] is missing the end '
On Mon, 27 Sep 2004 03:20:22 +0800, Jason Wong <[EMAIL PROTECTED]> wrote:
> On Monday 27 September 2004 03:01, Stuart Felenstein wrote:
> > How are they any different?
> >
> > I'm seeing the same thing as your method.
>
> These two methods are separat
On Monday 27 September 2004 03:01, Stuart Felenstein wrote:
> How are they any different?
>
> I'm seeing the same thing as your method.
These two methods are separate:
> > - Send user a system generated password with which
> > they can login and
> > subsequently change.
OR
> > - Send user an ac
Stuart... u got the logic now. check ur syntax problems urself...
this is the only way ull learn it!
a hint... if ur database query is giving u errors... try echoing it
before sending it to mysql_query. ull find out the problem yourself
then ;)
another hint... mysql_query always returns a
How are they any different?
I'm seeing the same thing as your method.
Stuart
--- Jason Wong <[EMAIL PROTECTED]> wrote:
> On Sunday 26 September 2004 19:45, Stuart Felenstein
> wrote:
>
> > While I'm okay with mine, not completely
> satisfied.
> > I'd like to change it to the type where like abo
Unknown column 'a338265f' in 'where clause' is the
latest problem (and should be the last). I had this
same error earlier while just doing a straight sql to
the database. I corrected it then by putting
apostrophes around the column name. That didn't help
here , not quotes , maybe double apostrop
On Sunday 26 September 2004 19:45, Stuart Felenstein wrote:
> While I'm okay with mine, not completely satisfied.
> I'd like to change it to the type where like above the
> username and password is sent via email, but with the
> addition of a link in the email whereby the user must
> click on link
> I'm getting an error using the
> "mysql_num_rows($result)"
> Warning: mysql_num_rows(): supplied argument is not a
> valid MySQL result resource in
> /home/lurkkcom/public_html/lurktivate.php on line 7
Did you happen to remember to change "fields" in the query string to your
table column names,
I'm getting an error using the
"mysql_num_rows($result)"
Warning: mysql_num_rows(): supplied argument is not a
valid MySQL result resource in
/home/lurkkcom/public_html/lurktivate.php on line 7
Why am I counting the number of rows in the table?
Shouldn't I be looking to see if the code I was pas
no you dont need a user id or anything, here is some sample code to
give you the idea
$result = mysql_query("SELECT fields FROM table WHERE code=".$_GET['code']);
if(mysql_num_rows($result) > 0) {
// we have a match, activate the account
$result1 = mysql_query("UPDATE table SET activated=1 WHE
Nothing like sharing my pain ;) sorry!
It seems that in order to compare the code to the one
in the database, don't I need the userid or something?
or just that it exists in the database?
Thank you,
Stuart
--- Joseph Crawford <[EMAIL PROTECTED]> wrote:
> what i did is i used php to create a rand
that is done when they click the link in thier email
if they are sent to domain.com/page.php?code=X4rfkj490T
the code in page.php will $_GET['code'] and compare it to the one in
the database, if they match, flip the switch if not show an error.
On Sun, 26 Sep 2004 06:35:59 -0700 (PDT), Stuart
K...I've added the 2 columns, my names - activate and
activate_hash.
Upon registration, the activate_hash has a generated
string inserted. activate column is default to 0.
I can compare it to the database - but not sure how to
flip the switch on the activate column 0->1
Is that done through an up
what i did is i used php to create a random string of numbers and
letters about 15 chars long, then i store this in the db, and in the
email i make the link page.php?code=RandomStringHere, then on the
page.php i get the code and compare it to the ont in the database. If
they match activate the use
Ok , I think this is along the lines of what I've
started. I added a column called "active" with a
default to 0. It's a tiny int since I'm think
0=fales, 1=true.
So can you explain a tad more about this hash stuff ?
Is that specific to a sql field or just a name you've
chose ? I'm not sure what
currently i do it the same way M Saleh EG does it ;)
i have found that is the easiest way and works perfect.
> On Sun, 26 Sep 2004 16:34:16 +0400, M Saleh EG <[EMAIL PROTECTED]> wrote:
> > I'd do it this way...
> >
> > I'd add two column in the users table. 1- activated, 2- activation-hash
> >
>
I'd do it this way...
I'd add two column in the users table. 1- activated, 2- activation-hash
once the registeration form is ubmited..
a-the username and user info will be saved in the users table.
b-an encrypted hash would be made n saved in activation-hash column
and sent along with the regist
Currently there are only 2 types of users planned
Each has a basic access level. I don't think this is
the same as a usergroup though.
If I don't have usergroups, but access levels, then
perhaps I should set the level to some less then what
is required login till activated.
Then it sounds like
something
along the lines of userid, tousergroup, activationcode).
/ rylin
-Original Message-
From: Stuart Felenstein [mailto:[EMAIL PROTECTED]
Sent: den 26 september 2004 13:46
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Question on Registration Method
Right now my registration / login sy
Right now my registration / login system works like
this:
1-User goes to registration page and fills out form
2-User gets to choose username but password is
autogenerated by system
3-System encrypts password in database
4-Password is unencrypted and sent along with username
to registrant's email a
20 matches
Mail list logo