5 Years
Discussion Span
Last Post by andreiviziru
Featured Replies

What happened? Do you get errors? Be more specific, we cannot just guess what's wrong without knowing/seeing what you have done.


so i have this in my index.php

    <div id="content" style="margin-bottom:100px;">
<form action="index.php" method="post" class="registration_form">
    <legend>Registration Form </legend>

    <p>Create A new Account <span style="background:#EAEAEA none repeat scroll 0 0;line-height:1;margin-left:210px;;padding:5px 7px;">
Already a member? <a class="black" href="login.php">Log in</a></span> </p>

    <div class="elements">
      <label for="name">Name :</label>
      <input type="text" id="name" name="name" size="25" />
    <div class="elements">
      <label for="e-mail">E-mail :</label>
      <input type="text" id="e-mail" name="e-mail" size="25" />
    <div class="elements">
      <label for="Password">Password:</label>
      <input type="password" id="Password" name="Password" size="25" />
    <div class="submit">
     <input type="hidden" name="formsubmitted" value="TRUE" />
      <input type="submit" value="Register" />
include ('db_con.php');
if (isset($_POST['formsubmitted'])) {
    $error = array(); //Declare An Array to store any error message
    if (empty($_POST['name'])) { //if no name has been supplied
        $error[] = 'Please Enter a name '; //add to array "error"
    } else {
        $name = $_POST['name']; //else assign it a variable

    if (empty($_POST['e-mail'])) {
        $error[] = 'Please Enter your Email ';
    } else {

        if (preg_match("/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/",
            $_POST['e-mail'])) {
            //regular expression for email validation
            $Email = $_POST['e-mail'];
        } else {
            $error[] = 'Your EMail Address is invalid  ';


    if (empty($_POST['Password'])) {
        $error[] = 'Please Enter Your Password ';
    } else {
        $Password = $_POST['Password'];

    if (empty($error)) //send to Database if there's no error '

    { // If everything's OK...

        // Make sure the email address is available:
        $query_verify_email = "SELECT * FROM members  WHERE Email ='$Email'";
        $result_verify_email = mysqli_query($dbc, $query_verify_email);
        if (!$result_verify_email) { //if the Query Failed ,similar to if($result_verify_email==false)
            echo ' Database Error Occured ';

        if (mysqli_num_rows($result_verify_email) == 0) { // IF no previous user is using this email .

            // Create a unique  activation code:
            $activation = md5(uniqid(rand(), true));

            $query_insert_user =
                "INSERT INTO `members` ( `Username`, `Email`, `Password`, `Activation`) VALUES ( '$name', '$Email', '$Password', '$activation')";

            $result_insert_user = mysqli_query($dbc, $query_insert_user);
            if (!$result_insert_user) {
                echo 'Query Failed ';

            if (mysqli_affected_rows($dbc) == 1) { //If the Insert Query was successfull.

                // Send the email:
                $message = " To activate your account, please click on this link:\n\n";
                $message .= WEBSITE_URL . 'activate.php?email=' . urlencode($Email) . "&key=$activation";
                mail($Email, 'Registration Confirmation', $message, 'From:'.EMAIL);

                // Flush the buffered output.

                // Finish the page:
                echo '<div class="success">Thank you for
registering! A confirmation email
has been sent to ' . $Email .
                    ' Please click on the Activation Link to Activate your account </div>';

            } else { // If it did not run OK.
                echo '<div class="errormsgbox">You could not be registered due to a system
error. We apologize for any

        } else { // The email address is not available.
            echo '<div class="errormsgbox" >That email
address has already been registered.

    } else { //If the "error" array contains error msg , display them

        echo '<div class="errormsgbox"> <ol>';
        foreach ($error as $key => $values) {

            echo '  <li>' . $values . '</li>';

        echo '</ol></div>';


    mysqli_close($dbc); //Close the DB Connection

} // End of the main Submit conditional.


and the db_con.php contents are:


/*Define constant to connect to database */
DEFINE('DATABASE_HOST', 'localhost');
/*Default time zone ,to be able to send mail */

/*You might not need this */
ini_set('SMTP', "mail.myt.mu");
// Overide The Default Php.ini settings for sending mail

//This is the address that will appear coming from ( Sender )
define('EMAIL', 'email@gmail.com');

/*Define the root url where the script will be found such as
http://website.com or http://website.com/Folder/ */
DEFINE('WEBSITE_URL', 'http://www.jocurigratisonlinenet.ro/registration/');

// Make the connection:

if (!$dbc) {
 trigger_error('Could not connect to MySQL: ' . mysqli_connect_error());


i get the activation link but when i click it it takes me to activate.php
and get this error "Oops !Your account could not be activated. Please recheck the link or contact the system administrator."
here's the contents of activate.php

include ('db_con.php');
if (isset($_GET['email']) && preg_match('/^([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+$/',
 $_GET['email'])) {
 $email = $_GET['email'];
if (isset($_GET['key']) && (strlen($_GET['key']) == 32))
 //The Activation key will always be 32 since it is MD5 Hash
 $key = $_GET['key'];

if (isset($email) && isset($key)) {

 // Update the database to set the "activation" field to null

 $query_activate_account = "UPDATE members SET Activation=NULL WHERE(Email ='$email' AND Activation='$key')LIMIT 1";
 $result_activate_account = mysqli_query($dbc, $query_activate_account);

 // Print a customized message:
 if (mysqli_affected_rows($dbc) == 1) //if update query was successfull
 echo '<div>Your account is now active. You may now <a href="login.php">Log in</a></div>';

 } else {
 echo '<div>Oops !Your account could not be activated. Please recheck the link or contact the system administrator.</div>';



} else {
 echo '<div>Error Occured .</div>';

Edited by andreiviziru


Echo the query you run, and run it with phpMyAdmin. Perhaps you have either no matching rows, or multiple matching rows.


when i run

"UPDATE members SET Activation=NULL WHERE(Email ='some@email.com' AND Activation='s0m3k3y')LIMIT 1"

it says "Affected rows: 0 (Query took 0.00001 sec)


this is what i get after echoing on activate.php

UPDATE members SET Activation=NULL WHERE(Email ='andrei_3333333333@yahoo.com' AND Activation='8f979bda59ba8c10b3eb8b1d03b7f7ce')LIMIT 1

Oops !Your account could not be activated. Please recheck the link or contact the system administrator.

Edited by deceptikon: Added code tags


Run this query in phpMyAdmin, see what happens. Perhaps it triggers an error. Check if these values match in your table.


maybe i screwed with the database table i have inserted it in a query

Edited by andreiviziru


Affected rows: 0 (Query took 0.0001 sec)
SQL query:

UPDATE members SET Activation = NULL WHERE (
    Email = 'gffg@hhh.com' AND Activation = '657t67tr67t76t'
) LIMIT 1 

Edited by deceptikon: Added code tags


Are you sure you're on the right database? That's the only thing I can think of. Other than that, I'm out of ideas.


Have you cheched if the new user is succesfull inserted into the database (before the activation step)?


i have as txt this editor doesn't allow as sql

-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
-- Host: localhost
-- Generation Time: Aug 28, 2013 at 07:53 AM
-- Server version: 5.1.57
-- PHP Version: 5.2.17


-- Database: `a4610871_reguser`

-- --------------------------------------------------------

-- Table structure for table `members`

CREATE TABLE `members` (
  `Memberid` int(10) NOT NULL AUTO_INCREMENT,
  `Username` varchar(20) NOT NULL,
  `Email` varchar(20) NOT NULL,
  `Password` varchar(10) NOT NULL,
  `Activation` varchar(40) DEFAULT NULL,
  PRIMARY KEY (`Memberid`)

-- Dumping data for table `members`

INSERT INTO `members` VALUES(31, 'omustean', 'andrei_3333333333@ya', 'password', '99172f3d733bbf757373c5a775b83db0');

See your attached file. You tried to validate andrei_3333333333@yahoo.com but in your table it is andrei_3333333333@ya, because the email column is only 20 characters. That's the reason the row is not found.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.