<?php

include_once 'config.php';

$instruction = '<p style="text-align: justify;"><strong>In case no improvement is required, choose “No improvement” option.</strong></p>';

$getquestions = $live->query("SELECT question_id FROM csp_sp_question where sub_topic_id='220' and question_instruction='$instruction' and question_statement LIKE '%text-decoration: underline;%' and question_flag='0' and DATE_FORMAT(last_update_on, '%Y-%m-%d')='2021-05-24' limit 20");
echo $live->error;
$question_server = array("sarkari-pariksha");
$quesOfjson = json_encode($question_server, JSON_UNESCAPED_UNICODE);
$i=1;
foreach ($getquestions as $q) {
    echo $i.'--'.$q['question_id'];
    
    $ques_id = $q['question_id'];
    if ($ques_id != '') {
        $instruction_new = '<p style="text-align: justify;"><strong>In the following question, a part of the sentence is underlined. Below are given alternatives to the underlined part which may improve the sentence. Choose the correct alternative. In case no improvement is required, choose “No improvement” option.</strong></p>';
        // $updateQuestion = "UPDATE csp_sp_question set question_instruction='$instruction_new',question_of='$quesOfjson',question_flag='1' where question_id='$ques_id'";
        // if ($live->query($updateQuestion)) {
        //     echo "update";
        // }
    }
    $i++;
    echo '<br>';
}