how to remain correct user info in signup page

hi

when user entered particulars in signuppage and click" signup" button, i will direct them to do_signup.php. if say the NRIC is dupicate in datebase, i will redirect them back to signup page again to re-signup, however, i would like to remain all the correct infromation, and let users re-entered their NRIC. how can i do this. can i use Session, but it seems cant work. any one can help me?

my code in signup page is like this:

Expand|Select|Wrap|Line Numbers

  
<html>

<head>

<link rel="stylesheet" type="text/css" href="gallery.css" />
 
<script language="JavaScript">
 
<!--
 
function validate_form ( )

{

    valid = true;

    if ( document.regForm.uName.value == "" )

    {

        alert ( "Please fill in the 'Your name' box." );

        regForm.uName.focus();

        valid = false;

    }

     else if ( ( document.regForm.gender[0].checked == false )

    && ( document.regForm.gender[1].checked == false ) )

    {

        alert ( "Please choose your Gender: Male or Female" );

        valid = false;

    }

    else if ( document.regForm.country.selectedIndex == 0 )

        {

                alert ( "Please select your country." );

                regForm.country.focus();

                valid = false;

        }
 
    else if ( document.regForm.age.selectedIndex == 0 )

        {

                alert ( "Please select your Age." );

                regForm.age.focus();

                valid = false;

        }
 
    else if ( document.regForm.email.value == "" )

    {

        alert ( "Please fill in the 'Your email' box." );

        regForm.email.focus();

        valid = false;

    }  
 
    else if ((/^\w+([\.-]?\w+)*@\w+([\.-]?\w+)*(\.\w{2,3})+$/.test(regForm.email.value))==false){

        alert ( "The email address provided is not valid");

        regForm.email.focus();

        valid = false;

    }

    else if ( document.regForm.address.value == "" )

    {

        alert ( "Please fill in the 'Your address' box." );

        regForm.address.focus();

        valid = false;

    }

    else if( (/^\d{6}$/).test(regForm.postal.value) ==false){

        alert ( "The postal code should have 6 digits");

        regForm.postal.focus();

        valid = false;
 
    }//postal codes
 
    else if( (/^[SG]\d{7}[A-Z]$/).test(regForm.nric.value) ==false){

        alert ( "The nric is not valid"); //start with S OR G and end with a CAPITAL LETTER

        regForm.nric.focus();

        valid = false;

    }//ic

  else if( (/^.*(?=.{8,})(?=.*\d)(?=.*[a-z])(?=.*[A-Z])(?=.*[@#$%^&+=]).*$/).test(regForm.pass1.value) ==false){

        alert ( "The password is not valid"); //start with S OR G and end with a CAPITAL LETTER

        regForm.pass1.focus();

        valid = false;

    }//ic
 
    else if( (regForm.pass1.value) != (regForm.pass2.value)) {

        alert ( "Passwords do not match");

        regForm.pass2.focus();

        valid = false;

    }//password match

    else if ( document.regForm.secret.value == "" )

    {

        alert ( "Please fill in your Secret Question." );

        regForm.secret.focus();

        valid = false;

    }  

    else if ( document.regForm.answer.value == "" )

    {

        alert ( "Please fill in your Secret Answer." );

        regForm.answer.focus();

        valid = false;

    }

  else if ( ( document.regForm.Hphone.value=="" )

    && ( document.regForm.HP.value =="") && ( document.regForm.Ophone.value == "") )

    {

        alert ( "Please enter any one of the three phone NO" );

        valid = false;

        }

    else if ( ( document.regForm.Hphone.value!="" )&&((/^(\((\+\d{2})?\))?[56]\d{7}$/).test(regForm.Hphone.value) ==false)){

        alert ( "the Home phone No entered is not valid" );

        valid = false;

        }
 
    else if (( document.regForm.HP.value !="")&&((/^(\((\+\d{2})?\))?[89]\d{7}$/).test(regForm.HP.value) ==false)){

             alert ( "the HP phone No entered is not valid" );

        valid = false;

            }
 
    else if (( document.regForm.Ophone.value != "")&&((/^(\((\+\d{2})?\))?[3456]\d{7}$/).test(regForm.Ophone.value) ==false)){

             alert ( "the Office phone No entered is not valid" );

        valid = false;

        }
 
    else if ( document.regForm.years.value == "" )

    {

        alert ( "please enter numerical value for No of years you played golf" );

        regForm.years.focus();

        valid = false;

    }  

else if( (/^((\d{1})|(\d{2}))$/).test(regForm.years.value) ==false){

        alert ( "your input is incorrect,please enter numerical value");

        regForm.years.focus();

        valid = false;

    }
 
    return valid;

}
 
//-->

</script>
 
</head>

<body>

<div id="header">

</div>

<div id="leftcol">    

</div>

<div id="maincol">

    <form name = 'regForm' action = "do_signup.php" method = "POST" onSubmit = 'return validate_form ();'>

         <? echo "<br>";?>

         <table>

         <tr>

  <td> <font size="4"color="red">*</font> User Name </td><td><input type = "text" name="uName"> </td>

    <td>

    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font size="4"color="red">*</font>please enter one or more of the following Phone NO:</td>

   </tr>
 
    <tr>

    <td class="tablebody1"><font size="4"color="red">*</font>Gender:<BR>

</td>
 
<td class="tablebody1">

<input name="gender" type="radio" value="male" />

 Male&nbsp;&nbsp;&nbsp;&nbsp;

<input name="gender" type="radio" value="female" />

Female</td>
 
    <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Home Phone&nbsp;&nbsp;&nbsp;&nbsp;<input type = "text" id="1" name="Hphone"></td>
 
</tr>
 
 <tr>

                <td class="loginFormLabel"><font size="4"color="red">*</font>    <span class="error"><nobr>Country:</nobr></span>

</td>

                <td class="formFieldSmall">

                    <select name="country" tabindex="11">

                            <option value="---">---</option>

                            <option value="Indonesia" >Indonesia  </option>

                            <option value="Malaysia" >Malaysia  </option>

                            <option value="Philippines" >Philippines   </option>

                            <option value="Singapore" > Singapore </option>

                            <option value="Thailand" > Thailand</option>

                            <option value="Vietnam " > Vietnam  </option>

                            <option value="Laos" >Laos </option>

                            <option value="Myanmar" > Myanmar </option>

                            <option value="Cambodia" > Cambodia </option>

                            <option value="Brunei" > Brunei </option>
 
                    </select>

                    <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Hand Phone&nbsp;&nbsp;&nbsp;&nbsp;  <input type = "text" id="2" name="HP"></td>

</td>

</tr>

           <tr>

        <td class="loginFormLabel"><font size="4"color="red">*</font>    <span class="error"><nobr>Your age:</nobr></span>

</td>

                <td class="formFieldSmall">

                <select name="age">

                            <option value="---">---</option>

                            <option value="15-25">15-25 years</option>

                            <option value="26-35">26-35 years</option>

                            <option value="36-45">36-45 years</option>

                            <option value="46-60">46-60 years</option>

                            <option value="60+">60+ years</option>

                            </select>

                </td>

            <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Office Phone&nbsp;&nbsp;&nbsp; <input type = "text" id="3" name="Ophone"></td>
 
            </tr>

    <tr>

    <td><font size="4"color="red">*</font>Email Address </td> <td><input type = "text" name="email"></td> 

    </tr>

    <tr>

    <td><font size="4"color="red">*</font>Address </td> <td><input type = "text" name="address"></td> 

    <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<font size="4"color="red">*</font>please enter No of years you played golf:</td>

    </tr>

    <tr>

    <td><font size="4"color="red">*</font>Postal Code </td> <td><input type = "text" name="postal"></td>

    <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;No of years:&nbsp;&nbsp;&nbsp;&nbsp; <input type = "text"size="2" name="years"> years</td>

    </tr>
 
    <tr>

    <td><font size="4"color="red">*</font>FIN/IC Number </td> <td><input type = "text" name="nric"></td>

    <td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<i>(Please enter in numerical figures)&nbsp;&nbsp;&nbsp;&nbsp;</i></td>

    </tr>

    <tr>

    <td><font size="4"color="red">*</font>Password </td> <td><input type = "password" name="pass1"></td></tr>

    <tr><td><font size="4"color="red">*</font>Confirm Password</td><td><input type = "password" name="pass2"></td></tr>
 
    <tr>

    <td><font size="4"color="red">*</font>Your Secret Question </td> <td><input type = "text" name="secret"></td>

    </tr>

    <tr>

    <td><font size="4"color="red">*</font>Your Secret Answer </td> <td><input type = "text" name="answer"></td>

    </tr>

    </table>

    <input type ="submit" value="submit">
 
<?

    echo"<br>";

    echo"<br>";

    echo"<br>";

    echo"<br>";
 
    echo" NOTE:";

    echo"<br>";

    echo " * Password must be at least 8 characters";

    echo"<br>";

    echo "* Password must contain at least one one lower case letter, one upper case letter, one digit and one special character";

    echo"<br>";

    echo "* Valid special characters (which are configurable) are   '@#$%^&+='";

    echo"<br>";

    ?>
 
</form>

</div>

</body>

</html>

the code in do_signup.php is like this:

Expand|Select|Wrap|Line Numbers

 
<?php

ob_start();

session_start();

require('db.php');

//retrieve info from from

$usr = $_POST['uName'];

$gender=$_POST['gender'];

$country=$_POST['country'];

$age=$_POST['age'];

$eml =  $_POST['email'];

$addr = $_POST['address'];

$pCode = $_POST['postal'];

$phone = $_POST['Hphone'];

$HP = $_POST['HP'];

$OP = $_POST['Ophone'];

$nric = $_POST['nric'];

$years=$_POST['years'];

$pass1 = $_POST['pass1'];

$pass2 = $_POST['pass2'];

$secret=$_POST['secret'];

$answer=$_POST['answer'];
 
$_SESSION['username']=$usr;

$_SESSION['gender']=$gender;

$_SESSION['country']=$country;

$_SESSION['age']=$age;

$_SESSION['email']=$eml;

$_SESSION['address']=$address;

$_SESSION['postal']=$pCode;

$_SESSION['Hphone']=$phone;

$_SESSION['HP']=$HP;

$_SESSION['Ophone']=$OP;

$_SESSION['nric']=$nric;

$_SESSION['years']=$years;

$_SESSION['pass1']=$pass1;

$_SESSION['pass2']=$pass2;

$_SESSION['secret']=$secret;

$_SESSION['answer']=$answer;
 
if ($_POST['uName'] == “”){ 

echo 'you did not fill in your name';

}

else if ($_POST['gender'] == “”){ 

echo 'you did not choose your gender';

}

else if ($_POST['country'] == “”){ 

echo 'you did not choose your country';

}

else if ($_POST['age'] == “”){ 

echo 'you did not choose your age';

}

else if ($_POST['email'] == “”){ 

echo 'you did not fill in your email';

}
 
else if ($_POST['address'] == “”){ 

echo 'you did not fill in your address';

}
 
else if ($_POST['postal'] == “”){ 

echo'you did not fill in your postal';

}
 
else if ($_POST['nric'] == “”){ 

echo'you did not fill in your nric';

}

else if ($_POST['years'] == “”){ 

echo'you did not fill in how many years you played golf';

}

else if ($_POST['pass1'] == “”){ 

echo'you did not fill in your password';

}

else if ($_POST['pass1']!=$_POST['pass2']){ 

echo'your password did not match!';

}

else if ($_POST['secret'] == “”){ 

echo'you did not fill in your secret question';

}

else if ($_POST['answer'] == “”){ 

echo'you did not fill in your secret answer';

}

//Encrypt password

$pwd = MD5($pass1);
 
//Connect to Database server

mysql_connect(MACHINE, USER, '');

mysql_select_db(DBNAME);
 
//SQL statement to insert member record
 
$sql2="Select * from users where nric='" . $nric . "'";

$result2= mysql_query($sql2);
 
if(mysql_num_rows($result2) == 1)

{

echo" your NRIC is deupicated in our database, please re-signup";

echo"<br>";

echo "Error: could not add you as a member ";

echo"<br>";

//echo "<a href = 'signupform.php'>Go back to re-signup</a>";

echo "you will be redirected to our signup page to re-enter your NRIC";

//echo "<a href = 'update.php'>Renter your nric</a>";

header("Refresh: 5; URL=signupform.php");

}

else{

$sql = "INSERT INTO users (id, name, gender, country, age, password,secret,answer, email, address, postal_code, Hphone, HP, Ophone, nric,years) VALUES ";

$sql .= "('','".$usr."','".$gender."','".$country."','".$age."','".$pwd."','".$secret."','".$answer."','".$eml."','".$addr."','".$pCode."','".$phone."','".$HP."','".$Ophone."','".$nric."','".$years."')";

mysql_query($sql);
 
    $fromHeader = "From:"."feedback@postergolf.sg";

    $subject = "Welcome to the Golf Connect";

    $msg = "Your user name:". $usr." and password:".$pass1;
 
    mail($eml, $subject, $msg, $fromHeader );

    echo"<br>";

    echo " Confirmation Email has been sent to" .$usr."<br>";

    echo "Member ". $usr. " was successfully added!<br>";

    header("Refresh: 5; URL=index.php");

    echo "Redirecting to index.php"; //redirecting is done above!

}
 
//echo $num_rows;

//Add new user to database table

/*if ($num_rows==1){

    //show confirmation message upon success
 
    //Emailing

    $fromHeader = "From:"."feedback@postergolf.sg";

    $subject = "Welcome to the Golf Connect";

    $msg = "Your user name:". $usr." and password:".$pass1;
 
    mail($eml, $subject, $msg, $fromHeader );

    echo"<br>";

    echo " Confirmation Email has been sent to" .$usr."<br>";

    echo "Member ". $usr. " was successfully added!<br>";

    echo "Redirecting to index.php"; //redirecting is done above!

    //header("Refresh: 5; URL=index.php");

    //echo "<a href = 'index.php'>Go back to home page</a>";

}//end if

else{

    echo "Error: could not add you as a member ";

}//end else*/

//ob_end_flush();

?>

any one can help me with this ? it is urgent as the project timeline is very near! thanks for any kind help!! :)

Jul 14 '07 #1

Subscribe Post Reply

3196

pbmods

5,821

Expert 4TB

Heya, Kang.

What is your code doing that you don't want it to do? Give an example.
What is your code *not* doing that it is supposed to? Give an example.

Jul 14 '07 #2

Similar topics

Philadelphia area XML user group

by: info | last post by:

This is to announce the inaugural meeting of the Philadelphia XML Users Group. If you're in the Philadelphia area, and you have an interest in XML and related standards in publishing, you're...

.NET Framework

Correct way of serializing a "Quasi-singlton" class?

by: Kenneth Baltrinic | last post by:

Is the following code correct for serializing a quasi-single class, that is a class that has a descreet (though more than one, so not a true singleton) number of static instances and no dynamically...

C# / C Sharp

Question: Setting Profile for create new user

by: VB Programmer | last post by:

I am using personalization/profile to store info for the user that is not contained in the aspnet_Users or aspnet_Membership tables. This info includes, firstname, lastname, and phonenumber. ...

ASP.NET

Error while fetching values from table containing login info

by: warezguy05 | last post by:

Hello I'm experiencing a problem; I've written a small script where volunteers can be booked for work-activities at a festival. The festival has 5 different departments so i've created a...

PHP

How do I pass form info to autoresponder like GetResponse?

by: PaulPay | last post by:

I want to add a newsletter signup form to my ASP website and then have the newsletter automatically emailed to the client. I want to use a hosted email/autorresponder company because of the spam...

ASP / Active Server Pages

how to remain the correct value in signuppage

by: kang jia | last post by:

hi currently i am editing signup page, when user enter deupicated NRIC and click signup, they will go to do_signuppage and read the error message and then after 5 seconds, they will be redirected...

PHP

Signup Problem

by: nazgul42 | last post by:

Ok... this is my third problem today, but here goes: On my signup page for my login system on my website, I have some code that is supposed to check if a username is already taken and give an error...

PHP

user authentication with SESSION and FORGOT PASSWORD script

by: whitey | last post by:

Can anybody supply me with a script the does what is in the title above please? I have tried so many different methods! here is what im currently trying to get to work SIGN IN <!doctype...

PHP

how to prompt user that registration field is wrong or keyed in

by: happyse27 | last post by:

Hi All, In perl script(item b below) where we check if html registration form are filled in properly without blank with the necessary fields, how to prompt users that the field are incomplete...

Perl

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General