$ymdh = date( Y m d H ); $findOrderSoFar = mysqli_fetch_array($pdo->query( "SELECT count(public_order_id) as num FROM `order_record` WHERE FROM_UNIXTIME(add_time, %Y %m %d %H ) = {$ymdh} " )); $i $i = $findOrd...
the problem I face now is I have a datasheet that is almost 1 million. it s not a way to go on like this. how can I separate it out, but I can still use the data from the datasheet? because suppose I export it to the drop table I can t use it ...
first introduce the environment Linode ubuntu16.04,apapche,php7.3,mariadb current dilemma in my website folder, strictly speaking, there are three kinds of projects, one is e-commerce, one is blog, and the other is front-end and background . But now...
I added the mainframe in LINODE, and set up ubuntu 18.04 ephemeral apache.p7.3 phpmyadmin . but I can t remotely connect to the mariadb of this host on the local 127.0.0.1? my phpmyadmin can connect to the database normally phpmyadmin 127.0.0....
use Linode host, ubuntu16.04 apache + php + mariadb to set up a website, and cloudflare DNS currently need to have a shunt mechanism, but I don t know how to do it. (currently using Linode 4G scheme) would like to ask experienced people how to proce...
two hypotheses A $do->query( "INSERT INTO `abc` ( `public_order_id`, `add_time`, `status` ) VALUES ( {$public_order_id} , {$add_time} , ) &...
as shown in the picture, when I get my son s information, how can I find out his father s grandfather s information through his pid? ...
...
situation: uncertain orders are generated every day suppose there are eight orders generated today id status 1 2 3 4 5 6 7 8 I use loops to change the status of these eight orders to "shipping " . question: how can I tu...
Database query results: 11 code ID 1 purchased 3 times 11 Legacy ID 2 purchased 10 times on November 12th, ID 36 purchased once on November 12th, ID 37 purchased once SQL statement "$chartData " countid ID FROM_UNIXTIMEadd_time m...
I have recently seen a lot of OOP teaching mysqli (or PDO), found it to be a new world). The way I now connect to databases and statements is to introduce a large php file on each page, including links, and there are many small php files, which may be f...
assume the data table relationship: order order data sheet: order_id public_order_id 1 AAA 2 BBB 3 CCC prod goods data sheet: order_id prod_id 1 100 1 101 1 102 2 101 2 103 3 102 3 104 Front end display AAA BBB CCC when...
SELECT ss.quan FROM `stock` as ss JOIN `order_record` as r ON r.order_id = ss.order_id WHERE ss.from = c AND r.from = c AND r.status = ing AND ss.prod_id = 120 GROUP BY ss.order_id ...
I am currently working on a web site based on php + mariadb , but recently I want to change the web site to laravel traffic , but it is impossible to achieve it in the short term. so I want to ask the great gods how can I change the code to achieve t...
question A number table is post_id B number table bit is url An and B have a lot of data An and B some post_id matches url, and some are inconsistent (the fields related to An and B are post_id and url) how do I eliminate all those that do not matc...
the starting point is the article ID , which is assumed to be 123 . Now I want to find a match post_id = 123 , and then match meta_key = _ thumbnail_id and meta_value = 456 and then use the ID of 456 to find the ID, of wp_posts data table. d...
problem description the environmental background of the problems and what methods you have tried looked up a lot of materials: https: mariadb.com kb en lib. http: blog.sina.com.cn s blo....
I have a problem with batch updates hypothetically I am a loop printing out the box and product ID while($row = mysqli_fetch_array($data)){ <input type="hidden" name="cart_prod_id[]" value="<?=$row[ prod_id ];?>&qu...
assume that there is an item count table and use an item table when I want to make an item list I want to show an item table the behavior of an item table is to add this item to the goods store but I am shopping. How can I show it? I think of seve...
I want to be an e-commerce website. is paired with php + mysql . Now I have a big problem . At present, I intend to do a customized service , that is, this set of e-commerce websites are sold directly to you, and all the functions are maintained by me....