pdo statements
Blindmenü-list
bmenu.php
<?php
Administrator zugang öffnen
if (isset($_SESSION['id']) && $_SESSION['id']==1)
{
Sprung variable setzen
if($jumpi=='blind')
{
Tabellenkopf
echo'<table class="table">';
echo'<tr>';
echo'<th colspan="3">Blind-Menue</th>';
echo'<th colspan="3">';
echo'<a href="index.php?page=99&jump=3&jumpi=bnew&jumps=bneu">Blind-Menüpunkt erstellen</a>';
echo'</th>';
echo'</tr>';
echo'<tr class="big">';
echo'<td>ID</td>';
echo'<td>Menüname</td>';
echo'<td>wohin</td>';
echo'<td>Edit</td>';
echo'<td>Del</td>';
echo'</tr>';
Datenbank abfrage
$stmt = $pdo->prepare("SELECT id, labels, ziels, linken_url FROM blind_menu ORDER BY id");
$stmt->bindColumn(1,$bmen_id);
$stmt->bindColumn(2,$m_labels);
$stmt->bindColumn(3,$m_ziels);
$stmt->bindColumn(4,$m_links);
$stmt->execute();
Daten ausgabe
while($stmt->fetch())
{
echo'<tr>';
echo'<td>'.$bmen_id.'</td>';
echo'<td>'.$m_labels.'</td>';
echo'<td>'.$m_links.'</td>';
echo'<td>';
echo'<a href="index.php?page=99&jump=3&jumpi=brecht&bmen_id='.$bmen_id.'">Edit</a>';
echo'</td>';
echo'<td>';
echo'<a href="index.php?page=99&jump=3&jumpi=bdel&bmen_id='.$bmen_id.'">Del</a>';
echo'</td>';
echo'</tr>';
}
echo'</table>';
}
Top
Top