$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....
how do Vue projects built with Nuxt.js share header and footer files? only files with section contents are placed in the page directory. Navigation bars and footers and every time you jump to a new route, navigation doesn t have to be reloaded. Gods, ...
I found php-fpm.pid : in the var run php-fpm directory, but I couldn t find the php-fpm.sock file. Where do I usually store it? And what s the difference between them? ...
I need to listen to query on URL in a global state to do something. so sometimes when the URL is unchanged, add the GET parameter directly to the end , so you need to keep the original GET and add a new GET , but the actual operation URL is always unre...
The data table has 30 fields, and the json passed from the front end corresponds to 10 fields. How to easily modify the values of these fields. Front-end json: { name: a , active: play } I don t want to assign values explicitly, suc...
before, you can write your own webpack configuration in the package.json configuration browserslist field how to configure create-react-app? ...