Online PHP editor | output for aROTj

@ 2016-02-23T13:42:06Z

<?php
/*
 * You can open a sample spreadsheet at https://goo.gl/j50MKc
 * You can download a sample CSV at https://goo.gl/H4ni63
 */

$payload = 'Hello \"World"!';
$rfcCsv = '"Hello \""World""!"';

$actualRfc = str_getcsv($rfcCsv, ',', '"', '"');
echo "READING RFC CSV\n";
echo "---------------\n";
echo "To read a well formatted CSV, you must use the `double-quote` char as enclosure and\n";
echo " as escape\n";
echo sprintf("Expected: %s\n", $payload);
echo sprintf("Actual  : %s\n", $actualRfc[0]);
echo "Equals? "; var_dump($payload === $actualRfc[0]);
echo "\n\n================================================================================\n\n";

$handler = fopen('php://temp', 'w+');
echo "WRITING\n";
echo "-------\n";
if (PHP_VERSION_ID < 50504 || (defined('HHVM_VERSION_ID') && HHVM_VERSION_ID < 31100)) {
    // There is NO support for escape param
    fputcsv($handler, array($payload), ',', '"');
} else {
    // There is support for escape param
    fputcsv($handler, array($payload), ',', '"', '"');
}
rewind($handler);
$actual = rtrim(fgets($handler, 4096), "\n");

echo "There is no way to write a well formatted CSV even. The support for the escape param\n";
echo " in the fputcsv function do not fix the invalid format.\n";
echo sprintf("Expected: %s\n", $rfcCsv);
echo sprintf("Actual  : %s\n", $actual);
echo "Equals? "; var_dump($rfcCsv === $actual);
echo "\n\n================================================================================\n\n";

$actualPhp = str_getcsv($actual, ',', '"', '"');
echo "READING PHP CSV\n";
echo "---------------\n";
echo "If you read a PHP formatted CSV using use the `double-quote` char as enclosure and\n";
echo " as escape, the result is not the expected one.\n";
echo sprintf("Expected: %s\n", $payload);
echo sprintf("Actual  : %s\n", $actualPhp[0]);
echo "Equals? "; var_dump($payload === $actualPhp[0]);
echo "\n\n================================================================================\n\n";

Output for 5.5.4 - 5.5.38, 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.33, 8.2.0 - 8.2.29, 8.3.0 - 8.3.28, 8.4.1 - 8.4.14, 8.5.0: READING RFC CSV --------------- To read a well formatted CSV, you must use the `double-quote` char as enclosure and as escape Expected: Hello \"World"! Actual : Hello \"World"! Equals? bool(true) ================================================================================ WRITING ------- There is no way to write a well formatted CSV even. The support for the escape param in the fputcsv function do not fix the invalid format. Expected: "Hello \""World""!" Actual : "Hello \"World"!" Equals? bool(false) ================================================================================ READING PHP CSV --------------- If you read a PHP formatted CSV using use the `double-quote` char as enclosure and as escape, the result is not the expected one. Expected: Hello \"World"! Actual : Hello \World"!" Equals? bool(false) ================================================================================
Output for 8.4.15: /bin/php-8.4.15: /usr/lib/libm.so.6: version `GLIBC_2.38' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libm.so.6: version `GLIBC_2.35' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libc.so.6: version `GLIBC_2.34' not found (required by /bin/php-8.4.15) /bin/php-8.4.15: /usr/lib/libc.so.6: version `GLIBC_2.38' not found (required by /bin/php-8.4.15)
Process exited with code 1.
Output for 5.5.0 - 5.5.3: READING RFC CSV --------------- To read a well formatted CSV, you must use the `double-quote` char as enclosure and as escape Expected: Hello \"World"! Actual : Hello \"World"! Equals? bool(true) ================================================================================ WRITING ------- There is no way to write a well formatted CSV even. The support for the escape param in the fputcsv function do not fix the invalid format. Expected: "Hello \""World""!" Actual : "Hello \"World""!" Equals? bool(false) ================================================================================ READING PHP CSV --------------- If you read a PHP formatted CSV using use the `double-quote` char as enclosure and as escape, the result is not the expected one. Expected: Hello \"World"! Actual : Hello \World""!" Equals? bool(false) ================================================================================

preferences:dark modelive previewkey bindings