<?php
include 'config.php';

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);


$SP_QUESTION = 'csp_sp_question';
$SP_QUESTION_MEDIUM_WISE = 'csp_sp_question_medium_wise';
$SP_QUES_HISTORY = 'csp_sp_question_history';
$f_fdate = '2021-11-01';
$f_tdate = '2022-03-31';
//and (date(action_date) BETWEEN '$f_fdate' AND '$f_tdate')

$getData = $conn->query("SELECT count(question_id) as total FROM $SP_QUESTION where (date(add_date) BETWEEN '$f_fdate' AND '$f_tdate')");
$gd = $getData->fetch_assoc();

echo "Count -".$gd['total'];

die();
// $questions = array("235947","235948","235949","236846","236853","236859","236840");

// $e_sbtpc_master = 44;
// $e_sbtpc_subject = 5908;
// $e_sbtpc_topic = 5917;
// $e_sub_topic = 5949;
// $editor_id = "131";
// $curDate = date('Y-m-d H:i:s');
// $flag = 1;
// $previous_exam_name = '';
// $previous_exam_year = '';
// $question_server = array("sarkari-pariksha");
// $quesOfjson = json_encode($question_server, JSON_UNESCAPED_UNICODE);


/***
 * for banking
 */
$opt5_e='<p>None of the above</p>';
$opt5_h='<p>उपर्युक्त में से कोई नहीं</p>';

$getIds = $conn->query("SELECT question_id FROM $SP_QUESTION where question_statement like '%uploads/tet_admin_photos_sp%'");

$i=1;
foreach ($getIds as $q) {
    $qid = $q['question_id'];
    if ($qid != '' && $qid != '0') {
        echo  "<br>";
        echo $i.'--'.$qid;
        //  echo $insertPrimaryQ = "INSERT INTO $SP_QUESTION (`oly_id`, `old_question_id`, `master_id`, `subject_id`, `topic_id`, `sub_topic_id`, `sys_id`, `level_name`, `difficulty`, `medium_id`, `question_group`, `no_of_option`, `question_instruction`, `question_statement`, `option_1`, `option_2`, `option_3`, `option_4`, `option_5`, `correct_answer`, `question_hint`, `question_solution`, `active_solution`, `previous_exam_name`, `previous_exam_year`, `exam_shift`, `question_expiry`, `source_id`, `add_by`, `add_date`, `last_update_on`, `last_update_by`, `last_proofread_by`, `last_proofread_date`, `status`, `question_type`, `question_of`, `question_flag`, `exam_bound`, `e_id`, `e_sub_id`, `e_top_id`) SELECT `oly_id`, `old_question_id`, $e_sbtpc_master, $e_sbtpc_subject, $e_sbtpc_topic, '$e_sub_topic', `sys_id`, `level_name`, `difficulty`, `medium_id`, `question_group`, `no_of_option`, `question_instruction`, `question_statement`, `option_1`, `option_2`, `option_3`, `option_4`, `option_5`, `correct_answer`, `question_hint`, `question_solution`, `active_solution`, `previous_exam_name`, `previous_exam_year`, `exam_shift`, `question_expiry`, $qid, '$editor_id', '$curDate', '$curDate', $editor_id, `last_proofread_by`, `last_proofread_date`, `status`, `question_type`, '$quesOfjson', '$flag', `exam_bound`, `e_id`, `e_sub_id`, `e_top_id` FROM $SP_QUESTION WHERE question_id='$qid'";
        // if ($conn->query($insertPrimaryQ)) {
        //     echo $new_question_id = $conn->insert_id;
        //     $insertSecQ = "INSERT INTO $SP_QUESTION_MEDIUM_WISE (`question_id`, `oly_id`, `medium_id`, `question_instruction`, `question_statement`, `option_1`, `option_2`, `option_3`, `option_4`, `option_5`, `question_hint`, `question_solution`, `active_solution`, `source_id`, `add_by`, `add_date`, `last_update_on`, `last_update_by`, `last_proofread_date`, `last_proofread_by`, `status`) SELECT $new_question_id, `oly_id`, `medium_id`, `question_instruction`, `question_statement`, `option_1`, `option_2`, `option_3`, `option_4`, `option_5`, `question_hint`, `question_solution`, `active_solution`, `source_id`, '$editor_id', '$curDate', '$curDate', $editor_id, `last_proofread_date`, `last_proofread_by`, `status` FROM $SP_QUESTION_MEDIUM_WISE WHERE question_id='$qid'";
        //     $conn->query($insertSecQ);
        // }
        // if ($conn->error) {
        //     echo "ERROR :" . $conn->error;
        // }
    }
    $i++;
}