checkbox
http://www.artz-ict.nl/database/admin/printlog.php?relid=111&hsid=111
Ik wil een paar rows uit mijn database halen en in een nieuwe pagina laden die dan vervolgens worden uitgeprint
hoe kan ik ervoor zorgen dat als je een check box aanvingt dat ze worden verzonden, ik bedoel daar ook mee dat het 1 of meerdere aangeklikt kunnen worden
Code (php)
1
2
3
4
5
6
7
8
2
3
4
5
6
7
8
<?
require "connect.php";
if ($_POST["submit"])
{
// hier komt dan zoiets //echo "<a href="/javascript:print();"/><font face='Verdana' size='2'>afdrukken</font></a>";
echo "<table border='0' cellpadding='0' style='border-collapse: collapse' width='560'>";
echo "<tr><td width='560' colspan='2'>Klant gegevens en HSid</td></tr>";
?>
require "connect.php";
if ($_POST["submit"])
{
// hier komt dan zoiets //echo "<a href="/javascript:print();"/><font face='Verdana' size='2'>afdrukken</font></a>";
echo "<table border='0' cellpadding='0' style='border-collapse: collapse' width='560'>";
echo "<tr><td width='560' colspan='2'>Klant gegevens en HSid</td></tr>";
?>
Ik weet dus niet hoe je de variablen nu kan selecteren en kan printen naar pagina
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
<?
$queryprint = mysql_query("SELECT * FROM logboek ?????
while ($result = mysql_fetch_array($queryprint))
{
echo "<tr>";
echo "<td width='140' rowspan='2'><font face='Verdana' size='1'>" . $result['gebruiker'] . "</font><br><br>Datum</td>";
echo "<td width='420'><font face='Verdana' size='1'>" . $result['onderw'] . "</font></td></tr><tr>";
echo "<td width='420'><font face='Verdana' size='1'>" . $result['oms'] . "</font></td></tr><tr>";
echo "<td height='10' width='560' colspan='2'><font size=1> </font></td>";
echo "</tr>";
}
echo "</table>";
}
else
{
echo "<table border='0' cellpadding='0' style='border-collapse: collapse' width='560' height='30'>";
echo "<tr><form method='Post' action='$php_self'>";
$query1 = mysql_query("SELECT * FROM logboek WHERE relid = '$relid' and hsid = '$hsid' order by id desc");
while ($result = mysql_fetch_array($query1))
{
echo "<td height='20' width='20' style='border:1px dashed #C0C0C0; '>";
echo "<font size='1' face='Verdana'><input type='checkbox' name='vink' value='off'></font></td>";
echo "<td height='20' width='140' style='border:1px dashed #C0C0C0; '>";
echo "<font face='Verdana' size='1'>" . $result['datum'] . "</font></td>";
echo "<td height='20' width='160' style='border:1px dashed #C0C0C0; '>";
echo "<font face='Verdana' size='1'>" . $result['onderw'] . "</font></td>";
echo "<td height='20' width='260' style='border:1px dashed #C0C0C0; '>";
echo "<font face='Verdana' size='1'>" . $result['oms'] . "</font></td></tr>";
}
echo "<tr><td colspan=4><font size='1' face='Verdana'><input type='submit' value='Printen' name='submit'> <input type='reset' value='Opnieuw' name='reset'></font></td></form></tr></table></body>";
}
?>
$queryprint = mysql_query("SELECT * FROM logboek ?????
while ($result = mysql_fetch_array($queryprint))
{
echo "<tr>";
echo "<td width='140' rowspan='2'><font face='Verdana' size='1'>" . $result['gebruiker'] . "</font><br><br>Datum</td>";
echo "<td width='420'><font face='Verdana' size='1'>" . $result['onderw'] . "</font></td></tr><tr>";
echo "<td width='420'><font face='Verdana' size='1'>" . $result['oms'] . "</font></td></tr><tr>";
echo "<td height='10' width='560' colspan='2'><font size=1> </font></td>";
echo "</tr>";
}
echo "</table>";
}
else
{
echo "<table border='0' cellpadding='0' style='border-collapse: collapse' width='560' height='30'>";
echo "<tr><form method='Post' action='$php_self'>";
$query1 = mysql_query("SELECT * FROM logboek WHERE relid = '$relid' and hsid = '$hsid' order by id desc");
while ($result = mysql_fetch_array($query1))
{
echo "<td height='20' width='20' style='border:1px dashed #C0C0C0; '>";
echo "<font size='1' face='Verdana'><input type='checkbox' name='vink' value='off'></font></td>";
echo "<td height='20' width='140' style='border:1px dashed #C0C0C0; '>";
echo "<font face='Verdana' size='1'>" . $result['datum'] . "</font></td>";
echo "<td height='20' width='160' style='border:1px dashed #C0C0C0; '>";
echo "<font face='Verdana' size='1'>" . $result['onderw'] . "</font></td>";
echo "<td height='20' width='260' style='border:1px dashed #C0C0C0; '>";
echo "<font face='Verdana' size='1'>" . $result['oms'] . "</font></td></tr>";
}
echo "<tr><td colspan=4><font size='1' face='Verdana'><input type='submit' value='Printen' name='submit'> <input type='reset' value='Opnieuw' name='reset'></font></td></form></tr></table></body>";
}
?>
Gewijzigd op 02/09/2004 13:10:00 door P.v.Denzel
Gesponsorde koppelingen:
Er zijn nog geen reacties op dit bericht.
