Please Help me with this

bharadwaj91

I have typed this code so as to post the value of the text box to the database.
it always posts the blank value .i.e. the or value of the ternary statement..

$SNAME = isset($POST['fldSwimmerName']) ? $POST['fldSwimmerName'] : "";;

i would be happy to know how to deal with this

bharadwaj91

When the query executed is echoed :

it comes like this

INSERT INTO tblSwimmer (fldSwimmerName,fldAge,fldDateOfBirth,fldPresentAddressLine1,fldPresentAddressLine2,fldPresentAddressLine3,fldPermanentAddressLine1,fldPermanentAddressLine2,fldPermanentAddressLine3,fldInstitutionAddressLine1,fldInstitutionAddressLine2,fldInstitutionAddressLine3,fldNationality,fldFatherName,fldMotherName,fldSpouseName,fldResidenceNumber,fldMobileNumber,fldHeightCMS,fldWeightKGS,fldEmergencyContactName,fldEmergencyContactRelationship,fldEmergencyContactAddressLine1,fldEmergencyContactAddressLine2,fldEmergencyContactAddressLine3,fldDoctorAddressLine1,fldDoctorAddressLine2,fldDoctorAddressLine3,fldMedicalFitness1,fldMedicalFitness2,fldMedicalFitness3,fldCompetitions)VALUES ('', '','','','','','','','','','','','','','','','','','','','','','','','','','','','','','','')

traq

who knows? we'd have to see your code. my first thought is that the form field name could be misspelled.

bharadwaj91

<?php
$SNAME = isset($_POST['fldSwimmerName']) ? $_POST['fldSwimmerName'] : "";;
$AGE = isset($_POST['fldAge']) ? $_POST['fldAge'] : "";;
$DOB = isset($_POST['fldDateOfBirth']) ? $_POST['fldDateOfBirth'] : "";;
$PRES1 =isset($_POST['fldPresentAddressLine1']) ? $_POST['fldPresentAddressLine1'] : "";;
$PRES2 = isset($_POST['fldPresentAddressLine2']) ? $_POST['fldPresentAddressLine2'] : "";;
$PRES3 = isset($_POST['fldPresentAddressLine3']) ? $_POST['fldPresentAddressLine3'] : "";;
$PERM1 =  isset($_POST['fldPermanantAddressLine1']) ? $_POST['fldPermanantAddressLine1'] : "";;
$PERM2 =  isset($_POST['fldPermanantAddressLine2']) ? $_POST['fldPermanantAddressLine2'] : "";;
$PERM3 = isset($_POST['fldPermanantAddressLine3']) ? $_POST['fldPermanantAddressLine3'] : "";;
$INS1 = isset($_POST['fldInstitutionAddressLine1']) ? $_POST['fldInstitutionAddressLine1'] : "";;
$INS2 =  isset($_POST['fldInstitutionAddressLine2']) ? $_POST['fldInstitutionAddressLine2'] : "";;
$INS3 =  isset($_POST['fldInstitutionAddressLine3']) ? $_POST['fldInstitutionAddressLine3'] : "";;
$NAT =  isset($_POST['fldNationality']) ? $_POST['fldNationality'] : "";;
$FATH =  isset($_POST['fldFatherName']) ? $_POST['fldFatherName'] : "";;
$MOTH = isset($_POST['fldMotherName']) ? $_POST['fldMotherName'] : "";;
$SPO = isset($_POST['fldSpouseName']) ? $_POST['fldSpouseName'] : "";;
$RES = isset($_POST['fldResidenceNumber']) ? $_POST['fldResidenceNumber'] : "";;
$MOB =  isset($_POST['fldMobileNumber']) ? $_POST['fldMobileNumber'] : "";;
$HGT =  isset($_POST['fldHeightCMS']) ? $_POST['fldHeight'] : "";;
$WGT = isset($_POST['fldWeightKGS']) ? $_POST['fldWeight'] : "";;
$EMCN =  isset($_POST['fldEmergencyContactName']) ? $_POST['fldEmergencyContactName'] : "";;
$EMCR =  isset($_POST['fldEmergencyContactRelationship']) ? $_POST['fldemergencyContactRelationship'] : "";;
$EMC1 = isset($_POST['fldEmergencyContactAddressLine1']) ? $_POST['fldEmergencyContactAddressLine1'] : "";;
$EMC2 = isset($_POST['fldEmergencyContactAddressLine2']) ? $_POST['fldEmergencyContactAddressLine2'] : "";;
$EMC3 =  isset($_POST['fldEmergencyContactAddressLine3']) ? $_POST['fldEmergencyContactAddressLine3'] : "";;
$DOC1 = isset($_POST['fldDoctorAddressLine1']) ? $_POST['fldDoctorAddressLine1'] : "";;
$DOC2 = isset($_POST['fldDoctorAddressLine2']) ? $_POST['fldDoctorAddressLine2'] : "";;
$DOC3 = isset($_POST['fldDoctorAddressLine3']) ? $_POST['fldDoctorAddressLine3'] : "";;
$MED1 = isset($_POST['fldMedicalFitness1']) ? $_POST['fldMedicalFitness1'] : "";;
$MED2 =  isset($_POST['fldMedicalFitness2']) ? $_POST['fldMedicalFitness2'] : "";;
$MED3 =  isset($_POST['fldMedicalFitness3']) ? $_POST['fldMedicalFitness3'] : "";;
$COMP =  isset($_POST['fldCompetitions']) ? $_POST['fldCompetitions'] : "";;


