prepare('SELECT * FROM sales_pilot.business_records WHERE Email = ? AND activation_code = ?')) { $stmt->bind_param('ss', $Email, $code); // Use the variables here $stmt->execute(); $stmt->store_result(); if ($stmt->num_rows > 0) { // Account exists with the requested email and code. // Prepare an UPDATE query to activate the account. if ($stmt = $con->prepare('UPDATE sales_pilot.business_records SET activation_code = ? WHERE Email = ? AND activation_code = ?')) { $newcode = 'activated'; $stmt->bind_param('sss', $newcode, $Email, $code); // Use the variables here $stmt->execute(); echo 'Your account is now activated! You can now login!'; } } else { echo 'The account is already activated or doesn\'t exist!'; } } else { echo 'Database query error.'; } // Check activation status and display content accordingly. $query = "SELECT activation_code FROM sales_pilot.business_records WHERE Email = ?"; if ($stmt = $con->prepare($query)) { $stmt->bind_param('s', $Email); $stmt->execute(); $stmt->bind_result($activationStatus); $stmt->fetch(); if ($activationStatus == 'activated') { echo 'user-confirm.html.'; } } } else { echo 'Invalid activation link.'; } ?>