Snapey

this

public function edit(ChannelStream $stream)

$stream

and this

Route::get('stream/{channelStream}/edit

channelStream

need to match.

optional just prevents an error being thrown. I think both of your examples is correct... it depends what you want to do. Personally, i have never found a need for optional()

ok, but null coalesce operator is useful for this type of situation.

As is the optional helper

one or more of your clubs is missing a president

change your view to catch this

<td class="text-center">
    <span class="badge badge-warning">{{ $club->president->name ?? '----' }}</span>
</td>

look in the Laravel log file to see your 500 error

dompdf perhaps requires a second thread and blocks for the reason I mentioned earlier

Below is a simple solution that shows 2 entries on either side (if there are pages). You will see a reduced number of links as you approach either end

            <ul class="pagination">
                @php($cur = $users->currentPage())
                @php($total = $users->lastPage())

                @if($cur-2 > 0) <li class="page-item"><a class="page-link" href="{{ $users->url($cur-2) }}">{{ $cur-2 }}</a></li>@endif
                @if($cur-1 > 0) <li class="page-item"><a class="page-link" href="{{ $users->url($cur-1) }}">{{ $cur-1 }}</a></li>@endif
                
                <li class="page-item active"><span class="page-link">{{ $cur }}</span></li>

                @if($cur+1 <= $total) <li class="page-item"><a class="page-link" href="{{ $users->url($cur+1) }}">{{ $cur+1 }}</a></li>@endif
                @if($cur+2 <= $total) <li class="page-item"><a class="page-link" href="{{ $users->url($cur+2) }}">{{ $cur+2 }}</a></li>@endif
            </ul>

It uses the standard pagination class to get the counters. Replace $users with your collection being paginated

its probably conflicting with itself.

Remember that the php built in server can only run one request at a time and cannot listen for a new request until it has finished the last one. If you have any scheduler tasks, or are calling third party api then new web requests will be blocked until this has finished.

Better to use a proper web server

one of your str_plural statements is being given something other than a number to work with

Should take you about 30 secondeps to determine which one

so user has many referals and user can belong to a referer

add a referrer column to the users table

users model;

public function referrer() { return $this->belongsTo(User::class, 'referrer', 'id'); }

public function referrals() { return $this->hasMany(User::class, 'referrer','id'); }

yes, the model refers back to itself

Then you can count the relations. https://laravel.com/docs/5.8/eloquent-relationships#counting-related-models

Why mess around with login? why dont you use the standard auth functionality?

create a new migration and add the extra column

php artusan make:migration --table=product

the table= part tells laravel to adjust the existing table , not create a new one

The public folder is where you keep your static assets that dont need to change. They are part of your application and not written to by the webserver. So you can then secure your public folders because nothing should need to change there when your application is running.

But you may also need somewhere to store user data, such as images. The storage folder is used for this so that you can allow your webserver to write to the storage folder. To allow these files to be served to the outside world, the symlink is used to allow parts of the storage folder to appear to the outside world.

If you cannot create the symlink then this might be a restriction of your webhost

To access files in the public folder from your php scripts, you can use the public_path() helper

you would be best to study and understand the request lifecycle

does this page show multiple users?

do you have a relationship referred on the user model?

its an .htaccess issue rather than being Laravel related

If you reference an image in css file then the location of the image is either relative to the css file or absolute if you start the path with a forward slash.

If using absolute path then your site needs to be correctly hosted with the public folder as the root folder

You can use your network tools in your browser to check where the browser is looking for the file

These are basic web development skills which should be learned before writing any back-end code.

Delete all related addresses and then add as new records.

To edit the existing records you would need to pass their ids to the form

if your data is coming in as a comma separated list, then use explode to create an array

$user->roles()->sync(explode(',',$role_id));

did you run php artisan migrate?

Sorry, i have been away. glad you got it sorted.

As a guess, you are using PHP webserver (php artisan serve) ?

It only handles one request at a time, so you cannot start another request from inside a request.

You could create a scope that tidies things up

in your model;

    public function scopeSearch(Builder $query, String $needle, Collection $cols)
    {
        $cols->each(function($col) use($needle,$query){
            $query->orWhere($col, 'like', "%{$needle}%");
        });

        return $query;
    }

(note this is doing a loose 'like' search because this was not possible passing an array into orWhere)

$columns = collect(['title', 'description', 'note']);
$needle = 'carrot';

$articles = App\Article::whereIsPublic(true)
    ->search($needle, $columns)
    ->whereIsFinished(true)
    ->orderBy('title')
    ->get();

There is only one of us here intellectually challenged.

@stereoh

I fix it...

open file

control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, control-X, etc

No-one can help you with this question.

Format your code

Describe what you are doing

Describe any error that you are seeing and include relevant messages.

wtf

Why? My example provides where on multiple columns (your title)

It does EXACTLY the same as your previous comment, but with less clutter as it does not need a closure.

Yes. You don't need the id column on this table but it can be useful.

I mentioned passing an array to where. Actually it also works with orWhere

$articles = Article::orWhere(['title'=>$needle, 'description'=>$needle, 'note'=>$needle])->get();

When defining the global scope, you can refer to the policy to know if the scope should be applied or if the scope varies according to the policy.

Did you get to this function direct from a route or by some other method?

is your 'Going to view Folder' shown?

you need to give your user write permission to storage folder (not www-data) since you are running this as part of cli artisan command

Check if you switch command line to storage folder that you can create both folders and files

Also, in your Role model you should have users() function and not user() since there can be many users for a role

just check it in tinker. Its the easiest way to check if your relationships are working

eg

>>> User::with('role')->find(1)

should return user 1 with their role. You will instantly see if role is found or if role_id is valid

so you need to group by category?

if this is 5.8 the id column on the users table has changed to big int. Your column in posts (user_id) has to match the same format

just checking that you dont have any with() statements in your models?

you always have to use multipart/form-data if you want image content to be sent to the server.

You are saving the image in a new location but not remembering where you put it

no. This hotels_users table is a pivot associating users with hotels. You still authenticate User model as normal

why do you want to save as json?

you seem to be overthinking it

Its just a straight belongsToMany relationship

post.php

public function tags()
{
    return $this->belongsToMany(Tag::class);
}

Tag.php

public function posts()
{
    return $this->belongsToMany(Post::class);
}

Baum appears to use the same table layout, and has commands like;

$tree = Category::where('name', '=', 'Books')->first()->getDescendantsAndSelf()->toHierarchy();

to dump out the entire hierachy

How about this;

https://github.com/etrepat/baum

I tested this with a model called 'Material'

There were a couple of typos in the last post.

class Material extends Model
{
    public function children()
    {
        return $this->hasMany(Material::class, 'parent_id')
            ->select(['id', 'name', 'parent_id']);
    }

}

then query the table

$model = Material::with('children.children.children')->whereNull('parent_id')->get(['id','name']);

then cast to json

$model->toJson();

produces this json;

[
  {
    "id": 12,
    "name": "Materials",
    "children": [
      {
        "id": 1,
        "name": "Roofing",
        "parent_id": 12,
        "children": [
          {
            "id": 2,
            "name": "Asphalt",
            "parent_id": 1,
            "children": [
              {
                "id": 3,
                "name": "Architectural",
                "parent_id": 2
              },
              {
                "id": 4,
                "name": "Laminated",
                "parent_id": 2
              }
            ]
          },
          {
            "id": 5,
            "name": "Cedar",
            "parent_id": 1,
            "children": []
          },
          {
            "id": 6,
            "name": "Rubber",
            "parent_id": 1,
            "children": []
          }
        ]
      },
      {
        "id": 7,
        "name": "Hardware",
        "parent_id": 12,
        "children": [
          {
            "id": 8,
            "name": "Fasteners",
            "parent_id": 7,
            "children": [
              {
                "id": 9,
                "name": "Bolts",
                "parent_id": 8
              },
              {
                "id": 10,
                "name": "Screws",
                "parent_id": 8
              },
              {
                "id": 11,
                "name": "Anchors",
                "parent_id": 8
              }
            ]
          }
        ]
      }
    ]
  },
  {
    "id": 13,
    "name": "",
    "children": []
  }
]

I must admit, when I have done this before, I just used regular relationships and could rely on eager loading relations.

eg

$model = Model::with('children.children.children')->whereNull('parent_id')->get('id','name');

This will only go to 4 levels.

Model has a children() relationship

        public function children()
        {
            return $this->hasMany(Model::class)->select('id','name','parent_id');
        }

Its a good few years ago though so I might be mistaken.

Then, if you have this structure, you can map over it, just pulling out the values you need if the structure does not suit.

you should not have html element ids inside a loop. They are meant to be unique within the page

Put the club id in a data attribute of the button so that you can grab it when the button is clicked

i think where() accepts an array, but these are treated as AND conditions

who cares? Rock your own thing.

Maybe you need global scopes? Automatically apply restrictions to your eloquent queries.

https://laravel.com/docs/5.8/eloquent#query-scopes