jlrdw

Append the parameters to pagination links:

From docs:

Appending To Pagination Links

You may append to the query string of pagination links using the appends method. For example, to append sort=votes to each pagination link, you should make the following call to appends:

{{ $users->appends(['sort' => 'votes'])->links() }}

If you wish to append all current query string values to the pagination links you may use the withQueryString method:

{{ $users->withQueryString()->links() }}

Also try moving your paginate to just before return view:

$product->paginate(10);

Example:

       $query = Dog::where('dogname', 'like', $dogsch);
        if ($aval == "n") {
            $query->where('adopted', '=', 1);
        } else if ($aval == "y") {
            $query->where('adopted', '=', 0);
        }
        $dogs = $query->orderBy('lastedit', 'DESC')->paginate(5);

       $params = array('psch' => $dogsearch, 'aval' => $aval);

And view:

{{ $dogs->appends($params)->links() }} 

Okay, I missed that.

Just like I did here:

        if ($aval == "n") {
            $query->where('adopted', '=', 1);
        } else if ($aval == "y") {
            $query->where('adopted', '=', 0);
        }

You have to work it out in some if statements while building up the query.

First pass is a post from a search form, all other passes is a get request.

Aren't you retrieving the parameters from the request, if not, use the network tab in your browser developer tools and see what request and response you are getting.

Did you move paginate, it can go last after all other parts are built up.

And example:

        If (!empty(Request::input('psch'))) {
            $dogsearch = Request::input('psch');
        } else {
            $dogsearch = "";
        }

In your case check for null, and you can use a ternary if also.

public function search(Request $request)
    {
        $query = Products::select('id', 'cats_id', 'brands_id', 'name_ar', 'admins_id')
            ->with('admins:id,name')
            ->with('cats:id,cats_name_ar')
            ->with('brands:id,brands_name_ar');
        if ($request->s !== null) {
            $query->where('name_ar', 'LIKE', "%{$request->s}%");
        }
        if ($request->discount == '1') {
            $query->where('discount', '!=', null);
        }
	$product = $query->paginate(10);
	
	// if sending parameters as array
	$params = [your params array];
	return view('admin.product.indexproduct', compact('product', 'params'));  // if sending params
        return view('admin.product.indexproduct', compact('product'));  //if not sending params
    }

Append the parameters to pagination links:

From docs:

Appending To Pagination Links

You may append to the query string of pagination links using the appends method. For example, to append sort=votes to each pagination link, you should make the following call to appends:

{{ $users->appends(['sort' => 'votes'])->links() }}

If you wish to append all current query string values to the pagination links you may use the withQueryString method:

{{ $users->withQueryString()->links() }}

Also try moving your paginate to just before return view:

$product->paginate(10);

Example:

       $query = Dog::where('dogname', 'like', $dogsch);
        if ($aval == "n") {
            $query->where('adopted', '=', 1);
        } else if ($aval == "y") {
            $query->where('adopted', '=', 0);
        }
        $dogs = $query->orderBy('lastedit', 'DESC')->paginate(5);

       $params = array('psch' => $dogsearch, 'aval' => $aval);

And view:

{{ $dogs->appends($params)->links() }} 

First, have your dates in the correct format, meaning:

2020-09-08

for use in a query. Is that the format you are sending to the query.

I just logged in, in chrome, but I use the authenticated method from the trait.

    public function authenticated(Request $request, $user)
    {
        
        $role = $user->role;
        $checkrole = explode(',', $role);
        if (in_array('admin', $checkrole)) {
            return redirect('admin/index');
            
        } else {
            return redirect('pet/index');
        }
    }

What happens if nothing is modified, and you only use the out of the box authentication, then can you login in Chrome?

You should consider at least some sanitizing on raw post:

    $log_email = trim($_POST['log_email']);    // sanitize these with strip_tags
    $log_password = trim($_POST['log_password']);

Have you checked to make sure session is being written?

I have not had to modify any out of the box middleware, I use the trait for redirects. Never had a problem with out of box Auth.

What JS library are you using?

Could you show some code.

I'm not familiar with fa fa-star-o, but doesn't that Library you are using have the CSS to color it.

You could probably change the color in some JavaScript.

Turn $request->stockItem into a collection, do a loop, and each Loop see if it's part of $editableStockItemIds. I imagine using in.

Edit: Not in, but contains, I was thing sql at first -- sorry.

You said It's an array. Why not use in_array.

https://www.php.net/manual/en/function.in-array.php

I have actually learned quite a bit of newer PHP techniques by looking at how Taylor did things in the vendor folder. After all Taylor has to know PHP real well in order to write a framework.

Try solutions here: https://stackoverflow.com/questions/44746763/laravel-print-preview-using-laravel-dompdf

Maybe it's usage, here is a good example of usage https://laraveldaily.com/eloquent-withcount-get-related-records-amount/

To add, there should be a place to pick me PHP version, you may not need to actually do an upgrade.

Try

$mycount = $departmentLessons->count();

Padding, background color, etc

Look at laravels pagination templates, you will get the idea of how its done.

Where you have so from this i can create total 10000

Add a derived column there and just calculate the total: Similar to a income expense report:

Or a check ledger:

Total column is derived (calculated) column.

order_detail
+----+------------+------------+--------------+-------+
| id |  order_id  | price      |   qty  | total   |


total is order_detail.price * order_detail.qty for that column.

It should only run if it's blank. To have an alternative you would want an else statement.

