tisuchi

@untymage

sudo apt-get install php-sqlite3

Ref: https://laracasts.com/discuss/channels/laravel/sqlite-database-throw-error-could-not-find-driver-sql-pragma-foreign-keys-on

@wakanda Just to fix the typo on @tykus comment.

It should be -

->when($this->categoryId

instead of -

->when($this->$categoryId

@tuinhanne Check this tutorial. https://www.youtube.com/watch?v=H7Vzad8gXHc

@mohib_ullah It looks like the path issue.

Check this discussion. https://stackoverflow.com/questions/27670140/laravel-resource-controller-testing-gives-notfoundhttpexception-the-second-time

@mecjos Just follow this tutorial.

https://www.itsolutionstuff.com/post/laravel-8-rest-api-with-passport-authentication-tutorialexample.html

@mecjos You can keep the both option like that way.

    public function redirectTo($request)
    {
        if ($request->expectsJson()) {
            return response()->json(['error' => 'Unauthenticated.'], 401);
        }
    
        return route('login');
    }

@fcode

User.php

    public function contents()
    {
        return $this->hasMany(Content::class)->orderBy('updated_at');
    }

Content.php

    public function user()
    {
        return $this->belongsTo(User::class);
    }

Now, in the controller, you can write the query like this way-

// Getting all latest contents of user ID = 1
$contents = User::with('contents')->findOrFail(1);

// Getting all latest contents of user ID = 1
$contentsInLast24Hours = User::with('contents', function ($query) {
    $query->where('created_at', '>=', now()->subDay(1));
})->findOrFail(1);

@johny-22 Haha... No worries. That should be fine as long as the answer solves your issue. I am happy to see that. :)

@deekshith Have you checked this threat?

https://laracasts.com/discuss/channels/laravel/preview-doc-ppt-and-pdf

@johny-22 Ideally YES. It is better to have two separate methods for two separate functionalities. It will give you better code tracking, idea approach for testing, and easy to read.

My opinion will go with separate functionalities.

@amit028

As I was building this new Kuztek site I wanted to build it to the same standards I would if I were building it for any client and that means protecting the site from malicious code or security threats. I may be the only one adding content to this site or modifying what is in the database, but filtering what we are outputting to the browser to make sure it doesn’t harm the site or our users just makes sense. We don’t want to leave our sites vulnerable to Cross-Sites Scripting(XSS). This tutorial covers Laravel customization and is intended to be used by developers to improve their site security.

When using Laravel Blade templates we typically would output content doing something like this:

Hello, {{ $name }}. 

The double curly brackets used in Blade indicate that the content will be escaped and any html code that would have been outputted will be removed automatically. But what if we want some html to come through from our database but not anything that would be a security risk? We searched around for some existing code to do the job because writing something from scratch could take a lot of time. Enter HTMLPurifier, a well maintained tool that cleans up code and even fixes things like missing html tags or illegal html nesting. To get HTMLPurifier into our Laravel project we used a handy package from MeWebStudio and added it to our site using composer.

Ref: https://kuztek.com/blog/use-laravel-purifier-security#:~:text=Enter%20HTMLPurifier%2C%20a%20well%20maintained,tags%20or%20illegal%20html%20nesting.

@trifek The easiest way would be the make a row and then dividend into two columns inside the col-6 class. Then duplicate your code.

<div class="col-6">
  <div class="row">
    <div class="col-6">
        <div class="form-check py-2">
          <input id="productIngredientId-{{ $productIngredient->id }}"
                 class="form-check-input enableInput" style="margin-top:10px"
                 name="productIngredient[]" type="checkbox"
                 value="{{ $productIngredient->id }}"
                 @if($selectedProductIngredients->contains('ingredient_id', $productIngredient->id) === true) checked @endif>
          <label class="form-check-label" for="flexCheckChecked">
              {{ $productIngredient->name }} [{{ $productIngredient->short_name }}]
          </label>
          <input id="productIngredient-{{ $productIngredient->id }}" type="text"
                 name="productIngredient-{{ $productIngredient->id }}" maxlength="10"
                 class="form-control weight-input weightMask"
                 style="width:100px;display: inline; margin-left:20px" placeholder=""
                 value="{{ $weight }}">
      </div>
    </div>
    <div class="col-6">
        <div class="form-check py-2">
          <input id="productIngredientId-{{ $productIngredient->id }}"
                 class="form-check-input enableInput" style="margin-top:10px"
                 name="productIngredient[]" type="checkbox"
                 value="{{ $productIngredient->id }}"
                 @if($selectedProductIngredients->contains('ingredient_id', $productIngredient->id) === true) checked @endif>
          <label class="form-check-label" for="flexCheckChecked">
              {{ $productIngredient->name }} [{{ $productIngredient->short_name }}]
          </label>
          <input id="productIngredient-{{ $productIngredient->id }}" type="text"
                 name="productIngredient-{{ $productIngredient->id }}" maxlength="10"
                 class="form-control weight-input weightMask"
                 style="width:100px;display: inline; margin-left:20px" placeholder=""
                 value="{{ $weight }}">
      </div>
    </div>
  </div>
</div>
    

@user1980 Try this-

return $this->view('emails.myDemoMail')
            ->attach(public_path('pdf/sample.pdf'), [
                 'as' => 'sample.pdf',
                 'mime' => 'application/pdf',
            ])->attach(public_path('other/file/type.dox')
            ])->attach(public_path('other/file/type.ppt');

Check more: https://laravel.com/api/8.x/Illuminate/Mail/Mailable.html#method_attach

@momoyem You should mark @frankielee reply as the best answer since it helps you to figure it out.

@simonangatia If it fetches data from the API, then why not consider VUE side to render it. Unless you have to store data inside the DB.

I may use this approach.

@amireix Have you tried this?

You can set it up this way:

public function run($count = 1)

And then you can pass the argument this way:

$this->call(ClientSeeder::class, false, ['count' => 500]);

Ref: https://stackoverflow.com/questions/59077308/passing-a-quantity-or-other-arguments-to-a-laravel-seeder

@user1980 Try this-

return $this->view('emails.myDemoMail')
            ->attach(public_path('pdf/sample.pdf'), [
                 'as' => 'sample.pdf',
                 'mime' => 'application/pdf',
            ])->attach(public_path('other/file/type.dox')
            ])->attach(public_path('other/file/type.ppt');

Check more: https://laravel.com/api/8.x/Illuminate/Mail/Mailable.html#method_attach

@trifek The easiest way would be the make a row and then dividend into two columns inside the col-6 class. Then duplicate your code.

<div class="col-6">
  <div class="row">
    <div class="col-6">
        <div class="form-check py-2">
          <input id="productIngredientId-{{ $productIngredient->id }}"
                 class="form-check-input enableInput" style="margin-top:10px"
                 name="productIngredient[]" type="checkbox"
                 value="{{ $productIngredient->id }}"
                 @if($selectedProductIngredients->contains('ingredient_id', $productIngredient->id) === true) checked @endif>
          <label class="form-check-label" for="flexCheckChecked">
              {{ $productIngredient->name }} [{{ $productIngredient->short_name }}]
          </label>
          <input id="productIngredient-{{ $productIngredient->id }}" type="text"
                 name="productIngredient-{{ $productIngredient->id }}" maxlength="10"
                 class="form-control weight-input weightMask"
                 style="width:100px;display: inline; margin-left:20px" placeholder=""
                 value="{{ $weight }}">
      </div>
    </div>
    <div class="col-6">
        <div class="form-check py-2">
          <input id="productIngredientId-{{ $productIngredient->id }}"
                 class="form-check-input enableInput" style="margin-top:10px"
                 name="productIngredient[]" type="checkbox"
                 value="{{ $productIngredient->id }}"
                 @if($selectedProductIngredients->contains('ingredient_id', $productIngredient->id) === true) checked @endif>
          <label class="form-check-label" for="flexCheckChecked">
              {{ $productIngredient->name }} [{{ $productIngredient->short_name }}]
          </label>
          <input id="productIngredient-{{ $productIngredient->id }}" type="text"
                 name="productIngredient-{{ $productIngredient->id }}" maxlength="10"
                 class="form-control weight-input weightMask"
                 style="width:100px;display: inline; margin-left:20px" placeholder=""
                 value="{{ $weight }}">
      </div>
    </div>
  </div>
</div>
    

@swimmer Have you tried with @tykus suggestion?

@swimmer can you show your code?

@paulomanrique I am afraid that, you cannot do this out of the box. The only solution would be just a screen record!

@swimmer Try whereIn().

$sku_to_update = ['5','1','20'];

$sku_to_update = Sku::whereIn('sku', $sku_to_update)->get();

Cool.

@jarjis What I can suggest you inspect your query locally that it behaves as expected.

You just install Laravel Debugbar to inspect your app.

@jarjis The following example may help you to understand how MySqli and PDO fetch data.

MySQLi

$stmt = $mysqli->prepare("SELECT id, name, age FROM myTable WHERE name = ?");
$stmt->bind_param("s", $_POST['name']);
$stmt->execute();
$arr = $stmt->get_result()->fetch_all(MYSQLI_ASSOC);
if(!$arr) exit('No rows');
var_export($arr);
$stmt->close();

PDO

$stmt = $pdo->prepare("SELECT * FROM myTable WHERE id <= ?");
$stmt->execute([5]);
$arr = $stmt->fetchAll(PDO::FETCH_ASSOC);
if(!$arr) exit('No rows');
var_export($arr);
$stmt = null;

Read more: https://websitebeaver.com/php-pdo-vs-mysqli

@foks Are you still getting the same error?

@huntwu Check this: https://dev.to/bloodrave_n/how-to-retrieve-tokenid-from-acesstoken-personal-access-token-hmh

@foks Try this-

php artisan config:cache --env=testing

and

php artisan config:clear

@mohafiz It's hard to get the direct resource. But you can get some ideas from this tutorial. It was helpful for me.

https://www.youtube.com/watch?v=R8pMwciZ95U

@jerem-d Instead of where, why not you use orWhere()?

Besides. you can take a look this article to gain better understanding: https://dev.to/mehdifathi/making-the-advanced-query-filter-with-eloquent-filter-in-laravel-3m5l

@skoobi Show your code that you have so far?

@saraswat19 unfortunately, there is a no option to delete a question from Laracasts forum.

@mehrdad70 What if you tried this?

@foreach(json_decode($tag->tag_name, true) as $value)
...

@mehrdad70 Can you show exactly what is the actual json format that you have stored in the db?

@md_imran What you have tried so far?

@david19 For your further reference, you can check this: https://laracasts.com/series/git-me-some-version-control/episodes/5

@hasen39 Have you checked this?

https://medium.com/@matthewcoatney/laravel-voyager-gotchas-9ab48067a615

@fajar You better wrap your form by foreach(). And you need to add <button type="submit">. It should work then.

@foreach($siswas as $siswa)
    <form action="{{route('simpan-data.absensi-siswa')}}" method="post">
        @csrf

        <tr>
            <td>
                
                {{$siswa->user->name}}
            </td>
            <td>
                <div class="form-group">
                    <input type="text" name="absen" id="" class="form-control">
                </div>
            </td>
            <td><button type="submit" class="btn btn-info btn-sm">Absen</button></td>
        </tr>
    </form>    
@endforeach

@kidi You better show what you have tried. It may gain a better understanding for everyone to try.

@fajar You better wrap your form by foreach(). And you need to add <button type="submit">. It should work then.

@foreach($siswas as $siswa)
    <form action="{{route('simpan-data.absensi-siswa')}}" method="post">
        @csrf

        <tr>
            <td>
                
                {{$siswa->user->name}}
            </td>
            <td>
                <div class="form-group">
                    <input type="text" name="absen" id="" class="form-control">
                </div>
            </td>
            <td><button type="submit" class="btn btn-info btn-sm">Absen</button></td>
        </tr>
    </form>    
@endforeach

@nafeeur10 I don't know exactly how did you register your helper.

Follow this document. It may help you.

https://medium.com/@razamoh/create-own-custom-helper-functions-classes-in-laravel-e8d2f50ff38

@nafeeur10 I don't know exactly how did you register your helper.

Follow this document. It may help you.

https://medium.com/@razamoh/create-own-custom-helper-functions-classes-in-laravel-e8d2f50ff38

@brainyt Have you checked this discussion?

https://stackoverflow.com/questions/54240537/laravel-5-7-on-apache-error-call-to-undefined-function-illuminate-encryption-ope

@new-2-lara It always depends on your preferences. As of my understanding from your points, you can either choose wordpress (where you don't have to write code literally) OR use laravel where you could have a lot of flexibility for implementation.

Side Note: For using laravel you may need good knowledge of PHP (OOP).

@brainyt Have you checked this discussion?

https://stackoverflow.com/questions/54240537/laravel-5-7-on-apache-error-call-to-undefined-function-illuminate-encryption-ope

@ajvanho I guess you don't need to use collection here if it is an array. You can try this-

    $lists = [
        "key" => "7beqbabdHqdd3NMZ",
        "attributes" => [
            "url" => "GitHub",
            "name" => "https://github.com/foo"
        ]
    ];

    $replacedValues = [
        "name" => "GitHub",
        "url" => "https://github.com/foo",
    ];

    $finalOutput = array_replace($lists, $replacedValues);

@ajvanho Have you tried replace()?

Check here: https://laravel.com/docs/8.x/helpers#method-fluent-str-replace

@jkrantz It seems it's possible. Have you checked this post? https://programmersought.com/article/66685893412/

@austinbryan Welcome to the Laravel World.

Honestly, as long as your code works, there is nothing wrong with that. But there are a lot of ways to improve your code. I believe it's all about fundamental parts.

I would recommend you to watch this series.

https://laracasts.com/series/code-reflections

@mbo You may not get the exact plugin on Laravel.

But what I suggest you that, since you know already what to build is just build from the sketch. That will help you to improve the knowledge!