arrays - How to get directory name from file path using php

Solution:

This looks like a plain string operation:

1. split the string
2. get the desired element

Maybe like this:

$s = '/documentLibrary/work/marketingProcess/BusinessMarketing/Design/Images/02_Product_Images/04_SHORT-RANGE/NINA/01_NINA-B1/source_WEB';

$a = explode(DIRECTORY_SEPARATOR, dirname($s)); //removes source_WEB and splits the string

echo array_pop($a); //gets the last element '01_NINA-B1'
Copy code

Demo

Solution:

Is this drupal? from my research I found out that db_select is a drupal function.

Can you try this one? it will attempt to explode the path string and find the second last element, if none is found it will return "N/A"

 $query = db_select('network_drive','networkd');
 $query
->fields('networkd', array('path'))
->condition('ndid',$networkdriveid,'=')
->orderBy('networkd.ndid');
$results = $query->execute();
foreach($results as $result){ 
    $array = explode("\\", $result->path);
    echo isset($array[count($array) - 2]) ? $array[count($array) - 2] : "N/A";
}
Copy code