Asksearch_php.cn

Community Learn Tools Library Leisure

English

Popular searches：
PHP
MySQL
jquery
HTML
CSS

How to hide tabs on small screens?

I have an antd menu with labels and icons. This is the minimal representation of the design. Codesandbox Now what I want is to hide the labels and only show the icons when the menu starts showing ellipses. Since I'm not very familiar with CSS, I was wondering if this functionality could be achieved ...

P粉520204081 2023-08-17 12:53:57

mysql - String replacement based on dictionary

Source table: Dictionary table: It is expected to replace the values in the source table according to the dictionary table. The target results are as follows: I tried using the replace function, but it can only be replaced individually. (Note: Since other values are separated by commas, the ...

PHPz 2017-05-18 10:50:38

When I try to translate the element via js it doesn't work

All elements with em class need to be displayed one at a time based on the rating. I made the emoji container as big as the icon, so with the overflow hidden, only one emoji container can be shown. The problem is, when I try to modify the transform properties, it doesn't work. conststarsEl=document....

P粉277305212 2024-02-17 20:11:05

Move a varchar column containing CSV format to another table

The database I created 15 years ago was poorly designed. I have a varchar column containing comma separated strings: '5,8,13'. The string does not contain spaces and trailing commas, but the number of values is variable. What I want to do is create a new table and move these values paired with t...

P粉478188786 2023-09-10 19:59:25

How can I make text turn into a new element (like a divider) when clicked?

I'm trying to find a way to make certain text on the page turn into separators/new elements when clicked. I don't know how to explain it, but like, imagine an image with a title below it - click the title, and then the image above becomes like a text box/different images/scrollable separator. I'm tr...

P粉872101673 2024-04-04 11:21:03

The right way to achieve component decoupling

I'm dealing with communication between two components (using Vue2), one of which is a button, which can have states like initial, loading and completion (success or failure), for each state of the button I may display different text, Different icons (loading: spin icon, successful completion: tick, ...

P粉476475551 2023-09-14 10:57:11

Is storing delimited lists in database columns really that bad?

Imagine a web form with a set of checkboxes (any or all of them can be selected). I chose to save them in a comma separated list of values stored in a column in the database table. Now, I know the correct solution is to create a second table and normalize the database correctly. It's faster to imp...

P粉020556231 2023-08-27 19:52:49

Visual Studio Code: Effective technique for clear dollar sign separation in variable names

I just switched from Atom to VisualStudioCode and I'm looking for a way to visually separate the dollar signs from variable names. Something like this is possible in Atom by editing a personal CSS stylesheet. After applying some CSS rules, this can be achieved: there is no space character between th...

P粉543344381 2024-03-21 20:31:19

Sort by date, use IN to get latest and previous entry for multiple entries

My goal: I have a list of stock_ids and want to get the last bids (sorted by date) one for each stock_id. For the picture this means I want: stock_id bid 3663.91953146.4428129.02798 One problem is that we have stocks like Gazprom that are suspended, so one of the last bids could be for example 2021-...

P粉653045807 2023-09-03 23:52:49

How to add a column in select query with right join

I'm trying to find a way to add a country code to a database call record based on a phone number column. I have a table that contains countries and their dialing codes (called countries). I can query all records and append the country code, but I need to be able to filter and paginate the results. I...

P粉564192131 2024-01-10 18:08:33

flex css - clip element after certain height instead of wrapping

The borders represent static height and width. I want item 5 and 6 to stay on the second row and cut off item 3 and 6 instead of wrapping a third time as shown. How can I achieve this with Flex? To complement this problem, the width of the container (displayed with a border) can be resized by user a...

P粉785957729 2024-04-01 14:02:02

How to find JSON data based on other content in a JSON object when duplicates exist?

I'm currently implementing some data charts on a website, and I have a JSON that contains some data, specifically some ID numbers, some dates, and some data points. Because I have multiple dates under the same ID, I'm looking for a way to do essentially "find a JSON object with this ID and mont...

P粉713846879 2024-04-04 10:57:45

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

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

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

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

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

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

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