How to plan e-commerce merchandise, list list!

I found that the e-commerce merchandise list needs to be planned
but I don"t know where to refer to
currently my merchandise list basically has names / original sales / displays / benefits
but I still have several major types

one is commodity classification
the other is brand classification
free of charge for all stations.

how do I plan the number table?
is there a great god who can provide an idea?

there is also a list
because you can add items
, so there will be a lot of fake five items
, but there will only be one list, but the noodles contain five items
this list is completely planned
how to solve this?

Mysqli mysql php7 php

Mar.22,2021

take a look at how the open source product ecshop is designed. Address: http://book.ecmoban.com/

A summary of the creation of super elementary data tables written by myself

you can take a brief look at it, because it's only shorthand, but creating a datasheet is nothing more than determining which tables you need, and you're clear about that. Then the relationship between each table and the table can be determined, and after it is clear, the corresponding association or even relational table can be established. More needs to be based on specific needs, as well as personal experience accumulation, or systematic learning. My knowledge only supports me to say so much.

Previous: Python regular matches the contents of the specified start HTML tag and end tag

Next: There is a minimum value and a maximum value, and the database is also designed into two fields, the maximum and the minimum. How does sql search according to the user input range?

Can the counterparty access my database through php curl?
want to check the hypothesis. I want the counterparty to access my database via php curl what can I do this? Is there a template you can refer to? this is due to the fact that the host is in parallel with mysql and all the mysql data are managed cent...

Mariadb mysqli mysql php7 php

Mar.04,2021
After JOIN, if the two bits are duplicated, but all of them have to be shown, how can they be distinguished?
SELECT * FROM `product` AS p JOIN `store` AS s ON p.prod_id = s.prod_id my join has realized that I need store s name, icon and product s name, icon . What should I do? this is what I show: <? while($row = mysqli_fetch_array($data)...

Mysqli mysql php7 php

Mar.23,2021
Display different values in the same data table?
SELECT * FROM `user_cart` as c JOIN `product` AS b ON c.prod_id = b.prod_id WHERE c.id = {$_SESSION["user-id"]} I have a value in product called from, which is either an or b , but what is shown now is ...

Mysqli mysql php7 php

Mar.24,2021
Arrange the names and commas from the data
$product_name = $pdo->query( "SELECT * FROM `stock` as s JOIN `product` as p ON p.prod_id = s.prod_id WHERE s.order_id = {$first_order[ order_id ]} " ); $productNameArray = null; while ($row = mysqli...

Array mysqli mysql php7 php

Mar.30,2021
How to start AUTO_INCREMENT from 0 through php mysql checking?
check I can t even find the method on the website how to start AUTO_INCREMENT from 0 via php mysql lookup? not in this way: CREATE TABLE `admin` ( `x` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; is the way to ...

Auto_increment mysqli mysql php7 php

Apr.03,2021
Two while cannot be applied to the same query?
encountered a problem today $sql = $mysqli->query( "SELECT .... " ); I have a query that I want to apply to two while, but only the first one has a response <? while ($row = mysqli_fetch_array($sql)){ ?> ...

Mysqli mysql php7 php

Apr.07,2021
When entering data, process string at the same time through php or mysql?
reason suppose I want to input all the data of a number table, how can I change the value of this field to B if there is A? INSERT INTO `wp_posts` (`ID`, `content`) VALUES (13335, <h3>< h3> r n[embed]https: www.instagram.com p Bc...

Mysql-optimized mysqli mysql php7 php

Jul.10,2021
How do I replace other tables in php?
subject I now have a problem data table structure: 2158 2159 16620 2158 16620 2159 blog_id tags 16620 null I am now writing that the tags field of C datasheet is empty I want to associate C s blog_id associated B Datasheet-> to...

Mysqli mysql php7 php

Jul.15,2021
Call for help! RSS & RSS format conversion & mysql & facebook instant article?
call for help I m really in a hurry right now. I m going to make a copy of RSS, for An and B (one of which is a facebook instant article). but I don t know anything about RSS! what I thought of create two number tables, and when you add a...

Rss mysqli mysql php7 php

Jul.26,2021
How to make a relational update between a data table and a data table?
SQL $rs = $do->query( "SELECT t.name as name, tr.object_id as object_id FROM wp_terms as t JOIN wp_term_relationships as tr ON tr.term_taxonomy_id = t.term_id JOIN blog as b ON b.url = tr.object_id " ); UP...

Mysqli mysql php7 php

Jul.29,2021
Web site formal and test data and backend planning problems
suppose a web site has a backend, and the default is test.com admim (test.com is my own personal domain and must be encrypted to log in, so the test will have a test manager account, and there will be an official manager account), and you can add back-...

Database mysqli mysql php7 php

Aug.24,2021
Php several different array to calculate a different size and add up?
assume that the front end is <input type="hidden" name="cart_prod_id[]" value="<?=$row[ prod_id ];?>"> <input type="hidden" name="cart_quantity[]" value="<?=$row[ quan ];?>...

Mysqli mysql php7 php array

Oct.03,2021