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...