Gegevens worden niet ge-updated of gewist
Het script laat de gegevens uit de database keurig zien, maar vervolgens geeft hij lege pagina's bij het wijzigen of het verwijderen, en wordt er niets gedaan.
Hoe kan ik dat verhelpen?
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
2
3
4
5
6
7
8
9
10
11
12
13
14
15
<?php
require ('connect.php');
if(!isset($_GET['iD'])){
$sql="SELECT * FROM programmering ORDER BY Dag, Starttijd";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
echo $sql1;
}
else {
$sql="SELECT * FROM programmering WHERE iD='".mysql_real_escape_string($_GET['iD'])."' ORDER BY Dag, Starttijd";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
echo $sql1;
}
?>
require ('connect.php');
if(!isset($_GET['iD'])){
$sql="SELECT * FROM programmering ORDER BY Dag, Starttijd";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
echo $sql1;
}
else {
$sql="SELECT * FROM programmering WHERE iD='".mysql_real_escape_string($_GET['iD'])."' ORDER BY Dag, Starttijd";
$result=mysql_query($sql);
$count=mysql_num_rows($result);
echo $sql1;
}
?>
<table border='1' class="tabel">
<tr class="titelrij">
<th>iD</th>
<th>Programma</th>
<th>Presentatie</th>
<th>Begin</th>
<th>Eind</th>
<th>Dag</th>
<th colspan="2">Edit</th>
</tr>
Code (php)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
2
3
4
5
6
7
8
9
10
11
12
13
14
15
<?php
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['iD'] . "</td>";
echo "<td>" . $row['Programma'] . "</td>";
echo "<td>" . $row['Presentatie'] . "</td>";
echo "<td>" . $row['Starttijd'] . "</td>";
echo "<td>" . $row['Stoptijd'] . "</td>";
echo "<td>" . $row['Dag'] . "</td>";
echo "<td><a href='progs_edit.php?iD=" . $row['iD'] . "'><img alt='Bewerken' src='img/ico_edit.png'></a></td>";
echo "<td><a href='progs_delete.php?iD=" . $row['iD'] . "'><img alt='Verwijderen' src='img/ico_delete.png'></a></td>";
echo "</tr>";
}
?>
while($row = mysql_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['iD'] . "</td>";
echo "<td>" . $row['Programma'] . "</td>";
echo "<td>" . $row['Presentatie'] . "</td>";
echo "<td>" . $row['Starttijd'] . "</td>";
echo "<td>" . $row['Stoptijd'] . "</td>";
echo "<td>" . $row['Dag'] . "</td>";
echo "<td><a href='progs_edit.php?iD=" . $row['iD'] . "'><img alt='Bewerken' src='img/ico_edit.png'></a></td>";
echo "<td><a href='progs_delete.php?iD=" . $row['iD'] . "'><img alt='Verwijderen' src='img/ico_delete.png'></a></td>";
echo "</tr>";
}
?>
</table>
Gewijzigd op 24/03/2011 00:16:14 door Axel Neve
