$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....
my IDEA version is 2018.2 182.3684.101 After the update, I found that I kept flashing updating indices and scanning files to index,2 seconds. I tried fild- > Invalidate Caches Restart to no avail. this problem does not exist in another project. ...
I read the following blog, can only achieve the second jump does not show, the first time there will be, is there any way to completely hide the white edge? https: blog.csdn.net gaofei8....
problem description after the mac computer installs confluence6.6.2, the installation process is fine. After you create a new document, you cannot save the document (make sure there are no special characters). Enter 1 for title and 1. for content. ...
question: is it not recommended to use multi-table queries for mongodb non-relational databases? ...
for example, there is an option list at the top reports Statistics articles goods Manager Edit Statistics this is the name of each title each title can enter a different face for example, managers can enter the above four facets editing ca...