eventespresso / event-espresso-core

	 *			@param string $mysql_null - allows php NULL to be overridden with MySQl's insertable NULL value

	 *			@return void

	 */

	private function fputcsv2 ($fh, array $row, $delimiter = ',', $enclosure = '"', $mysql_null = FALSE) {

		//Allow user to filter the csv delimiter and enclosure for other countries csv standards

		$delimiter = apply_filters( 'FHEE__EE_CSV__fputcsv2__delimiter', $delimiter );

		$enclosure = apply_filters( 'FHEE__EE_CSV__fputcsv2__enclosure', $enclosure );

		$delimiter_esc = preg_quote($delimiter, '/');

		$enclosure_esc = preg_quote($enclosure, '/');

		$output = array();

		foreach ($row as $field_value) {

			if(is_object($field_value) || is_array($field_value)){

				$field_value = serialize($field_value);

			}

			if ($field_value === null && $mysql_null) {

				$output[] = 'NULL';

				continue;

			}

			$output[] = preg_match("/(?:${delimiter_esc}|${enclosure_esc}|\s)/", $field_value) ?

				( $enclosure . str_replace($enclosure, $enclosure . $enclosure, $field_value) . $enclosure ) : $field_value;

		}

		fwrite($fh, join($delimiter, $output) . PHP_EOL);

	}

	 *	@param bool $mysql_null - allows php NULL to be overridden with MySQl's insertable NULL value

	 *	@return string of text for teh csv file

	 */

	public static function get_csv_row ( array $row, $delimiter = ',', $enclosure = '"', $mysql_null = false ) {

		//Allow user to filter the csv delimiter and enclosure for other countries csv standards

		$delimiter = apply_filters( 'FHEE__EE_CSV__fputcsv2__delimiter', $delimiter );

		$enclosure = apply_filters( 'FHEE__EE_CSV__fputcsv2__enclosure', $enclosure );

		$delimiter_esc = preg_quote($delimiter, '/');

		$enclosure_esc = preg_quote($enclosure, '/');

		$output = array();

		foreach ($row as $field_value) {

			if(is_object($field_value) || is_array($field_value)){

				$field_value = serialize($field_value);

			}

			if ($field_value === null && $mysql_null ) {

				$output[] = 'NULL';

				continue;

			}

			$output[] = preg_match("/(?:${delimiter_esc}|${enclosure_esc}|\s)/", $field_value) ?

				( $enclosure . str_replace($enclosure, $enclosure . $enclosure, $field_value) . $enclosure ) : $field_value;

		}

		return  implode($delimiter, $output) . PHP_EOL;

	}