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

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

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

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

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

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

What are the performance numbers next to components in the Vue dev tools?

Does anyone have insights or resources for a certain feature in the Vue development tools? On the components pane, it shows my component, and then these little red and yellow squares, and what I'm assuming is the performance of the component. When I first load the app they don't appear, but for exam...

P粉420868294 2023-11-09 14:46:48 0 1 305

Merge associative arrays with shared column values

I want to merge two arrays based on common column values. Here are my 2 arrays: $array1=[["total_process_per_category"=>"6","category_id"=>"1"],["total_process_per_category"=>"2","ca

P粉966979765 2023-11-09 08:47:41 0 2 217

PHPcurl, a dedicated network interface

I have a (webserver) server with two network interfaces. The first is a standard interface for public internet connections and the other is a virtual VPN network interface. Now I want to send POST data via curl on other web services inside the VPN network. How can I say that the php there must use t...

P粉521697419 2023-11-08 20:01:46 0 1 261

Fix issue in Laravel-8 trying to read property "id" on null

I get this error when running phpartisanmigrate:fresh --seed This command will create a table in the MySQL database and populate the database details DB_DATABASE into the .env file. parent::boot();static::creating(function($model){$user=Auth::user();model->created_by=$user->id?$user->id

P粉194919082 2023-11-08 14:07:01 0 2 155

sqlalchemy.exc.ArgumentError: list argument must contain only tuples or dictionaries

I've been trying to use sqlalchemy to dump data into a mysql database. When I try to do this, it gives the error sqlalchemy.exc.ArgumentError: List arguments must contain only tuples or dictionaries. The following code is used for insertion. definsert_data(db,table,rows):db.execute(f"INSERTINTO...

P粉080643975 2023-11-07 21:06:02 0 1 286

Prevent MySQL from reading when updating

I have two simple queries, one to read the table and one to update the table. How to lock the read of a select query while the update query is running. Now in MySQLInnoDB, I noticed that writes/updates are locked by default, but reads/selects get the old data before the transaction. I tried using a ...

P粉190883225 2023-11-07 18:05:53 0 1 203