PHP Tutorials: Register & Login: Email activation (Part 3)

[fruitman89]

ALEX == Boss

[mezigpo]

woman scream at 8:30. is it in a brothel? jk

[Royalllllll]

I dont know why,but if i have for example 4 users nonactivated and one from them is going to activate, rest of them actives automaticly as well...what the?

[lauris47]

@Royalllllll now, "id" shows which ine to activate

[ultrastatic100]

woman scream at 8:30 xD

[416905com]

@ultrastatic100 Actually the woman screams at 8:31

[ultrastatic100]

woman scream at 8:31 xD

[TheRishikumra]

I need help because, I keep getting

Notice: Undefined index: id in (my file location\activate,php) on line 6

Notice: Undefined index: code in (my file location\activate.php) on line 7

I understand the error is on lines 6 and 7 and it doesn't understand the $id and $code. However i do not know how to fix it. Could you please take a look at my code? Please provide your email... thanks

[lyndr29]

I didn't understand the use of the GET, and it's producing some errors in the page. Can somebody please explain why? Thanks.

[khandaniyaal2000]

@lyndr29 To help make it user friendly so that the user doesnt need to type any thing

[HumanLife52627]

around 6:48 LOL hilarious

[HorizonEW]

Ook I dont understand .... i get this warning message ... Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /Applications/XAMPP/xamppfiles­/htdocs/xampp/phplogtest2/acti­vate.php on line 14

Invalid id or activation code on line 14 is this $checknum = mysql_num_rows($check);

[cutesheikh1000]

@HorizonEW

check your query ... here is the code ... den u get 2 know whats wrong in it ...

if (!$check) { // add this check. die('Invalid query: ' . mysql_error());

}

[darklink51]

Hello, sorry for my English ... I do not speak very well. I have a mistake entering the data manually.

The error is as follows:

mysql_num_rows() expects parameter 1 to be resource

What could be happening?

[nnngggiii]

what is the different beetwen of this TUT and Register & Login: Email activation (Part 2,1)?

thanks nice tuts

[vader0109]

Hey what video is it that has the construction of the connect.php, am kinda stuck here with out checking that one out!

[Grkgermn333]

@vader0109 I don't think he made a vid about that, but here's the code inside it:

$connect = mysql_connect("localhost", "root", "") or die("Couldn't connect to database");

mysql_select_db("phplogin") or die("Couldn't connect to database");

[terraf1rma]

@Grkgermn333 he did, register and login part 1, watch them all from the start

[ikzegmenaamniet]

I have this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /public_html/home/phplogin/act­ivate.php on line 16

Invalid ID or Activation code.

Does anyone know how I can solve this?

[matrixITALIA]

alex we should put active=1 in log in page because we check just for username and password, so we log in even if the avtivation is 0

[matrixITALIA]

what about the part 2? wasnìt it good? or this is just an otherway 4 actvation? thanks so much from Italy :)

[jackrios2]

Hi Alex, again your tutorials are awesome and very helpful. Is that possible you create a tutorial for "forgot your password?" and then send a provisory password by email, so the person will be able to login and reset/create a new password? I mean, do you have any tutorial for this?Thanks a lot

[himankerable]

8:31 what the sound wah!!!

[msborat96]

what is wrong with this lie of code

$check = mysql_query("SELECT * FROM users WHERE id='$id' AND random='$code'");

[halogreg8889]

@msborat96 did u setup

$connect = mysql_connect('host','username­','password')

mysql_select_db("date base name");

and THEN put

$check = mysql_query("SELECT * FROM users WHERE id='$id' AND random='$code'");

[007mcbc]

can u give ur source code? coz i making a php website and it can be help in me a lot i hope u response quick thanks for the advance....

[18Mrnazareno]

can you send me your code plsss.... thnks

[OnlyInNaziGermany]

Random woman screaming

[ilovetheinternet]

@OnlyInNaziGermany I read this at the beginning of watching the video, but had completely forgot about it by the time I got there. That was priceless!

[wackerist]

Thanks, really greatttttttttt, 5 stars.....

[mahesh0018]

I sent mails to my yahoo account to check mail function but there were no mails also i sent to my gmail account and it shows them ....Why my mail Function doesn't work with Yahoo...Please help me??

[ZiguaThaMaster]

good lookin out dude

[omanoman98]

Wooooooooooow! Goooooooooood stuff! Alex you are making PHP and hence programming much more fun! Thanks a lot!

[filapente]

question: when the user submits and the data is sent to the db.. and the echo shows on the page that it was sent. what happens if i place the php code on the bottom of a page and when submitted it refreshes and all the data is submitted but now the page is on top..and the echo is at the bottom of the page... how can i stay where it shows me the echo once submitted.. instead of being placed on the top part of the page??

[Knowledgeable88]

I added some fields in the code and into my datebase. I get it to say registered and i check the email, then when i click the link I keep geting data missing. I have all of the fields in the same order as the database. Can you help me??

[phpacademy]

If you'd like to send me your code i'll take a look?

[Knowledgeable88]

I sent you an email from lildaddyha at yahoo dot come. The subject is"heres my code'. Looking forward to your reply. Thanks a lot!!

[modernclics]

Easier than I thought. Thanks.