how to fetch the values from page1 to page2 to page3

anto · December 18, 2009

Dear All,

I am newbie to php.I am creating some account registration pages for our website using php , mysql.

for that iam using 3 pages in page1 i added all the fields for signup like(emailid,password,firstname,lastname,address1,address2,city,state,country.....).

In page 2 i have written the php code to save sll the filled fields in page1 to mysql database table.In page 3 i want to dispaly the billing address from page1 and page 2(address1,address2,city,state,country) with some other fields to finish the registration.

for that i am using the below code

<?php

session_start();

require_once("dbconnection.php");

echo $email_id=$_SESSION['usr_email'];

//if(isset($_COOKIE['id']))

//$email_id=$_COOKIE['usr_email'];

$an=mysql_fetch_array(mysql_query("select address1,address2,city,state,country,zip_code from personal_signup where email_id='$email_id' "));

?>

below i have attatched the page2 and page3.

please give me a solution it's very urgent for me,

thanks and regards,

swathi.

/****************PAGE2************/

<?php

session_start();

require_once("dbconnection.php");

include("personal_signup1.php");

$fname=$_POST['fname'];

$lname=$_POST['lname'];

$usr_email=$_POST['usr_email'];

$gender=$_POST['gender'];

$usrpword=$_POST['usrpword'];

$usrpword1=$_POST['usrpword1'];

$addr_line01=$_POST['addr_line01'];

$addr_line02=$_POST['addr_line02'];

$city=$_POST['city'];

$state=$_POST['state'];

$country=$_POST['country'];

$zip=$_POST['zip'];

$mobile_number=$_POST['mobile_number'];

//$usr_phone=$_POST['usr_phone'];

$dt=$_POST['dt'];

$month=$_POST['month'];

$year=$_POST['year'];

$date=$year."-".$month."-".$dt;

$type=$_POST['type'];

$count=mysql_num_rows(mysql_query("select email_id from personal_signup where email_id='$usr_email'"));

if($count!=0)

{

header("Location: ./personal_signup.php?id=1");

exit;

}

// 2 is for sending confirmation message for pre signup Admin

mysql_query("insert into personal_signup(email_id,password,fname,lname,address1,address2,city,state,country,zip_code,phone_number,dob) values('$usr_email','$usrpword','$fname','$lname','$addr_line01','$addr_line02','$city','$state','$country','$zip','$mobile_number','$date')");

$oldid=0;

$q=mysql_fetch_array(mysql_query("select max(user_id) from user_table "));

$u_id= $q[0];

$u_id++;

mysql_query("insert into user_table (user_id,email) values('$id','$usr_email')");

mysql_close($link);

$_SESSION['email_id']="";

//$_SESSION ['email_id'] = $email_id;

header("Location: ./personal_signup1.php");

?>

/***********************PAGE3*****************/

<?php

session_start();

require_once("dbconnection.php");

echo $email_id=$_SESSION['usr_email'];

//if(isset($_COOKIE['id']))

//$email_id=$_COOKIE['usr_email'];

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-Transitional.dtd">

<head>

<title>Company title</title>

</head>

<body>

<tr>

<td><h1 id="logo"><a href="#" title="Company Title - return to the homepage">Company Logotip</a></h1></td>

<td><h1 id="menu"><a href="#">contact</a> | <a href="#">search</a> | <a href="#">sitemap</a></h1></td>

</tr>

</table>

</div>

<?php include("toplinks.php");?>

</div></div>

<br />

<h2 align="left" style="margin-left:30px;">To make the most of your EvolPay account, enter your credit card <br />information</h2>

<tr>

</tr>

<tr>

<td width="107" height="35" align="right">Creditcard Number: </td>

</tr>

<tr>

<td align="right">Expiration Date:</td>

</select>

<option value="03">March</option>

<option value="04">April</option>

<option value="08">august</option>

</select>

<?php for($yy=1990;$yy<=2020;$yy++){?>

<?php }?>

</select>

*</td>

</tr>

<tr>

</tr>

<tr>

</tr>

<tr>

<td align="right" class="menubackgr" id="billing-address_label" >Billing Address :

<?php

$an=mysql_fetch_array(mysql_query("select address1,address2,city,state,country,zip_code from personal_signup where email_id='$email_id' "));

?>

</p>

<!--<td><div id="billing-address-display">

</div><a href="" style="padding-left:60px"><font color="#C88039">Change</font></a></td>

</p>-->

<tr>

<br />

</tr>

<tr>

</tr>

</table>

</form>

<p align="left"><a href="">Goto my account</a></p>

</div>

<h3 align="center"><font size="3">Pay with my</font><br />credit card</h3>

<p align="left">Pay right away - get set up in seconds.</p>

<p align="left">Pay without exposing your card number to merchants.</p>

<p align="left">No need to retype your credit card information.</p>

</ul>

</div></div>

</div>

<tr>

</tr>

</table>

</div>

</body>

</HTML>

cags · December 18, 2009

If it's so urgent and you expect us to do it for you, perhaps you should have at least taken the time to respect the forums rules. Firstly you posted it in the wrong board, I really don't think it's that complicated to get things in the right place. Granted some topics are difficult to place, but since you placed it in the Regex sub-board. Your problem certainly doesn't seem to be related to Regex, in fact as far as I can tell you don't even have any Regex in your code. The amusing thing is the fact you've essentially shot yourself in the foot right from the off because the Regex forum is probably far less frequented than the PHP main board. I'll move the topic for you when I've posted this message.

Secondly you posted large amounts of code without using code tags, this makes it a pain to read and will likely mean most people will completely skip over it. To use the tags you either click the button marked with a # above the box you type in or you place tags around your code. When posting code from multiple places I'd highly recommend posting in separate code tags.

Deoctor · December 18, 2009

dear cags

i think this guy had been asked by some one else to do it out(probably a girl!!! ) so he just copied the same and have pasted it here..

any way it is right wht ever u have told himm...

@anto

use the code tags and replace the code...

Deoctor · December 18, 2009

i just went through ur code and wt ever u have written up.

wht for solution should we give..is ur code not working or how is it happening??

can u explain in more detail

emopoops · December 18, 2009

u need to make sure the query is on the same page as the posted vars hon

anto · December 19, 2009

dear All,

I am really sorry for my last post,i was just in hurry so i didn't follow the rules.

Can you please hide my forum..

Regards,

Anto

Sign In

how to fetch the values from page1 to page2 to page3

Recommended Posts

anto

Link to comment

Share on other sites

cags

Link to comment

Share on other sites

Deoctor

Link to comment

Share on other sites

Deoctor

Link to comment

Share on other sites

emopoops

Link to comment

Share on other sites

anto

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information