如何在WordPress自定义中的一个MySQL字段中存储两个字段值

Question

这是我在数据表中存储值的数组代码。 我想在一个 MySQL 字段中存储四个字段值

我需要在答案行中存储答案 1、答案 2、答案 3、答案 4

它显示了一个错误：- WPDB：:p repare 被错误调用。不支持的值类型(数组(。有关更多信息，请参阅 WordPress 中的调试。(此消息是在版本 4.8.2 中添加的。

这是我的数组代码

if(isset($_POST['submit'])){    
$answer1=$_POST['answer1'];
$answer2=$_POST['answer2'];
$answer3=$_POST['answer3'];
$answer4=$_POST['answer4'];
$table_name2 = $wpdb->prefix . 'pte_quiz';
$wpdb->insert(
$table_name2,
array(
'answer' => array('answer1' =>$answer1, 'answer2' =>$answer2, 'answer3' =>$answer3, 'answer4' =>$answer4),
'uid' => $uid,
'user' => $user )
);
echo "Your answer successfully submited!!!";?><br>
Your Answer is <?php echo $answer;
exit;
}

Answer 1

试一试

if(isset($_POST['submit'])){    
$answer1=$_POST['answer1'];
$answer2=$_POST['answer2'];
$answer3=$_POST['answer3'];
$answer4=$_POST['answer4'];
$table_name2 = $wpdb->prefix . 'pte_quiz';
$wpdb->insert(
$table_name2,
array(
'answer' => json_encode(array('answer1' =>$answer1, 'answer2' =>$answer2, 'answer3' =>$answer3, 'answer4' =>$answer4)),
'uid' => $uid,
'user' => $user )
);
echo "Your answer successfully submited!!!";?><br>
Your Answer is <?php echo json_decode($answer,true);
exit;
}

我们可以简单地将答案数组转换为 JSON 字符串并将其存储到数据库中。稍后当我们需要使用存储的值时，我们可以简单地json_decode()它并获得所需的数组。