The idea of the project was born from life. How to save money when buying? It is often necessary to compare the prices of goods or products in different stores. Sellers and manufacturers deliberately do so to confuse the buyer and sell him the product at an inflated price. Make different volumes and more. The project aims to store information about the price and volume or weight of the product in different stores. This allows you to check where a kilogram, piece, cubic meter or other unit of measurement is cheaper.
This project is part of a training of skills in the course of study. In it I passed the following stages: development of the idea of the project, designing of a database, partial development of a frontend part, programming of a backend part. It is interesting to pay attention to the query to the database to find the best price for a given product.
$sql="SELECT product.name, main.price, measure.unit, main.quantity, shop.name AS shop_name, measure.name AS measure_name, shop.address, picture.name AS picture_name, (1 / main.quantity * main.price / measure.normalize_unit) AS normalize_price FROM main inner join product on main.product_id = product.id inner join picture on product.picture_id = picture.id inner join measure on product.measure_id = measure.id inner join shop on main.shop_id = shop.id WHERE product.name LIKE '%" . $_GET["text"] . "%' ORDER BY normalize_price ASC";
HTML, CSS, JavaScript, PHP, Ajax, JSON, Sql