adding information

ceanth

hi all, i have the following table:

create table customer
(
cust_no INT NOT NULL auto_increment,
cust_fname VarChar (25),
cust_sname VarChar (25),
cust_tel INT (15),
cust_cc INT (16),
cust_address VarChar (30),
cust_postcode VarChar (10),
Primary Key (cust_no)
)

and i have the following add script:

include("db.php");

$sql = mysql_query("INSERT INTO customer (cust_fname)
VALUES('$fname);
?>

what am i doing wrong? i am basically calling the $fname from a previous page, so i have page1-search, page2-cart, page3-enterdetail, page4-confirmdetail, page5-add (which is the problem page).

Can the $fname be called when it was used in page4?

many thanks

ceanth

leatherback

Little typo: In values($fname) you only have a single open quote.

Check if the value is passed to your page by including a line:
echo $fname ;

ceanth

interesting $fname doesnt get passed onto this screen:

include("db.php");

echo $fname;

should $fname be able to pass onto 2 php scripts?

leatherback

Hi,

you'd have to give us a bit more info on how you pass the variable between pages, since it seems that that is your problem.

How do you pass info between pages?

ceanth

ok my url is:

http://meglos.lgu.ac.uk/~cghe11/testv1/enterdetail.php

ok u enter some details and click "click"

now the next page shows all the $fname etc etc etc. this works via:

<?php echo "$fname"; ?><br>
<?php echo "$sname"; ?><br>
<?php echo "$address"; ?><br>
<?php echo "$postcode"; ?><br>
<?php echo "$telephone"; ?><br>
<?php echo "$email"; ?><br>

now i want to allow people to enter details, confirm then 3rd page add, the values pass onto the second page but not 3rd.

i hope this has explained ok, if not then i can create a page with the full php script

ceanth

i have just copied the display page of the $fname etc etc to the next page and it doesnt pass on the values

leatherback

Ah,

Got it.

you post your data with a submit to page 2.
But then in page 2, you don't use them (Except for showing the input data).

What you'd need to do is add hidden fields to your form for each variable passed from page 1, where you put all the data which has been entered:

<input type="hidden" name="fname" value "$fname">
etc.

THen you should be able to use the vars in page 3 too.

Hope this helps,

ceanth

that makes sence but getting one problem:

<h4>Confirm Details</h4>
<h3>Please check that the following details are correct</h3>

<?php echo "$fname"; ?><br>
<?php echo "$sname"; ?><br>
<?php echo "$address"; ?><br>
<?php echo "$postcode"; ?><br>
<?php echo "$telephone"; ?><br>
<?php echo "$email"; ?><br>

<h3>Please enter your card number</h3>
<form method="post" action="addinfo.php">

Enter Your FirstName
<input type="text" name="ccard"></input><br>
<input type="hidden" name="fname" value="$fname"</input><br>

</form>

</body></html>

having the value of $fame just displayes $fname

leatherback

Did you try:

ceanth

same, umm shouldnt $fname be around <? ?>

how exactly do i add that in the code?

leatherback

OK, I suppose I will go back to bed, and get a few more hours of sleep!

SORRY!

Yes. Of course. <? .. ?> shouold do the trick (Since it is a PhP var..)

What I would do: in the PhP section of your page (First section?), is something like:

$PassedData = "

<input type=\"hidden\" name=\"fname\" value=$fname </input>
//for all variables
";

And in the HTML section / form:

<? echo $PassedData ?>

zudo

Parse error: parse error in /homes/cghe11/public_html/testv1/confirm_details.php on line 21

that is the error you get...
try this script

<html>
<head>
<title>Enter Customer Details</title>
<meta name="author" content="Chetan Ghedia">
<meta name="Version" content="1.1">
</head>
<body>
<center>
<h4>Checkout</h4>
<h3>Please fill out your details</h3>
<form method="post" action="confirm_details.php">

Enter Your FirstName
<input type="text" name="fname"><br>
Enter Your Surname
<input type="text" name="sname"><br>
Enter Your Address
<input type="text" name="address"><br>
Enter Your Postcode
<input type="text" name="postcode"><br>
Enter Your Telephone Number
<input type="text" name="telephone"><br>
Enter Your Email
<input type="text" name="email"><br>

</form>
</center>
</body></html>

ceanth

errm thats enter details (which works) the next page doesnt:

<?
$PassedData = "

<input type=\"hidden\" name=\"fname\" value=$fname </input>
//for all variables

<?php echo "$PassedData"; ?><br>
<?php echo "$sname"; ?><br>
<?php echo "$address"; ?><br>
<?php echo "$postcode"; ?><br>
<?php echo "$telephone"; ?><br>
<?php echo "$email"; ?><br>

<h3>Please enter your card number</h3>
<form method="post" action="addinfo.php">

Enter Your FirstName
<input type="text" name="ccard"></input><br>
<input type="hidden" name="fname" value=$fname</input><br>

</form>

</body></html>

ceanth

ok this doesnt give an error but doesnt contain the value for fname (i.e. $PassedData doesnt hold the value):

<?
$PassedData = "

<?php echo "$PassedData"; ?><br>
<?php echo "$sname"; ?><br>
<?php echo "$address"; ?><br>
<?php echo "$postcode"; ?><br>
<?php echo "$telephone"; ?><br>
<?php echo "$email"; ?><br>

<h3>Please enter your card number</h3>
<form method="post" action="addinfo.php">

Enter Your FirstName
<input type="text" name="ccard"></input><br>

</form>

</body></html>

leatherback

Here goes. This works for me:

<?php echo "<input type=\"hidden\" name=\"fname\" value= $fname"; ?>
<?php echo "<input type=\"hidden\" name=\"name\" value= $name"; ?>
<?php echo "<input type=\"hidden\" name=\"address\" value= $address"; ?>
<?php echo "<input type=\"hidden\" name=\"postcode\" value= $postcode"; ?>
<?php echo "<input type=\"hidden\" name=\"telephone\" value= $telephone"; ?>
<?php echo "<input type=\"hidden\" name=\"email\" value= $email"; ?>

Name: <?php echo "$sname"; ?><br>
address: <?php echo "$address"; ?><br>
postcode: <?php echo "$postcode"; ?><br>
tel: <?php echo "$telephone"; ?><br>
email: <?php echo "$email"; ?><br>

<h3>Please enter your card number</h3>
<form method="post" action="addinfo.php">

Enter Your FirstName
<input type="text" name="ccard"></input><br>
<input type="hidden" name="fname" value=$fname</input><br>

</form>

</body></html>

ceanth

leatherback it worked, but i dont seem to see "name" in the next page

ceanth

guess what guys, the page after this one doesnt work

name: <?php echo "$fname"; ?><br>
surname: <?php echo "$sname"; ?><br>
address: <?php echo "$address"; ?><br>
postcode: <?php echo "$postcode"; ?><br>
tel: <?php echo "$telephone"; ?><br>
email: <?php echo "$email"; ?><br>

when you click "click" i added this script but the variables dont get passed on (which is were i had the problem), shouldnt they have gotten passed?

leatherback

Two options:

There is a space between the "=" and the value in the hidden fields

The <form> statement is under the hidden fields.

I am not sure which is giving you a headach. Change both, and try again!?

ceanth

tryed both, tryed hidden b4, after and inside <form>, anyone have any other ideas?

leatherback

OK, here goes:

enterdetails.php:

Enter Your FirstName
<input type="text" name="fname"></input><br>
Enter Your Surname
<input type="text" name="sname"></input><br>
Enter Your Address
<input type="text" name="address"></input><br>
Enter Your Postcode
<input type="text" name="postcode"></input><br>
Enter Your Telephone Number
<input type="text" name="telephone"></input><br>
Enter Your Email
<input type="text" name="email"></input><br>

</form>

</body></html>

Confirm_details.php:

<html>
<head>
<title>Enter Customer Details</title>
<meta name="author" content="Chetan Ghedia">
<meta name="Version" content="1.1">
</head>
<body>
<center>
<h4>Confirm Details</h4>
<h3>Please check that the following details are correct</h3>
<form method="post" action="inputtest.php">
<?php echo "<input type=\"hidden\" name=\"fname\" value='$fname' >"; ?>
<?php echo "<input type=\"hidden\" name=\"sname\" value='$sname' >"; ?>
<?php echo "<input type=\"hidden\" name=\"address\" value='$address'> "; ?>
<?php echo "<input type=\"hidden\" name=\"postcode\" value='$postcode' >"; ?>
<?php echo "<input type=\"hidden\" name=\"telephone\" value='$telephone' >"; ?>
<?php echo "<input type=\"hidden\" name=\"email\" value='$email'> "; ?>

Name: <?php echo "$sname"; ?><br>
address: <?php echo "$address"; ?><br>
postcode: <?php echo "$postcode"; ?><br>
tel: <?php echo "$telephone"; ?><br>
email: <?php echo "$email"; ?><br>

<h3>Please enter your card number</h3>

Enter Your FirstName
<input type="text" name="ccard"></input><br>
<input type="submit" name="submit" value="click"></input>

</form>

</body></html>

inputtest.php:

echo $fname;

echo $sname;

echo $address;

echo $postcode;

echo $telephone;
echo $email;

?>
<html>

</html>

This should work. (It does here..)