How to list data in a section by ID using while loop in PHP?

I have a mysql table with these columns: series_id, series_color, product_name In the output I want to list the data by sections, one section per series_id like this: A12SeriesProduct-Milk-Tea-sugar-waterB12SeriesProduct-Water-Banana -Cofee-Tea

P粉505917590 2023-11-17 20:03:03 0 1 290

Best way to preload route data before accessing the route.

Before rendering the page for a given route, I want to first get the necessary data synchronously. Ideally I'd like to get the data in the page component, but I'm not opposed to doing it in the router file. I've read and tried various approaches, but part of the challenge comes from the fact that th...

P粉197639753 2023-11-17 14:54:42 0 2 379

How to set Laravel Spatie permission setting method to define a set of permissions for each user based on role?

I have 4 types of users using my system: 1. Super Admins 2. Team Super Admins, 3. Administrators and 4. Managing team members, since I use spatie to handle roles and permissions, I have a set of modules (permissions) that are common to all types of users, and another set of modules (permissions) tha...

P粉197639753 2023-11-14 12:58:58 0 1 292

Implement filters and pagination using Laravel Eloquent

I'm trying to create an API that will return all customer records from a database. But this provides paging and filtering functionality. , the filter function is an optional query parameter. So it doesn't have to be included in the query parameters. But I'm having problems doing this. This is the in...

P粉010967136 2023-11-12 18:42:35 0 1 310

Stream data from OpenAI's API using AJAX, PHP, and server-sent events

How can I use Server Sent Events (SSE) to stream data from the above API to a browser client using JavaScript and PHP? I've been working on this problem for hours and I can't seem to figure out what's going wrong. For reference, I tried adapting the solution here: StreamDATAFromopenaiGPT-3APIusingPH...

P粉762447363 2023-11-11 12:03:23 0 1 497

Leverage VueJS components in PHP

I want to mix basic HTML generated by Php and VueJS components without having to use VueJS all the way down to the lowest dom leaf. The parent layout has a Vue application applied, all headers, navigation, sidebars, etc. are Vue components, and the main content on most pages is still pure HTML gener...

P粉611456309 2023-11-11 00:01:44 0 2 288

Retrieve MySql rows with the same column value

Let us consider the following table - IDScore19521003884100573 I am a complete SQL noob, but how to return a score containing ID2 and 4? So it should return 100 since it appears in both ID2 and 4

P粉464088437 2023-11-10 21:53:39 0 2 331

Livewire undefined

I'm having trouble deploying my LaravelLivewire project to the server. The problem is that the livewire.js file is not accessible and showing error Livewireisnotdefined in console My server environment is LNMP. I'm using Nginx instead of apache. There is another way to solve this problem, which is t...

P粉450744515 2023-11-09 15:34:23 0 1 233

How to simulate a request to a third-party API using the GuzzleHttp client in a Laravel functional test?

In a Laravel project (Laravel8 on PHP8.0) I have a functional test where an internal endpoint is tested. The endpoint has a controller that calls a method on the service. The service then attempts to call the third-party endpoint. It is this third party endpoint that I want to simulate. The current ...

P粉842215006 2023-11-09 11:42:58 0 1 207

Preserve caret position in HTML contenteditable when inner HTML changes

I have a div that acts as a WYSIWYG editor. It acts as a text box but renders Markdown syntax within it to show live changes. Problem: When typing letters, the caret position resets to the beginning of the div. consteditor=document.querySelector('div');editor.innerHTML=parse('**dlob***cilati*');edit...

P粉668804228 2023-11-08 22:38:23 0 2 285

What is the difference between Text and LongText in Laravel migration?

The migration file parts are listed below: Schema::create('samples',function(Blueprint$table){$table->id();$table->text('title1');$table->longText(' title2');$table->timestamps();});

P粉268284930 2023-11-08 16:42:35 0 2 278

Encountering Laravel Mix error while trying to install Laravel Breeze

I'm trying to install LaravelBreeze in my new Laravel application. Everything is working fine, but when typing npmrundev in the console I keep getting this error: 3 warnings present in child compilation (each using 'stats.children:true') '--stats-children' for more details Info) I think everything i...

P粉635509719 2023-11-07 23:05:02 0 1 299

How can I set the height of an outer div to always be equal to the height of a specific inner div?

I have an outer div that contains three inner divs. I want the leftmost inner div to always determine the height of the outer div. If the other inner divs have less content [than the leftmost div], they will have empty space. If they have more content [than the leftmost div], they will get a scrollb...

P粉903052556 2023-11-07 13:59:30 0 2 314

Thousand separator PHP

I extracted this $number=100000.5; from the database. What I need is to set the format to 100.000,5str_replace+number_format I guessed it. My replace works perfectly, echostr_replace('.',',',$row['anskaf_sum']); (returns: 100000,5) but when I add number_format, I somehow fail with number_format($row...

P粉848442185 2023-11-07 12:00:02 0 1 207

How to prevent the page from scrolling after route changes in Nuxt?

I have a Nuxt project. When I change the route from http://localhost:3000/catalog/postery to http://localhost:3000/catalog/postery/all?photos%5B%5D=262, my page scrolls to the top, only after After my route changed my file scrollBehavior.js: exportdefaultasyncfunction(to,from,saved

P粉865900994 2023-11-06 18:56:58 0 1 266

How to embed background video in HTML/CSS?

Hi everyone, I recently encountered a problem. I'm trying to set a video background to my site, but the centered text runs all the way to the bottom, I don't know why, yet the navigation bar is fine. I've done a lot of research but can't find a solution. For CSS, I made the following settings: *{mar...

P粉176203781 2023-11-06 13:59:13 0 1 240

Rewrite the title to: Vue 3: Transfer content to element and replace

I'm using Vue3's teleport to render an element into a div and it works as expected. Teleport will add the item to the selected element but will not replace the current element in the div. How can I set up the teleport to replace elements within the div, similar to how a vue app replaces the content ...

P粉237029457 2023-11-06 11:01:38 0 1 451

Alternative to copy or download generated QR (vue-qrcode) code using VueJs

I'm using the plugin "vue-qrcode" to generate a QR code for users to create a QR code for their public profile link so they can share it on their business card. The idea now is to give the user the possibility to download the QR code through a button and copy the QR code to the clipboard t...

P粉294954447 2023-11-06 00:01:12 0 1 301

Heroku/Nuxt: nuxt command not found (sh: 1: nuxt: not found)

I ran into a problem where I ended up deploying a server side nuxt app with express server to Heroku. The build is successful, but when trying to launch, I get the following error: 2021-07-29T18:13:38.000000+00:00app[api]: Build successful 2021-07-29T18:13:42.050534+00:00heroku[web.1] :Process exite...

P粉757556355 2023-11-05 18:59:02 0 1 290

Vue 3 Composition API: Render Props and v-if even if value is False

I'm running into a problem here that I feel like I don't really understand. I include a child component that is passed a prop called "active" which can be set to true or false. The idea is that if "true" is passed, then part of the component will be displayed, if "false"...

P粉786432579 2023-11-05 14:48:16 0 2 280