reason suppose I want to input all the data of a number table, how can I change the value of this field to B if there is A? INSERT INTO `wp_posts` (`ID`, `content`) VALUES (13335, <h3>< h3> r n[embed]https: www.instagram.com p Bc...
mysqli::query(): send of 8192 bytes failed with errno=32 Broken pipe mysqli::query(): send of 72 bytes failed with errno=32 Broken pipe question I encountered the above problem when my mysql entered data I uploaded a 10m clip to an editor, and the n...
this is the result of the query this is the php query code SELECT FROM_UNIXTIME(add_time, %Y-%m-%d ) as add_time, count(view_id) as viewTime FROM `view` GROUP BY `add_time` this is the whole php code header( Content-type: application j...
I d like to ask about the problem of how to reorganize the network so that you don t need to reconnect to the database. have I looked up https: stackoverflow.com que. and found that php7 doesn t seem to have this function? have you ever realiz...
want to ask a question see what everyone does suppose there is an item < 1 the user sets up a list after buying item A, and uses the relational database to find 1 and then go to the information table product to introduce purchased goods suppose one...
encountered a problem today $sql = $mysqli->query( "SELECT .... " ); I have a query that I want to apply to two while, but only the first one has a response <? while ($row = mysqli_fetch_array($sql)){ ?> ...
check I can t even find the method on the website how to start AUTO_INCREMENT from 0 via php mysql lookup? not in this way: CREATE TABLE `admin` ( `x` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; is the way to ...
$product_name = $pdo->query( "SELECT * FROM `stock` as s JOIN `product` as p ON p.prod_id = s.prod_id WHERE s.order_id = {$first_order[ order_id ]} " ); $productNameArray = null; while ($row = mysqli...
online time() online 20 id 2 s online_status deduction time () has been higher than 30, but id 1 does not have it, but it is still found out? ...
while ($row = mysqli_fetch_array($aa)){ $public_order_id = date( Ymd , time()).rand(1,999999); because there will be more than one br in an instant. my current idiotic approach is to use rand. , but 1999999 still has a chance to reproduce, bec...
$subtotal = $pdo->query( "SELECT s.quan as quan, s.price as price, p.store_id as store_id FROM `stock` as s JOIN product as p ON s.prod_id = p.prod_id " ); while ($row_ = mysqli_fetch_array($sub...
I have a problem now join store product product store_id product store_id The check box is store_id , but I found that even if it is the same store_id, it will print out . What I want to achieve is that just show a store_id, and as long as t...
I want to read the sql file through php to create the database and write some initial data, so I wrote the following php code and sql after the first floor hint, the code has run array (size=5) 0 => string CREATE DATABASE IF NOT EXISTS wishwall...
SELECT * FROM `user_cart` as c JOIN `product` AS b ON c.prod_id = b.prod_id WHERE c.id = {$_SESSION["user-id"]} I have a value in product called from, which is either an or b , but what is shown now is ...
SELECT * FROM `product` AS p JOIN `store` AS s ON p.prod_id = s.prod_id my join has realized that I need store s name, icon and product s name, icon . What should I do? this is what I show: <? while($row = mysqli_fetch_array($data)...
I found that the e-commerce merchandise list needs to be planned but I don t know where to refer to currently my merchandise list basically has names original sales displays benefits but I still have several major types one is commodity clas...
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...
SELECT * FROM user_order as c LEFT JOIN product_order AS b ON c.order_id = b.order_id LEFT JOIN product AS a ON a.prod_id = b.prod_id WHERE c.id = 16 too expensive my user_order list has name, id my product_order also has i...
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...
Deprecated: mysql_connect (): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in www wwwroot xcx.xxxxxx.com phpwxpay connect.php on line 11 ID order number, serial number, payment time the background o...
are jade and jsp the same thing? what are the advantages of templates such as jade over vue,react? What kind of scenarios are suitable for? is jade server rendering? ...
after win10 system installs node successfully, node-v can publish this number, but npm cannot be used. Error: Error: spawn D: nodejs node.exe ENOENT at _errnoException (util.js:1031:13) at Process.ChildProcess._handle.onexit (internal child_p...
the following is the source code of the unlinkFirst method in LinkedList where f is the head of the linked list it says that f.next = null; is good for gc I don t quite understand, f is already ROOT unreachable must be gc Why does it help gc? to s...
remote branch already has a branch develop,local branch has a branch XX, how to push XX code to develop ...
there is an access data table with nearly 200000 pieces of data. I don t know when to modify it manually. The format of is as follows: there are fields in the Content table Chinese name: Xiao Li English name: xiaoli gender: male Chinese name: X...