When using laravel, the problem of saving checkboxes to the database

When using laravel, there is a problem with saving checkboxes to the database. This is the demo of html: https://jsfiddle.net/4j3hoyvn/ Question: How to save the checkbox (checkbox) in the form in the database? Create a separate table? The effect to be achieved: When the "Edit Page" is ope...

滿天的星座 2017-05-16 16:51:04 0  1  526

Rewrite the title as: Translate "Array as session variable" into Chinese as "Use array as session variable"

In PHP, is it possible to set an array as a session variable? The situation is that I have a table (first page) in which some cells have links to specific pages. The next page will have a list of names (the second page, which I want to save in a session array) with corresponding checkboxes. After su...

P粉833546953 2023-08-21 18:07:56 0  2  567

Best way to store checkbox value in session when paginating

I work with Symfony and Twig. I currently have a twig page that contains a list of products, I use a foreach loop to display them, and set up pagination to limit the display of products. I have a form in this page which has a checkbox as input and when I go to the next page I need to check the save ...

P粉592085423 2024-02-25 16:37:32 0  1  419

Pass form with multiple ids and select to PHP using AJAX

I'm trying to collect selected checkboxes, update or delete them and pass this form to php via ajax. I'm very new to this and have spent a few days trying to figure out a way. Web research didn't give me any results, I tried sending ajax a few different ways - no results. Although using only PHP, I ...

P粉729198207 2024-02-26 14:17:13 0  1  496

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 0  2  486

How to verify Google reCAPTCHA v3 on the server side?

I just set up a new google verification code with checkboxes and it works fine on the front end but I don't know how to handle it on the server side using PHP. I tried using the old code below but the form is sent even though the verification code is invalid. require_once('recaptchalib.php');$privat...

P粉904191507 2023-08-27 16:48:47 0  2  681

vue-easytable plugin conditionally displays columns

I'm using vue-easytable plugin version 2.8.2 to display a table inside a Vue component. I'm having trouble finding how to conditionally display a table column. In the demo shown here, when the Row Radio or Row Checkbox switch is turned on, we can see a column being dynamically added to the demo tabl...

P粉066224086 2024-03-27 17:51:33 0  1  408

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

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

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

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

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

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

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

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

How to hide mui TextField label?

I'm developing a Nextjs app and I have a dashboard navigation bar built with mui that contains a notification that opens the notification box, which is built with regular HTML and CSS. dashboard-navbar.js: importNotificationBoxfrom"./notification-box/notification-box";//...exportconstDashb...

P粉239164234 2023-09-05 15:41:00 0  1  676

Custom Bootstrap 5 carousel on mobile (multiple items, but not in one row)

I'm having trouble trying to customize the carousel layout on mobile devices. I want it to show every item of the carousel on mobile instead of just one, but after trying with some CSS and JS, especially using displayfloat or max-witdh I'm just starting to think this isn't possible, Or I don't know ...

P粉763662390 2023-09-05 11:53:56 0  1  593

How to use Firebase Authentication with multiple login methods and role-based authentication?

I am creating a react.js application with nodejs as backend and I want to use these authentication methods to login using email/password, login using google and login using phone, now I want to keep the uniqueness of the user while signing the user's name for Any of these, I will also get other deta...

P粉574695215 2023-09-05 12:18:10 0  1  656