zdravim vie mi niekto poradit mam urobeny script na pridavanie podkategorii do db a zaroven ich ma priradit k prislusnej kategorii podla ID ... kategoria sa vybera cez "select" ... no pro pridani do db mi tam nezapisuje ID ...
Kód:
if ($_GET['action'] == "add") {
echo '<form method="post" action="admincenter.php?site=shopcategories" enctype="multipart/form-data"> <select>';
$ergebnis = safe_query("SELECT * FROM ".PREFIX."shop_subcategories ORDER BY namesub");
while($ds = mysql_fetch_array($ergebnis)) {
echo '
<option value="'.$ds['subcatID'].'">'.$ds['namesub'].' </option>';
}
echo '</select>';
echo'
<table cellpadding="4" cellspacing="0">
<tr>
<td>'.$_language->module['catname'].':</td>
<td><input type="text" name="name" class="form_off" onfocus="this.className = \'form_on\';" onblur="this.className = \'form_off\';" /></td>
</tr>
<tr>
<td>'.$_language->module['pic'].':</td>
<td><input name="pic" type="file" /></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="save" value="'.$_language->module['newcat'].'" /></td>
</tr>
</table>
</form>
';
}
submit:
Kód:
if ($_POST['save']) {
safe_query("INSERT INTO ".PREFIX."shop_categories (catID, subcatID, name, pic) values ('', '$subcatID', '$name', '') ");
$id = mysql_insert_id();
if ($pic['name'] != "") {
move_uploaded_file($pic['tmp_name'], $filepath . $pic['name']);
@chmod($filepath.$pic[name], 0755);
$file_ext = strtolower(substr($pic['name'], strrpos($pic['name'], '.')));
$file = $id . $file_ext;
rename($filepath . $pic['name'], $filepath . $file);
safe_query("UPDATE ".PREFIX."shop_categories SET pic='$file' WHERE catID='$id'");
}
}
vysledok:
Kód:
INSERT INTO `w_shop_categories` (`catID`, `subcatID`, `name`, `pic`) VALUES
(1, '', 'Assistent', '');