tag:blogger.com,1999:blog-9171370399460373731.post5253694716499760285..comments2023-10-28T04:59:55.119-07:00Comments on Mostlikers Programming Blog : New User Registration With Email Verification Using PHP and MysqliUnknownnoreply@blogger.comBlogger19125tag:blogger.com,1999:blog-9171370399460373731.post-73333361296185678532016-10-19T09:52:01.514-07:002016-10-19T09:52:01.514-07:00Erm, i just have one question doh. I like the moda...Erm, i just have one question doh. I like the modal one in the zip file. Only i like that centered on the page, then just hanging bit to the left. Was checking solutions out the web, but...i didn't found a worthy one. Because i making this for all kind of devices and for cleaning view, center looks always good ;)Jos Den Hertoghttps://www.blogger.com/profile/15888212162176959196noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-87048203085596620752016-10-19T04:54:10.738-07:002016-10-19T04:54:10.738-07:00Thx for the fast update :)Thx for the fast update :)Jos Den Hertoghttps://www.blogger.com/profile/15888212162176959196noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-34370159518964257552016-10-17T23:57:35.063-07:002016-10-17T23:57:35.063-07:00Demo and zip file data updated. Demo and zip file data updated. Mostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-4249296281044532622016-10-17T23:56:25.154-07:002016-10-17T23:56:25.154-07:00It will work. But you have to update local email s...It will work. But you have to update local email setting configuration.Mostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-78801987801809589452016-10-15T18:09:59.810-07:002016-10-15T18:09:59.810-07:00I will Karthick :D
Thx for updating the stuff, on ...I will Karthick :D<br />Thx for updating the stuff, on the things i said :)Jos Den Hertoghttps://www.blogger.com/profile/15888212162176959196noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-53685919474424222482016-10-15T10:25:55.455-07:002016-10-15T10:25:55.455-07:00Thank you for your suggestions. It's really he...Thank you for your suggestions. It's really helpful our readers, I have changed if($row['status']=='0'): line. Now it's working fine. Demo and zip file i will update soon.<br /><br />Keep and touch with us.Mostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-15431051063074202342016-10-15T05:27:52.477-07:002016-10-15T05:27:52.477-07:00Okay, i see that there need another fix :P
Correc...Okay, i see that there need another fix :P<br /><br />Correct php code is for verify:<br /><br />query("SELECT * FROM `users` WHERE `active_code` = '$active_code'");<br />$count=mysqli_num_rows($fetch);<br />if($count==1) :<br /> $row=mysqli_fetch_array($fetch);<br /> if($row['status']=='0'):<br /> $db->query("UPDATE `users` SET `status` = '1' WHERE `active_code` = '$active_code'");<br /> $msg="Your account is activated";<br /> else :<br /> $msg="Your account is already activated";<br /> endif;<br />else :<br /> $msg="Wrong activation code. Check your email activate again";<br />endif;<br />else :<br /> header("Location:404.php");<br />endif;<br />echo $msg;<br />?><br /><br />I need to say this, if you have issues with updating the status column. Then simply delete that row and create another column with a different name.<br /><br />So if you have the sql file, it looks like this:<br /><br />CREATE TABLE IF NOT EXISTS `users` (<br /> `id` int(11) NOT NULL AUTO_INCREMENT,<br /> `email` varchar(100) NOT NULL,<br /> `name` varchar(250) NOT NULL,<br /> `your column name` varchar(10) NOT NULL DEFAULT '0',<br /> `password` varchar(250) NOT NULL,<br /> `active_code` varchar(300) NOT NULL,<br /> PRIMARY KEY (`id`)<br />) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;<br /><br />and everything shall work fine.<br /><br /><br /><br />Besides that, i like to say there is a bug on activate.php, where he shouts 2 times account is activated. 1) where it suppose to be and little textline, in left upper corner.<br /><br />BUT, i think this bug is a friendly bug ;) Jos Den Hertoghttps://www.blogger.com/profile/15888212162176959196noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-2731498504900881332016-10-15T03:47:47.975-07:002016-10-15T03:47:47.975-07:00I only wonder about this little piece what it does...I only wonder about this little piece what it does: id='$user_id' in verify. Because, how far i can see it, i do not see an $user_id string, in both files (i might overlooked it somewhere).Jos Den Hertoghttps://www.blogger.com/profile/15888212162176959196noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-15978279073640730872016-10-14T23:38:55.740-07:002016-10-14T23:38:55.740-07:00Hi Jos,
I have replaced if($row['active_code&...Hi Jos,<br /><br />I have replaced if($row['active_code']=='0'): to if($row['status']=='0'): line<br /><br />I will update zip file ASAP.<br /><br />Thank youMostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-298410326187517442016-10-14T02:37:50.839-07:002016-10-14T02:37:50.839-07:00Can i ask, what did you fixed? Because i do not se...Can i ask, what did you fixed? Because i do not see it here and in de zip file. Thx btw for fast response.Jos Den Hertoghttps://www.blogger.com/profile/15888212162176959196noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-31289247796591555432016-10-13T23:20:36.873-07:002016-10-13T23:20:36.873-07:00This comment has been removed by the author.Mostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-69744610307056932382016-10-13T17:12:26.331-07:002016-10-13T17:12:26.331-07:00The register code is working like it should be, no...The register code is working like it should be, no errors at all. Only, it seems from verifying, that i am always am activated.<br /><br />The status column is not updating at all, i even replaced the status column with a new one. I wonder only about this part of the code:<br /><br /> if($row['active_code']=='0'):<br /> $db->query("UPDATE `users` SET `status` = '1' WHERE id='$user_id'");<br /><br /><br />Does it not need to check the status column instead of active_code? Btw, is not $user_id wrong? Does is not need to check email is the same and then update the status column to 1?<br /><br />I might seen a bug there, that with pressing the activation link or before, that the active_code is filled in and might he said then, that he is already activated? I can be wrong here btw :)<br /><br />Jos Den Hertoghttps://www.blogger.com/profile/15888212162176959196noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-65937951418735458852016-08-03T01:55:21.217-07:002016-08-03T01:55:21.217-07:00create new 'status' columncreate new 'status' column Mostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-47410727859991740142016-07-30T05:52:08.746-07:002016-07-30T05:52:08.746-07:00no mysql 'status'
$db->query("UPD...no mysql 'status'<br /><br />$db->query("UPDATE `users` SET `status` = '1' WHERE id='$user_id'");Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-74725211940718459582016-07-30T05:50:49.547-07:002016-07-30T05:50:49.547-07:00no 'status'no 'status'Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-56889199932706334282016-06-09T01:44:39.297-07:002016-06-09T01:44:39.297-07:00will it work on localhost?
will it work on localhost?<br />Anonymoushttps://www.blogger.com/profile/12704508213306335928noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-26410969397958148652016-06-09T01:44:12.445-07:002016-06-09T01:44:12.445-07:00will it be applied in localhost?
will it be applied in localhost?<br />Anonymoushttps://www.blogger.com/profile/12704508213306335928noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-53153977836253347382016-04-08T19:56:37.926-07:002016-04-08T19:56:37.926-07:00Thank you bro. It's confidentialThank you bro. It's confidentialMostikershttps://www.blogger.com/profile/12751758635595080729noreply@blogger.comtag:blogger.com,1999:blog-9171370399460373731.post-32130072720744722352015-11-03T10:28:03.859-08:002015-11-03T10:28:03.859-08:00hi karthick
how much you earned from your blog :)
...hi karthick<br />how much you earned from your blog :)<br /><br />keep up the good work<br /><br />srinivasnoreply@blogger.com