Re: [PHP] How to confirm subscriptions by e-mail on a PHP site ?
The way i did it was, put a 25char hash inside the registered column, then sent an email to the user containing something like domain.com?user=id_numberhash=hash then i did select userID where userID = $_GET['user'] registered = $_GET['hash'] (not exactly the sql phrase, but i dont feel like adding %s's and mysql_real_escape_strings to it but you get the picture) then from the data i got, i did if($row_is_returned) { update users set registered=yes WHERE userID = $_GET['user']; } and that was it. Marcus Mário Gamito wrote: Hi, I'm making this middle-range site (i. e., not so little, bit not so big, either), and i want users that subscribe to my site to have their confirmation made by email. Does anyone sugests a simple, yet effective way to do this ? Please, don't misunderstand me. The PHP part i know. The sugestions i'm asking for are about the mechanism. Thanking you in advance. Warm Regards, Mário Gamito -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Refresh (F5) adds another SQL record.
Why dont you check that data isnt being duplicated? $query = SELECT auto_col FROM table where col1 = $var1 col2 = $var 3.; $call_query = mysql_query($query,... $query_data = mysql_assoc($call_query); if(!$query_data) { do form } else echo information already exists in database; Pierce Robert Meyer wrote: Hello, Scenario: 1) User is presented a blank form. 2) User fills in form. 3) User submits form. 4) Record is added to database. 5) Back to 1). All is fine to here. 6) User clicks refresh. 7) Another record is added, same data except auto-increment field. How do I prevent these last two steps, or at least prevent a record from being added when refresh is clicked? Regards, Robert -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Why not @ ?
It was curious to me, but I did a right click view source and here is your %40. a href =http://www.dte.ua.pt/cv/cv_show.php?email=gamito%40gmail.com;Maacute;rio Gamito/a well if your source code when you upload says @, then i can only imagin its being rendered on the server, otherwise every mailto:[EMAIL PROTECTED] would be broken. Marcus Joyce Mário Gamito wrote: Hi, If you care to take a peak at http://www.dte.ua.pt/cv/ and pass your mouse over the link Mário Gamito, you'll see in the status bar that the link is: http://www.dte.ua.pt/cv/[EMAIL PROTECTED] Allright. However, if you click and go to the respective page, you'll see that the @ is switched by %40. There is no need to even click it. Just Copy the link in the page and paste it in some editor. Even this way, the link is wrong. This completely bogles me. I mean, i pass the mouse over the link and i see @ in the status bar. If i Copy the link and paste it into a text editor, i get %40. Any help would be apreciated. The relevant code follows my signature. Warm Regrds, Mário Gamito -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php