Keine Ahnung warum es nicht geht.
Wenn ich beim Input "add_karde" den name in valvu ersetze.
Trägt es in die datenbank ein.
Aber mit dem name macht er nichts
PHP
<?php
include('config.php');
// Lösch Script
// if( isset($_GET['id']) )
// {
// $id = $_GET['id'];
// $sql= "DELETE FROM db_karte WHERE tb_karte_id='$id'";
// $res= mysql_query($sql) or die("Failed".mysql_error());
// echo "<meta http-equiv='refresh' content='0;url=card_typ_add.php'>";
// }
if(isset($_POST['add'])){
$tb_karte_name_de = $_POST["add_karde"];
$tb_karte_name_en = $_POST["add_karen"];
$tb_karte_kartennummer = $_POST["add_karnr"];
//Hier mal die eingegebenen Daten noch prüfen.
//mit htmlspecialchars und dem Skript für Umlaute
$eintrag = "INSERT INTO db_karte
(tb_karte_name_de, tb_karte_name_en, tb_karte_kartennummer)
VALUES
('$tb_karte_name_de', '$tb_karte_name_en', '$tb_karte_kartennummer')";
$eintragen = mysql_query($eintrag);
}
?>
<!DOCTYPE html>
<html lang="de">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<link rel="icon" href="../../favicon.ico">
<title>Yugi-Mania</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/dashboard.css" rel="stylesheet">
<link href="css/sticky-footer-navbar.css" rel="stylesheet">
<link href="css/breadcrumbs.css" rel="stylesheet">
</head>
<body>
<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="container-fluid">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="true" aria-controls="navbar">
<span class="sr-only">Navigation ein-/ausblenden</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="index.php">Admin Control Panel</a>
</div>
<ul class="nav navbar-nav">
<li><p class="navbar-text">Angemeldet als <a href="kunde0.php">Shark Master</a></p></li>
</ul>
<form class="navbar-form navbar-right">
<div class="input-group">
<input type="text" class="form-control" placeholder="Suche nach...">
<span class="input-group-btn">
<button class="btn btn-default" type="button">Los!</button>
</span>
</div>
</form>
<div id="navbar" class="navbar-collapse collapse">
</div>
</div>
</nav>
<div class="container-fluid">
<div class="row">
<div class="col-sm-3 col-md-2 sidebar">
<ul class="nav nav-sidebar">
<li>
<div class="panel panel-default">
<div class="panel-heading" role="tab" id="überschriftDrei">
<h4 class="panel-title">
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#allgemein" aria-expanded="false" aria-controls"allgemein">
Allgemein
</a>
</h4>
</div>
<div id="allgemein" class="panel-collapse collapse" role="tabpanel" aria-labelledby="überschriftDrei">
<div class="panel-body">
<ul class="nav nav-sidebar">
<li><a href="option.php">Einstellung</a></li>
<li><a href="ordner.php">Ordnerverwaltung</a></li>
<li><a href="#">Rechnungen</a></li>
<li><a href="test.php">Test veruche</a></li>
</ul>
</div>
</div>
<div class="panel-heading" role="tab" id="überschriftDrei">
<h4 class="panel-title">
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#kartenverwaltung" aria-expanded="false" aria-controls"kartenverwaltung">
Kartenverwaltung
</a>
</h4>
</div>
<div id="kartenverwaltung" class="panel-collapse .collapse.in" role="tabpanel" aria-labelledby="überschriftDrei">
<div class="panel-body">
<ul class="nav nav-sidebar">
<li><a href="card_att_add.php">Karten Attribut</a></li>
<li><a href="card_typ_add.php">Karten Effekt Kategorien</a></li>
<li><a href="card_katogorie_add.php">Karten Katogorie</a></li>
<li><a href="card_effekt_add.php">Karten Effekt</a></li>
<li><a href="card_efk_kat_add.php">Karten Effekt Kategorien</a></li>
<li class="active"><a href="card_add.php">Karte hinzufügen</a></li>
</ul>
</div>
</div>
<div class="panel-heading" role="tab" id="überschriftDrei">
<h4 class="panel-title">
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#editionverwaltung" aria-expanded="false" aria-controls"editionverwaltung">
Editionverwaltung
</a>
</h4>
</div>
<div id="editionverwaltung" class="panel-collapse collapse" role="tabpanel" aria-labelledby="überschriftDrei">
<div class="panel-body">
<ul class="nav nav-sidebar">
<li><a href="#">Edition hinzufügen</a></li>
<li><a href="#">Editionliste</a></li>
<li><a href="#">Release</a></li>
</ul>
</div>
</div>
<div class="panel-heading" role="tab" id="überschriftDrei">
<h4 class="panel-title">
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#kundenverwaltung" aria-expanded="false" aria-controls"kundenverwaltung">
Kundenverwaltung
</a>
</h4>
</div>
<div id="kundenverwaltung" class="panel-collapse collapse" role="tabpanel" aria-labelledby="überschriftDrei">
<div class="panel-body">
<ul class="nav nav-sidebar">
<li><a href="#">Kunde hinzufügen</a></li>
<li><a href="#">Kundenliste</a></li>
</ul>
</div>
</div>
<div class="panel-heading" role="tab" id="überschriftDrei">
<h4 class="panel-title">
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#kaufverwaltung" aria-expanded="false" aria-controls"kaufverwaltung">
Kaufverwaltung
</a>
</h4>
</div>
<div id="kaufverwaltung" class="panel-collapse collapse" role="tabpanel" aria-labelledby="überschriftDrei">
<div class="panel-body">
<ul class="nav nav-sidebar">
<li><a href="#">Einkauf hinzufügen</a></li>
<li><a href="#">Einkaufsliste</a></li>
</ul>
</div>
</div>
<div class="panel-heading" role="tab" id="überschriftDrei">
<h4 class="panel-title">
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#verkaufverwaltung" aria-expanded="false" aria-controls"verkaufverwaltung">
Verkaufverwaltung
</a>
</h4>
</div>
<div id="verkaufverwaltung" class="panel-collapse collapse" role="tabpanel" aria-labelledby="überschriftDrei">
<div class="panel-body">
<ul class="nav nav-sidebar">
<li><a href="#">Produckte</a></li>
<li><a href="#">Angebotsliste</a></li>
<li><a href="#">Gewinn</a></li>
</ul>
</div>
</div>
<div class="panel-heading" role="tab" id="überschriftDrei">
<h4 class="panel-title">
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#tauschverwaltung" aria-expanded="false" aria-controls"tauschverwaltung">
Tauschverwaltung
</a>
</h4>
</div>
<div id="tauschverwaltung" class="panel-collapse collapse" role="tabpanel" aria-labelledby="überschriftDrei">
<div class="panel-body">
<ul class="nav nav-sidebar">
<li><a href="#">Tauschliste</a></li>
</ul>
</div>
</div>
<div class="panel-heading" role="tab" id="überschriftDrei">
<h4 class="panel-title">
<a class="collapsed" role="button" data-toggle="collapse" data-parent="#accordion" href="#links" aria-expanded="false" aria-controls"links">
Externe Links
</a>
</h4>
</div>
<div id="links" class="panel-collapse collapse" role="tabpanel" aria-labelledby="überschriftDrei">
<div class="panel-body">
<ul class="nav nav-sidebar">
<li><a href="#">Link 1</a></li>
<li><a href="#">Link 2</a></li>
</ul>
</div>
</div>
</div>
</li>
</ul>
</div>
<div class="col-sm-9 col-sm-offset-3 col-md-10 col-md-offset-2 main">
<h2>Karte hinzufügen</h2>
<p>TEXTTEXTTEXTTEXTTEXTTEXTTEXTTEXTTEXT</p>
<form method="POST" action="card_add.php">
<div class="bs-example bs-example-tabs" data-example-id="togglable-tabs">
<ul id="meineTabs" class="nav nav-tabs" role="tablist">
<li role="presentation" class="active"><a href="#Sonstiges" id="Sonstiges-tab" role="tab" data-toggle="tab" aria-controls="Sonstiges" aria-expanded="true">Sonstiges</a></li>
<?php
$strSQL = "
SELECT
db_karten_kategorie.tb_karten_kategorie_id AS tbkkid,
db_karten_kategorie.tb_karten_kategorie_name_de AS tbkknd,
db_karten_kategorie.tb_karten_kategorie_name_en AS tbkkne,
db_karten_kategorie.tb_karten_kategorie_attribut AS tbkkat,
db_karten_kategorie.tb_karten_kategorie_typ AS tbkkty,
db_karten_attribut.tb_karten_attribut_id AS tbkaid,
db_karten_attribut.tb_karten_attribut_name_de AS tbkand,
db_karten_typ.tb_karten_typ_id AS tbktid,
db_karten_typ.tb_karten_typ_name_de AS tbktnd
FROM
db_karten_kategorie
LEFT JOIN
db_karten_attribut
ON
db_karten_attribut.tb_karten_attribut_id = db_karten_kategorie.tb_karten_kategorie_attribut
LEFT JOIN
db_karten_typ
ON
db_karten_typ.tb_karten_typ_id = db_karten_kategorie.tb_karten_kategorie_typ
ORDER BY
db_karten_kategorie.tb_karten_kategorie_name_de";
$rs = mysql_query($strSQL);
while($row = mysql_fetch_array($rs)) {
echo "<li role='presentation'><a href='#".$row['tbkkid']."' role='tab' id='".$row['tbkkid']."-tab' data-toggle='tab' aria-controls='".$row['tbkkid']."'>".$row['tbkknd']."</a></li>";
}
?>
</ul>
<div id="meinTabContent" class="tab-content">
<div role="tabpanel" class="tab-pane fade in active" id="Sonstiges" aria-labelledBy="Sonstiges-tab">
<p>Effektmonsterdddd</p>
</div>
<?php
$rs = mysql_query($strSQL);
while($row = mysql_fetch_array($rs)) {
echo "<div role='tabpanel' class='tab-pane fade' id='".$row['tbkkid']."' aria-labelledBy='".$row['tbkkid']."-tab'>";
?>
<table class="table">
<tbody>
<tr>
<td>Name der Karte (deutsch)</td>
<td><input type="text" class="form-control" id="add_karde" name="add_karde"></td>
</tr>
<tr>
<td>Name der Karte (englisch)</td>
<td><input type="text" class="form-control" name="add_karen"></td>
</tr>
<tr>
<td>Kartennummer</td>
<td><input type="text" class="form-control" name="add_karnr"></td>
</tr>
<tr>
<td>Attribut</td>
<td><select multiple class="form-control" size="7" name="add_karat">
<?php
$array = explode ( ',', $row['tbkkat'] );
for ( $x = 0; $x < count ( $array ); $x++ ){
echo "<option value='".$array[$x]."'";
echo ">".$array[$x]."</option>\n";}
?>
</select>
<div class="panel panel-default">
<div class="panel-heading">
<button type="button" class="btn btn-default btn-xs spoiler-trigger" data-toggle="collapse">Spoiler</button>
</div>
<div class="panel-collapse collapse out">
<div class="panel-body">
<ul>
<?php
$query = "
SELECT
db_karten_attribut.tb_karten_attribut_id AS tbkaid,
db_karten_attribut.tb_karten_attribut_name_de AS tbkand
FROM
db_karten_attribut
ORDER BY
db_karten_attribut.tb_karten_attribut_id";
$resultat = mysql_query($query) OR die("Error: ".mysql_error()."</ br> Zeile ".__LINE__);
while($zeile = mysql_fetch_assoc($resultat)){
extract($zeile);
echo "<li>".$tbkaid." = ".$tbkand."</li>";}
?>
</ul>
</div>
</div>
</div>
</td>
</tr>
<tr>
<td>Typ</td>
<td><select multiple class="form-control" size="7" name="add_karty">
<?php
$array = explode ( ',', $row['tbkkty'] );
for ( $x = 0; $x < count ( $array ); $x++ ){
echo "<option value='".$array[$x]."'";
echo ">".$array[$x]."</option>\n";}
?>
</select>
<div class="panel panel-default">
<div class="panel-heading">
<button type="button" class="btn btn-default btn-xs spoiler-trigger" data-toggle="collapse">Spoiler</button>
</div>
<div class="panel-collapse collapse out">
<div class="panel-body">
<ul>
<?php
$query = "
SELECT
db_karten_typ.tb_karten_typ_id AS tbktid,
db_karten_typ.tb_karten_typ_name_de AS tbktnd
FROM
db_karten_typ
ORDER BY
db_karten_typ.tb_karten_typ_id";
$resultat = mysql_query($query) OR die("Error: ".mysql_error()."</ br> Zeile ".__LINE__);
while($zeile = mysql_fetch_assoc($resultat)){
extract($zeile);
echo "<li>".$tbktid." = ".$tbktnd."</li>";}
?>
</ul>
</div>
</div>
</div>
</td>
</tr>
<tr>
<td>Effekt</td>
<td><select multiple class="form-control" size="5" name="add_karef[]">
<?php
$query = "
SELECT
db_karten_effekt.tb_karten_effekt_id AS tbkeid,
db_karten_effekt.tb_karten_effekt_name_de AS tbkend,
db_karten_effekt.tb_karten_effekt_name_en AS tbkene
FROM
db_karten_effekt
ORDER BY
db_karten_effekt.tb_karten_effekt_name_de";
$resultat = mysql_query($query) OR die("Error: ".mysql_error()."</ br> Zeile ".__LINE__);
while($zeile = mysql_fetch_assoc($resultat)){
extract($zeile);
echo "<option name='add_kkat' value='".$tbkeid."'>".$tbkend."</option>\n";}
?>
</select></td>
</tr>
<tr>
<td>Effekt Kategorien</td>
<td><select multiple class="form-control" size="5" name="add_karek[]">
<?php
$query = "
SELECT
db_karten_effekt_kategorie.tb_karten_effekt_kategorie_id AS tbkekid,
db_karten_effekt_kategorie.tb_karten_effekt_kategorie_name_de AS tbkeknd
FROM
db_karten_effekt_kategorie
ORDER BY
db_karten_effekt_kategorie.tb_karten_effekt_kategorie_name_de";
$resultat = mysql_query($query) OR die("Error: ".mysql_error()."</ br> Zeile ".__LINE__);
while($zeile = mysql_fetch_assoc($resultat)){
extract($zeile);
echo "<option name='add_kkat' value='".$tbkekid."'>".$tbkeknd."</option>\n";}
?>
</select></td>
</tr>
<tr>
<td>Text</td>
<td><textarea class="form-control" rows="3"></textarea></td>
</tr>
<tr>
<td>Bild</td>
<td><input type="file" id="beispielFeldDatei"></td>
</tr>
</tbody>
</table>
<button type="submit" id="button" name="add" class="btn btn-default">
<span class="glyphicon glyphicon-plus" aria-hidden="true" name="add"></span> Senden
</button>
</form>
<?php
echo "</div>";
}
?>
</div>
</div>
</div>
</div>
<footer class="footer">
<div class="container">
<p class="text-muted">
<?php
echo "Letztes Aktualisierung: " .
date("d.m.Y - H:i", filemtime(basename($_SERVER["SCRIPT_NAME"])));
?>
</p>
</div>
</footer>
<!-- Bootstrap-JavaScript
================================================== -->
<!-- Nur, um unsere Platzhalter-Bilder zum Laufen zu bringen. Die nächste Zeile nicht wirklich kopieren! -->
<script src="../../assets/js/vendor/holder.min.js"></script>
<!-- IE10-Anzeigefenster-Hack für Fehler auf Surface und Desktop-Windows-8 -->
<script src="../../assets/js/ie10-viewport-bug-workaround.js"></script>
<script src="js/jquery.min.js"></script>
<script src="js/bootstrap.min.js"></script>
<script src="js/spoiler.js"></script>
</body>
</html>