Bootstrap Insert Into

Shark Master · Feb 23rd 2016

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>

Display More

**Tim Düsterhus** · Feb 23rd 2016

Hallo,

mal ohne mich durch die 855 Zeilen Code zu lesen: Dein Code ist anfällig für SQL-Injection und die alte mysql_query-API ist hoffnungslos veraltet. Wenn du das erste Problem korrigierst, dann korrigierst du vermutlich implizit auch das zweite.

Shark Master · Feb 23rd 2016

das es veraltet ist mir klar.
Sie seite ist nur für mich gedacht und soll mir beim Lagern helfen

Bootstrap Insert Into

Participate now!

Share