hele koden ser således ud :
<html>
<head>
<title>Udskriv</title>
<style type="text/css">
body, td {
font-family:verdana;
font-size:10pt;
}
</style>
</head>
<body>
<?
$counter = -1;
function get_next() {
global $counter;
$counter = $counter + 1;
return $counter;
}
$subject_nr = $_GET["subjectnr"];
if (isset($subject_nr)) {
include('dbfunctions.inc.php');
$conn = get_connection();
$sql_statement =
"SELECT ".
" EmneNr, ".
" TelefonNr, ".
" Navn, ".
" Adresse, ".
" PostNr, ".
" By, ".
" Fødselsdag, ".
" Kronisksyg, ".
" Dagsdato, ".
" omsætning, ".
" CPR, ".
" Kontonr, ".
" Regnr, ".
" [Phoner id], ".
" Bemærkning ".
"FROM DataFraExcel ".
"WHERE EmneNr = '".$subject_nr."'";
$recordSet = &$conn->Execute($sql_statement);
if (!$recordSet) {
print $conn->ErrorMsg();
} else {
if (!$recordSet->EOF) {
$subject_nr = $recordSet->fields[get_next()];
$telephone = $recordSet->fields[get_next()];
$name = $recordSet->fields[get_next()];
$address = $recordSet->fields[get_next()];
$post_nr = $recordSet->fields[get_next()];
$town = $recordSet->fields[get_next()];
$birth_date = $recordSet->fields[get_next()];
$sick = $recordSet->fields[get_next()];
$todays_date = $recordSet->fields[get_next()];
$cash = $recordSet->fields[get_next()];
$cpr = $recordSet->fields[get_next()];
$conto_nr = $recordSet->fields[get_next()];
$reg_nr = $recordSet->fields[get_next()];
$phoner_id = $recordSet->fields[get_next()];
$remarks = $recordSet->fields[get_next()];
?>
<h1>Data er succesfuldt overført!</h1>
<table border="0">
<tr>
<td style="width:150px;">Emne nr</td>
<td><?=$subject_nr?></td>
</tr>
<tr>
<td>Telefonnr</td>
<td><?=$telephone?></td>
</tr>
<tr>
<td>Navn</td>
<td><?=$name?></td>
</tr>
<tr>
<td>Adresse</td>
<td><?=$address?></td>
</tr>
<tr>
<td>Post nr</td>
<td><?=$post_nr?></td>
</tr>
<tr>
<td>By</td>
<td><?=$town?></td>
</tr>
<tr>
<td>Fødselsdag</td>
<td><?=$birth_date?></td>
</tr>
<tr>
<td>Kronisk syg</td>
<td><?=$sick?></td>
</tr>
<tr>
<td>Dagsdato</td>
<td><?=$todays_date?></td>
</tr>
<tr>
<td>Omsætning</td>
<td><?=$cash?></td>
</tr>
<tr>
<td>CPR</td>
<td><?=$cpr?></td>
</tr>
<tr>
<td>Konto nr</td>
<td><?=$conto_nr?></td>
</tr>
<tr>
<td>Reg nr</td>
<td><?=$reg_nr?></td>
</tr>
<tr>
<td>Phoner id</td>
<td><?=$phoner_id?></td>
</tr>
<tr>
<td>Bemærkninger</td>
<td><?=$remarks?></td>
</tr>
</table>
<SCRIPT LANGUAGE="JavaScript">
<!--
alert ("hejsa");
self.focus();
self.print();
window.print();
alert ("hejsa2");
//-->
</script>
<?
}
// claus ændring
else {
?>
<p>Der er ikke indtastet emnenr, indtast venligts emnenr.</p>
<?
}
}
$recordSet->Close(); # optional
$conn->Close(); # optional
} else {
?>
<p>Forkert emne nr</p>
<?
}
?>
</body>
</html>
Ny bruger
Nybegynder
Opret
Preview
