how to remain the correct value in signuppage

88 New Member

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 to signup page again, however, this time they go back, all the correct value will be remain. how should i achieve this.

my current code for singup.php 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>

in my do_signup.php, the code 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();

?>

is it i have to do a new page for user resign up when there is an error like deupication of NRIC in database?

can anyone help me with this, it is urgent, as project time is very near. thanks in advance for the help :)

Jul 13 '07 #1

Subscribe Reply

2610

pbmods

5,821

Recognized Expert Expert

Heya, Kang.

When the User posts his form values, save the data in the $_SESSION. When the User goes back to the form, echo these values.

Jul 13 '07 #2

Similar topics

2751

GUID in ASP - defined variable does not remain constant

by: BigDadyWeaver | last post by:

I am using the following code in asp to define a unique and unpredictable record ID in Access. <% 'GENERATE UNIQUE ID Function genguid() Dim Guid guid = server.createobject("scriptlet.typelib").guid guid=Left(guid,instr(guid,"}")) genguid=guid

ASP / Active Server Pages

10746

correct use of xsi:schemaLocation

by: Sarah Tegtmeier | last post by:

Hi I have a question about the correct use of the attribute xsi:schemaLocation. My programm has to process XML files where the value of this attribute causes some problems. The programm is written in C++ using Xerces C++ version 2.3.0. An older older version of the programm used Xerces C++ version 1.6.0. The XML files look like the following example:

.NET Framework

7764

printersettings papersources does not return correct values

by: Richard Golebiowski | last post by:

I have been trying to figure this out for quite some time and cannot find any examples in VB.Net or in VB that work correctly. I am working on an application where I want the user to be able to select a peinter and printer tray to print reports out. In Crystal Reports 8.5, I can select a printer and tray and it prints correctly. I did a test report that I use to tell me the value that Crystal Reports is using for the paper source. When I...

.NET Framework

1005

Input string was not in a correct format.

by: ST | last post by:

Hello, I will be posting 2 errors that I just can't seem to figure out (I'll put them in different posts). I have looked all over the internet, and I still can't figure these out! This webapp was working fine, and then all of a sudden it just "broke"! Thanks in advance for your help! Input string was not in a correct format. Description: An unhandled exception occurred during the execution of the current web request. Please review...

.NET Framework

1410

Does a static variable in a class's member fn always remain static?

by: Sam | last post by:

I'm thinking about this question. I've a class A and its member function fn. In fn there's a static variable s. If I create an object by A a; When I call the function a.fn, s would remain static throught out all the callings of a.fn, in other words it would be affected by all the callings of a.fn.

C / C++

1497

What is the correct case convention for Set?

by: **Developer** | last post by:

I looked at MSDN and a book and both described the naming convention for parameters should be camel style. The book used camel, except for Set (ByVal Value as ...) There it always used an uppercase V What is the correct convention for Set?

Visual Basic .NET

1328

how to remain original value at parent page after updated at child page

by: cheergurl | last post by:

i have two text box inside parent page (one for user name, another one for department name) and one button that will open child page. i will choose department name at child page.The value will pass into the parent page,But after the child page closed, the data for user name are dissapeared since the parent page refresh all the value at that page. Can anybody give me a solution for me to remain the data after closing the child page??? TQ :)

Visual Basic 4 / 5 / 6

3254

how to remain correct user info in signup page

by: kang jia | last post by:

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: ...

PHP

2209

Show how many answers are correct on clicking a button

by: onetruelove | last post by:

I want to creat a post like this blog: http://onlinetoefltest.blogspot.com/2007/08/level-c-lesson-1.html When you chose all the answers and click show answer a msg box will appear and tells how many answers are correct I view the blog source and copied all the code to my post but it didn't work when i click the show answer button in my post. Can any one help me with the code? Thanks in advance

Javascript

9617

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9454

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10099

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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8931

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7456

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

6710

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5482

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4007

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

3609

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP