Tray2

So the desired reslt is something like

• Steve (Manager)
• Carol (Sales) $1000
• Ben (Sales) $900
• Aaron (Sales) $850

?

What is the output of which ffprobe?

When I run that command I see

/usr/bin/ffprobe

Something along the lines of

SELECT product_id, variant_id, sum(item_qty)
FROM subscriptions
GROUP BY product_id, variant_id

?

Something along the lines of

SELECT product_id, variant_id, sum(item_qty)
FROM subscriptions
GROUP BY product_id, variant_id

?

What is the button supposed to do?

If it's not to submit a from you need to add some javascript function to it.

What is the button supposed to do?

If it's not to submit a from you need to add some javascript function to it.

Does the Laravel welcome page work?

I suggest you use a prefix on one of them. Bootstrap might become bs. So to use it you do bs-row instead of just row.

https://stackoverflow.com/questions/29003264/customize-twitter-bootstrap-classnames

Not sure exactly what you mean but let's say you have a element with two classes

<style>
    .boxed {
        border: 1px solid black;
        border-radius: 5px;
    }

    .rounded {
        $border-radius: 10px;
    }
</style>

<p class="boxed rounded">

The above <p> would get rounded 10px corners.

If you change the order of the classes on the element.

<p class="rounded boxed">

It would get the 5px rounded corners.

You can use the !important keyword to override the default cascade.

    .boxed {
        border: 1px solid black;
        border-radius: 5px !important;
    }

That would make the above example use rounded 5px corners. This is a bad practice.

If you have the same class name in several of those files it will give you strange effects since they will all be added.

I would probably use the same controller for both the "html" and the "api" way since they are the same.

Something like

public function store(Request $request)
{
    $movie = Movie::create($this->validate($request));
    $message = $movie->title . ' Successfully added';
    if($request->wantJson()) {
        return response()->json([
                'status => 200,
                'message' =>  $message
        ]);
        return redirect('/movies')->with(['message' => $message]);
}

Something like

DB::getConnection()->statement('CREATE DATABASE :schema', array('schema' => $schemaName));

Should do the trick.

More info here https://laravel.io/forum/09-13-2014-create-new-database-and-tables-on-the-fly

I'm guessing multi user setup?

Then you will need a dedicated host with lots of CPU, lots of memory, lots of diskspace and unlimited traffic. That is not cheap at all.

It should tell you on what row in your code it fails.

The code is barely readable so it's hard to understand what it does.

No.

Not until there is an actual insert into the table will the id be incremented and if a rollback occurs it will most likely just skip a number.

• 1
• 2
• 4
• 5

and so on.

For images I'd use Intervention http://image.intervention.io/getting_started/installation#laravel

When it comes to video I'd use ffmpeg https://www.ffmpeg.org/

There is a laravel package for ffmpeg https://github.com/pascalbaljetmedia/laravel-ffmpeg

But like @fylzero says it's much easier to handle it on the local machine since it required lots of computing power to convert video.

You also need to be able to handle large uploads, lots of memory and a huge drive.

I would create a service something like

Route::get('/someapi', '[email protected]');

public function someApi()
{
    return SomeApi::all()->toJson()
}

async function fetchSomeApi() {
    const response = await fetch('/someapi'); 
    const json = await response.json();
    document.querySelector('#somefield').value = json.somefield; 
}

When using XAMPP you don't need to install PHP seperatly. You just need to add the path to the php.exe file to your computers path.

https://docs.alfresco.com/4.2/tasks/fot-addpath.html

Then you need to close your commend window and open it again. After that youhould be good to go.

I would do a check to see if the values are the same for the fields then return with a message.

Both in the backend and the frontend.

something like

public function(Category $category, Request $request)
if($category->title == $request->title) {
    return redirect->back()->withStatus('No changes made');
}

and

let isDirty = false;

document.querySelector('#title').addEvenListener('change', function() {
    isDirty = true;
});

document.querySelector('#category_form').addEventListener('submit', function(event) {

    if (isDirty) {
        event.perventDefault();
        console.log('No changes to save');
          }
});

I haven't tested the code so there might be some type-Os.

Or use a common S3 bucket to store the images.

Check this guide

https://www.opentechguides.com/how-to/article/php/112/laravel-install-wamp.html

Have you activated mod_rewrite in Wamp?

So you mean something like

That you have a form with let's say three fields

And instead of having names like

• first_name
• last_name
• age

They have names like

• field1
• field2
• field3

And you get the labels from a table in the database.

The table has the following structure

• id
• field1
• field2
• field3

The table is named scenrios or something like it

So in your controller you load a random scenario

$scenario = Scenerio::all()->random(1);

In your view you can then do something like

<label for="field1">{{ $scenario->field1 }}</label>
<input type="text" name="field1">

Not sure that is possible but give this a try

$filter = $request->filter

$products = DB::table('product_filters')
                ->selectRaw("product_id WHERE pf.filter_id in ?' 
                             AND EXISTS (SELECT pfi.product_id  
                             FROM product_filter pfi 
                             WHERE pfi.product_id = pf.product_id 
                             AND pfi.filter_id in ?", $filter, $filter)
                ->get();

So you only want product_id 42?

SELECT pf.product_id
FROM product_filter pf
WHERE pf.filter_id = 2
AND EXISTS (SELECT pfi.product_id 
                      FROM product_filter pfi 
                      WHERE pfi.product_id = pf.product_id 
                      AND pfi.filter_id = 4);

Show me some example data from the table

Yes that query is fubar.

You want to get product filters that has the filter_id of 2 or 3.

In SQL I would do something like this

SELECT product_id
FROM product_filter
WHERE filter_id IN (2, 4);

In Eloquent the same query would look something like this

ProducFilter::whereIn('filter_id', [2, 4])->get();

And to make it more dynamic you just excehange the [2, 4] with a variable passed into the request something like

public function(Request $request)
{
     $filters = $request->filters;
     $products = ProductFilter::whereIn('filter_id', $filters])->get(): 
}

You should of course validate the request->filters before using it in your query

In your case it should be $request->subject

Well then show us the table structure and the models for them then.

You need to seperate the wildcards with a /

Route::get('{name}/{id}', [email protected]');

Be aware that it will catch any url in your app that has <something>/<something> in it.

Use

Route::get('products/{id}', '[email protected]');

instead.

Or even better name the Controller and the method like so

Route::get('products/{id}', '[email protected]');

You can name it whatever you like but I'd use the convetion for and name in comments since it gets multiple comments and not just one.

That way your blade view gets more readable

Compare these two

@foreach($comment as $row)
    {{ $row->body }}
@endforeach

or

@foreach($comments as $comment)
    {{ $comment->body }}
@endforeach

I prefer the second one since I now know that we are working with comments and we do something for each comment. This might seem trivial in this case but if you have more fields you want to display it's easier to red without scrolling up to the beginning of the foreach to see what you are working with.

Yes and you should create a post_tags for the relation between them.

You need to change the $data2 to $data in your foreach.

@foreach($data2 as $ctg)
      <option value="{{ $ctg->id }}">{{ $ctg->ctg_name }}</option>
@endforeach

Dude you should know this by now...

Change

return view('admin.page.page')->with('list', $data);

to

return view('admin.page.page')->with(['list' =>  $data, 'data2' => $data2]);

I also highly suggest you change the variable names $data and $data2 to something more descriptive.

The view code seems ok.

I suggest you use another database structure for this

You need three tables

• posts
• tags
• post_tags

You store each tag as a record in the tags table then you use the pivot table post_tags to link the post and tag. A classig many to many relationship.

https://laravel.com/docs/6.x/eloquent-relationships#many-to-many

If you have a migration file named create_some_table then Laravel is looking for a class named CreateSomeTable so when you rename the file to create_some_other_table you need to rename the class as well or Laravel will not find CreateSomeOtherTable.

If you have a migration file named create_some_table then Laravel is looking for a class named CreateSomeTable so when you rename the file to create_some_other_table you need to rename the class as well or Laravel will not find CreateSomeOtherTable.

Or you can do this

 return view('pages/pastpapers/igcse')->with([
    'paper' =>$paper,        
        'pastpapers'=> $pastpapers,
        'items' => $items,
        'filter' => $filter
]);

Since you are mixing plural and sigular in your code make sure you have the same variable names in your view.

As I see it there are two ways to acheive this with as little headache as possible.

1. Store the stats in it's own table
2. Use a view to calculate on the fly

If we start with the first one you create a table that has the following fields

• id
• comment_id
• number_of_comments

Then you can update the number of comments with your trigger.

The second we can create a view that on the fly calculates the number of comments

CREATE OR REPLACE VIEW comment_stats AS
SELECT c.id AS comment_id, count(*) AS number_of_comments
FROM comments
GROUP BY id

This is a bit over simplified when you add nesting. To solve that you need to add the "parent" to the view as well.

Do you have the proper indexes on offices and students?

From a quick run through it seems like you need to have indexes on

• transactions.office_id
• students.rfid
• offices.letter

500 means that something went wrong.

If one image size works and not another it sounds to me that there might be a limitation of either the file size or the memory available for php.

Check these values in you php.ini

• upload_max_filesize – The maximum allowed upload file size.
• post_max_size – The maximum allowed POST data size.
• max_input_time – Maximum allowed input time.
• max_execution_time – The maximum allowed time the scripts are allowed to run.

If you want to do something like that (which I advice against) you can do something like

Clients Table

• id
• user_id
• client_no

and some client info fields.

Then you ignore the id and use the client_no instead as your counter.

That would mean you need to get the max client_no for that user every time you create a new client.

Something like

$clientNo = Client::where('user_id', Auth::user()->id)->count(); + 1;
 Client::create([
    'user_id' => Auth::user()->id,
        'client_no' => $clientNo
]);

I would create a view that represents the data set and paginate from that.

CREATE OR REPLACE VIEW some_view AS
SELECT some_field, sum(some_other_field)
FROM some_table
GROUP BY some_field;

Then I can run a simple Eloquent query on it

$result = SomeView::paginate(25);

This example is very simplified.

You can use a migration to create the database view

In your up() method

DB::statement("CREATE OR REPLACE VIEW some_view AS
SELECT some_field, sum(some_other_field)
FROM some_table
GROUP BY some_field");

You use parameters.

Function one calls function two with an argument.

Procedural way:

function one()
{
    $foo = 'Some value';
        two($foo);
}

function two($value)
{
    store($value);
}

OOP way

public function one()
{
    $foo = 'Some value';
    $this->two($foo);
}

public function two($value)
{
   store($value);
}

If you don't know how to pass arguments between functions in PHP I suggest you learn the basics of PHP before you start using Laravel.

How do you populate the collection?

If it's from a table in the database it's much better to let the database handle the filtering.

Otherwise you can try forget

https://laravel.com/docs/5.7/collections#method-forget

How do you populate the collection?

If it's from a table in the database it's much better to let the database handle the filtering.

Otherwise you can try forget

https://laravel.com/docs/5.7/collections#method-forget

Did exactly that this weekend and took me about two hours to get it back up again.

Not sure what made it run again but I ran the following

brew uninstall [email protected]

brew uninstall nginx

brew uninstall dnsmasq

brew install php

brew install nginx

brew install dnsmasq

sudo valet install

Good luck.

That is hard to predict but a proper stack uses less resources than xampp.

This document might shed some light.

https://www.dynatrace.com/news/blog/7-minute-workout-does-your-apache-web-server-need-love/

Not knowing exactly what you mean but something like this maybe?

@foreach($records as $record)
    @if(! $loop->first())
        {{ $records[$loop->index -1]->value }}
    @endif

    {{ $record->value}}
    
    @if(! $loop->last())
        {{ $records[$loop->index +1 ]->value }}
    @endif
@endforeach

What is the error message?

@omkark610 I wouldn't use XAMPP in a production like environment since it's mostly for development. I suggest you set up a proper stack lemp or lamp.

https://www.howtoforge.com/perfect-server-debian-10-nginx-bind-dovecot-ispconfig-3.1/

https://www.howtoforge.com/perfect-server-debian-10-buster-apache-bind-dovecot-ispconfig-3-1/

Regardning the high CPU load it's probably due to the sql that is getting run. Without any code example it's hard to see the reason for it but it might be poorly written SQL and or missing indexes.

Take this simple query for example

SELECT * FROM some_table WHERE created_at BETWEEN '2019-12-01' AND'2019-12-02';

If you don't have an index on created_at it will scan every record in your table. When you add an index it will maybe read 10 records intead of thousands.

Oh and by the way, please don't hijack threads that are years old. Create a new one instead.