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

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

Uncaught TypeError: Cannot set property of undefined (set 'innerHTML')

I'm trying to create a webpage using php, on an element of class "Continuous TextBox" (defined by my class), when clicked I have to start a Javascript function that should change the content of another function id "harta-modal" ” element, but that won’t happen. I keep getting the...

P粉022140576 2023-11-08 21:06:09 0 1 278

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

typeof something returns an object, not an array

x is an array. I used console.log(x) to output the result as ['value'] but when I checked the type of x using console.log(typeofx) it showed as object. why?

P粉659378577 2023-11-06 12:49:14 0 1 297

Sequelize CLI migration error: Cannot access property of undefined (specifically 'details')

I'm running npxSequelize-clidb:migrate to create a table in the database and the following message is returned: SequelizeCLI[Node:18.9.1,CLI:6.5.1,ORM:6.20.1]ERROR:Cannotfind"/src/db/migrations/config /config.json".Haveyourun"sequelizeinit"?ERROR

P粉463418483 2023-11-04 23:07:03 0 2 245

Using useFetch to retain cached data in Nuxt3

I have the following problem while using nuxt3. The dynamic page [slug].vue loads the data for the initial slug correctly. When I leave the page and come back, the new data does not load, instead the old data is still displayed. If I refresh said page with old data it works fine. This seems to happe...

P粉547420474 2023-11-03 21:01:41 0 2 244

Laravel Inertia JS Flash message only displays once

Because InertiaJS does not refresh the same route component, things like flash messages will only be displayed once, no matter how many times you pass the message from the backend. I've tried everything but nothing works, all I need is to be able to trigger the same flash message again after failing...

P粉852578075 2023-11-03 12:33:50 0 1 342

Updating existing codebase to PHP 8.1: Handling non-nullable internal function parameters with Null values

I've just started upgrading my code to be compatible with php8.1. I have a lot of code snippets where I'm passing potential null values to inner functions. if(strlen($row)>0){...} where $row comes from a source that may have null values (such as a query). This may generate a deprecation warni...

P粉344355715 2023-10-31 20:01:48 0 2 222

Vue 3 composition api - computed property returns undefined

Using the Vue3 composition API, how to return the calculated value of the property firstDigit? The keyword this in the computed property is undefined but when I exclude this I get the error fourDigitsisnotDefined. import{computed,reactive}from'vue'consstinput=reactive({fourDigits:...

P粉662089521 2023-10-31 19:00:10 0 2 197

TypeError when using vitest: default is not a function

I'm using vitest to do some unit testing in my vue application. I've written some tests but they fail with the error message: "TypeError: default value is not a function". But I am not using the function named default() in my code. importgetInfofrom'./info';vi.mock('axios',()=>{return{d...

P粉817354783 2023-10-29 18:05:17 0 1 238

Should we check mysqli_connect() errors manually?

The PHP manual for mysqli_connect() recommends checking the return value and displaying an error message on the screen. $link=mysqli_connect("127.0.0.1","my_user","my_password","my_db");if(!$link){echo"Error:UnabletoconnecttoMySQL.&qu

P粉031492081 2023-10-27 10:51:49 0 1 288

Get the calculated value of a CSS variable using a calc-like expression

In JavaScript, you can get the value of a CSS variable using getPropertyValue(property). This function is useful for retrieving variables declared in :root blocks. :root{--example-var:50px;} However, if this variable expression contains a calc-like function, the getPropertyValue call will return the...

P粉111627787 2023-10-25 09:39:36 1 2 521

PHP cURL method to get redirect target without following redirect

The curl_getinfo function returns a large amount of metadata about the result of the HTTP request. However, for some reason it doesn't contain the information I currently want, which is the target URL if the request returns an HTTP redirect code. I'm not using CURLOPT_FOLLOWLOCATION because I want t...

P粉575055974 2023-10-25 08:56:01 0 1 205

Laravel 5.3 auth check constructor returns false

I'm using Laravel5.3 and I'm trying to get the authenticated user's id in the constructor method so that I can filter the users by a specified company like this: namespaceApp\Http\Controllers;useIlluminate\Foundation\Bus\DispatchesJobs;useIlluminate\ Routing\ControllerasBaseController;useIllum

P粉769045426 2023-10-24 20:03:40 0 2 245

Instagram Public API ( __a=1 ) is disabled. Are there any other options?

I use instag ram public api (add __a=1 to parameters of url) to get post details (caption, imageUrl, postType, likes, commentsphpcnendcphpcn, number of views). But it seems Instagram has banned this recently and returns a 403. When I try to open the post directly via its usrl, it also asks for login...

P粉894008490 2023-10-24 16:54:59 0 1 187

Update multiple rows of data using PDO loop

I have a form that retrieves multiple rows of data, each item has a text area for users to comment on a specific item. The number of items returned is variable, and they do not have to leave comments in any/all boxes. <...

P粉384366923 2023-10-24 09:38:58 0 2 296

Why do you need to use React useState in the form of functional updates?

I'm reading the ReactHook documentation about feature updates and looking at the following quote: The "+" and "-" buttons use functional form because the updated value is based on the previous value but I don't see what the purpose of needing feature updates is, and how do they r...

P粉155551728 2023-10-22 15:37:50 0 2 247

Is there a way to retrieve specific "columns" from a PHP array?

I have an array of arrays with the following structure: array(array('page'=>'page1','name'=>'pagename1')array('page'=>'page2','name'=>'pagename2 ')array('page'=>'page3','name'=>'pagename3')) Is there a built-in function that returns a new array containing only the "name" ...

P粉423694341 2023-10-21 00:01:53 0 2 347

Asynchronous functions return Promises, not values

I'm trying to understand how async/await works with Promises. asyncfunctionlatestTime(){constbl=awaitweb3.eth.getBlock('latest');console.log(bl.timestamp);//Returnsaprimitiveconsole.log(typeofbl.timestamp.then=='function');//Return

P粉464208937 2023-10-19 18:54:01 0 2 193