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...
import React, {Component} from react import . App.scss import NavBar from . components NavBar NavBar export default class App extends Component { render () { return ( <div className="App"> <header className=...
as shown in the figure: you can share the project on github. The github account is also logged in. checkoutgithub ...
when you encounter a requirement in the project, scroll the winning list infinitely, either on the phone or package it into app. When you swipe two times, it will scroll intermittently . var mySwiper = new Swiper ( .swiper-container , { dire...
1. First look at the screenshot picture description I want to keep a straight line between the left side and the right side of the input box and a straight line on the right . 2. The static box code of bootstrap is used as follows: ...
I am a chart project developed by vue scaffolding, and now I need to change the position separately because the label and Abscissa of the column chart overlap. ask the boss for an answer. as shown in the figure, the first two histograms are normal...