Not sure what you are trying to do.

Could you give an example?

There are videos on Vue some of them are free I would watch some. Jeffrey will explain how this all works.

I don't use Vue I use regular JavaScript and fetch Js.

In the head is where you load the library. Scripts where you're actually doing something goes at end.

You can use your original query in laravel, use the db facade, here is an example:

https://laracasts.com/discuss/channels/laravel/sql-native-to-query-builder

Look at the example queries in that chapter. Not rewriting your query but here is an example of what one looks like:

$quy = Powner::query()->leftJoin('dc_pets', 'dc_powners.ownerid', '=', 'dc_pets.ownerid')
                ->select('dc_powners.ownerid', 'dc_powners.oname')
                ->selectRaw('count(dc_pets.petid) as countOfPets')
                ->groupby('dc_powners.ownerid')
                ->orderby('dc_powners.oname')
                ->get();

Results basically give:

ownerid, oname, countOfPets

Like:

5|Bob|3
4|Greg|9
2|Rob|1

But if you are new to this seriously work some of those examples in the documentation and watch some free videos in the from scratch series.

And eloquent also has all query Builder methods.

https://laravel.com/docs/7.x/queries#joins

Right in that section Taylor has examples of a left join. Please review the documentation.

See how the client wants their forms laid out.

I'd start with the examples in the query Builder chapter. There are good examples of groupby, aggregates Etc.

https://laravel.com/docs/7.x/queries

No, PHP artisan serve is for development. If Apache is the server there set it up correctly.

Also digital ocean has tutorials.

You could paginate your collection if you want to, https://laracasts.com/discuss/channels/guides/paginate-collection-simple-example-guide Second example.

I normally just use HTML tables with some JavaScript and a mix of Ajax as needed.

A little more work but once you done it a couple or three times you can kind of use what you have as a guide or template for other projects.

Have a look at https://laravel.com/docs/7.x/pagination#paginating-eloquent-results

If you don't want collections, query the json direct: https://stackoverflow.com/questions/46055223/select-where-json-array-contains

Also look at the Mysql manual for json data, they have examples.

And see https://stackoverflow.com/questions/50450667/how-to-sort-a-json-object-in-laravel

You could put into a collection and use collection methods.

No, PHP artisan serve is for development. If Apache is the server there set it up correctly.

Also digital ocean has tutorials.

The out of box authentication has login validation already. So if using custom, still look over how Taylor accomplished it and just duplicate that. I've gotten many ideas from Taylor.

You can have more than one folder to store images, sub folders.

Example"

storage\app\UploadedFiles\products
storage\app\UploadedFiles\some_other_image_folder
-------- etc

Do they need named like AXF8JV8as4tdoOubZsVNnwAYvoZaZ73lfAPVf7jP.png

Sometimes I name like:

ann478_127.jpg

Where 478 is count + 1 of images. and 127 is user id.

And a method I have only lets user 127 see their images.

Get the information from data like:

data[0].whatever

You may need to loop, I don't know your whole setup.

Use your network dev tools to see exactly how "data" is returned, probably a json array of objects.

Or take a tutorial on json and json arrays and how to loop and get data from them.

Generally a parameter is used somewhere in code, so binding parameters in a raw expression takes care of it.

From the example in the docs:

$users = DB::select('select * from users where active = ?', [1]);

The last part is binding.

Also I wrote a custom router in a framework and for uri parameters I send them through this:

    public static function fixUriParts($rvalue)
    {
        $rvalue = empty($rvalue) ? NULL : trim(strip_tags($rvalue));
        $rvalue = strtok($rvalue, '?');
        $rvalue = htmlspecialchars($rvalue);
        return $rvalue;
    }

But why sanitize a page parameter, I have never seen that come up or asked before.

But you are free to run any parameter through htmlspecialchars if you want to.

Also see this article: https://www.cloudways.com/blog/prevent-xss-exploits-using-laravel-validation-and-sanitization/

Go here, you have to insert in related model.

https://laravel.com/docs/7.x/eloquent-relationships#inserting-and-updating-related-models

Check for the existence of the completed zip file prior to running the delete. Maybe somehow delete is taking place prior to everything being zipped.

When submitting a form you don't need a parameter there:

Route::get('/fabrication/weldtub', '[email protected]')->name('weldtub.show');

Just request the data:

$serial = $request->serial;

Its a form there, not a link.

A link

<a href="<?php echo 'weldtub/' . $row->serial; ?>">Edit</a>  // just example.

A link and a submitted form are not the same.

That should be a post form the way you are using it.

See the chapter on routing, they would be passed as parameters rather than get request would be the only difference.

Similar to passing parameters to a function.

See second answer down here, try tracing all or any errors:

https://stackoverflow.com/questions/20029606/invalid-or-unitialized-zip-object/39775980

Also go here https://www.php.net/manual/en/class.ziparchive.php

Then scroll town to see this function: function ZipStatusString( $status )

Something similar was just done, see https://laracasts.com/discuss/channels/laravel/login-a-user-to-confirm

I'd go here https://laracasts.com/browse/all and pick a topic. You'll see what you viewed already.

Something similar was just done, see https://laracasts.com/discuss/channels/laravel/login-a-user-to-confirm

Print out this post here, and show the replies.

Try several other post, punch into google:

site:laracasts.com CSRF TOKEN mismatch exception

Surely one of the replies will help.

Google search is more powerful than search here, I find many answers that way.