public function getProductById($id) { $query = "SELECT p.id as pid, p.name, p.description, p.image_url, \n p.price, c.id as cid, c.name as cat_name, s.id as sid, s.value as size\n FROM products p, categories c, sizes s, products_sizes ps \n WHERE p.id = ps.pid AND s.id = ps.sid AND p.category = c.id AND p.id={$id}"; $this->connectDb(); $result = mysql_query($query); while ($row = mysql_fetch_array($result)) { if (isset($product) == false) { $product = new ProductInfo(); $product->id = $row["pid"]; $product->name = $row["name"]; $product->description = $row["description"]; $product->setImageUrl($row["image_url"]); $product->price = $row["price"]; $category = new ProductCategory(); $category->id = $row["cid"]; $category->name = $row["cat_name"]; $product->category = $category; } $size = new ProductSize(); $size->id = $row["sid"]; $size->value = $row["size"]; $product->sizes[$size->id] = $size; } $this->disconnectDb(); return $product; }
<?php } ?> </select> <div class="lbls">Цена:</div><input required name="fPrice" type="text" placeholder="цена..." id="in_price" /> <input name="addItem" type="image" src="/images/admin_additem.png" /> <?php if (isset($_POST['addItem_x'])) { unset($_POST['addItem_x']); $product = new ProductInfo(); if (is_uploaded_file($_FILES["foto"]["tmp_name"])) { $upfile = getcwd() . "\\images\\items\\" . basename($_FILES["foto"]["name"]); $product->setImageUrl($_FILES["foto"]["name"]); move_uploaded_file($_FILES["foto"]["tmp_name"], $upfile); } else { echo "Error =("; } if (is_uploaded_file($_FILES["prefoto"]["tmp_name"])) { $upfile = getcwd() . "\\images\\items\\preview_" . basename($_FILES["prefoto"]["name"]); move_uploaded_file($_FILES["prefoto"]["tmp_name"], $upfile); } else { echo "Error =("; } $product->name = $_POST['fName']; $product->category = categoryById($cats, $_POST['fCat']); $product->description = $_POST['fText']; $product->price = $_POST['fPrice']; $ch_sizes = $_POST['fSizes'];