$form_fields = new crf_basic_fields(); $qry = "select count(*) from {$crf_stats} where form_id=" . $form_id; $total_stats = $wpdb->get_var($qry); $qry = "select count(*) from {$crf_stats} where `details` LIKE '%yes%' and form_id=" . $form_id; $total_submission = $wpdb->get_var($qry); $total_fail = $total_stats - $total_submission; //echo "SELECT * FROM $crf_stats where form_id ='".$form_id."' <br/>"; $stats_entries = $wpdb->get_results("SELECT * FROM {$crf_stats} where form_id ='" . $form_id . "'"); // pie chart for browsers if (!empty($stats_entries)) { $i = 1; foreach ($stats_entries as $entry) { //for get country name start $details = maybe_unserialize($entry->details); $ExactBrowserNameUA = $details['Browser']; $ExactBrowserNameBR = $form_fields->crf_get_browser_name($ExactBrowserNameUA); $browsers_uses[] = $ExactBrowserNameBR; //for get success browser details start if (isset($details['submitted']) && $details['submitted'] == 'yes') { $browsers_success_uses[] = $ExactBrowserNameBR; //for get country name end } //for get success browser details end unset($details); $i++; } } // end pie chart for browsers //print_r($browsers_success_uses);die; $qry = "select * from {$crf_stats} where `details` LIKE '%yes%' and form_id=" . $form_id; $reg = $wpdb->get_results($qry);