' . '' . '' . '' . '' . '' . '' . ''; while ($r = mysqli_fetch_assoc($query)) { $id = $r['id']; $upc = $r['upc']; $name = $r['name']; $price = $r['price']; $category = $r['category']; $supplier = $r['supplier']; $final_link = $link . $id; echo "" . "" . "" . "" . "" . "" . ""; } echo '
IDАртикулНаименованиеЦенаКатегорияПоставщикПодробности
$id$upc$name$price$category$supplier


'; } } function addPart($con) { if (isset($_REQUEST['add_part'])) { $upc = $_REQUEST['part_add_upc']; $name = $_REQUEST['part_add_name']; $price = $_REQUEST['part_add_price']; $category = $_REQUEST['part_add_categorys']; $supplier = $_REQUEST['part_add_suppliers']; $description = $_REQUEST['part_add_description']; $path = $_FILES['part_add_image']['name']; $ext = pathinfo($path, PATHINFO_EXTENSION); $image = "$upc.$ext"; $moveto = "../images/parts/$image"; if (move_uploaded_file($_FILES['part_add_image']['tmp_name'], $moveto)) { if ($upc != '' && $name != '') { $sql = "SELECT addNewPart('$upc', '$name', $price, $category, $supplier, '$description', '$image') AS 'result';"; $query = mysqli_query($con, $sql); $r = mysqli_fetch_assoc($query); $result = $r['result']; if ($result == 1) echo 'Товар успешно добавлен!'; else echo 'Товар с таким артикулом уже существует!'; } else echo 'Заполнены не все поля!'; } else echo 'Ошибка при загрузке изображения!'; } }