-
Php mariadb sum divided by if there is no value, can NAN, be shown as 0?
$selectTip = $pdo->query("SELECT * FROM `tips_rate`
WHERE `tip_id` = ".$row[ id ]." "
);
$selecttotal = mysqli_num_rows($selectTip);
$rate = $pdo->query("SELEC...
-
Use mariadb (mysql) php to write an api for your own use.
the api I am talking to now is a request from others. is to use curl to catch the opposite party http. I give it to the opposite party json , and then the opposite party gives back to me json, and then I show it (using mongodb, nodejs) ).
it s just t...
-
Php uses curl, and the counterpart is also php. How can I get it?
I wrote an api hypothesis called sql.php myself.
I am in another sql-test.php
$data = array(
"errno" => 1 ,
"errstr" => 2 ,
"errfile" => 3 ,
"errline" => 4
);
$data_string = js...
-
Can the counterparty access my database through php curl?
want to check the hypothesis. I want the counterparty to access my database via php curl what can I do this? Is there a template you can refer to? this is due to the fact that the host is in parallel with mysql and all the mysql data are managed cent...
-
Access denied for user appears when using mycat agent to connect to the database
background: according to the mycat document, try to build a mycat+MariaDB service on a Tencent Cloud. Then try to access the data with Navicat (using port 8099 of mycat) and Access denied for user test check:
---->
...
-
What is the connection between PHP and MYSQL?
want to check I have a problem with MYSQL now I have installed XAMPP so my localhost already has a phpmyadmin , but I also have mysql and phpmyadmin installed on my other host (linode), so this is another MYSQL want to check if I want localhost to ...
-
The problem of mariadb's aggregate function count
my statement is select user_vip_card . , flow_of_vipcard . , if ((user_vip_card.max_times IS NULL OR user_vip_card.max_times= 0 OR user_vip_card.max_times=9999),-1, (user_vip_card.max_times-count (flow_of_vipcard.id)
AS remain_times
...
-
How can I fix the mariadb, that cannot be installed after / etc/mysql has been deleted?
hand disabled deleted everything in the etc mysql folder, making it impossible to install mariadb, now. How should I fix it?
update-alternatives: error: alternative path etc mysql mariadb.cnf doesn t exist
dpkg: error processing package mariadb...
-
How to upgrade XAMPP on macos?
check it out. I don t seem to have found it on the website. how to upgrade the new version of XAMPP that has been installed in macos? is there anything related to teaching or experienced gods to share? I hope to be able to upgrade very easily ...
-
How typecho links to mariaDB databases
typecho cannot link to the database
the database uses mariaDB5
Is not supported?
ask how to support
...
-
You don't need to show your face directly after tab.
check it out, for example, say this noodle
https: mega.nz fm contacts
after cutting the sidelines tab, he can load it as if he doesn t have to check it. what kind of technology can this do? Php add some skills, can you?
...
-
I want to write an e-commerce site with php, js, mariadb (mysql), but I have a big problem with "update"!
I want to be an e-commerce website. is paired with php + mysql . Now I have a big problem . At present, I intend to do a customized service , that is, this set of e-commerce websites are sold directly to you, and all the functions are maintained by me....
-
What is the principle of the relational number table? There is a query, but the query does not show?
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...
-
Batch updates to database?
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...
-
Update data sheets and data sheets directly with sql? The number of databases that make my balls hurt.
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...
-
Mysql does not have the data for this condition? Update the value of data from another table to another table?
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...
-
How to change the idea of native php and laravel to laravel?
I am currently working on a web site based on php + mariadb , but recently I want to change the web site to laravel traffic , but it is impossible to achieve it in the short term.
so I want to ask the great gods how can I change the code to achieve t...
-
There is no problem with the quantity when printing, but the number is wrong when sum?
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
...
-
Find out the order, but does not contain some goods! As long as there is a non-conforming order, it will not be displayed?
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'd like to ask about the concept of php OOP and sort out some parts that I don't understand.
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...