mysql_connect("localhost", "root", "") or die('Error:' .mysql_error());
mysql_select_db("serp");

$query="INSERT INTO tblSwimmer (fldSwimmerName,fldAge,fldDateOfBirth,fldPresentAddressLine1,fldPresentAddressLine2,fldPresentAddressLine3,fldPermanentAddressLine1,fldPermanentAddressLine2,fldPermanentAddressLine3,fldInstitutionAddressLine1,fldInstitutionAddressLine2,fldInstitutionAddressLine3,fldNationality,fldFatherName,fldMotherName,fldSpouseName,fldResidenceNumber,fldMobileNumber,fldHeightCMS,fldWeightKGS,fldEmergencyContactName,fldEmergencyContactRelationship,fldEmergencyContactAddressLine1,fldEmergencyContactAddressLine2,fldEmergencyContactAddressLine3,fldDoctorAddressLine1,fldDoctorAddressLine2,fldDoctorAddressLine3,fldMedicalFitness1,fldMedicalFitness2,fldMedicalFitness3,fldCompetitions)VALUES ('".$SNAME."', '".$AGE."','".$DOB."','".$PRES1."','".$PRES2."','".$PRES3."','".$PERM1."','".$PERM2."','".$PERM3."','".$INS1."','".$INS2."','".$INS3."','".$NAT."','".$FATH."','".$MOTH."','".$SPO."','".$RES."','".$MOB."','".$HGT."','".$WGT."','".$EMCN."','".$EMCR."','".$EMC1."','".$EMC2."','".$EMC3."','".$DOC1."','".$DOC2."','".$DOC3."','".$MED1."','".$MED2."','".$MED3."','".$COMP."')";
mysql_query($query) or die('Error:' .mysql_error());



echo "Database updated succesfully...";

?>

NogDog

Please make use of this forum's [noparse]

...

[/noparse] bbcode tags, as it makes it much easier to read your code. (I have inserted them into both your posts in this thread.) I'd also suggest that for your own sanity (as well as ours) that you make use of your return/enter key when defining long queries. Not only does it make them easier to read, but if you get an error in your query and have adequate debugging messages in use, they will tell you which line of the query had the error. (Right now they would always be on line #1. 😉 )

As far as your problem, try doing a print_r() or var_dump() of $_POST to see what array keys actually are coming through to your script.

bharadwaj91

The array returns as

set empty

What should i do i will pot my frontend code too

<table class="application"cellpadding="4" cellspacing="4" width="100%" style="border-style:0; border-color: #000000" align="center"font size="3" face="verdana" color="black">
	<tr>
		<td width="1%">

			<table cellpadding="3" cellspacing="0" width="10%">
				<tr>
					<td width="49%">Applicant's Name</td>
					<td width="2%">:</td>
					<td width="49%" align="right"><input type="text" name="fldSwimmerName"></td>
				</tr>

traq

Remove [font=monospace]onclick="window.location = 'SERP_SwimmerRegistration_Backend.php' [/font].

You're sending the user to the form processing page without submitting the form.

bradgrafelman

You'll probably also want to use a 'submit' <input> type (rather than a generic 'button' type).

bharadwaj91

It so worked.....

My next issue is to create the validating...please post if you have sample validation forms

Thank you very much

bharadwaj91

Where to insert my validation queries...please help me with validation....

bharadwaj91

I have a screen like this

[ATTACH]4476[/ATTACH]

if i press the radio button it must post that value of application id (inpic:9) to the previous page application id text box as below

[ATTACH]4477[/ATTACH]

what should i do