HELP ! How to Integrate hMail with the Signup Form

Home Forums Programming HELP ! How to Integrate hMail with the Signup Form

This topic contains 1 reply, has 2 voices, and was last updated by  Satish 4 years, 11 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #1908

    leezhijiang
    Member

    I am running a Hmail server which is relying on mySQL for storing data . I noticed that accounts are stored in the table called hm_accounts.  What is the code to register a new email address on my server by using the signup form.

    _____________________________________________________________________________________________
    Original signup.php
    < ?php include_once("db.php"); ?>

    < ?php $user = $_POST['n']; $pass = $_POST['p']; $id = $_POST['id']; #$sql = "INSERT into phplogin values(".$id.",'".$user."','".$pass."')"; $sql = "INSERT into phplogin values($id,'$user','$pass')"; $qury = mysql_query($sql); #  INSERT into phplogin values( #   1, #   'satish', #   'satish'); if(!$qury) { echo "Failed ".mysql_error(); echo "
    SignUp";
    echo "
    SignIn";
    }
    else
    {
    echo "Successful";
    echo "
    SignUp";
    echo "
    SignIn";
    }
    ?>
    My Codes for Signup Form

    < html >
    < form action="signup.php" method="post" >
    Desired Username@chemistry.my(please complete with @chemistry.my:
    < input type="text" name="accountaddress"/ >
    Desired Password:< input type="password" name="accountpassword" />
    Account Id      :< input type="text" name="accountid"/ >
    < input type="submit"/>
    < /form >
    < /html >

    The table created by hmail server in my mysql database( in xps form)

    http://www.mediafire.com/?2cdhgbr80gykfmm

    Can someone please analyze all these information and tell me what should I change on “signup.php” and “signupform.php”

    Thank You !

     

    #1995

    Satish
    Keymaster

    You should modify the mysql to

    $accountaddress = $_POST[‘accountaddress’];
    $accountpassword = $_POST[‘accountpassword’];
    INSERT into phplogin(‘accountaddress’, ‘accountpassword’) values($accountaddress,’$accountpassword’)

    Other fields:
    You can auto-increment accountid.
    Also implement email verification through this mechanism: http://technotip.com/1672/email-verification-in-php-part-1/
    accountlevel has to be set.
    and the email account creation set using now() function, and expiration set by admin or is preset for some predetermined period of time.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.