Double opt in problem

I have followed the video tutorial several times and keep having problems. The verification email is sent but when the verification link is clicked, the page that loads is blank and the emailVerified row of the db does not update from 0 to 1. The URL for the verification link is in this format - http://www.letsparksfly.com/userconfirm.php?id=1&randomString=t6he9m&email=dgwebs@gmail.com. All of the variables are correct. In this instance, the userID is 1, the randomString is correct (based on the one showing in table), and the email is correct.

In the tutorial at 22:53 of the video tutorial a session value is being added to the userconfirm page and in the dialog box that appears, the session variable name defaults to emailVerified. I do not have a session variable of emailVerified available. I notice earlier in the video that session variable appears in the bindings panel but it is has never appeared in mine in any of the six times I've tried this. Could that be my problem?

Many thanks for your help!

if the session binding does not get created automatically, you may need to create it manually.

on the bindings panel, click the plus button, select Session and enter the name for the session binding.

sometimes the sites _notes folder can become corrupted and cause creating new bindings to fail.

use the OS File System explorer to browse to the site and delete the _notes folder if you are not able to manually create the binding.


can you send a copy of the userconfirm.php file so i can see how it is set up.

I created the session binding manually and tried again. Still the same result. I'm attaching both the userconfirm.php and the email form in case the problem might be there. My userconfirm.php page doesn't contain links to log in because once the user verifies him/herself, a representative from the company will be in touch with them via phone and the user doesn't have any need to access any of the profile information.

visiting your original link shows a blank page.

a blank page means that a php error is occurring but error reporting is turned off.

to turn error reporting on, add the following code at line 1:

<?php
error_reporting(E_ALL);
ini_set('display_errors','on');
?>

once we know what the error is, we will be able to troubleshoot the cause.

First off, thanks so much for your help Jason!

Okay, I added that code and it immediately said there was a syntax error on line 48 but I do not know what that error is. I'm attaching the updated file.

ok, the syntax error is the use of squiggly brace where a square bracket should be.

line 47 - 50:

$paramemail_rsVerify = "-1";
if (isset($_GET['email'})) {
  $paramemail_rsVerify = $_GET['email'};
}

should be:

$paramemail_rsVerify = "-1";
if (isset($_GET['email'])) {
  $paramemail_rsVerify = $_GET['email'];
}

Ahhhhhhhh!!!! Thank you so much Jason!

no worries.

when creating the paramemail variable in the recordset, you where entering:
$_GET['email'}

as the run time value instead instead of:
$_GET['email']

The weird thing is, each time I tried this I was positive I entered it proprely. Obviously, I was wrong!

Thanks again. The video tutorial is great, by the way. I feel like the woman who recorded it and I are now close friends since I listened to her so many times.

you're welcome.