Yes Roger we spoke about this:
http://phpbuilder.com/board/showthread.php?t=10312697
but the quote_smart approach was not working out. I read up on the link but couldn't figure out how to make use of thr best practice.
I reposted as I had different error messages but now ive come back to the same problem.
I have just tried your suggestion in the other thread again with the following which comes out with an undefined variable error:
Notice: Undefined variable: besttimecontact in /disk1/home3/mindseye/public_html/nottsvcs_short_1_4_formhandler.php on line 257
here is my code:
<?php
session_start();
foreach($_POST as $key => $val)
{
$_SESSION[$key] = $val;
}
//open the db connection
include("connect.php");
if (isset($_POST['Submit']))
$sql = "INSERT INTO nottsvcs (contact, nameorg, telephone, besttimecontact
,address1
,address2
,town
,county
,postcode
,fax
,email
,website
,govoffreg
,premises
,commitee
,fundingsources
,bmeorg
,ethnictyusers
,orgtype
,activities
,beneficiaries
,contactrole
,legalstatus
,levelorg
,areaop
,incomeft30plus
,pt16hrs
,pt1630hrs
,sessional
,trainers
,unclassified
,volunteer
,common_whatexpec
,reliable
,cheap
,personalservice
,slow
,qualifiedstaff_people
,widechoice
,consistent
,approachable
,fitforpurpose
,welleducated
,friendly
,prompt
,attentive
,speedy
,meetsneeds
,takeson
,providesxtras
,handson
,responsive
,ltdselection
,competent
,affordable
,accessible
,knowledgeable
,checkssatisfaction
,getsdetails
,understands
,important1
,important2
,important3
,important4
,important5
,nameofsystems
,not_adopting_sys_1
,not_adopting_sys_2
,not_adopting_sys_3
,not_adopting_sys_4
,not_adopting_sys_5
,not_adopting_sys_6
,not_adopting_sys_7
,not_adopting_sys_8
,list_quality_sys_1
,list_quality_sys_2
,list_quality_sys_3
,list_quality_sys_4
,list_quality_sys_5
,list_quality_sys_6
,list_quality_sys_7
,list_quality_sys_8
,list_quality_sys_9
,list_quality_sys_10
,list_quality_sys_11
,list_quality_sys_12
,list_quality_sys_13
,list_quality_sys_14
,list_quality_sys_15
,list_quality_sys_16
,list_quality_sys_17
,list_quality_sys_18
,list_quality_sys_19
,list_quality_sys_20
,list_quality_sys_21
,list_quality_sys_22
,list_quality_sys_23
,list_quality_sys_24
,list_quality_sys_25
,list_quality_sys_26
,list_quality_sys_27
,list_quality_sys_28
,list_quality_sys_29
,list_quality_sys_30
,list_quality_sys_31
,list_quality_sys_32
,list_quality_sys_33
,list_quality_sys_34
,list_quality_sys_35
,list_quality_sys_36
,list_quality_sys_37
,list_quality_sys_38
,list_quality_sys_39
,list_quality_sys_40
,list_quality_sys_41
,list_quality_sys_42
,list_quality_sys_43
,list_quality_sys_44
,list_quality_sys_45
,list_quality_sys_46
,list_quality_sys_47
,list_quality_sys_48
,list_quality_sys_49
,list_quality_sys_50
,list_quality_sys_51
,list_quality_sys_52
,list_quality_sys_53
,list_quality_sys_54
,list_quality_sys_55
,list_quality_sys_56
,list_quality_sys_57
,list_quality_sys_58
,how_you_feel_1
,how_you_feel_2
,how_you_feel_3
,how_you_feel_4
,how_you_feel_5
,how_you_feel_6
,how_you_feel_7
,how_you_feel_8
,how_you_feel_9
,clear_view_plan
,features_quality_rate_1
,features_quality_rate_2
,features_quality_rate_3
,features_quality_rate_4
,features_quality_rate_5
,features_quality_rate_6
,features_quality_rate_7
,features_quality_rate_8
,features_quality_rate_9
,features_quality_rate_10
,features_quality_rate_11
,features_quality_rate_12
,features_quality_rate_others)
VALUES ($_SESSION'['$contact']'
,$_SESSION'['$nameorg']'
,$_SESSION'['$telephone']'
,$_SESSION'['$besttimecontact']'
,$_SESSION'['$address1']'
,$_SESSION'['$address2']'
,$_SESSION'['$town']'
,$_SESSION'['$county']'
,$_SESSION'['$postcode']'
,$_SESSION'['$fax']'
,$_SESSION'['$email']'
,$_SESSION'['$website']'
,$_SESSION'['$govoffreg']'
,$_SESSION'['$premises']'
,$_SESSION'['$commitee']'
,$_SESSION'['$fundingsources']'
,$_SESSION'['$bmeorg']'
,$_SESSION'['$ethnictyusers']'
,$_SESSION'['$orgtype']'
,$_SESSION'['$activities']'
,$_SESSION'['$beneficiaries']'
,$_SESSION'['$contactrole']'
,$_SESSION'['$legalstatus']'
,$_SESSION'['$levelorg']'
,$_SESSION'['$areaop']'
,$_SESSION'['$income']'
,$_SESSION'['$ft30plus']'
,$_SESSION'['$pt16hrs']'
,$_SESSION'['$pt1630hrs']'
,$_SESSION'['$sessional']'
,$_SESSION'['$trainers']'
,$_SESSION'['$unclassified']'
,$_SESSION'['$volunteer']'
,$_SESSION'['$common_whatexpect']'
,$_SESSION'['$reliable']'
,$_SESSION'['$cheap']'
,$_SESSION'['$personalservice']'
,$_SESSION'['$slow']'
,$_SESSION'['$qualifiedstaff_people']'
,$_SESSION'['$widechoice']'
,$_SESSION'['$consistent']'
,$_SESSION'['$approachable']'
,$_SESSION'['$fitforpurpose']'
,$_SESSION'['$welleducated']'
,$_SESSION'['$friendly']'
,$_SESSION'['$prompt']'
,$_SESSION'['$attentive']'
,$_SESSION'['$speedy']'
,$_SESSION'['$meetsneeds']'
,$_SESSION'['$takeson']'
,$_SESSION'['$providesxtras']'
,$_SESSION'['$handson']'
,$_SESSION'['$responsive']'
,$_SESSION'['$ltdselection']'
,$_SESSION'['$competent']'
,$_SESSION'['$affordable']'
,$_SESSION'['$accessible']'
,$_SESSION'['$knowledgeable']'
,$_SESSION'['$checkssatisfaction']'
,$_SESSION'['$getsdetails']'
,$_SESSION'['$understands']'
,$_SESSION'['$important1']'
,$_SESSION'['$important2']'
,$_SESSION'['$important3']'
,$_SESSION'['$important4']'
,$_SESSION'['$important5']'
,$_SESSION'['$nameofsystems']'
,$_SESSION'['$not_adopting_sys_1']'
,$_SESSION'['$not_adopting_sys_2']'
,$_SESSION'['$not_adopting_sys_3']'
,$_SESSION'['$not_adopting_sys_4']'
,$_SESSION'['$not_adopting_sys_5']'
,$_SESSION'['$not_adopting_sys_6']'
,$_SESSION'['$not_adopting_sys_7']'
,$_SESSION'['$not_adopting_sys_8']'
,$_SESSION'['$list_quality_sys_1']'
,$_SESSION'['$list_quality_sys_2']'
,$_SESSION'['$list_quality_sys_3']'
,$_SESSION'['$list_quality_sys_4']'
,$_SESSION'['$list_quality_sys_5']'
,$_SESSION'['$list_quality_sys_6']'
,$_SESSION'['$list_quality_sys_7']'
,$_SESSION'['$list_quality_sys_8']'
,$_SESSION'['$list_quality_sys_9']'
,$_SESSION'['$list_quality_sys_10']'
,$_SESSION'['$list_quality_sys_11']'
,$_SESSION'['$list_quality_sys_12']'
,$_SESSION'['$list_quality_sys_13']'
,$_SESSION'['$list_quality_sys_14']'
,$_SESSION'['$list_quality_sys_15']'
,$_SESSION'['$list_quality_sys_16']'
,$_SESSION'['$list_quality_sys_17']'
,$_SESSION'['$list_quality_sys_18']'
,$_SESSION'['$list_quality_sys_19']'
,$_SESSION'['$list_quality_sys_20']'
,$_SESSION'['$list_quality_sys_21']'
,$_SESSION'['$list_quality_sys_22']'
,$_SESSION'['$list_quality_sys_23']'
,$_SESSION'['$list_quality_sys_24']'
,$_SESSION'['$list_quality_sys_25']'
,$_SESSION'['$list_quality_sys_26']'
,$_SESSION'['$list_quality_sys_27']'
,$_SESSION'['$list_quality_sys_28']'
,$_SESSION'['$list_quality_sys_29']'
,$_SESSION'['$list_quality_sys_30']'
,$_SESSION'['$list_quality_sys_31']'
,$_SESSION'['$list_quality_sys_32']'
,$_SESSION'['$list_quality_sys_33']'
,$_SESSION'['$list_quality_sys_34']'
,$_SESSION'['$list_quality_sys_35']'
,$_SESSION'['$list_quality_sys_36']'
,$_SESSION'['$list_quality_sys_37']'
,$_SESSION'['$list_quality_sys_38']'
,$_SESSION'['$list_quality_sys_39']'
,$_SESSION'['$list_quality_sys_40']'
,$_SESSION'['$list_quality_sys_41']'
,$_SESSION'['$list_quality_sys_42']'
,$_SESSION'['$list_quality_sys_43']'
,$_SESSION'['$list_quality_sys_44']'
,$_SESSION'['$list_quality_sys_45']'
,$_SESSION'['$list_quality_sys_46']'
,$_SESSION'['$list_quality_sys_47']'
,$_SESSION'['$list_quality_sys_48']'
,$_SESSION'['$list_quality_sys_49']'
,$_SESSION'['$list_quality_sys_50']'
,$_SESSION'['$list_quality_sys_51']'
,$_SESSION'['$list_quality_sys_52']'
,$_SESSION'['$list_quality_sys_53']'
,$_SESSION'['$list_quality_sys_54']'
,$_SESSION'['$list_quality_sys_55']'
,$_SESSION'['$list_quality_sys_56']'
,$_SESSION'['$list_quality_sys_57']'
,$_SESSION'['$list_quality_sys_58']'
,$_SESSION'['$how_you_feel_1']'
,$_SESSION'['$how_you_feel_2']'
,$_SESSION'['$how_you_feel_3']'
,$_SESSION'['$how_you_feel_4']'
,$_SESSION'['$how_you_feel_5']'
,$_SESSION'['$how_you_feel_6']'
,$_SESSION'['$how_you_feel_7']'
,$_SESSION'['$how_you_feel_8']'
,$_SESSION'['$how_you_feel_9']'
,$_SESSION'['$clear_view_plan']'
,$_SESSION'['$features_quality_rate_1']'
,$_SESSION'['$features_quality_rate_2']'
,$_SESSION'['$features_quality_rate_3']'
,$_SESSION'['$features_quality_rate_4']'
,$_SESSION'['$features_quality_rate_5']'
,$_SESSION'['$features_quality_rate_6']'
,$_SESSION'['$features_quality_rate_7']'
,$_SESSION'['$features_quality_rate_8']'
,$_SESSION'['$features_quality_rate_9']'
,$_SESSION'['$features_quality_rate_10']'
,$_SESSION'['$features_quality_rate_11']'
,$_SESSION'['$features_quality_rate_12']'
,$_SESSION'['$features_quality_rate_others']'
)";
mysql_query($sql) or die (mysql_error());
//execute query and store the result
$res = mysql_query($sql,$connection);
if ($res) {
echo "Your survey has been submitted - thankyou<BR /><BR />";
} else {
echo "There was a problem with your post - please click the previous button and try again or contact the system administrator: tez@mindseyemidlands.co.uk<BR /><BR />";
}
?>
I cannot win either way at the moment as this creates an undefined variable error and if I do it the other way with POST then I have undefined indexes
