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...
there has just been a problem with the online code. The reason is that order sorting is not used in sql, resulting in inconsistent results of each query. So what is the default collation for mysql without specifying order by? ...
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....
The project is a multi-entry application, referring to one and two methods in activity.js in test.js and test1.js, respectively. But in the last two js, it is found that both methods refer to . single entry is not a problem related codes activity...
I put down a drag-and-drop sort plug-in written by native js, because the plug-in itself is a PC-side method and all the methods are mouse operations. I changed it to the mobile method and found that the event in ontouchmove does not have the attributes...
< H2 > execute statements directly in the database table < H2 > see which objects are locked: select object_name, machine, s.sid, s.serial-sharp from v$locked_object l, dba_objects o, v$session s where l.object_id = o.object_id and l.session_id = s.s...