i take information from a database and then have the collected values entered into a form with hidden fields.
when i submit the form with all the other text fields filled out......then in the file to save it to a database it brings up the error....."unde fined index" although i only have 1 index set.
Code:
<input type="hidden" name="returnURL" id="returnURL" value="<?php print $returnURL;?>"/> <input type="hidden" name="tempID" id="tempID" value='<?php print $random_digit;?>'/> <input type="hidden" name="htmlcss" id="htmlcss" value='<?php print $htmlcss;?>'/> <input type="hidden" name="header" id="header" value='<?php print $header;?>'/> <input type="hidden" name="nav" id="nav" value='<?php print $nav;?>'/> <input type="hidden" name="titleWrap01" id="titleWrap01" value='<?php print $titleWrap01;?>'/> <input type="hidden" name="titleWrap02" id="titleWrap02" value='<?php print $titleWrap02;?>'/> <input type="hidden" name="subheadWrap01" id="subheadWrap01" value='<?php print $subheadWrap01;?>'/> <input type="hidden" name="subheadWrap02" id="subheadWrap02" value='<?php print $subheadWrap02;?>'/> <input type="hidden" name="flashWrap01" id="flashWrap01" value='<?php print $flashWrap01;?>'/> <input type="hidden" name="flashWrap02" id="flashWrap02" value='<?php print $flashWrap02;?>'/> <input type="hidden" name="flash01" id="flash01" value='<?php print $flashURL;?>'/> <input type="hidden" name="flashVar" id="flashVar" value='<?php print $flashVar;?>'/> <input type="hidden" name="flash02" id="flash02" value='<?php print $flash02;?>'/> <input type="hidden" name="flashWrap03" id="flashWrap03" value='<?php print $flashWrap03;?>'/> <input type="hidden" name="descriptionWrap01" id="descriptionWrap01" value='<?php print $descriptionWrap01;?>'/> <input type="hidden" name="descriptionWrap02" id="descriptionWrap02" value='<?php print $descriptionWrap02;?>'/> <input type="hidden" name="generalWrap01" id="generalWrap01" value='<?php print $generalWrap01;?>'/> <input type="hidden" name="generalWrap02" id="generalWrap02" value='<?php print $generalWrap02;?>'/> <input type="hidden" name="aboutWrap01" id="aboutWrap01" value='<?php print $aboutWrap01;?>'/> <input type="hidden" name="aboutWrap02" id="aboutWrap02" value='<?php print $aboutWrap02;?>'/> <input type="hidden" name="paymentWrap01" id="paymentWrap01" value='<?php print $paymentWrap01;?>'/> <input type="hidden" name="paymentWrap02" id="paymentWrap02" value='<?php print $paymentWrap02;?>'/> <input type="hidden" name="termsWrap01" id="termsWrap01" value='<?php print $termsWrap01;?>'/> <input type="hidden" name="termsWrap02" id="termsWrap02" value='<?php print $termsWrap02;?>'/> <input type="hidden" name="footer" id="footer" value='<?php print $footer;?>'/>
Code:
<?PHP error_reporting(E_ALL);
$username="tempsUser";
$password="auction";
$database="auctionTemps";
$returnURL = $_POST['returnURL'];
$tempID=$_POST['tempID'];
$htmlcss=$_POST['htmlcss'];
$header=$_POST['header'];
$nav=$_POST['nav'];
$titleWrap01=$_POST['titleWrap01'];
$title=$_POST['title'];
$titleWrap02=$_POST['titleWrap02'];
$subheadWrap01=$_POST['subheadWrap01'];
$subheading=$_POST['subheading'];
$subheadWrap02=$_POST['subheadWrap02'];
$flashWrap01=$_POST['flashWrap01'];
$flashWrap02=$_POST['flashWrap02'];
$flash01=$_POST['flash01'];
$flashVar=$_POST['flashVar'];
$flash02=$_POST['flash02'];
$flashWrap03=$_POST['flashWrap03'];
$descriptionWrap01=$_POST['descriptionWrap01'];
$description=$_POST['description'];
$descriptionWrap02=$_POST['descriptionWrap02'];
$generalWrap01=$_POST['generalWrap01'];
$general=$_POST['general'];
$generalWrap02=$_POST['generalWrap02'];
$aboutWrap01=$_POST['aboutWrap01'];
$about=$_POST['about'];
$aboutWrap02=$_POST['aboutWrap02'];
$paymentWrap01=$_POST['paymentWrap01'];
$payment01=$_POST['payment01'];
$payment02=$_POST['payment02'];
$paymentWrap02=$_POST['paymentWrap02'];
$termsWrap01=$_POST['termsWrap01'];
$terms=$_POST['terms'];
$termsWrap02=$_POST['termsWrap02'];
$footer=$_POST['footer'];
?>
<?
// OPEN CONNECTION --->
$connection=mysql_connect("localhost" ,"$username", "$password") or die("Unable to connect!");
mysql_select_db("$database") or die("Unable to select database!");
// Select column 1 from table name where column name = $your_var.
$sql = "SELECT tempID FROM savedTemps WHERE tempID = '{$tempID}'";
// If mysql_query returns false, we'll die with the error.
$res = mysql_query( $sql ) or die( mysql_error() );
// If a there is a match
if ( mysql_num_rows( $res ) > 0 )
{
// EXECUTE QUERY --->
$qry="UPDATE savedTemps
SET htmlcss='$htmlcss', header='$header', nav='$nav.', titleWrap01='$titleWrap01', title='$title', titleWrap02='$titleWrap02', subheadWrap01='$subheadWrap01', subheading='$subheading', subheadWrap02='$subheadWrap02', flashWrap01='$flashWrap01', flashWrap02='$flashWrap02', flash01='$flash01', flashVar='$flashVar', flash02='$flash02', flashWrap03='$flashWrap03', descriptionWrap01='$descriptionWrap01', description='$description', descriptionWrap02='$descriptionWrap02', generalWrap01='$generalWrap01', general='$general', generalWrap02='$generalWrap02', aboutWrap01='$aboutWrap01', about='$about', aboutWrap02='$aboutWrap02', paymentWrap01='$paymentWrap01', payment01='$payment01', payment02='$payment02', paymentWrap02='$paymentWrap02', termsWrap01='$termsWrap01', terms='$terms', termsWrap02='$termsWrap02', footer='$footer'";
$res=mysql_query($qry) or die("Error in query:".mysql_error());
}
else
{
// EXECUTE QUERY --->
$query="INSERT savedTemps (
tempID,
htmlcss,
header,
nav,
titleWrap01,
title,
titleWrap02,
subheadWrap01,
subheading,
subheadWrap02,
flashWrap01,
flashWrap02,
flash01,
flashVar,
flash02,
flashWrap03,
descriptionWrap01,
description,
descriptionWrap02,
generalWrap01,
general,
generalWrap02,
aboutWrap01,
about,
aboutWrap02,
paymentWrap01,
payment01,
payment02,
paymentWrap02,
termsWrap01,
terms,
termsWrap02,
footer)
VALUES(
'$tempID',
'$htmlcss',
'$header',
'$nav.',
'$titleWrap01',
'$title',
'$titleWrap02',
'$subheadWrap01',
'$subheading',
'$subheadWrap02',
'$flashWrap01',
'$flashWrap02',
'$flash01',
'$flashVar',
'$flash02',
'$flashWrap03',
'$descriptionWrap01',
'$description',
'$descriptionWrap02',
'$generalWrap01',
'$general',
'$generalWrap02',
'$aboutWrap01',
'$about',
'$aboutWrap02',
'$paymentWrap01',
'$payment01',
'$payment02',
'$paymentWrap02',
'$termsWrap01',
'$terms',
'$termsWrap02',
'$footer')";
$result=mysql_query($query) or die("Error in query:".mysql_error());
}
// CLOSE CONNECTION --->
mysql_close($connection);
//
?>
<script language="JavaScript">
<!--
window.location="<? print $returnURL?>";
//-->
</SCRIPT>
Comment