[insert_php]
// load folder with file names in uploads directory
global $wpdb;
$uploads = wp_upload_dir();
$m_brain_name=’m819′;
$m_label =’F’;
$m_brain_id=’819′;
$jp2_image_folder = $m_brain_name.’/’.$m_brain_name.$m_label.’/JP2′;
$roi_image_folder = $m_brain_name.’/’.$m_brain_name.$m_label.’/ROI’;
$new_images_jp2 = array();
$new_images_roi = array();
$scan_jp2 = scandir($uploads[‘basedir’].’/’.$jp2_image_folder.’/’);
$scan_roi = scandir($uploads[‘basedir’].’/’.$roi_image_folder.’/’);
foreach($scan_jp2 as $file){
if (!is_dir($file)){
$new_images_jp2[] = $file;
}
}
sort($new_images_jp2, SORT_NATURAL | SORT_FLAG_CASE);
foreach($scan_roi as $file2){
if (!is_dir($file2)){
$new_images_roi[] = $file2;
}
}
sort($new_images_roi, SORT_NATURAL | SORT_FLAG_CASE);
$count_image_jp2 = count($new_images_jp2);
$match_count = 0;

foreach($new_images_roi as $image_roi) {
$mach_file_to_cropping_image = explode(‘ – ‘, $image_roi, 2)[1];
$mach_file_to_cropping_image = str_replace(“_macro.jpg”,””,$mach_file_to_cropping_image);
$mach_file_to_cropping_image = ‘M’.$m_brain_id.’-‘.$mach_file_to_cropping_image;
//echo $mach_file_to_cropping_image.’
‘;
$match_index = explode(‘-‘, $mach_file_to_cropping_image, 2)[1];
if($m_brain_id==’819’){
$match_index = explode(‘N’, $match_index, 2)[1];
}else{
$match_index = explode($m_label, $match_index, 2)[1];
}
//echo $match_index.’
‘;
}

foreach($new_images_jp2 as $image_jp2) {
$m_du_section = $wpdb->get_results(“SELECT * FROM Navigator_section WHERE filename LIKE ‘$image_jp2’ AND brain_id=$m_brain_id AND label=$m_label”);
//echo $image_jp2;
if(count($m_du_section) == 0){
echo ‘No Data
‘;
}else{
echo ‘Yes. with Data
‘;
}
}
[/insert_php]