query("delete from ".$wpdb->prefix."crumsubscribe where id = '".$wpdb->escape($id)."' limit 1"); $count++; } $message = $count." subscribers have been removed successfully."; } } if ($_SERVER['REQUEST_METHOD']=="POST" and $_POST['crum_import']) { $correct = 0; if($_FILES['file']['tmp_name']) { if(!$_FILES['file']['error']) { $file = file_get_contents ($_FILES['file']['tmp_name']); $lines = preg_split('/\r\n|\r|\n/', $file); if (count($lines)) { $sql = array(); foreach ($lines as $data) { $data = explode(',', $data); $num = count($data); $row++; if (is_email(trim($data[0]))) { $c = $wpdb->get_row("SELECT * FROM ".$wpdb->prefix."crumsubscribe where crum_email LIKE '".$wpdb->escape(trim($data[0]))."' limit 1", ARRAY_A); if (!is_array($c)) { $wpdb->query("INSERT INTO ".$wpdb->prefix."crumsubscribe (crum_email) VALUES ('".$wpdb->escape(trim($data[0]))."')"); $correct++; } else { $exists++; } } else { $invalid++; } } } else { $message = 'Oh no! Your CSV file does not apear to be valid, please check the format and upload again.'; } if (!$message) { $message = $correct.' records have been imported. '.($invalid?$invalid.' could not be imported due to invalid email addresses. ':'').($exists?$exists.' already exists. ':''); } } else { $message = 'Ooops! There seems to of been a problem uploading your csv'; } } } //echo $sql; if ($message) { echo '

'.$message.'

'; } ?> get_results( "SELECT * FROM ".$wpdb->prefix."crumsubscribe"); if (count($results)<1) echo ''; else { foreach($results as $row) { echo ''; /**/ echo ''; } } ?>



'.esc_html__('No mailing list subscribers have been added.','polo_extension').'
	'.esc_js(esc_html($row->crum_email)).'	'.esc_js(esc_html($row->crum_name)).'

Ubuntu

Your Subscribers