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....
two hypotheses A $do->query( "INSERT INTO `abc` ( `public_order_id`, `add_time`, `status` ) VALUES ( {$public_order_id} , {$add_time} , ) &...
a table a_id name 1 1 2 2 3 3 4 4 5 5 b table b_id name a_id 1 a 1 2 b 1 3 c 1 4 d 2 5 e 2 how to write the sql statement to query 10 pieces of data for each category find an array structure si...
https: blog.csdn.net u013802. $stmt = $mysqli->prepare("INSERT INTO table_name (name) VALUES (?)"); $stmt->bind_param( s , $postedName); I use this way to inject data into . It seems to be possible to wait for Filter. I see that "f...
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...
I would like to ask if there are multiple sub-items in a main commodity multiple sub-items will have their own inventory how can the database plan correctly? main commodity prod_id stock price 1 0 0 2 0 0 3 0 0 4 10 30 Sub-merc...
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...
I use the keyup event to automatically save fields to the database html <input type="file" id="file" name="cover" accept="image jpeg, image png, image jpg"> ajax $( body ).on( keyup , -sharpconten...
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 ...
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 ];?>...
assume that the current user_id = 1 uc table prod_id user_id 102 1 103 1 cs table prod_id user_id 102 1 I want to find out 103, that is, those data that are available in the uc table but not in the cs table SELECT uc.prod_id F...
hypothetical articles have a bit called tags that he has finished. every article has a similar tag, for example, id blog_title tags 1 Hi A,B,C 2 A,B 3 C,D I want to use tags to find other articles that are similar to this article h...
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-...
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...
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...
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...
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...