codeigniter - PHP CI framework caching problem online etc.

CI goes to the database to query the results. If the cache is turned on in the configuration, it can be cached. However, it is cached in the form of files. If I use memcache to cache the results, is it unnecessary? There is another problem. The caching mechanism of CI itself is similar to memcache. ...

为情所困 2017-05-16 16:43:32 0  1  707

Open source PHP novice entry-level framework WillPHP (similar to ThinkPHP)

WillPHP is a lightweight development and learning MVC framework, an entry-level framework for PHP newbies (similar to ThinkPHP). ###Lightweight and extremely fast size 211KB (uncompressed), 22 initial files loaded (15 with page cache enabled), memory overhead <100KB. ###Main functions: automatic ...

P粉605904125 2022-07-23 16:30:16 0  0  828

How to configure the domestic pypi mirror source?

PyPI (Python Package Index) is a software repository for the Python programming language. Developers can find and install software developed and shared by the Python community through PyPI, and they can also upload their own developed libraries to PyPI. So how to configure the domestic pypi mirror s...

萌褚 2021-11-09 15:43:28 0  5  1323

Under what circumstances should cache be used? How to optimize the front and back ends (mini program page)

A product details interface, query data through product ID, and the front end mainly displays a picture. Database field pictue: the saved picture address, the picture is stored on the server. The problem now is that the pictures are loading too slowly, sometimes it takes a second to open, and someti...

小萝卜头 2020-05-16 18:32:29 0  3  1385

How to clear database cache in mysql 8 innodb

I've tried running the same query multiple times on the same mysql8 database and table. I need to experiment to determine if tuning the query and/or the table itself can improve performance. However, after the first try, the response time is much faster, I think because the data is cached. mysql8inn...

P粉571233520 2023-08-27 23:46:28 0  2  709

centos - How to run the python environment in the one-click installation environment of lnmp (php)

The server is centos. The backend language of the server is php, but there is an open source library that is a Python version. How can I run two environments on one server? I'm a newbie, please give me some guidance. Thank you.

淡淡烟草味 2017-05-19 10:06:58 0  5  752

Caching reporting data in the same transaction database vs using a data warehouse

We have a SaaS solution where each tenant has its own MySQL database. Now I'm designing a dashboard for this SaaS system and it requires some analytical charts. To obtain the data required for the chart, we can query each tenant's transaction data in real time from its database. and get updated grap...

P粉511749537 2024-02-26 19:20:23 0  1  438

How does PHP save setting information locally?

For example, there are many forms in a PHP page, which require users to fill in some information parameters. Generally, these information parameters are saved in the database, right? The next time the user opens it, it will be read from the database and filled in automatically. What I'm thinking abo...

流年 2019-08-20 11:38:56 0  2  1110

I would like to ask if PHP can read the mssql record set directly and store it directly into an array? Thank you

It used to be asp, but now it is transferred to php. For example, $sql = "SELECT * FROM abcDB"; //Record 20 records. How to get a two-dimensional record set and store it in an array at one time. Reason: After the database operation is completed, I want to disconnect. The data is slowly cir...

stock2 2019-04-27 20:02:10 0  1  1005

Ask the teacher about the weird problem of logging in

Sorry to cause trouble to the teacher, please ask the teacher: "I directly used the teacher's courseware code to test, but when I opened the login page for the first time every day, I successfully logged in and entered the page normally, but when I used logout() (or directly accessed the page t...

弹下弹下 2018-10-11 21:39:31 0  2  1328

How to pass data to backend in React Native

I'm trying to develop a barcode scanner app for IOS, now I have managed to create a scanner that can read data from barcodes, but not just reading the data, I also want to store the data into a database, I have explored Some source code on the other side is my code. Scanner.js This is the scanner so...

P粉878542459 2024-03-29 09:26:34 0  1  421

I have the front-end source code, but I don't know how to connect it to the back-end.

I want to develop a backend management system, similar to cms. There are more than 1000 html files. I want to convert them into php or stored databases, but I don’t know how to operate them. I tried to transfer these files to the WordPress theme yesterday and failed many times. I want to Please tell...

P粉932382659 2022-05-24 16:47:40 0  0  1027

Display json type data in blade

Displaying json type data in blade I have a table in my database which stores data and one of the data is of json type, everything is going fine but when I want to display these json in blade the problem starts which is My json data type [![Enter image description here][1]][1] In my blade I use php ...

P粉064448449 2024-03-22 12:05:15 0  1  395

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  931

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  802

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  682

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  658

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  1076

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  561

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  759