bin php anfänger kann mir bitte jemand sagen warum das hier nicht funktioniert danke voraus
<?php
if (isset($_POST["title"]) && isset($_POST["description"])&& isset($_POST["kategories"]) ) {
$title = $_POST["title"];
$cheat = $_POST["cheat"];
$description = $_POST["description"];
$kategories = $_POST["kategories"];
if (strlen($title) < 3) {
?>
<div class="badanswer">Title too short !</div>
<?php
} else if (strlen($description) < 3) {
?>
<div class="badanswer">Description too short !</div>
<?php
} else {
$result1 = mysql_query("SELECT * FROM games where title = '" . mysql_real_escape_string($title) . "'", $con);
$size = 0;
while ($row1 = mysql_fetch_array($result1)) {
$size++;
}
if ($size == 0){
mysql_query("Insert into games values(NULL,'" . mysql_real_escape_string($title) . "','".mysql_real_escape_string($kategories)."',NOW ())", $con);
}
$result = mysql_query("SELECT id_game FROM games where title like '" . mysql_real_escape_string($title) . "'", $con);
$row = mysql_fetch_array($result);
mysql_query("Insert into cheats values(NULL,$row[0],'" . $description . "','".mysql_real_escape_string($cheat)."',0,0,NOW( ))", $con)or die(mysql_error());
?>
<div class="goodanswer">Cheat Code added successfully !</div>
<?php
}
} else {
echo "<div><h2>Add a new Cheat Code</h2></div>";
?>
<form id="usrform" method="POST" action="addGameCheat.php">
<div class="styled-select">
<select id="my_selection" name="kategories" onChange="aendern(this.options[this.selectedIndex].value);" size="1">
<option value="0">Category</option>
<option value="1">PC</option>
<option value="2">PLAYSTATION</option>
<option value="3">PS VITA</option>
<option value="4">PLAYSTATION 2</option>
<option value="5">PLAYSTATION 3</option>
<option value="6">PLAYSTATION 4</option>
<option value="7">XBOX</option>
<option value="8">XBOX 360</option>
<option value="9">XBOX ONE</option>
<option value="10">DREAMCAST</option>
<option value="11">NINTENDO 64</option>
</select>
</div>
<p><input type="text" name="title" placeholder="Game Name" class="game_name" ></p>
<p><input type="text" name="cheat" placeholder="Cheat for" class="game_name" ></p>
<textarea id="eingabefeld" name="description" form="usrform" placeholder="Enter Cheat Code..." class="cheat_code"></textarea>
<p><input type="submit" value="Submit" class="submit_game"/></p>
</form>
<div id="anzeige"> </div>
</div>
<?php } ?>
<?php
if (isset($_POST["title"]) && isset($_POST["description"])&& isset($_POST["kategories"]) ) {
$title = $_POST["title"];
$cheat = $_POST["cheat"];
$description = $_POST["description"];
$kategories = $_POST["kategories"];
if (strlen($title) < 3) {
?>
<div class="badanswer">Title too short !</div>
<?php
} else if (strlen($description) < 3) {
?>
<div class="badanswer">Description too short !</div>
<?php
} else {
$result1 = mysql_query("SELECT * FROM games where title = '" . mysql_real_escape_string($title) . "'", $con);
$size = 0;
while ($row1 = mysql_fetch_array($result1)) {
$size++;
}
if ($size == 0){
mysql_query("Insert into games values(NULL,'" . mysql_real_escape_string($title) . "','".mysql_real_escape_string($kategories)."',NOW ())", $con);
}
$result = mysql_query("SELECT id_game FROM games where title like '" . mysql_real_escape_string($title) . "'", $con);
$row = mysql_fetch_array($result);
mysql_query("Insert into cheats values(NULL,$row[0],'" . $description . "','".mysql_real_escape_string($cheat)."',0,0,NOW( ))", $con)or die(mysql_error());
?>
<div class="goodanswer">Cheat Code added successfully !</div>
<?php
}
} else {
echo "<div><h2>Add a new Cheat Code</h2></div>";
?>
<form id="usrform" method="POST" action="addGameCheat.php">
<div class="styled-select">
<select id="my_selection" name="kategories" onChange="aendern(this.options[this.selectedIndex].value);" size="1">
<option value="0">Category</option>
<option value="1">PC</option>
<option value="2">PLAYSTATION</option>
<option value="3">PS VITA</option>
<option value="4">PLAYSTATION 2</option>
<option value="5">PLAYSTATION 3</option>
<option value="6">PLAYSTATION 4</option>
<option value="7">XBOX</option>
<option value="8">XBOX 360</option>
<option value="9">XBOX ONE</option>
<option value="10">DREAMCAST</option>
<option value="11">NINTENDO 64</option>
</select>
</div>
<p><input type="text" name="title" placeholder="Game Name" class="game_name" ></p>
<p><input type="text" name="cheat" placeholder="Cheat for" class="game_name" ></p>
<textarea id="eingabefeld" name="description" form="usrform" placeholder="Enter Cheat Code..." class="cheat_code"></textarea>
<p><input type="submit" value="Submit" class="submit_game"/></p>
</form>
<div id="anzeige"> </div>
</div>
<?php } ?>
Kommentar