mysql - database table structure design

Describe the requirements: Now we need to design the database table structure. There are many types of rules. How to design tables to store these rules. Each rule has common attributes and different attributes. Currently, I think of two methods: the first is through foreign keys (common attributes o...

習慣沉默 2017-06-30 09:55:23 0  3  1060

Regarding the problems encountered in chain operations, please give examples.

The article list uses a chain operation to associate the user table and the article table and uses volist to loop this data. When you click on this data to jump to the details page and pass an ID, you will find several problems: 1. The data time obtained by the chain cannot be automatically converte...

2018-12-18 09:27:07 0  4  1366

How to sort query results according to fields of another table through chain operations in TP5

Specific situation: one user table and the other is a user level table. I query (select) the information of the user table and want to sort it according to the power field of the user level table. What I wrote myself is to query the records one by one through a for loop and then write them to In a t...

葫芦娃平衡盘 2018-04-19 16:50:01 0  2  1407

Create a trigger in a mysql stored procedure

I want to create a trigger in the process. But after some research I found this is not possible. Can you suggest me another way to achieve the following? (For some reason I can't share the exact data and query. Please refer to similar queries.) What I want I created a temporary table that contains t...

P粉197639753 2024-02-25 19:35:21 0  1  461

node.js - How to best communicate with each other between http service and tcp service?

The project has a web background. The operations in the background issue instructions for the settings of the hardware devices. However, the hardware devices use the TCP protocol, so a separate TCP service is set up to communicate with the hardware and run in two separate processes. The information ...

PHP中文网 2017-05-16 13:38:05 0  4  794

python - How to call up the modal box through buttons on the django list page

As shown in the picture above, I want to call up a modal box through a button on the Django list page to perform confirmation and cancellation operations. I don’t know how to operate the template. The template of the list page is provided in the Django source code. If it is an ordinary template file...

phpcn_u1582 2017-05-19 10:06:50 0  2  674

javascript - Interaction with jQuery's ajax background in vuejs

I want to use vuejs to call jQuery's ajax, but the event on the page is triggered. I want it to be triggered as soon as the page is loaded. How to operate the code is as follows: HTML: {code...} js: {code...} Me What should I do to send an ajax request as soon as the page is loaded? Please give me s...

高洛峰 2017-05-19 10:41:03 0  3  519

How to save notifications for multiple users in phpmysql database without overloading the database with records

I'm concerned that I could easily create a crawl in the database while trying to ensure that all users in the database can view the same messages. The problem is that I need to be able to send a message from my admin area and have all users receive notifications and also have the option to mark the ...

P粉068174996 2024-03-30 22:51:20 0  1  517

android - communication problem between two fragments in ViewPage in fragment

In the main fragment, there is a toolbar with a ViewPager underneath it, and a fragment inside the ViewPager. Now I want to operate the button on the toolbar and change the data in the Fragment in the ViewPager. Is there any good communication method?

PHP中文网 2017-05-16 13:21:02 0  2  674

Build efficient Laravel applications: implement dual API and view functions, and separate controllers

I want to structure my Laravel application so that API and view functionality are handled efficiently while avoiding duplication in controllers. How do I set up my application to have two separate controllers, one dedicated to API operations and another for view-related operations? Also, what is the...

P粉558478150 2023-08-16 10:39:36 0  1  642

Can the LightningChart shared axis feature stack 2 line series on multiple Y axes with a shared X axis?

I need to create stacked line chart. Basically I want to create 2 Y axes and have them share a common X axis. The two Y-axes should be stacked on top of each other. I know ChartXY has an option to add an axis (https://lightningchart.com/lightningchart-js-api-documentation/v4.0.0/classes/ChartXY.html...

P粉894008490 2024-02-04 10:24:44 0  1  457

How to sort objects of different classes in java

Assume that two classes A and B have a common attribute date. I want to sort the two List<A> and List<B> according to date. What is the best way to do it? The method I know is to write a base class, and then A and B inherit this base class, and then call Collections.sort(...

学习ing 2017-06-14 10:52:58 0  3  844

python selenium gets image verification code

I want to cache the image verification code locally, and then let the user see the image through the web service and manually type the code to log in. Since the official operation is interface-less, selenium screenshots cannot be used. In addition to selenium screenshot and right-click method, is th...

PHP中文网 2017-06-12 09:21:28 0  4  1601

Which options in the Vim editor configuration file are necessary?

Although Vim is very smooth to operate, for a Chinese developer, Vim's default configuration often appears garbled. The second is the issue of indentation, how to make the code layout format seen by different system platforms have the same style. When participating in open source projects, there are...

伊谢尔伦 2017-05-16 16:43:13 0  4  865

File reorganization causing problems with selections, hyperlinks and import templates?

I'm using jQuery to import a common template file into certain parts of the page. Everything works perfect until I organize my file structure differently. Now, my SELECT dropdown doesn't work except for the title, and even though VSCode autopopulates half of the regular hyperlinks, I can't keep trac...

P粉436410586 2024-02-04 10:37:52 0  1  528

Laravel, limit database queue to 1 email per minute

My application is hosted on a shared hosting platform which has a limit of 200 emails per hour. My application is running the database connection driver and I have 3000 jobs in the jobs table. I want to limit this queue so that it only sends 1 email every 30 seconds or 1 minute to ensure there are n...

P粉310931198 2023-12-13 14:53:22 0  1  612

Recruiting PHP development engineers

Job Responsibilities: 2+ years of PHP development experience, proficient in MySQL database, familiar with Linux operations, and able to use Git, continuous learning ability, good at communication, strong ability to withstand pressure, focus on efficiency, familiar with HTML5, CSS3, JavaScript and ot...

手机用户1617931986 2022-09-08 09:31:12 0  2  1032

Inheritance/Shared Operations and Getters in Pinia

I have several Pinia stores that are supposed to share a set of actions and getters, but I'm not quite sure how to implement this efficiently. I'm building an application that allows users to manage a variety of different media (books, movies, TV shows, etc.). The way I'm currently thinking about it...

P粉662614213 2023-12-22 13:50:12 0  2  519

The Linux system does not support PHP operations to access the database. Can you please advise on other solutions?

The database of Windows computer software is accessible. If you want to share data, upload the database mdb file to the web server through php, and then php reads the mdb database into html. When the web server is windows, the test is normal. The Linux system does not support PHP operations to acces...

forever 2017-10-31 14:35:35 0  1  1029

Change database using partial Http request Url during Spring Boot execution

Every time there is a new Http request, I need to change the database I am currently using and whose name is part of the HttpURL request. I'm trying to use the following code, but when I call the service and it's executing, I can't call it again until the previous service completes or it crashes. I ...

P粉663883862 2024-03-31 12:55:54 0  1  435