how to remain correct user info in signup page

88 New Member

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 Reply

3250

pbmods

5,821

Recognized Expert Expert

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

1315

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 invited to join us. Our initial meeting will be hosted by Elsevier, in the Curtis Center on Independence Mall in Philadelphia. A map and directions can be found at our website: http://www.xmlphilly.org/calendar.htm "The Value of an XML User Group"

.NET Framework

1402

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 creatable instances? Please forgive my use of terms. Quasi-signleton is a term I made up and static instances is a little bogus too but I don't know the correct terms for what I mean if there are any. However, I think the code below should be...

C# / C Sharp

2320

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. On my "signup" page I ask for all their info at one time, including username, password, firstname, lastname, etc.... After I do a Membership.CreateUser and Roles.AddUserToRole I want to store the profile information. But, the code still thinks...

ASP.NET

1665

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 database-table named "COORDINATOR" where all 5 usernames, password (md5 protected) and short description of the departments are located. When a volunteer is getting booked by a certain festivaldepartment, the earlier mentioned description of the...

PHP

5549

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 issues are all handled by them. I contacted hosted email/autoresponder company GetResponse ($17/month) and generated their HTML Form to capture the first_name and email_address to add to my website. I installed the HTML, but the info was not...

ASP / Active Server Pages

2608

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 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 <html> <head> <link rel="stylesheet" type="text/css" href="gallery.css" />

PHP

1828

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 if it is. The problem is that I submit a set of values, and it works as expected. Then I submit the same set of values, and it enters them into the database anyways. this is my code: <?php session_name("SIGNUP"); session_start();...

PHP

2835

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 html public "-//w3c//dtd html 3.2//en">

PHP

4243

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 or blank and then go back to main page(item a below user registration html page) always, something like goggle or msn login page function... Thanks and Best Rgds, Andrew a) script called from user registration html...

Perl

9568

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

10156

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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10007

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

9832

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6649

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

5275

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5419

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

3924

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

3531

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