question_process_part3.php

<?php 
session_start();
include 'admin/json/settings.php'; 
$id=$_SESSION['user_id'];
$obj1   = new commonFunctions();
$dbh    = $obj1->dbh;
$status = false;
$row    = '';
$query  = $dbh->prepare("select * from pig_questions where peradd='0' order by id asc");
$query->execute();
$counts_questions=$query->rowCount();
if ($query->rowCount() > 0) 
{
        $status = true;
        while($row = $query->fetch(PDO::FETCH_ASSOC))
        {
            if($row['type']==1)
            {
                 $answer=$_REQUEST['optionsRadios'.$row['id']];
            }
            else if($row['type']==2)
            {
                $answer=$_REQUEST['txt'.$row['id']];
            }
            else if($row['type']==3)
            {
                $answer=$_REQUEST['options'.$row['id']];
            }
            else if($row['type']==4)
            {
                $answer=$_REQUEST['dropdownval'.$row['id']];
            }
            $_SESSION['qn']['question'.$row['id']]=array("question_id"=>$row['id'],"type"=>$row['type'],"answer"=>$answer);
            
            
         }
         
        if(!empty($_SESSION['qn']))
        {
            $obj3   = new commonFunctions();
            $dbh1    = $obj3->dbh;
            $query1  = $dbh1->prepare("insert into pig_user_answer_rel(`user_id`) values(:id)");
            $query1->bindParam(":id",$id,PDO::PARAM_INT); 
            $query1->execute();
            $propertyId = $dbh1->lastInsertId();
           foreach ($_SESSION['qn'] as $value) 
           {
           
                $obj3   = new commonFunctions();
                $dbh3    = $obj3->dbh;
                $question_id=$value['question_id'];
                $answer=$value['answer'];
                $type=$value['type'];
                
                $query3  = $dbh->prepare("insert into pig_user_answer (`question_id`,`answer`,`question_type`,`user_id`,`property_id`) values(:question_id,:answer,:type,:id,:propertyId)");
                $query3->bindParam(":question_id",$question_id,PDO::PARAM_INT);
                $query3->bindParam(":answer",$answer,PDO::PARAM_STR); 
                $query3->bindParam(":type",$type,PDO::PARAM_INT); 
                $query3->bindParam(":id",$id,PDO::PARAM_INT); 
                $query3->bindParam(":propertyId",$propertyId,PDO::PARAM_INT);

                $query3->execute();
                //
            }
                $_SESSION['qn']='';
                $_SESSION['valid_user']='set';
                $_SESSION['user_id']=$id;
                echo "1";
       }
       else
       {
          echo "0";
       }
}
else
{
    
}
?>