----- Original Message -----
From: "Brian E Boothe"
if i fill out a online form that i made how can i get it to transpose
values to an excel Spreadsheet ??
-----------------------------
Hello Brian,
I did respond before but it didn't get through so I will
try it again.
Previous post -
<?php
// This file is testform.php
//No sessions so only one document can be stored
//Freehand so no security checks and probably some typo's
//just an example - better to use loops
$r1c1 = "";
$r1c2 = "";
$r2c1 = "";
$r2c2 = "";
if (isset($_POST['r1c1'])) {$r1c1 = $_POST['r1c1'];}
if (isset($_POST['r1c2'])) {$r1c1 = $_POST['r1c2'];}
if (isset($_POST['r2c1'])) {$r1c1 = $_POST['r2c1'];}
if (isset($_POST['r2c2'])) {$r1c1 = $_POST['r2c2'];}
$csv = '"' . $r1c1 . '","' . $r1c2 . '"' . "\r\n";
$csv .= '"' . $r2c1 . '","' . $r2c2 . '"' . "\r\n";
fh$=fopen("spreadsheet.csv", "w");
fwrite($fh, $csv);
fclose($fh);
echo("<html><head></head><body>\n");
echo('<a href="spreadsheet.csv" target="csv">');
echo("Right Click to download</a>\n");
echo("<br><br>\n");
echo('<form action="testform.php" method="POST">' . "\n");
echo("<table>\n");
echo("<tr><td>\n");
echo('<input name="r1c1" type="text" value="' . $r1c1 .'"><br>' . "\n");
echo("</td><td>\n");
echo('<input name="r1c2" type="text" value="' . $r1c2 .'"><br>' . "\n");
echo("</td></tr><tr><td>\n");
echo('<input name="r2c1" type="text" value="' . $r2c1 .'"><br>' . "\n");
echo("</td><td>\n");
echo('<input name="r2c2" type="text" value="' . $r2c2 .'"><br>' . "\n");
echo("</td></tr>\n");
echo("</table><br><br>\n");
echo('<input name="submit" type="Submit" value="Update">' . "\n");
echo("</body></html>\n");
?>
