$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 to judge a.b.c in js. When getting attribute c, you need to nest to determine whether it is empty or not. In c-sharp? Grammar is fine. Is there a more convenient way to write it in js? ...
is there a kind boss passing by to tell me how to do this phpstudy configuration domain name? Find the process on the Internet, and then finish it. You can access this domain name on the server, but you can t access it on other computers. What s the re...
es6 block-level scope let Why not add the sentence "let a = 2000 " in the following code, the console.log (a) result is 100; and why you report an error an after adding this sentence is the definition. I came across the knowledge of let in es6. var...
problem description python processes the front-end request and sends back a json data the environmental background of the problems and what methods you have tried the shit I need to do, the backend implements a crawler with python, and gets two pi...
< html > < head > < meta charset= "utf-8 " > < script > function showHint (str) { var xmlhttp; if (str.length==0) { document.getElementById("txtHint").innerHTML=""; return; } if (window.XMLHttpRequest) { IE7+, Firefox,...