Query benar, data tidak masuk

coba contoh berikut.

mysql

<pre> CREATE TABLE answer ( answer_tags char(1) DEFAULT NULL, answer_subject varchar(255) DEFAULT NULL, quiz_id int(11) DEFAULT NULL, activity_id int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 </pre>

php

<pre> class ABC{ private $mysqli; public function __construct(){ $this-&gt;mysqli=mysqli_connect("localhost","XXXXX","XX","XXXXX"); } public function escape($str){ if (get_magic_quotes_gpc()) { return $str; } else { return mysqli_real_escape_string($this-&gt;mysqli,$str); } } public function insertAnswer($table, $dataTags = [], $dataSubj = [], $total, $fields = []) { $column = implode(', ', array_keys($fields)); $value = implode(', ', array_values($fields));

	$value    = $this->escape($value);
	for ($x = 0; $x < $total; $x++) {
		$query = "INSERT INTO $table (answer_tags, answer_subject, $column) VALUES ('$dataTags[$x]','$dataSubj[$x]',$value)";
		print_r($query);    
		$data = $this->mysqli->query($query);
	}

	if ($data) {
		die();
	} else {
		die('gagal');
	}
}

}

$table="answer"; $dataTags=[ 'A','B','C','D','E' ]; $dataSubj=[ "satu", "dua", "tiga", "empat", "lima" ]; $total=count($dataTags); $fields=[ "quiz_id"=&gt;2, "activity_id"=&gt;1 ];

$abc=new ABC(); $abc-&gt;insertAnswer($table,$dataTags,$dataSubj,$total,$fields); </pre>

Hmmm... setiap table "answer" dan "quiz" saya reset / truncate. fungsi kembali normal. apa mungkin karena saat saya debug di bagian "answer", ID "Quiz" yang saya dapatkan dengan mengambil nilai hash dari "quiz" pada table "answer" tidak valid ? *hmmmm <pre> require_once "../Core/init.php";

if (!Session::exists('examygoUser')) { Redirect::to('/examygo/user/login.php'); } if (Session::exists('examygoUser') && $user-&gt;getUser('username', Session::get('examygoUser'))['role'] &lt;= 1) { Redirect::to('/examygo/courses/'); }

$quiz = new Quiz;

$activities = $course-&gt;getActivity('activity_id', $_GET['activity_id']); $course = $course-&gt;getCourse('course_id', $_GET['course_id']);

$cid = $_GET['course_id']; $aid = $_GET['activity_id'];

if (Input::get('submit')) {

$_SESSION['addquiz'] = $_POST;

//call validation class
$validasi = new Validation;

//rule validasi
// $validasi = $validasi->check([
//     'course_full_name'  => [
//         'required'  =>   true,
//         'min'       =>   4,
//         'max'       =>   30,
//         'char'      =>   '/^[a-zA-Z0-9 ]*$/',
//     ],
//     'course_short_name'  => [
//         'required'  =>   true,
//         'min'       =>   4,
//         'max'       =>   30,
//         'char'      =>   '/^[a-zA-Z0-9 ]*$/'
//     ]
// ]);

if (Helper::checkToken(Input::get('csrf'))) {


    if (!isset($_FILES['audio']['name'])) {
        //audio
        $nama_audio = $_FILES['audio']['name'];
        $asal_audio = $_FILES['audio']['tmp_name'];
        $format_audio = $_FILES['audio']['type'];
        $size_audio = $_FILES['audio']['size'];
        $error_audio = $_FILES['audio']['error'];

        $nama_audio = time() . addslashes($nama_audio);
        //validasi audio input
        if ($error_audio == 0) {
            if ($format_audio == 'audio/mpeg' || $format_audio == 'audio/x-wav') {
                if ($size_audio < 3000000) {
                    move_uploaded_file($asal, '../Assets/Media/Upload/Audio' . $nama_audio);
                } else {
                    $errors['inputAudio'] = "maximum audio file size is 3mb";
                }
            } else {
                $errors['inputAudio'] = "format that allowed is .mp3 / .wav";
            }
        } else {
            $errors['inputAudio'] = "There is an error!";
        }
    }

    if (!isset($_FILES['image']['name'])) {
        //image
        $nama_image = $_FILES['image']['name'];
        $asal_image = $_FILES['image']['tmp_name'];
        $format_image = $_FILES['image']['type'];
        $size_image = $_FILES['image']['size'];
        $error_image = $_FILES['image']['error'];

        $nama_image = time() . addslashes($nama_image);
        //validasi image input
        if ($error_image == 0) {
            if ($format_image == 'image/jpeg' || $format_image == 'image/png') {
                if ($size_image < 3000000) {
                    move_uploaded_file($asal, '../Assets/Media/Upload/Image' . $nama_image);
                } else {
                    $errors['inputimage'] = "maximum image file size is 3mb";
                }
            } else {
                $errors['inputimage'] = "format that allowed is .jpg / .png";
            }
        } else {
            $errors['inputimage'] = "There is an error!";
        }
    }

    if (!isset($hash)) {
        $hash = time();
    } else {
        $hash;
    }

    $quizData = $quiz->addQuiz([
        'activity_id'   =>  $activities['activity_id'],
        'course_id'     =>  $course['course_id'],
        'semester'      =>  Input::get('semester'),
        'audio'         =>  $nama_audio,
        'image'         =>  $nama_image,
        'question'      =>  Input::get('question'),
        'answer_key'    =>  Input::get('answer_key'),
        'hash'          =>  $hash
    ]);
    if ($quizData == true) {
        $quizId = $quiz->getQuiz('hash', $hash)['quiz_id'];

        $answer_tags = Input::get('answer_tags');
        $answer_subject = Input::get('answer_subject');
        $total_tags = count($answer_tags);

        $result = $quiz->addAnswer($answer_tags, $answer_subject, $total_tags, [
            'quiz_id'       =>  $quizId,
            'activity_id'   =>  $activities['activity_id']
        ]);
    } else {
        echo "<script>Swal.fire('Sorry!', 'fail to upload data!', 'error');</script>";
    }
} else {
    Redirect::to('/examygo/courses/');
}

} </pre>