pdo statements
Blindmenü-insert
bmenu.php
Sprung variable setzen
if($jumpi=='bnew')
{
Tabellenkopf
echo'<table class="table">';
echo'<tr>';
echo'<th>ID</th>';
echo'<th>Menüname</th>';
echo'<th>wohin</th>';
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'</tr>';
}
echo'</table>';
Sprung variable in Sprung variable setzen
if($jumps=='bneu')
{
Dateikopf
echo'<div class="bigg">Blind Menüpunkt erstellen</div>';
echo'<form action="index.php?page=99&jump=3&jumpi=bwrite&jumps=bschreib" method="post">';
echo'<input name="jumpo" type="hidden" value="schreib">';
echo'<div class="form-face">';
echo'<input required="required" placeholder="ID:" class="form-control" name="ids" type="text">';
echo'</div>';
echo'<div class="form-face">';
echo'<input required="required" placeholder="Menüname:" class="form-control" name="labels" type="text">';
echo'</div>';
echo'<div class="form-face">';
echo'<input required="required" placeholder="wohin:" class="form-control" name="linksurl" type="text">';
echo'</div>';
echo'<div class="form-face">';
echo'<input type="submit" name="schreib" value="Menüpunkt erstellen" class="butt button-blue">';
echo'<input type="reset" value="L?schen" class="butt button-red">';
echo'</div>';
echo'</form>';
Sprung variablen ende
}
}
Menüpunkt eintragen
Sprung variable setzen
if($jumpi=='bwrite')
{
Sprung variable in Sprung variable setzen
if($jumps=='bschreib')
{
$_POST Dateien
$ids = isset($_POST['ids']) ? $_POST['ids'] : '';
$labels = isset($_POST['labels']) ? $_POST['labels'] : '';
$linksurl = isset($_POST['linksurl']) ? $_POST['linksurl'] : '';
In Datenbank schreiben
$stmt = $pdo->prepare("INSERT INTO blind_menu (id,labels,ziels,linken_url) VALUES (:id,:label,:ziel,:linkurl)");
$stmt->bindParam(':id',$ids,PDO::PARAM_INT);
$stmt->bindParam(':label',$labels,PDO::PARAM_STR);
$stmt->bindParam(':ziel',$ids,PDO::PARAM_INT);
$stmt->bindParam(':linkurl',$linksurl,PDO::PARAM_STR);
if($stmt->execute())
{
header("Location:index.php?page=99&jump=3&jumpi=blind");
}
else
{
echo"Da ist was schief gelaufen";
}
Sprung variablen ende
}
}
Top
Top