";
}
if ($jedID2 == 105) {
$customer_id=$_POST['lookD'];
// $survey_num=$survey_id;
$sql33 ="SELECT * FROM $table_name36 WHERE customer_id = '$customer_id' ";
$result222 = @mysqli_query($connection,$sql33) or die(mysqli_error($connection));
while ($row1 = mysqli_fetch_array($result222)) {
$first = stripslashes($row1['firstname']);
$last =stripslashes($row1['lastname']);
$id2= $row1['customer_id'];
$login2 =$row1['store_id'];
$address_id =$row1['address_id'];
$company= $row1['company'];
$email= $row1['email'];
$telephone= $row1['telephone'];
$fax= $row1['fax'];
$sql34 ="SELECT * FROM $table_name40 WHERE address_id = '$address_id' ";
$result224 = @mysqli_query($connection,$sql34) or die(mysqli_error($connection));
$row14 =mysqli_fetch_array($result224,MYSQLI_ASSOC);
if ($address_id == $row14['address_id'])
{
$company= $row14['company'];
$address_1 =$row14['address_1'];
$address_2 =$row14['address_2'];
$city =$row14['city'];
$postcode =$row14['postcode'];
$country_id =$row14['country_id'];
$zone_id =$row14['zone_id'];
}
$sql35 ="SELECT * FROM $table_name45 WHERE country_id = '$country_id' ";
$result225 = @mysqli_query($connection,$sql35) or die(mysqli_error($connection));
$row15 =mysqli_fetch_array($result225,MYSQLI_ASSOC);
if ($country_id == $row15['country_id'])
{
$country= $row15['name'];
}
$sql36 ="SELECT * FROM $table_name46 WHERE country_id = '$country_id' AND zone_id = '$zone_id' ";
$result226 = @mysqli_query($connection,$sql36) or die(mysqli_error($connection));
$row16 =mysqli_fetch_array($result226,MYSQLI_ASSOC);
if (($zone_id == $row16['zone_id']) || ($country_id==$row16['country_id']))
{
$zone= $row16['name'];
}
//$sql33vv ="SELECT * FROM $tablename361 WHERE customer_id = '$customer_id'";
$sql33vv ="SELECT * FROM $table_name361 WHERE customer_id = '$customer_id' ";
$result222vv = @mysqli_query($connection,$sql33vv) or die(mysqli_error($connection));
while ($row1vv = mysqli_fetch_array($result222vv)) {
$hh=$hh+1;
$fieldvalueY[$hh]= $row1vv['name'];
$fieldtypeY[$hh]= $row1vv['additional_customer_id'];
$sql34zz ="SELECT * FROM $table_name360 WHERE additional_customer_id = '$fieldtypeY[$hh]' ";
$result224zz = @mysqli_query($connection,$sql34zz) or die(mysqli_error($connection));
$row14zz =mysqli_fetch_array($result224zz,MYSQLI_ASSOC);
if ($fieldtypeY[$hh] == $row14zz['additional_customer_id'])
{
$fieldnameY[$hh]= $row14zz['name'];
}
$display_blockExtra .=" $fieldnameY[$hh] = $fieldvalueY[$hh] ";
}
$display_blockV .= "
Id
First Name
Last Name
Phone
Fax
Email
Address
$id2
$first
$last
$telephone
$fax
$email
$address_1 $city, $zone, $country $postcode
Additional Information:
$display_blockExtra"; }
$display_block .= "
$display_blockV
";
}
if ($jedID2 == 6) {
$survey_id=$_POST['lookD'];
$survey_num=$survey_id;
$boo="great";
// $survey_idW=$_POST['survey_idW'];
$bat=$_POST['bat'];
// $survey_idW=3;
// if ($gbad >0){
// }
$sq112azg="DELETE FROM $table_name77 WHERE surveyA_id ='$bat' ";
$result331 = @mysqli_query($connection,$sq112azg) or die(mysqli_error($connection));
$warn= "
Answer Deleted
";
$sq112a="SELECT * FROM $table_name76 WHERE survey_id ='$survey_id' Order By surveyQ_id ";
// $boo="great";
include("surv_display2.php");
include("surv_display3.php");
include("survey_manage2.php");
$display_block .= "
$display_blockV
$display_block2
";
}
if ($jedID2 == 7) {
$survey_id=$_POST['lookD'];
$survey_num=$survey_id;
$boo="great";
$survey_idWa=$_POST['survey_idWa'];
$bat=$_POST['bat'];
// $survey_idW=3;
// if ($gbad >0){
// }
$Q_delete=$_POST['del_Q'];
$sq112d="SELECT * FROM $table_name76 WHERE survey_id ='$survey_idWa'AND surveyQQ_id ='$Q_delete' ";
$result331d = @mysqli_query($connection,$sq112d) or die(mysqli_error($connection));
while ($row1d = mysqli_fetch_array($result331d)) {
$surveyQ_id= $row1d['surveyQ_id'];
}
$sq112az="DELETE FROM $table_name76 WHERE survey_id ='$survey_idWa'AND surveyQQ_id ='$Q_delete' ";
$result331 = @mysqli_query($connection,$sq112az) or die(mysqli_error($connection));
$sq112az="DELETE FROM $table_name77 WHERE survey_id ='$survey_idWa'AND surveyQ_id ='$surveyQ_id' ";
$result331 = @mysqli_query($connection,$sq112az) or die(mysqli_error($connection));
$warn= "
Question Deleted
";
$sq112a="SELECT * FROM $table_name76 WHERE survey_id ='$survey_id' Order By surveyQ_id ";
// $boo="great";
include("surv_display2.php");
include("surv_display3.php");
include("survey_manage2.php");
$display_block .= "
$display_blockV
$display_block2
";
}
if ($jedID2 == 8) {
$Q_add=$_POST['del_Add'];
if ($Q_add == 2 or $Q_add ==3){
if ($Q_add == 2){
$title_Q ="This answer will have radio button inputs.";
}
if ($Q_add == 3){
$title_Q ="This answer will have check boxes.";
}
include("add_question.php");
}
if ($Q_add == 0 ){
$title_Q ="This answer will have a text input box.";
$mess_fill="";
$dont2="";
include("add_question_single.php");
}
$barrie="states";
if ($Q_add == 19 ){
$title_Q ="This answer will have a pulldown state menu.";
$mess_fill="";
$dont2="";
include("add_question_single.php");
}
$barrie="countries";
if ($Q_add == 29 ){
$title_Q ="This answer will have a pulldown country menu.";
$mess_fill="";
$dont2="";
include("add_question_single.php");
}
$survey_id=$_POST['lookD'];
$survey_num=$survey_id;
// $warn= "
Question Deleted
";
$sq112a="SELECT * FROM $table_name76 WHERE survey_id ='$survey_id' Order By surveyQ_id ";
// $boo="great";
include("surv_display2.php");
include("surv_display3.php");
include("survey_manage2.php");
$display_block .= "
$display_blockV
$display_block2
";
}
if ($jedID2 == 9) {
$Q_add=$_POST['Q_add'];
$test_type=$Q_add;
$barrie="states";
$barrie1="countries";
if ($test_type ==19 or $test_type ==29){
$test_type=4;
}
$survey_id=$_POST['survey_idw'];
$survey_num=$survey_id;
$admin=0;
$q1=addslashes($_POST['QuestionOne']);
$qc1=addslashes($_POST['Hint']);
$a1= $_POST['answer1'];
$p1= addslashes($_POST['Panswer1']);
$c1= addslashes($_POST['Comment1']);
$sq112d="SELECT surveyQ_id FROM $table_name76 WHERE survey_id ='$survey_id' Order by surveyQ_id DESC Limit 1 ";
$result331d = @mysqli_query($connection,$sq112d) or die(mysqli_error($connection));
while ($row1d = mysqli_fetch_array($result331d)) {
$surveyQ_id= $row1d['surveyQ_id'];
}
$dont="Do Not Include";
$surveyQ_id=$surveyQ_id+1;
$sql2 = "INSERT INTO $table_name76 ( survey_id, surveyQ_id, question,comment, administrative, create_date) VALUES ('$survey_id','$surveyQ_id', '$q1','$qc1','$admin', '$today')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
if ($a1 != $blink ){
if( $a1 != $dont){
$a1= addslashes($_POST['answer1']);
$sql2 = "INSERT INTO $table_name77 ( surveyQ_id, survey_id, answer,comment, test_type, A_points) VALUES ('$surveyQ_id','$survey_id', '$a1','$c1','$test_type', '$p1')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
}}
$a2= $_POST['answer2'];
if ($a2 != $blink ){
if( $a2 != $dont){
$a2= addslashes($_POST['answer2']);
$p2= addslashes($_POST['Panswer2']);
$c2= addslashes($_POST['Comment2']);
$sql2 = "INSERT INTO $table_name77 ( surveyQ_id, survey_id, answer,comment, test_type, A_points) VALUES ('$surveyQ_id','$survey_id', '$a2','$c2','$test_type', '$p2')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
} }
$a3= $_POST['answer3'];
if ($a3 != $blink ) {
if ($a3 != $dont){
$a3= addslashes($_POST['answer3']);
$p3= addslashes($_POST['Panswer3']);
$c3= addslashes($_POST['Comment3']);
$sql2 = "INSERT INTO $table_name77 ( surveyQ_id, survey_id, answer,comment, test_type, A_points) VALUES ('$surveyQ_id','$survey_id', '$a3','$c3','$test_type', '$p3')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
}}
$a4= $_POST['answer4'];
if ($a4 != $blink){
if( $a4 != $dont){
$a3= addslashes($_POST['answer4']);
$p3= addslashes($_POST['Panswer4']);
$c3= addslashes($_POST['Comment4']);
$sql2 = "INSERT INTO $table_name77 ( surveyQ_id, survey_id, answer,comment, test_type, A_points) VALUES ('$surveyQ_id','$survey_id', '$a3','$c3','$test_type', '$p3')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
} }
$a5= $_POST['answer5'];
if ($a5 != $blink) {
if ($a5 != $dont){
$p3= addslashes($_POST['Panswer5']);
$c3= addslashes($_POST['Comment5']);
$a3= addslashes($_POST['answer5']);
$sql2 = "INSERT INTO $table_name77 ( surveyQ_id, survey_id, answer,comment, test_type, A_points) VALUES ('$surveyQ_id','$survey_id', '$a3','$c3','$test_type', '$p3')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
} }
$a6= $_POST['answer6'];
if ($a6 != $blink) {
if ( $a6 != $dont){
$p3= addslashes($_POST['Panswer6']);
$c3= addslashes($_POST['Comment6']);
$a3= addslashes($_POST['answer6']);
$sql2 = "INSERT INTO $table_name77 ( surveyQ_id, survey_id, answer,comment, test_type, A_points) VALUES ('$surveyQ_id','$survey_id', '$a3','$c3','$test_type', '$p3')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
} }
$a7= $_POST['answer7'];
if ($a7 != $blink ){
if ($a7 != $dont){
$p3= addslashes($_POST['Panswer7']);
$c3=addslashes($_POST['Comment7']);
$a3= addslashes($_POST['answer7']);
$sql2 = "INSERT INTO $table_name77 ( surveyQ_id, survey_id, answer,comment, test_type, A_points) VALUES ('$surveyQ_id','$survey_id', '$a3','$c3','$test_type', '$p3')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
} }
$a8= $_POST['answer8'];
if ($a8 != $blink){
if ($a8 != $dont){
$p3= addslashes($_POST['Panswer8']);
$c3= addslashes($_POST['Comment8']);
$a3= addslashes($_POST['answer8']);
$sql2 = "INSERT INTO $table_name77 ( surveyQ_id, survey_id, answer,comment, test_type, A_points) VALUES ('$surveyQ_id','$survey_id', '$a3','$c3','$test_type', '$p3')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
} }
$a9= $_POST['answer9'];
if ($a9 != $blink){
if ($a9 != $dont){
$p3= addslashes($_POST['Panswer9']);
$c3= addslashes($_POST['Comment9']);
$a3= addslashes($_POST['answer9']);
$sql2 = "INSERT INTO $table_name77 ( surveyQ_id, survey_id, answer,comment, test_type, A_points) VALUES ('$surveyQ_id','$survey_id', '$a3','$c3','$test_type', '$p3')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
}}
$a10= $_POST['answer10'];
if ($a10 != $blink ){
if ($a10 != $dont){
$p3= addslashes($_POST['Panswer10']);
$c3= addslashes($_POST['Comment10']);
$a3= addslashes($_POST['answer10']);
$sql2 = "INSERT INTO $table_name77 ( surveyQ_id, survey_id, answer,comment, test_type, A_points) VALUES ('$surveyQ_id','$survey_id', '$a3','$c3','$test_type', '$p3')";
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
} }
// include("add_question.php");
// $warn= "
Question Deleted
";
$sq112a="SELECT * FROM $table_name76 WHERE survey_id ='$survey_id' Order By surveyQ_id ";
// $boo="great";
include("surv_display2.php");
include("surv_display3.php");
include("survey_manage2.php");
$display_block .= "
$display_blockV
$display_block2
";
}
if ($jedID2 == 10) {
$quest= $_POST['Quest'];
$survey_id=$_POST['survey_idw'];
$survey_num=$survey_id;
$questEdit= addslashes($_POST['Edit']);
$sql2 = "UPDATE $table_name76 SET question=' $questEdit' WHERE survey_id ='$survey_id'AND surveyQ_id ='$quest' " ;
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
$spot1=$_POST['1'];
$bot=1;
if ($spot1 != $blink) {
$sql2 = "UPDATE $table_name76 SET administrative='$spot1' WHERE survey_id ='$survey_id'AND surveyQ_id ='$bot' " ;
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
}
$spot1=$_POST['2'];
$bot=2;
if ($spot1 != $blink) {
$sql2 = "UPDATE $table_name76 SET administrative=' $spot1' WHERE survey_id ='$survey_id'AND surveyQ_id ='$bot' " ;
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
}
$sq112e="SELECT * FROM $table_name77 WHERE survey_id ='$survey_id' AND surveyQ_id ='$quest' ";
$result24 = @mysqli_query($connection,$sq112e) or die(mysqli_error($connection));
while ($row1da = mysqli_fetch_array($result24)) {
$surveyA_id= $row1da['surveyA_id'];
$test_type= $row1da['test_type'];
$Pname="P$surveyA_id";
$Cname="C$surveyA_id";
$Aname="Q$surveyA_id";
$pquest= $_POST["$Pname"];
$cquest= addslashes($_POST["$Cname"]);
$aquest= addslashes($_POST["$Aname"]);
if (($test_type !=4) AND ($test_type !=0)) {
$sql2 = "UPDATE $table_name77 SET answer ='$aquest', comment='$cquest', A_points='$pquest' WHERE surveyA_id ='$surveyA_id'" ;
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
}
if ($test_type ==4) {
$sql2 = "UPDATE $table_name77 SET comment='$cquest', A_points='$pquest' WHERE surveyA_id ='$surveyA_id'" ;
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
}
if ($test_type ==0) {
$aquest=addslashes($_POST["$quest"]);
$sql2 = "UPDATE $table_name77 SET answer ='$aquest', comment='$cquest', A_points='$pquest' WHERE surveyA_id ='$surveyA_id'" ;
$result2 = @mysqli_query($connection,$sql2) or die(mysqli_error($connection));
}
}
$sq112a="SELECT * FROM $table_name76 WHERE survey_id ='$survey_id' Order By surveyQ_id ";
// $boo="great";
include("surv_display2.php");
include("surv_display3.php");
include("survey_manage2.php");
$display_block .= "
