Connecting the form plugin with the database plugin

douxdoux-1312 · February 16, 2024, 7:27pm

I’m trying to find a way to connect my GRAV form to my postgresql database using the database plugin. The goal would be to save the form content to the database. I have all the prerequisites installed, but I don’t really understand to go from there.

Did anyone tried it already ? Do yo have any idea which files should be modified ? I’m a a loss.

Karmalakas · February 19, 2024, 8:13am

I believe you’d nee a custom form action, which would put the data to DB

anon76427325 · February 19, 2024, 11:45am

@douxdoux-1312 , Plugin SQLite allows saving a form into a SQLite database using the 'onFormProcessedEvent` and custom form action ‘sql-insert’:

github.com

finanalyst/grav-plugin-sqlite/blob/8af55a37938f8b7ed10b415565db5ce2ecff864d/sqlite.php#L82-L188


      
          public function onFormProcessed(Event $event)

          {

              if ( isset($this->grav['sqlite']['error'])  && $this->grav['sqlite']['error'] ) {

                  $this->log(self::ERROR,$this->grav['sqlite']['error']);

                  $this->grav->fireEvent('onFormValidationError', new Event([

                        'form'    => $event['form'],

                        'message' => sprintf($this->grav['language']->translate(['PLUGIN_SQLITE.DATABASE_ERROR']), $this->grav['sqlite']['error'])

                  ]));

                  $event->stopPropagation();

                  return;

              }

              $action = $event['action'];

              $params = $event['params'];

              $form = $event['form'];

              switch ($action) {

                  case 'sql-insert':

                        $data = $form->value()->toArray();

                        if ( isset($params['ignore'])) {

                            foreach ( $params['ignore'] as $k ) unset( $data[$k] );

                        }

This file has been truncated. show original

douxdoux-1312 · February 19, 2024, 5:05pm

Yeah I set up the SqLite plugin first, but I’m more used to Postgresql (especially when it comes to remotely access the db which would be required for the project) !

anon76427325 · February 19, 2024, 5:42pm

@douxdoux-1312, I was only showing how a plugin can intercept the ‘Submit’ of a form and processing the custom action.

Both the Database plugin and SQLite plugin contain part of your needs which you can combine into your own plugin.

hughbris · February 21, 2024, 11:54pm

Then say so initially!

Topic		Replies	Views
Form followed by Form Plugins	0	565	January 29, 2018
Save image as BLOB with SQLite plugin Forms & Blueprints form , plugins	1	256	January 16, 2024
Exception handling Plugins	1	1111	January 28, 2018
Correctly handling errors from custom form processes Plugins	0	586	June 22, 2018
SQLite integration in Grav Plugins first-time	7	1261	December 13, 2018

Connecting the form plugin with the database plugin

Related topics