Защо не ми попълва всички полета

goshkoy

Registered
Код:
<?php
include("include/session.php");
include("include/constants.php");
if($session->logged_in){
echo "Admin <b>$session->username</b>";
} else {
header("location: index.php");
}
?>
<html>
<head>
<title>Item Creator only for admins</title>
</head>
<body>
<br><form action ="" method="POST"></br>
Name<br><input type= "text" name="names"></br>
<br>Examle:Small shield of mana(with lower defense and some mana)</br>
Durablity<br><input type = "text" name="durablity"></br>
Attack<br><input type = "text" name="atk"></br>
Defense<br><input type = "text" name="def"></br>
Speed<br><input type = "text" name="speed"></br>
Resist<br><input type = "text" name="resist"></br>
Life<br><input type = "text" name="life"></br>
Mana<br><input type = "text" name="mana"></br>
Priceon shop<br><input type = "text" name="price"></br>
<br><select>
<option value="type">Armor</option>
<option value="type">Sword</option>
<option value="type">Boots</option>
<option value="type">Gloves</option>
<option value="type">Helm</option>
<option value="type">Shield</option>
<option value="type">Spear</option>
<option value="type">Book</option>
</select></br>
<br><select>
<option value="class">Legendary</option>
<option value="class">Unique</option>
<option value="class">Mystic</option>
<option value="class">Magic</option>
<option value="class">Normal</option>
</select></br>
<br><input type="submit" name="create" value="Create"></br>
</form>
</body>
</html>
<?php
$name = $_POST['names'];
$type = $_POST['type'];
$clas = $_POST['class'];
$dur = $_POST['durablity'];
$atk = $_POST['atk'];
$def = $_POST['def'];
$speed = $_POST['speed'];
$resist = $_POST['resist'];
$life = $_POST['life'];
$mana = $_POST['mana'];
$price = $_POST['price'];
if (isset($_POST['create'])) {
$query = "INSERT INTO `items` (type, class, durablity, atk, def, speed, resist, life, mana) VALUES ('$type', '$clas', '$dur', '$atk', '$def', '$speed', '$resist', '$life', '$mana')";
$res = mysql_query($query) or die(mysql_error());
$que2 = "INSERT INTO `shop` (`price`) VALUES ($price)";
$res2 = mysql_query($que2) or die(mysql_error());
echo "The item added succsesful";
} else {
die();
}
?>
Полетата name,type,class остават празни в ДБ всичко друго го вкарва
 
Селекта трябва да ти е

<select name="type">
<option value="armor">Armor</option>
<option value="shield">Shield</option>
</select>

Заради това не ти излиза type и clas.
За name ти не си сложил да се вкарва във заявката ($query). :)
 
трябват ти апострофи ...
$query = "INSERT INTO `items` (type, class, durablity, atk, def, speed, resist, life, mana) VALUES ('$type', '$clas', '$dur', '$atk', '$def', '$speed', '$resist', '$life', '$mana')";

ще иглежда така ..

$query = mysql_query("INSERT INTO `items` (`type`, `class`, `durablity`,` atk`, `def`, `speed`, `resist`, `life`,` mana`) VALUES ('$type', '$clas', '$dur', '$atk', '$def', '$speed', '$resist', '$life', '$mana')");



:?: :?:
 

Back
Горе