kima

find function is able to receive an array in the $id argument:

$departments = Department::find([1, 2, 3, 4, 5, 6, 7])

The chunk works with an anonymous function, thus the sitemap is not in your scope. you should declare $sitemap before the chunk function, and add it with a use to the anonymous function:

        $sitemap = [];

        Listing::where('Inactive', '=', 0)
            ->where('Status', '=', 'Active')
            ->chunk(200, function($listings) use ($sitemap) {
            foreach($listings as $listing) {
                $sitemap[] = array (
                    $cleanURL = "https://listingnaples.com/listing/" . $listing->MLSNumber . "/" . $listing->CleanAddressURL,
                    "loc" => $cleanURL,
                    "changefreq" => "daily",
                    "priority" => "0.90"
                );
            }
        });

I didn't understand your logic, but at notice that the where function is immutable, and you need to set the $allUsers as the result:

$allUsers = $allUsers->where($key, 1)

The save functions in add_spouse should get the member model and not the spouse id

public function add_spouse($spouse_id)
    {
        $spouse = Member::find($spouse_id);
        $this->spouse()->save($spouse);
        $spouse->spouse()->save($this);
    }

Please show your ApiRequest::curlRequest method

@zaheer Please change the $rslt = DB::table('journal') to $rslt = YoutModelName::query()

When you are querying with DB::table, the records are returned as stdClass, with no Eloquent features.

DB::raw has no $bindings parameter. please try this:

 $query  = DB::table('branch')
            ->select(['id', 'name'])
            ->selectRaw("( 3959 * acos ( cos ( radians(?) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(?) ) + sin ( radians(?) ) * sin( radians( latitude ) ) ) ) as distance", [$latitude, $longitude, $latitude])
            ->having("distance", "<", $request->distance)
            ->orderBy('distance', 'asc')
            ->offset(0)
            ->limit(20);

        $data = $query->get();

@ssquare accourding to your updated code, your having should be removed from the ->select() clause, to a ->having() clause:

        $query  = DB::table('branch')
            ->select(
                'id',
                'name',
                \DB::raw('( 3959 * acos ( cos ( radians(?) ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians(?) ) + sin ( radians(?) ) * sin( radians( latitude ) ) ) ) as distance')
            )
            ->having("distance", "<", $request->distance)
            ->orderBy('distance', 'asc')
            ->offset(0)
            ->limit(20);

        $data = $query->get();

It should work. please send here the current code and a JSON of $data

$document var is actually not a model, but a models array. you should save the model in $document var, save it, and then add it to a $documents array

        // Before the foreach
        $documents = [];
        
        // Inside foreach
        $document = new Document(array(
            'user_id'=>$request->get('user_id'),
            'doc_type' => $files,
            'doc_path' => $picName,
        ));
        $document->save();
        $documents[] = $document;

another option is to use the tap() helper, like:

        $document[] = tap(new Document(array(
            'user_id'=>$request->get('user_id'),
            'doc_type' => $files,
            'doc_path' => $picName,
        )), function ($document) { $document->save(); });

@SWIMMER - It depends on your implementation. how do you call it?

Are there situations when you have no Menu model for this $url? If no, do you check that the getAll() result is an array before you iterate it? if you iterate it at all

I'm not familiar with the mysqlnd extension, but I check the php.net (https://www.php.net/manual/en/mysqlnd.install.php) page and noticed this:

The MySQL database extensions must be configured to use the MySQL Client Library. In order to use the MySQL Native Driver, PHP needs to be built specifying that the MySQL database extensions are compiled with MySQL Native Driver support. This is done through configuration options prior to building the PHP source code.

As I can see, you have no other DB extention, mysqli for example

I noticed some issues in StackOF, all of them pointing to the mysqlnd extension. Please check your php-mysqlnd extension is updated to your php version, and loaded properly by Apache. Restart Apache if needed.

Are you using a debugger?

Please set the DB_CONNECTION value in your env file to lower case, as there is no 'MySql' key in your connections array

You need to use ->first(), to actually fetch the record from the database, but with no ->toArray() function. Please try this:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class content extends Model
{
    static public function getAll($url){
        if($menu = Menu::where('url', '=', $url)->first()) {
            $content = Content::where('menu_id', '=',$menu->id)->get()->toArray();

            return $content;
        }
        
        return [];
    }
}

I don't understand the logic here, but it seems like you try to do a Menu existing validation, but the validation breaks when there is no Menu and the first() function returns null. so please try to remove the first toArray()

@CHRISTOPHHARMS - @keizah Both databases should work with no backticks at all:

$neighbours = Category::where('left', '>', $category->right);

$neighbours->update([
    'left' => DB::raw('left+2'),
    'right' => DB::raw('right+2'),
]);

@ChristophHarms This is not a Collection, the $neighbours variable is still a QueryBuilder as it didn't use the get() method.

why not using

ModelClass::query()->select

?

if you want to use the hydrate function you can use it like

ModelClass::hydrate($results->toArray())

the when clause is for PHP boolean and not being interpreted in SQL. Please try to set the DB::raw inside the the Join clause

->join("person_fields", function(\Illuminate\Database\Query\JoinClause $join){
                        $join->on('person_fields.name','Name')
                             ->where('person_fields.person_type','Family Member')
                             ->whereRaw('person_vatas.member_id IS NOT NULL');
                        });

Did you make sure the routes files are not cached? Please run 'php artisan route:clear' and try again