Hi
does anyone have an solution for my problem
When someone fills in the checkboxes and then enters the ok button
the data will be saved in a database.
But when someone fills in the checkboxes (and before saving the checkboxes in the database the user changes the sorting of the data by clicking the small arrows on top of the list) all the checks are gone and the user can start all over again checking the boxes.
these are my two code files openstaand.php and control.php
openstaand.php:
<html>
<head>
<title>FM mobiele telefonie registratie systeem</title>
<link rel="stylesheet" type="text/css" href="/cmt/sites/web/css/form.css">
<meta http-equiv="pragma" content="no-cache">
</head>
<body bgcolor="#FFFFFF" text="#000040" link="#000080" vlink="#800080" style="font-family: Arial; font-size: 10pt">
<?
include("config.php");
$gebruikersnaam = $_SERVER['PHP_AUTH_USER'] ;
$connection = mssql_connect($db_hostname, $db_username, $db_password);
$db = mssql_select_db($db_name, $connection);
$sql = "EXEC spPHPPersCnt $gebruikersnaam";
$result = mssql_query($sql,$connection);
$row = mssql_fetch_array($result);
$persoonsid = $row["lngPersCnt"];
if ($row['strMobNr']=="")
{
echo '
<p align="center"><img src="images/hr_logo.gif"></p>
<h1 align="center"><font face="Verdana">FM mobiele telefonie registratie systeem</font></h1>
<p align="center"><font face="Verdana" size="1">
U heeft nog geen GSM van Holland Railconsult in gebruik<br>
Mocht u van mening zijn dat dit onjuist is, Neem dan contact op met FM.
</p>';
}
else
{
echo '
<p align="center"><img src="images/hr_logo.gif"></p>
<h3 align="center"><font face="Verdana">FM mobiele telefonie registratie systeem</font></h3>
<p align="center"><font face="Verdana" size="1">
PersoonsID: <b>'.$persoonsid.'</b>
Gebruiker: <b>'.$gebruikersnaam.'</b>
Personeelsnummer: <b>'.$row["lngPersNr"].'</b>
Naam: <b>'.$row["estrNameFull"].'</b><br>
Telefoonnummer(s): <b>';
$result = mssql_query($sql,$connection);
while ($row = mssql_fetch_array($result))
{
echo ' ';
echo $row["strMobNr"];
echo ' ';
}
echo'
</P>';
if ($sort == "")
{
$sql = "EXEC spPHPFiatCalls $persoonsid,$periode";
$result = mssql_query($sql,$connection);
}
else
{
$sql = "EXEC $sort $persoonsid,$periode";
$result = mssql_query($sql,$connection);
}
echo '<P align="center"><B>Declaratiemaand: '.$periode.'</B></P>';
echo '
<form method="POST" action="control.php?periode='.$periode.'&persoonsid='.$persoonsid.'">
<center>
<table border=0 width=100%>
<tr>
<td><p align=center><font face="Verdana" size="1"><b>Datum </B><br><A HREF="openstaand.php?sort=spPHPFiatCallsDateAsc&periode='.$periode.'&persoonsid='.$persoonsid.'"> <img src="images/ascending.gif" width="8" height="8" border="0"></A> <A HREF="openstaand.php?sort=spPHPFiatCallsDateDesc&periode='.$periode.'&persoonsid='.$persoonsid.'"> <img src="images/descending.gif" width="8" height="8" border="0"></A></td>
<td><p align=center><font face="Verdana" size="1"><b>Tijdstip </B><br> </td>
<td><p align=center><font face="Verdana" size="1"><b>Mobielnummer </B><br> </td>
<td><p align=center><font face="Verdana" size="1"><b>Type </B><br><A HREF="openstaand.php?sort=spPHPFiatCallsTypeAsc&periode='.$periode.'&persoonsid='.$persoonsid.'"> <img src="images/ascending.gif" width="8" height="8" border="0"></A> <A HREF="openstaand.php?sort=spPHPFiatCallsTypeDesc&periode='.$periode.'&persoonsid='.$persoonsid.'"> <img src="images/descending.gif" width="8" height="8" border="0"></A></td>
<td><p align=center><font face="Verdana" size="1"><b>Gebeld nummer</B><br><A HREF="openstaand.php?sort=spPHPFiatCallsCalledNbrAsc&periode='.$periode.'&persoonsid='.$persoonsid.'"> <img src="images/ascending.gif" width="8" height="8" border="0"></A> <A HREF="openstaand.php?sort=spPHPFiatCallsDateDesc&periode='.$periode.'&persoonsid='.$persoonsid.'"> <img src="images/descending.gif" width="8" height="8" border="0"></A></td>
<td><p align=center><font face="Verdana" size="1"><b>Tijd </B><br> </td>
<td><p align=center><font face="Verdana" size="1"><b>Bedrag </B><br> </td>
<td><p align=center><font face="Verdana" size="1"><b>Prive </B><br> </td>
</tr>';
while ($row = mssql_fetch_array($result))
{
if ($row["blnPrivateCall"] == 0)
echo '
<tr></tr><tr>
<td><p align=center><font face="Verdana" size="1">'.strftime("%A %e %B %Y", strtotime($row["dtmCallDate"])).'</td>
<td><p align=center><font face="Verdana" size="1">'.$row["dtmCallTime"].'</td>
<td><p align=center><font face="Verdana" size="1">'.$row["strMobNbr"].'</td>
<td><p align=center><font face="Verdana" size="1">'.$row["strCallType"].'</td>
<td><p align=center><font face="Verdana" size="1">'.$row["strCalledNbr"].'</td>
<td><p align=center><font face="Verdana" size="1">'.$row["lngSeconds"].'</td>
<td><p align=center><font face="Verdana" size="1">€ '.$row["curAmount"].'</td>
<input type="hidden" name="amount[]" value='.$row["curAmount"].'></td>
<td><p align=center><font face="Verdana" size="1">
<input type="checkbox" value='.$row["lngCallCnt"].' name="prive[]"></td>';
else
echo '
<tr>
<td><p align=center><font face="Verdana" size="1">'.strftime("%A %e %B %Y", strtotime($row["dtmCallDate"])).'</td>
<td><p align=center><font face="Verdana" size="1">'.$row["dtmCallTime"].'</td>
<td><p align=center><font face="Verdana" size="1">'.$row["strMobNbr"].'</td>
<td><p align=center><font face="Verdana" size="1">'.$row["strCallType"].'</td>
<td><p align=center><font face="Verdana" size="1">'.$row["strCalledNbr"].'</td>
<td><p align=center><font face="Verdana" size="1">'.$row["lngSeconds"].'</td>
<td><p align=center><font face="Verdana" size="1">€ '.$row["curAmount"].'</td>
<input type="hidden" name="amount[]" value='.$row["curAmount"].'></td>
<td><p align=center><font face="Verdana" size="1">
<input type="checkbox" value='.$row["lngCallCnt"].' name="prive[]" checked></td>';
}
$sql = "EXEC spPHPTotalMonth $persoonsid,$periode";
$result = mssql_query($sql,$connection);
$row = mssql_fetch_array($result);
echo '
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td><p align=left><font face="Verdana" size="1"><b>_______________</b></td>
</tr>
<tr>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td><p align=left><font face="Verdana" size="1"><b>Totaal EUR '.$row["expCurAmount"].' </b></td>
<td></td></tr>
';
}
echo '</table><p><input type="submit" value="Ok" name="ok"><input type="reset" value="Wissen" name="wissen"></form>';
mssql_close($connection);
?>
control.php
<HTML>
<HEAD>
<title>FM mobiele telefonie registratie systeem</title>
<link rel="stylesheet" type="text/css" href="/cmt/sites/web/css/form.css">
<meta http-equiv="pragma" content="no-cache">
</HEAD>
<BODY>
<H3>Verwerken formulier</H3>
<?php
include("config.php");
// Database connectie openen
$connection = mssql_connect($db_hostname, $db_username, $db_password);
$db = mssql_select_db($db_name, $connection);
// Update hele set voor persoonsid en periode
$sql = "EXEC dbo.spPHPUpdateSetFalse $persoonsid,$periode";
mssql_query($sql, $connection);
// Input formulier checked => updaten
foreach ($_POST['prive'] as $value)
{
$sql2 = "EXEC dbo.spPHPUpdateSetTrue $value";
mssql_query($sql2, $connection);
}
// Updaten Medewerker fiat check
$sql3 = "EXEC dbo.spPHPUpdateSetFiatMedTrue $persoonsid,$periode";
mssql_query($sql3, $connection);
// Opvragen totaal van door medewerker gefiatteerde telefoongesprekken
$sql4 = "EXEC dbo.spPHPSumPrivateCalls $persoonsid";
$result = mssql_query($sql4, $connection);
$row = mssql_fetch_array($result);
$som = $row["Som"];
//Database connectie sluiten
mssql_close($connection);
echo '<P>De door u opgegeven privé telefoongesprekken zijn verwerkt in de database.</P>';
if ($som >= 20)
{
echo '
<P>total EUR '.$som.'
<BR>Dit totaal kan meerdere periodes beslaan.
<BR><a href="printform.php">Klik hier om nu het formulier af te drukken.</a></P>
';
};
?>
<BR><BR><BR><BR><BR><BR>
<P><A HREF="index.php">Terug naar het hoofdmenu.</A></P>
</BODY>
</HTML>
