function makeTheDocument($key) { $feed = "http://docs.google.com/spreadsheet/pub?key=" . $key . "&output=csv"; $row = 1; $keys = array(); if (($handle = fopen($feed, "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $num = count($data); if ($row < 2) { //make the keys for ($c = 0; $c < $num; $c++) { //echo $c; $keys[$c] = $data[$c]; //echo $keys[$c]; //echo "<br>"; } $row++; } else { $num = count($data); //echo "<p> $num fields in line $row: <br /></p>\n"; $row++; //echo '<div class = aScene>'; //echo $data[4]; //echo '</div>'; echo '<div class = aScene>'; for ($c = 0; $c < $num; $c++) { //loops through switch ($c) { default: $thisData = nl2br($data[$c]); //translates the strings to have the correct line breaks $thisData = correct_encoding($thisData); $thisData = htmlentities($thisData); echo "<p class = \"{$keys[$c]}\">" . $thisData . "</p>" . "\n"; case 0: $thisData = nl2br($data[$c]); echo "<Div class = \"{$keys[$c]}\">" . $thisData . "</Div>" . "\n"; break; // // echo "<p class = \"$keys[$c]\">" . $thisData . "</p>" . "\n"; } //end switch } echo "</div>"; } } fclose($handle); } }
function makeTheDocument($key) { $feed = "http://docs.google.com/spreadsheet/pub?key=" . $key . "&output=csv"; $row = 1; $keys = array(); if (($handle = fopen($feed, "r")) !== FALSE) { while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) { $num = count($data); if ($row < 2) { //make the keys for ($c = 0; $c < $num; $c++) { //echo $c; $keys[$c] = $data[$c]; //echo $keys[$c]; //echo "<br>"; } $row++; } else { $num = count($data); //echo "<p> $num fields in line $row: <br /></p>\n"; $row++; echo '<div class="aScene">'; for ($c = 0; $c < $num; $c++) { $thisData = nl2br($data[$c]); //translates the strings to have the correct line breaks $thisData = correct_encoding($thisData); $thisData = htmlentities($thisData); //$thisData = str_replace("'","'",$thisData); //$thisData = addslashes($thisData); //$thisData = htmlspecialchars($thisData, ENT_QUOTES); //$thisData = html_entity_decode($thisData); echo "<p class = \"{$keys[$c]}\">" . $thisData . "</p>" . "\n"; // echo "<p class = \"$keys[$c]\">" . $thisData . "</p>" . "\n"; } echo "</div>"; } } fclose($handle); } }