Category "php"

SQL AVG() to 2 decimals

I'm trying to get this average to give me 2 decimals, so instead of 17.4534 I just get 17.45. I tried various combinations using CAST in each of the 2 places I

Laravel 5: Is there a non-case sensitive way to sort a collection by an attribute?

I'm struggling to sort an Eloquent collection using the sortBy() method. The issue is that the sorting is case sensitive and it first retrieves the uppercase re

WooCommerce single product page by Woolentor : Related product customize

I use WooCommerce, Woolentor, and WooCommerce subscriptions to construct a website. I'm trying to use the 'WL:Related Product' widget for Woolentor's Single Pro

WooCommerce how to update order meta data key value with woo rest api 3

I've been searching around but can't get it to work. Using the api v3 I'm able to get all orders and everything is ok, but now I need to be able to update a met

PHPUnit gives error: Target [Illuminate\Contracts\View\Factory] is not instantiable

I created a simple test for my new Laravel 7 application. But when I run php artisan test I get the following error. Target [Illuminate\Contracts\View\Factory]

How to call a php file with arguments from VBA for Mac? Equivalent of VBA.createObject("wscript.shell") on Mac?

Still in need of help :) I'm trying to adapt the following chunk of code to VBA for Mac (as the final implementation has to be on Mac): Dim ws as Object Dim res

FASTCGI process has failed frequently recently. Try the request again in a while

We have setup a Wordpress Website on IIS 10 which was working fine. But suddenly it stops working and i got this error "FASTCGI process has failed frequent

RabbitMQ PRECONDITION_FAILED - unknown delivery tag

We have a PHP app that forwards messages from RabbitMQ to connected devices down a WebSocket connection (PHP AMQP pecl extension v1.7.1 & RabbitMQ 3.6.6).

Laravel Schedule not sending email

It's my first time trying to implement Task Scheduling, I'm trying to send automatic E-mails at a certain time: Before implementing my cron I first tested my em

"cannot list resources" error from WooCommerce REST API

I am very new to WordPres` and using the WooCommerce plugin for the first time and want to use the WooCommerce REST API in my Android app. I have enabled the

Center point of multiple gps coordinates with php

A simple php array with all coordinates $gps = array( array("lat" => 62.986049, "lng" => 176.075001), array("lat" => 57.125353, "lng" => -1

Magento Installation SQLSTATE[HY000] [2002] No such file or directory error

I am a newbie at LAMPP enviroment and I installed XAMPP for installing Magento. Everthing was going fine till "Add database" step of Magento installation. I cre

phpChart_Lite water mark displayin in graph

I am working with PHP graph and using new C_PhpChartX. PHP Chart Lite. Graph is displaying very well, but watermark behind graph not being removing.can anone he

facebook-php-business-sdk getting PHP Fatal error: Uncaught FacebookAds\Http\Exception\AuthorizationException: Invalid parameter in targeting

PHP Fatal error: Uncaught FacebookAds\Http\Exception\AuthorizationException: Invalid parameter in C:\xampp8.0\htdocs\facebook-php-business-sdk\src\FacebookAds

Invalid Value provided for RegionId field in Magento 2

I am getting this error while the controller run -'Invalid value of "491" provided for the regionId field.'. I want to transfer the telephone number from the bi

How update php.ini on a Mac OS X Mojave?

I'm on Mac OS X Mojave Step 1 I ran php -i | grep php.ini I got Configuration File (php.ini) Path => /usr/local/php5/lib Loaded Configuration File =

Parsing JSON File to array in PHP

I am currently trying to read co-ordinates from a JSON file and save them to an array for further use. However I am not managing to read the file successfully.

Utf8 encoding issue with Laravel

I have an issue after deploying my laravel website ( that works properly in local ). Some text are not encoded correctly, for example : what should be Joë

Acces to MySQL automatic data transfer

I have to pass data from Access database to a MySQL database attached to HeidiSQL automatically every minutes. To do that i put the data into excel files format

PHP Slim Framework request using withAttribute error

I am just try to pass username from middileware auth function $request->withAttribute('username','XXXXXX'); return $next($request, $response); But i cann