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

How to make table cell values hyperlinked in Dash? (Using Plotly, Dash, Pandas, etc.)

I want to set the cell value under the "JobLink" column as a hyperlink. When I click this link it should navigate to the link in a new tab/window. Please help how to achieve this? The table is displayed in Dash and I'm finding it difficult to make it hyperlinked. Attached screenshot: https...

P粉517090748 2023-11-17 18:47:10 0 1 283

How to access $vuetify instance in setup function

Is there a way to access $vuetify (and any other added globals) in the settings function? Is there a way to give composables access to it? ...setup(){const{isDesktop}=$vuetify.breakpoints.mdAndUp;//<===howtoget$vuetifyreturn{isDesktop};},

P粉659518294 2023-11-17 17:47:45 0 1 366

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

New title: New script does not correctly display strange character encoding of stored data

I'm trying to rewrite an old website. It is in Persian and uses Persian/Arabic characters. CREATEDATABASE`db`DEFAULTCHARACTERSETutf8COLLATEutf8_persian_ci;USE`db`;Almost all my tables/columns COLLATE are set to utf8_persian_ci I am using codeigniter for my new script and I have 'char_set'=>'utf8'...

P粉337385922 2023-11-17 10:51:01 0 2 273

Nuxt.js SSG (Static Site Generator) Get API Data

When building a project using a static site generator, I understand that documentation created in advance is provided to the user. If there is logic to use axios to obtain data and display it on the screen when entering the page, is the corresponding API cached or not called?

P粉593536104 2023-11-16 21:36:07 0 1 176

How to get multiple data with the same user ID from a table in Nest.js? Assuming I have a users table, how do I get the data that matches the user ID?

How to get multiple data with same user id from table in Nestjs? Let's say I have a users table. How to get data matching user ID? import{Injectable}from'@nestjs/common';import{InjectRepository}from'@nestjs/typeorm';import{Repository}from'typeorm';import{usertbl}from'./usertbl.e

P粉116654495 2023-11-16 20:41:42 0 2 214

Call to undefined function create_function()

I get this message on the home page of the website: Fatal error: Uncaught error: calling /customers/7/e/7/jovobytes.be/httpd.www/wp-content/themes/inovado/framework/inc/widgets/custommenu Undefined function create_function(). php:67 Stack trace: #0/customers/7/e/7/jovobytes.be/httpd.www

P粉198670603 2023-11-16 19:00:36 0 1 277

Catching Guzzle exceptions

I'm trying to catch exceptions in a set of tests running on an API I'm developing, and I'm using Guzzle to consume the API methods. I have wrapped the test in a try/catch block but it still throws an unhandled exception error. Adding an event listener as described in their documentation doesn't seem...

P粉511749537 2023-11-16 14:36:03 0 12 290

How to optimize tp6 query

When the tp6 model is associated with multiple data tables for query, the query will be very slow. How can I optimize it? Is there any optimization method? Help! ! ! ! !

以后会怎样 2023-11-17 08:50:36 0 0 84

Using triggers and constraints to limit the number of records in MySQL

I have a table called BFFs that stores user IDs and best friends' user IDs, and I want to limit the table to 3 best friends for each different user. I mean if the table structure is: BFFs(userID,userID) the records are: (3286,1212)(3286,4545)(3286,7878) In this case if the user with ID 3286 should n...

P粉807397973 2023-11-14 13:35:02 0 4 434

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

How to use open primitive tag in next js 13?

In the recent NextJS13 update, they introduced a new way of handling meta tags that differs from the traditional method of creating a NextHead and writing the usual html meta tags. In the new method, we create a metadata object-like method. But I haven't found a way to use open graph metadata. expor...

P粉768045522 2023-11-10 23:03:51 0 1 527

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

Title rewritten to: Dynamic component import in Vite with React and typescript causing failure in fast refresh

I'm trying to create a multi-step form and I'm putting the data in a separate file for constants like this import{lazy} from 'react';exportconststeps=[{id:0,name:'PersonalInfo',component: lazy(()=>import('../components/PersonalInfo')),},];I pass it to the custom hook in the context constdataSteps...

P粉546179835 2023-11-10 20:45:29 0 1 505

Why is the OpenAI Chat GPT (GPT-3.5) API unresponsive when the stream parameter is set to false?

You can see the $prompt value in my application below. When I enter this prompt value, chat GPT gives no results. But this is because "stream" => false in the parameter. If "stream"=>true, chat GPT gives the result. My question is why chat GPT doesn't give results when &quo...

P粉865900994 2023-11-10 18:39:06 0 1 338

How to publish SQLite database data to an online MySQL database in Flutter?

How to sync offline SQLite to MySQL online database in Flutter? Any suggestions?

P粉590428357 2023-11-10 12:36:40 0 2 247

XAMPP/SQLSRV: Unable to find Sqlsrv in PHPINFO(); - error from connection

I'm trying to connect to my SQLServer database hosted on a LinuxVM. I'm running xampp on my development windows machine, and the connection is from a php site I'm building. I think I need to use sqlsrv to connect. I downloaded dllsql-server-ver from https://learn.microsoft.com/en-us/sql/connect/php/...

P粉201448898 2023-11-09 22:34:33 0 1 172