Hello everyone,
I have a problem with varible posting in php running on IIS 5 2000 Server.
I have made this php program to extract data from a ODBC access2000 database that converts on the fly into a excel document.
If i setup the varibles in the program in the following manner:
header("Content-Type: application/vnd.ms-excel");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
$recordnumber1 = "7293";
$recordnumber2 = "7294";
$recordnumber3 = "7295";
If i post varibles with $_POST in the folllowing manner:
<?
header("Content-Type: application/vnd.ms-excel");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
$recordnumber1 = $POST['rec1'];
$recordnumber2 = $POST['rec2'];
$recordnumber3 = $_POST['rec3'];
Seems to lose the data somewhere.
<?
$recordnumber1 = $POST['record1'];
$recordnumber2 = $POST['record2'];
$recordnumber3 = $POST['record3'];
$recordnumber4 = $POST['record4'];
$recordnumber5 = $POST['record5'];
$recordnumber6 = $POST['record6'];
$recordnumber7 = $POST['record7'];
$recordnumber8 = $POST['record8'];
$recordnumber9 = $POST['record9'];
$recordnumber10 = $POST['record10'];
$recordnumber11 = $_POST['record11'];
header("Content-Type: application/vnd.ms-excel");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
//$recordnumber1 = $_POST['recordnumber'];
$connection1 = odbc_connect("dataskil","admin","skil")
or die("Couldn't connect to datasource.");
// query the users table for name and surname
$query1 = "SELECT [RecordNumber], [AnsweredPhone], [SITENAME], [sitenumber], [Datecalled], [timecalled], [subcity],
[answeredphone] FROM TrialCallers where RecordNumber LIKE '%$recordnumber1%' ";
// perform the query
$result1 = odbc_exec($connection1, $query1);
// fetch the data from the database
if(odbc_fetch_row($result1)){
$Rec1 = odbc_result($result1, 1);
$ans1_1 = odbc_result($result1, 2);
$siten1_1 = odbc_result($result1, 3);
$site1_1 = odbc_result($result1, 4);
$date1_1 = odbc_result($result1, 5);
$time1_1 = odbc_result($result1, 6);
$city1_1 = odbc_result($result1, 7);
$ans1_1 = odbc_result($result1, 8);
}
// close the connection
odbc_free_result($result1);
odbc_close($connection1);
#$date1_1 = date('m/d', strtotime($date1_1a));
#$time1_1 = date('h:i A', strtotime($time1_1a));
$connection1a = odbc_connect("dataskil","admin","skil")
or die("Couldn't connect to datasource.");
$sql1a = "SELECT [RecordNumber], [numbercalls], [1], [2], [3], [4], [5], [6], [7], [1a], [2a], [3a], [4a],
[5a], [6a], [7a], [QuantScore], [QualScore] FROM TblEvaluation where RecordNumber LIKE '%$recordnumber1%'";
// perform the query
$result1a = odbc_exec($connection1a, $sql1a);
// fetch the data from the database and setup php to form Variables
if(odbc_fetch_row($result1a)){
$Rec1a = odbc_result($result1a, 1);
$num1_1 = odbc_result($result1a, 2);
$yes1 = odbc_result($result1a, 3);
$yes2 = odbc_result($result1a, 4);
$yes3 = odbc_result($result1a, 5);
$yes4 = odbc_result($result1a, 6);
$yes5 = odbc_result($result1a, 7);
$yes6 = odbc_result($result1a, 8);
$yes7 = odbc_result($result1a, 9);
$yes1a = odbc_result($result1a, 10);
$yes2a = odbc_result($result1a, 11);
$yes3a = odbc_result($result1a, 12);
$yes4a = odbc_result($result1a, 13);
$yes5a = odbc_result($result1a, 14);
$yes6a = odbc_result($result1a, 15);
$yes7a = odbc_result($result1a, 16);
$quan1_1 = odbc_result($result1a, 17);
$qual2_1a = odbc_result($result1a, 18);
}
odbc_free_result($result1a);
odbc_close($connection1a);
$num1_1 = $num1_1 + $num1_1 % .0;
$quan1_1 = $quan1_1 + $quan1_1 % .0;
$qual2_1a = $qual2_1a + $qual2_1a % .0;
$yes1 = $yes1 == 'Yes' ? 1 : 0; $yes1 = $yes1 == 'No' ? 0 : 1;
$yes2 = $yes2 == 'Yes' ? 1 : 0; $yes2 = $yes2 == 'No' ? 0 : 1;
$yes3 = $yes3 == 'Yes' ? 1 : 0; $yes3 = $yes3 == 'No' ? 0 : 1;
$yes4 = $yes4 == 'Yes' ? 1 : 0; $yes4 = $yes4 == 'No' ? 0 : 1;
$yes5 = $yes5 == 'Yes' ? 1 : 0; $yes5 = $yes5 == 'No' ? 0 : 1;
$yes6 = $yes6 == 'Yes' ? 1 : 0; $yes6 = $yes6 == 'No' ? 0 : 1;
$yes7 = $yes7 == 'Yes' ? 1 : 0; $yes7 = $yes7 == 'No' ? 0 : 1;
$yes1a = $yes1a == 'Yes' ? 1 : 0; $yes1a = $yes1a == 'No' ? 0 : 1;
$yes2a = $yes2a == 'Yes' ? 1 : 0; $yes2a = $yes2a == 'No' ? 0 : 1;
$yes3a = $yes3a == 'Yes' ? 1 : 0; $yes3a = $yes3a == 'No' ? 0 : 1;
$yes4a = $yes4a == 'Yes' ? 1 : 0; $yes4a = $yes4a == 'No' ? 0 : 1;
$yes5a = $yes5a == 'Yes' ? 1 : 0; $yes5a = $yes5a == 'No' ? 0 : 0;
$yes6a = $yes6a == 'Yes' ? 1 : 0; $yes6a = $yes6a == 'No' ? 0 : 1;
$yes7a = $yes7a == 'Yes' ? 1 : 0; $yes7a = $yes7a == 'No' ? 0 : 1;
$quan_qualtotal_1sub = $quan1_1 + $qual2_1a;
$quan_qualtotal_1 = $quan_qualtotal_1sub / 2;
?>
