" , print_r( $formData) , ""; for($i=0;$i<=count($formData);$i++){ foreach ($formData as $key => $value) { $value=strstr($value, ":"); $data=explode(" ",$value); if($key==0) $member['Surname']=str_replace(":",'',$value); if($key==1) $member['Name']=str_replace(":",'',$value); if($key==2) $member['Nationality']=str_replace(":",'',$value); if($key==3) $member['Email address']=str_replace(":",'',$value); } } } if($key=='score'){ $member['score']=$value; } } foreach ($member as $key => $value) { echo $key .'=>'. $value.'
wp_wp_pro_quiz_statistic_ref AS ref
LEFT JOIN wp_wp_pro_quiz_statistic AS stat ON ref.statistic_ref_id = stat.statistic_ref_id
WHERE quiz_id =3
GROUP BY ref.statistic_ref_id
ORDER BY create_time ASC
```
* RESULT OF THE QUERY
* ```
registrationtime | form_data | user_id | score
1383642471 {"9":"sds","10":"sds","11":"sds","12":"sds@dfd.com 1 2
1383642491 {"9":"re","10":"test","11":"test1","12":"test@dtes.com 1 6
1383642410 {"9":"steeds","10":"sdrsrss","11":"sereds","12":"res@ssd.com 1 4
```
* In the following class WpProQuiz_Model_Participant it return an array
* ```
_wpdb->get_results(
$this->_wpdb->prepare(
"SELECT
create_time AS registrationtime,
form_data,user_id,SUM(points) as score
FROM
{$this->_tableStatisticRef} AS ref
LEFT JOIN
wp_wp_pro_quiz_statistic AS stat
ON ref.statistic_ref_id = stat.statistic_ref_id
WHERE
quiz_id = %d
GROUP BY ref.statistic_ref_id
ORDER BY
create_time ASC
"
, $quizId)
, ARRAY_A);
return json_encode($results);
```
* In my controller
* ```
showParticipantlist($quizId);
}
public static function showParticipantlist($quizId)
{
$obj = new WpProQuiz_Model_Participant();
$view = new WpProQuiz_View_Participant();
$items = array();
$participantlist = $obj->fetchparicipantlist($quizId);
$participantlist = json_decode($participantlist, true);
$member = array();
foreach ($participantlist as $data) {
foreach ($data as $key => $value) {
echo "
", print_r($data), ""; if ($key == 'registrationtime') { $value = WpProQuiz_Helper_Until::convertTime($value, 'Y/m/d g:i A'); $member['Date'] = $value; } if ($key == 'form_data') { $formData = str_replace("{", '', $value); $formData = str_replace("}", '', $formData); $formData = explode(',',$formData); foreach ($formData as $key => $value) { $formvalues = explode(':', $value); foreach ($formvalues as $key => $value) { if ($key == 0) unset($formvalues[$value]); else { $member['Surname'] = $value; $member['Name'] = $value; $member['Nationality'] = $value; $member['Email address'] = $value; // echo "
", print_r($member, 1), ""; } } } } } } } } ?> ``` * Am unable to store the values for each participant form values in the member array * I need to export these data in excel format EXCEL SHEET format * Date of registration|surname|name|nationality|Email address|score * Thanks for kind help and response * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Wp-Pro-Quiz] a 500 Internal Server Error occur on statisticLoadUser function](https://wordpress.org/support/topic/a-500-internal-server-error-occur-on-statisticloaduser-function/) * Thread Starter [preetee](https://wordpress.org/support/users/preetee/) * (@preetee) * [12 years, 9 months ago](https://wordpress.org/support/topic/a-500-internal-server-error-occur-on-statisticloaduser-function/#post-4288404) * Dear Wisecapt * Good news i resolved the issue..was turning crazy..but i think madness turns to bring buld of light on my head 😛 * To resolve this issue I have change add GROUP BY sf.statistic_ref_id in the class file named WpProQuiz_Model_StatisticRefMapper in the following function * ``` public function fetchByRefId($refIdUserId, $quizId, $avg = FALSE) { $where = $avg ? 'sf.user_id = %d' : 'sf.statistic_ref_id = %d'; $results = $this->_wpdb->get_results( $this->_wpdb->prepare( "SELECT sf.*, MIN(sf.create_time) AS min_create_time, MAX(sf.create_time) AS max_create_time FROM {$this->_tableStatisticRef} AS sf WHERE {$where} AND sf.quiz_id = %d GROUP BY sf.statistic_ref_id" , $refIdUserId, $quizId) , ARRAY_A); foreach ($results as $row) { $row['form_data'] = $row['form_data'] === null ? null : @json_decode($row['form_data'], true); return new WpProQuiz_Model_StatisticRefModel($row); } } ``` * Let’s me know about your feedback. Take care * Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/) In reply to: [[Wp-Pro-Quiz] a 500 Internal Server Error occur on statisticLoadUser function](https://wordpress.org/support/topic/a-500-internal-server-error-occur-on-statisticloaduser-function/) * Thread Starter [preetee](https://wordpress.org/support/users/preetee/) * (@preetee) * [12 years, 9 months ago](https://wordpress.org/support/topic/a-500-internal-server-error-occur-on-statisticloaduser-function/#post-4288400) * Dear Wisecapt, * Thank you for replying back.:) In fact the issue is due the version of mysql version on production server which is 5.0.45 . The php version on production server 5.2.4 * On local development side, the script is working perfectly with mysql version 5.5.24 and php version 5.4.3. When i tried to switch with php version 5.2.4 on locally it works then i switch with mysql version 5.0.45 locally as well, then i got the same 500 Internal error . * In my firebug, * POST * ``` Parametersapplication/x-www-form-urlencoded action wp_pro_quiz_admin_ajax data[avg] 0 data[quizId] 2 data[refId] 9 data[userId] 0 func statisticLoadUser Source action=wp_pro_quiz_admin_ajax&func=statisticLoadUser&data%5BquizId%5D=2&data%5BuserId%5D=0&data%5BrefId%5D=9&data%5Bavg%5D=0 ``` * RESPONSE * ```
WordPress database error: [Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause]
SELECT
sf.*,
MIN(sf.create_time) AS min_create_time,
MAX(sf.create_time) AS max_create_time
FROM
wp_wp_pro_quiz_statistic_ref AS sf
WHERE
sf.statistic_ref_id = 9 AND sf.quiz_id = 2