Php String Split to Array

$str = 'one,two,three,four';
$arr=explode(",",$str);
dpr($arr);

--------Result 

Array
(
    [0] => one
    [1] => two
    [2] => three
    [3] => four
)

drupal mysql insert statement

$id = db_insert('pms_link_master')
      ->fields(array(
          'NODE_ID' => '1',
          'PMS_ID' => '2',
          'CLINIC_ID' => '415',
          'MASTER_TYPE' => 'location'
  ))
  ->execute();

http://alvinalexander.com/drupal/drupal-7-db_insert-query-sql-insert-db_query

drupal custom mysql statement

 $sql_query = db_query("select * from pms_link_master");
  echo "total rows ".$sql_query->rowCount();

    $sql_array = array();
    foreach ($sql_query as $row) {
        $reaged = (array) $row; // Standard object to array    
        $sql_array[] = $reaged;
    }
dpr($sql_array);

PHP Read Folder Files

  $files = glob($dir . '*.csv');

foreach ($files as $x => $x_filepath) {
        // get file path
        $filePath = $x_filepath;
        // get file name
        $file_NAME = basename($filePath, ".csv");
}

PHP Read CSV file and store in array

function fun_readCSV($csvFile) {
    if (!file_exists($csvFile) || !is_readable($csvFile)) {
        fun_logMessage($messageID = '', $message = 'File Not Found', $mstType = 'Developer', $fieldName = '', $rowID = '');
        return FALSE;
    }
    $file_name = basename($csvFile);  // Show File Name
    echo ' File Size '.filesize($csvFile);
    $file_handle = fopen($csvFile, 'r');
    while (!feof($file_handle)) {
        $line_of_text[] = fgetcsv($file_handle, 1024);
    }
    fclose($file_handle);
    $line_of_text = array_unique($line_of_text, SORT_REGULAR);   
    print array2table($line_of_text);
    return $line_of_text;
}

PHP Drupal View to Array

function fun_View_to_Array($clinic_id, $fileType) {
    $view_get_field_details = views_get_view_result("pms_details", "page_4", $clinic_id, $fileType);
    //show_array($view_get_field_details);
    $array_field_list = array();
    if ($view_get_field_details) {
        foreach ($view_get_field_details as $fields) {
            $field_info = array();
            //print $fields->field_field_pms_field_validation_id[0]['raw']['target_id'];             

            $field_info['field_nid'] = $fields->nid;
            $field_info['field_name'] = $fields->node_title;
            $field_info['file_name'] = $fields->field_field_pms_file_name[0]['raw']['value'];
            $field_info['field_length'] = $fields->field_field_pms_field_length[0]['raw']['value'];
            $field_info['field_sequence'] = $fields->field_field_pms_field_sequence[0]['raw']['value'];
            $field_info['validation_nid'] = $fields->field_field_pms_field_validation_id[0]['raw']['target_id'];
            $field_info['clinic_id'] = $fields->field_field_pms_field_clinic_id[0]['raw']['target_id'];
            $field_info['Validation_message'] = $fields->field_field_pms_validation_message[0]['raw']['value'];
            $field_info['Validation_id'] = $fields->field_field_pms_validation_id[0]['raw']['value'];
            $array_field_list[] = $field_info;
        }
    }
    //print array2table($array_field_list);
    //show_array(array_filter($array_field_list, "Search_Function"));
    return $array_field_list;
}

array search

function findWhere($array, $matching) {
    foreach ($array as $item) {
        $is_match = true;
        foreach ($matching as $key => $value) {

            if (is_object($item)) {
                if (! isset($item->$key)) {
                    $is_match = false;
                    break;
                }
            } else {
                if (! isset($item[$key])) {
                    $is_match = false;
                    break;
                }
            }

            if (is_object($item)) {
                if ($item->$key != $value) {
                    $is_match = false;
                    break;
                }
            } else {
                if ($item[$key] != $value) {
                    $is_match = false;
                    break;
                } 
            }
        }

        if ($is_match) {
            return $item;   
        }
    }

    return false;
}

Example:

$cars = array(
    array('id' => 1, 'name' => 'Toyota'),
    array('id' => 2, 'name' => 'Ford')
);

$car = findWhere($cars, array('id' => 1));

or

$car = findWhere($cars, array(
    'id' => 1,
    'name' => 'Toyota'
));