Искам да ви попитам защо скриптчето...Защо не добавя информацията във базата данни...къде ми е грешката...досега работешеперфектно а сега...нищо не изкарва... къде бъркам...
Таблица:
Код:
<?php
include("config.php");
//Зимане на инфо
$name=$_POST[name];
$tip=$_POST[tip];
$power=$_POST[power];
$def=$_POST[def];
$health=$_POST[health];
$mana=$_POST[inte];
$hiss=$_POST[hiss];
$nivo=$_POST[nivo];
$cena=$_POST[cena];
$avtor=$_POST[avtor];
$sql = 'INSERT INTO `items` (`id`, `name`, `tip`, `power`, `defence`, `health`, `mana`, `history`, `level`, `cena`, `avtor`) VALUES(NULL , \"$name\", \"$tip\", \"$power\", \"$def\", \"$health\", \"$mana\", \"$hiss\", \"$nivo\", \"$cena\"
, \"$avtor\" );';
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf8">
<title></title>
<style type="text/css">
.body{
background-color:#000000;
}
.form{
background-color: #9c9c9c;
}
.blocks{
background-color:#CCCCCC;
}
.menu{
background-color:#666666;
}
</style>
<script type="text/JavaScript">
function MM_jumpMenu(targ,selObj,restore){
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
</script>
</head>
<body class="body">
<table width="253" height="319" border="0" cellspacing="0" bgcolor="9c9c9c">
<form action="additems.php" method="post" enctype="utf-8">
<tr><td>Име : </td>
<td><input name='name' type='text' class="blocks" size="26" maxlength="30"/></td>
</tr><tr><td>Тип : </td>
<td><select name="tip" class="menu">
<option value="0">Избери тип</option>
<option value="1">Oръжие</option>
<option value="2">Броня</option>
<option value="3">Щит</option>
</select></td></tr><tr><td>Сила : </td>
<td><input name='power' type='text' class="blocks" size="26" maxlength="3"/></td>
</tr><tr><td> Защита : </td>
<td><input name='def' type='text' class="blocks" size="26" maxlength="3"/></td>
</tr><tr><td>Кръв : </td>
<td><input name='health' type='text' class="blocks" size="26" maxlength="3"/></td>
</tr><tr><td>Интелект : </td>
<td><input name='inte' type='text' class="blocks" size="26" maxlength="3"/></td>
</tr><tr><td>История на предмета : </td>
<td><textarea name="hiss" rows="6" class="blocks" size="23"></textarea></td>
</tr><tr><td bordercolor="#FF0000" border="1">Изисквания </td><td></td></tr><tr><td>Ниво : </td>
<td><input name='nivo' type='text' class="blocks" size="26" maxlength="3"/></td>
</tr><tr><td>Цена : </td>
<td><input name='cena' type='text' class="blocks" size="26" maxlength="6"/></td>
</tr><tr><td>Автор : </td>
<td><input name='avtor' type='text' class="blocks" size="26" maxlength="30"/></td>
</tr><tr><td></td>
<td><input name="submit" type="submit" value="Submit" width="64" height="19" />
<input name="reset" type="reset" class="reset" title="reset" value="Reset"></td>
</tr></form></table>
</body>
</html>Таблица:
Код:
CREATE TABLE `items` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(30) collate utf8_unicode_ci NOT NULL default '',
`tip` tinyint(3) unsigned NOT NULL default '0',
`power` tinyint(6) unsigned NOT NULL,
`defence` tinyint(6) unsigned NOT NULL,
`health` tinyint(4) unsigned NOT NULL,
`mana` tinyint(4) unsigned NOT NULL,
`history` text collate utf8_unicode_ci NOT NULL,
`level` smallint(5) unsigned NOT NULL default '0',
`cena` smallint(5) unsigned NOT NULL default '0',
`avtor` text collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;