.-.-.-.-.-

<?php
try {
require_once 'setting.config.php';
require_once 'DBConnection.php';
require_once 'Metadata.php';

$database = new DBConnection($config);
    $metadata = new Metadata($database);

$param = [
        'id' => 9999,
        'campaigninfoid' => 9998,
        'slogande' => 'Wir testen für unsere Freiheit',
        'sloganfr' => 'Nous testons notre liberté',
        'sloganit' => 'Testiamo la nostra libertà',
        'imagepathde' => '',
        'imagepathfr' => '',
        'imagepathit' => '',
        'campaignstatus' => 1,
        'shortdescriptionde' => '',
        'shortdescriptionfr' => '',
        'shortdescriptionit' => '',
        'precheckdate' => '2022-03-31 00:00:00',
        'collectionstartdate' => '2022-04-01 00:00:00',
        'collectionexpirydate' => '2023-10-01 00:00:00',
        'submitteddate' => null,
        'linktobundesblatt' => 'www.microsoft.com',
        'bundesblatttitle' => 'Microsoft',
        'linktosignatureform' => '',
        'linktodetailpage' => '',
        'campaigntype' => 'Volksinitiative',
        'sigantureformpathpdfde' => '',
        'sigantureformpathpdffr' => '',
        'sigantureformpathpdfit' => '',
        'sigantureformpathjpgde' => '',
        'sigantureformpathjpgfr' => '',
        'sigantureformpathjpgit' => '',
    ];

var_dump($param);
    $result = $metadata->insert($param);

echo 'result = '.$result.'<br/>';

} catch (Exception $ex) {
    echo 'error '.$ex->getMessage().'<br/>';
}

/home/wirbesti/www/php/testmetadatainsert.php