Exemple #1
0
$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);