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

3008

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

Access Europe meeting on Wed 2 August - An Access Developer Guide to creating applications in Blazor

by: isladogs | last post by:

The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...

Microsoft Access / VBA

How to Use CodiumAI's pr-agent?

by: erikbower65 | last post by:

Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...

General

Speedup your spring application

by: linyimin | last post by:

Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...

General

Steps manually installing IntelliJ IDEA.

by: erikbower65 | last post by:

Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...

General

How to insert a new record in a database

by: Taofi | last post by:

I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...

DB2 Database

Cancel Print Action if Sub form has No Records

by: DJRhino1175 | last post by:

When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...

Microsoft Access / VBA

Python code for finding the longest common subsequence

by: Rina0 | last post by:

I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...

Python

To verify entry of a dropdown

by: DJRhino | last post by:

Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...

Microsoft Access / VBA

React to native button blinking effect

by: lllomh | last post by:

Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{

Software Development