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);
}
}
