Questions about dates growing periodically and inserted into the database

//Get a (string character time), b (number of times) from the form. $b=$_POST['b']; //Number of times $a = $_POST['a']; //Date$d = strtotime($a); //Convert string time to timestamp. //The database is simple in design, automatically growing the three fields id, a, and b. The connection code is omitte...

用岁月换光辉 2019-05-04 16:07:40 0  0  1005

The rewritten title is: Using PHP buttons combined with jQuery and POST methods to get return values

I have a simple form to get usernames and would like to achieve the following: When the user clicks on a button, the button will be disabled to prevent multiple clicks (in real cases it may take a few seconds to process all the data, e.g. calling an API , write to database, etc.); after clicking, a ...

P粉738821035 2023-09-05 08:42:27 0  2  598

Demonstrating SQL Virtual/Temporary Table Approach: Extracting Data from an Associative Array

I need a simple SQL query to display a virtual/temporary table without creating it in the database. I'm using PHP to create a query string with data. My current PHP code is: $array=[['id'=>1,'name'=>'one'],['id'=>2,'name'=>'two'],['id '=>3,'name'=>'three']];$subQuery="SELECT{$...

P粉066224086 2023-09-03 16:26:28 0  1  578

PHP code to convert numbers (0-23) to AM/PM time format

I have an array of numbers ranging from 0 to 23, each number represents a time from midnight to 11pm. It sorts by the key's value in descending order. 22=>int83=>int75=>int6 and so on. For example, if the key of the first element of the array is 22, I want the variable $first to be "10...

P粉009828788 2023-12-24 19:03:07 0  4  545

Change input quantity step value of simple product based on weight in WooCommerce

I want the quantity selector value to change based on the weight we set in Shipping > Product Weight for a simple product. As shown in the image below, when we set the weight of the product to 0.5 kg, the product quantity selector starts from 0.5 and if we set it to 1 kg, it starts from 1. Finall...

P粉351138462 2023-09-04 21:55:45 0  1  595

JavaScript: increment and decrement functions

I'm practicing my JavaScript skills, I've been mastering a simple incrementing counter function, I seem to have it figured out, so today I want to take that script to the next level and decrease the value, here is my question, When I click to add a number and then continue to click on the minus sign...

P粉761718546 2024-01-29 09:53:20 0  1  536

Updating existing codebase to PHP 8.1: Handling non-nullable internal function parameters with Null values

I've just started upgrading my code to be compatible with php8.1. I have a lot of code snippets where I'm passing potential null values ​​to inner functions. if(strlen($row)>0){...} where $row comes from a source that may have null values ​​(such as a query). This may generate a deprecation warni...

P粉344355715 2023-10-31 20:01:48 0  2  828

Sequentially rename files on upload based on existing files in directory

I'm using this (php) upload code I found online for an image upload form. I realize there are already a lot of questions/answers on the site about "renaming files" when uploading, and I've researched them quite a bit. So far...none of them seem to specifically address what I want to do. Ho...

P粉310931198 2023-09-10 13:14:12 0  1  738

Functionality without using <br> html to add line breaks

I'm currently learning VueJS and I've made a simple app that pulls information from an API and displays facts about a country based on a given 2 letter country code. Data retrieved from the API is mapped to country and properties. It stores detailed information about a country such as time zone, cur...

P粉567112391 2023-09-08 15:34:08 0  1  682

The question is still the same, but the title is rewritten as follows: My Javascript random function fails to generate valid responses

I'm making a simple random number generator game using JS and HTML. In this game you can set minimum and maximum values ​​of random numbers. However, when setting the variables and recording the results, an impossible number appears. For example, if I set the minimum value to 50 and the maximum valu...

P粉682987577 2024-04-03 22:03:14 0  1  466

Ways to fix issue 2003 (HY000): Unable to connect to MySQL server 'db_mysql:3306' (111)

I recently tried to containerize my FastAPIPython server (also for replication/doubling purposes). Before, I had just a MySQL server in a Docker container and everything was fine, but when I also made my web server a service, it couldn't connect to the MySQL server, so now the application doesn't wo...

P粉178132828 2023-09-05 11:18:47 0  1  915

Experiment with sorting after query limit

So this is my first question here, please forgive me if something is wrong. I'm trying to make a sort query based on constraints. So there is a Customers table with 90 records. I want to first perform a query limited to 3 records, and then sort the results of this query by a column called ContactNam...

P粉237125700 2023-09-05 14:46:42 0  1  795

CSS Grid: Create new row when child content overflows column width

I have a two column layout based on CSS grid. When the content of the second column exceeds 1fr I want to create a new row. As it currently stands, the content simply overflows the column. One requirement of this layout is that the items in the right menu column are in one row. I achieve this with: ...

P粉212114661 2023-09-05 15:18:28 0  1  673

PHP full text search functionality using AND, OR and NOT operators

Newbie question: I'm trying to implement a full text search on a search string using php and eloquent. $searchstring="+(victimsuspect)+crime-covid";$searchresult=RssItem::whereRaw("MATCH(description)AGAINST('$searchstring'INBOOLEANMODE)")->ge

P粉076987386 2023-09-05 15:06:32 0  1  646

Shortest way to convert all PHP types to string

I'm writing a general system that I hope can one day be applied to fields like medicine (i.e. it's "scientific"). I think the best way is to represent all the data in php with strings (true will be "true", false will be "false" and so on). The reason for this is that in...

P粉369196603 2023-09-05 15:34:44 0  1  1066

How to get average of DATETIME column in MySQL while grouping by other columns

I'm creating and populating a MySQL table using the following query: SETtime_zone='+00:00';CREATETABLEtimestamp_n_datetime(idINT,timeDATETIME,avg_timeDATETIME);INSERTINTOtimestamp_n_datetime(id,time,avg_time)VALUES("1","2023-01-0310:

P粉460377540 2023-09-05 11:46:21 0  1  559

Multi-device (mobile phone) synchronization - React Native

I'm trying to create a Lightshow that will launch on all users' mobile devices at the same time (can have up to 2000-3000 users). All users will use the Internet (Wi-Fi or mobile data). In our FE we use Apollo for subscriptions and it works like a charm. But the problem is, user A can get subscribed...

P粉151466081 2023-09-05 11:58:38 0  1  757

Spades, Diamonds, Hearts, Clubs => styles do not change font color in Chrome for Android

In Google Chrome on Windows, the card suit symbols (spades, hearts, diamonds, clubs) are colored correctly using the "style" attribute. Unfortunately, the same page displayed in Google Chrome on Android does not display the colors I defined but uses the default black and red. (See the atta...

P粉896751037 2023-09-05 15:25:13 0  1  809