How to update data in the database

FBioCS1

I haven’t learned Laravel systematically, I’m just trying to imitate other extensions to make my extension.

What I want to achieve is: add a button in the SettingsPage(done), onClick, do some logic, and update the column 'test' in the table 'users'.

I checked other extensions's code like 'NickName' and 'Suspend', and i imitate the following codes to do that, but it doesn't work.

/js/forum/index.js

app.initializers.add('test-test', () => {
//.........
  function saveChanges() {    //onclick={() => saveChanges()
    app.session.user.save({test: 1})  //change to '1'
  }

/extend.php

namespace Flarum\MyExtension;

use Flarum\Extend;
use Flarum\User\Event\Saving;
return [
    (new Extend\Event())
        ->listen(Saving::class, SaveTestToDatabase::class)
];

/src/SaveTestToDatabase.php


<?php

namespace Flarum\MyExtension;

use Flarum\User\Event\Saving;
use Illuminate\Support\Arr;


class SaveTestToDatabase{
    public function handle(Saving $event)
    {
//I don't know what to do here
    }
}

And how to update and query data out of the "users" table?

I have a small suggestion I hope you can refer to. For the pre-installed extensions, I hope you can write more comments. This is useful for people who do not want to systematically learn web development to develop some simple Flarum extensions.

clarkwinkelmann

Your code looks good. It just needs the saving logic in the event listener.

This is a simplified version of the code of https://github.com/flarum/nicknames/blob/master/src/SaveNicknameToDatabase.php

<?php

namespace Flarum\Nicknames;

use Flarum\User\Event\Saving;
use Illuminate\Support\Arr;

class SaveNicknameToDatabase {
    public function handle(Saving $event)
    {
        // Get the attributes out of the JSON:API formatted request (attributes passed to model.save() in the frontend are automatically added to the attributes key)
        $attributes = Arr::get($event->data, 'attributes', []);

        // Check our attribute is present. If it's not there, the user is probably performing another action like marking everything read or changing password
        if (isset($attributes['nickname'])) {
            // Update Eloquent model. Do not save here, Flarum will do it automatically after all extensions update their values
            $event->user->nickname = $attributes['nickname'];
        }
    }
}

Essentially, the event contains both the data from the request and a reference to the user being modified. You can retrieve the request data, check that your attribute is present in the request, and then update the Laravel Eloquent model with the new data. You don't need to save the model, Flarum already does it after the Saving event.

What I have removed from the original code are the permission checks (in my example, anyone can update that attribute on anyone else) and the validation (any value can be set in the example, including values too long for the database which will cause a 500 error)

If you tried something but encounter a javascript or PHP error, please share the error message.

FBioCS1

clarkwinkelmann Thank you.

I got this error:

POST http://mysite.com/api/users/1

ReflectionException: Class Flarum\MyExtension\SaveTestToDatabase does not exist in /www/wwwroot/mysite.com/vendor/illuminate/container/Container.php:873

I think there seems to be no 'test' attribute in 'users'. Do i need to ‘register’ it?

askvortsov

FBioCS1

SaveTestToDatabase

Make sure you're calling the correct class name, and that the class is in a file with a corresponding name.

FBioCS1

askvortsov

Yes, the file name in the /src is SaveTestToDatabase.php
here is the code in the /src/SaveTestToDatabase.php:

<?php

namespace Flarum\MyExtension;

use Flarum\User\Event\Saving;
use Illuminate\Support\Arr;


class SaveTestToDatabase{
    public function handle(Saving $event)
    {
        $attributes = Arr::get($event->data, 'attributes', []);

        $event->user->test = $attributes['test'];
    }
}

here is extend.php

namespace Flarum\MyExtension;

use Flarum\Extened;
use Flarum\User\Event\Saving;

return [
    (new Extend\Frontend('forum'))
        ->js(__DIR__.'/js/dist/forum.js')
        ->css(__DIR__.'/less/forum.less'),
    (new Extend\Frontend('admin'))
        ->js(__DIR__.'/js/dist/admin.js')
        ->css(__DIR__.'/less/admin.less'),
    new Extend\Locales(__DIR__.'/locale'),

    (new Extend\Event())
        ->listen(Saving::class, SaveTestToDatabase::class)
];

askvortsov

FBioCS1 make sure you don't have opcache running. Restarting your nginx /apache might help here.

Darkle

askvortsov Quite off-topic (sorry about that), but good to see you here 🙂

FBioCS1

askvortsov

I disabled opcache and restart the whole server, but still:

POST http://mysite.com/api/users/1

ReflectionException: Class Flarum\MyExtension\SaveTestToDatabase does not exist in /www/wwwroot/mysite.com/vendor/illuminate/container/Container.php:873

FBioCS1

askvortsov
Strangely, I found that when I started my extension, the nickname was also abnormal and when i tried to change my nickname, the same error occurred.

FBioCS1

FBioCS1
This issue is solved. I used updated the code to directly overwrite the local file to the vendor file, and then I tried to submit it to packgist and then update it through composer, I don't know why, but it succeeded.

Excited!!!!!!!!!!

askvortsov

FBioCS1 make sure that on your local development environment, you're pulling the dev package from your local path repository, not the published package from packagist.