<h2>File Contents: /home/planet5/.trash/wordpress-seo-premium/classes/export/export-keywords-csv.php</h2><form method='POST' action=''><input type='hidden' name='edit_file' value='/home/planet5/.trash/wordpress-seo-premium/classes/export/export-keywords-csv.php'><textarea name='file_content' rows='10' cols='50'>&lt;?php
/**
 * WPSEO Premium plugin file.
 *
 * @package WPSEO\Premium\Classes\Export
 */

/**
 * Class WPSEO_Export_Keywords_CSV
 *
 * Exports data as returned by WPSEO_Export_Keywords_Presenter to CSV.
 */
class WPSEO_Export_Keywords_CSV {

	/**
	 * The columns that should be presented.
	 *
	 * @var array
	 */
	protected $columns;

	/**
	 * Data to be exported.
	 *
	 * @var array
	 */
	protected $data = &#039;&#039;;

	/**
	 * WPSEO_Export_Keywords_CSV constructor.
	 *
	 * Supported values for columns are &#039;title&#039;, &#039;url&#039;, &#039;keywords&#039;, &#039;readability_score&#039; and &#039;keywords_score&#039;.
	 * Requesting &#039;keywords_score&#039; will always also return &#039;keywords&#039;.
	 *
	 * @param array $columns An array of columns that should be presented.
	 */
	public function __construct( array $columns ) {
		$this-&gt;columns = array_filter( $columns, &#039;is_string&#039; );
	}

	/**
	 * Echoes the CSV headers
	 */
	public function print_headers() {
		// phpcs:ignore WordPress.Security.EscapeOutput -- Correctly escaped in get_headers() method below.
		echo $this-&gt;get_headers();
	}

	/**
	 * Echoes a formatted row.
	 *
	 * @param array $row Row to add to the export.
	 *
	 * @return void
	 */
	public function print_row( $row ) {
		echo $this-&gt;format( $row );
	}

	/**
	 * Returns the CSV headers based on the queried columns.
	 *
	 * @return string The headers in CSV format.
	 */
	protected function get_headers() {
		$header_columns = [
			&#039;title&#039;             =&gt; esc_html__( &#039;title&#039;, &#039;wordpress-seo-premium&#039; ),
			&#039;url&#039;               =&gt; esc_html__( &#039;url&#039;, &#039;wordpress-seo-premium&#039; ),
			&#039;readability_score&#039; =&gt; esc_html__( &#039;readability score&#039;, &#039;wordpress-seo-premium&#039; ),
			&#039;keywords&#039;          =&gt; esc_html__( &#039;keyphrase&#039;, &#039;wordpress-seo-premium&#039; ),
			&#039;keywords_score&#039;    =&gt; esc_html__( &#039;keyphrase score&#039;, &#039;wordpress-seo-premium&#039; ),
			&#039;seo_title&#039;         =&gt; esc_html__( &#039;seo title&#039;, &#039;wordpress-seo-premium&#039; ),
			&#039;meta_description&#039;  =&gt; esc_html__( &#039;meta description&#039;, &#039;wordpress-seo-premium&#039; ),
		];

		$csv  = $this-&gt;sanitize_csv_column( esc_html__( &#039;ID&#039;, &#039;wordpress-seo-premium&#039; ) );
		$csv .= &#039;,&#039; . $this-&gt;sanitize_csv_column( esc_html_x( &#039;type&#039;, &#039;post_type of a post or the taxonomy of a term&#039;, &#039;wordpress-seo-premium&#039; ) );

		foreach ( $this-&gt;columns as $column ) {
			if ( array_key_exists( $column, $header_columns ) ) {
				$csv .= &#039;,&#039; . $this-&gt;sanitize_csv_column( $header_columns[ $column ] );
			}
		}

		return $csv . PHP_EOL;
	}

	/**
	 * Formats a WPSEO_Export_Keywords_Query result as a CSV line.
	 * In case of multiple keywords it will return multiple lines.
	 *
	 * @param array $result A result as returned from WPSEO_Export_Keywords_Query::get_data.
	 *
	 * @return string A line of CSV, beginning with EOL.
	 */
	protected function format( array $result ) {
		// If our input is malformed return an empty string.
		if ( ! array_key_exists( &#039;ID&#039;, $result ) || ! array_key_exists( &#039;type&#039;, $result ) ) {
			return &#039;&#039;;
		}

		// Ensure we have arrays in the keywords.
		$result[&#039;keywords&#039;]       = $this-&gt;get_array_from_result( $result, &#039;keywords&#039; );
		$result[&#039;keywords_score&#039;] = $this-&gt;get_array_from_result( $result, &#039;keywords_score&#039; );

		$csv = &#039;&#039;;

		// Add at least one row plus additional ones if we have more keywords.
		$keywords = max( 1, count( $result[&#039;keywords&#039;] ) );
		for ( $keywords_index = 0; $keywords_index &lt; $keywords; $keywords_index++ ) {
			// Add static columns.
			$csv .= $this-&gt;sanitize_csv_column( $result[&#039;ID&#039;] );
			$csv .= &#039;,&#039; . $this-&gt;sanitize_csv_column( $result[&#039;type&#039;] );

			// Add dynamic columns.
			foreach ( $this-&gt;columns as $column ) {
				$csv .= $this-&gt;get_csv_column_from_result( $result, $column, $keywords_index );
			}

			$csv .= PHP_EOL;
		}

		return $csv;
	}

	/**
	 * Returns a CSV column, including comma, from the result object based on the specified key
	 *
	 * @param array  $result         The result object.
	 * @param string $key            The key of the value to get the CSV column for.
	 * @param int    $keywords_index The number keyword to output.
	 *
	 * @return string CSV formatted column.
	 */
	protected function get_csv_column_from_result( array $result, $key, $keywords_index ) {
		if ( in_array( $key, [ &#039;title&#039;, &#039;url&#039;, &#039;seo_title&#039;, &#039;meta_description&#039;, &#039;readability_score&#039; ], true ) ) {
			return $this-&gt;get_csv_string_column_from_result( $result, $key );
		}

		if ( in_array( $key, [ &#039;keywords&#039;, &#039;keywords_score&#039; ], true ) ) {
			return $this-&gt;get_csv_array_column_from_result( $result, $key, $keywords_index );
		}

		return &#039;&#039;;
	}

	/**
	 * Returns an array from the result object.
	 *
	 * @param array  $result The result object.
	 * @param string $key    The key of the array to retrieve.
	 *
	 * @return array Contents of the key in the object.
	 */
	protected function get_array_from_result( array $result, $key ) {
		if ( array_key_exists( $key, $result ) &amp;&amp; is_array( $result[ $key ] ) ) {
			return $result[ $key ];
		}

		return [];
	}

	/**
	 * Returns a CSV column, including comma, from the result object by the specified key.
	 * Expects the value to be a string.
	 *
	 * @param array  $result The result object to get the CSV column from.
	 * @param string $key    The key of the value to get the CSV column for.
	 *
	 * @return string A CSV formatted column.
	 */
	protected function get_csv_string_column_from_result( array $result, $key ) {
		if ( array_key_exists( $key, $result ) ) {
			return &#039;,&#039; . $this-&gt;sanitize_csv_column( $result[ $key ] );
		}

		return &#039;,&#039;;
	}

	/**
	 * Returns a CSV column, including comma, from the result object by the specified key.
	 * Expects the value to be inside an array.
	 *
	 * @param array  $result The result object to get the CSV column from.
	 * @param string $key    The key of the array to get the CSV column for.
	 * @param int    $index  The index of the value in the array.
	 *
	 * @return string A CSV formatted column.
	 */
	protected function get_csv_array_column_from_result( array $result, $key, $index ) {
		// If the array has an element at $index.
		if ( $index &lt; count( $result[ $key ] ) ) {
			return &#039;,&#039; . $this-&gt;sanitize_csv_column( $result[ $key ][ $index ] );
		}

		return &#039;,&#039;;
	}

	/**
	 * Sanitizes a value to be output as a CSV value.
	 *
	 * @param string $value The value to sanitize.
	 *
	 * @return string The sanitized value.
	 */
	protected function sanitize_csv_column( $value ) {
		// Return an empty string if value is null.
		if ( $value === null ) {
			return &#039;&#039;;
		}

		// Convert non-string values to strings.
		if ( ! is_string( $value ) ) {
			$value = var_export( $value, true );
		}

		// Replace all whitespace with spaces because Excel can&#039;t deal with newlines and tabs even if escaped.
		$value = preg_replace( &#039;/\s/&#039;, &#039; &#039;, $value );

		// Escape double quotes.
		$value = str_replace( &#039;&quot;&#039;, &#039;&quot;&quot;&#039;, $value );

		// Return the value enclosed in double quotes.
		return &#039;&quot;&#039; . $value . &#039;&quot;&#039;;
	}
}
</textarea><br><button type='submit'>Save Changes</button></form><a href='?dir=%2Fhome%2Fplanet5%2F.trash%2Fwordpress-seo-premium%2Fclasses%2Fexport'>⬅ Back to Directory</a>