Inizio logica per inserimento database

Filippo Bertilotti

2024-07-25 6aea632ad61ffc31ed8b72e00e1693c1ca3c63fe

Inizio logica per inserimento database

 app/Http/Controllers/Profiles/ProfilesController.php

@@ -83,11 +83,11 @@
    
    public function saveUser(SSOFormRequest $request) {
        $data = $request->all();

        print_r($data);
        //VodafoneUser::save(["Name" => "Paolo", "Surname" => "Test", "EmailAddress" => "paolotest@test.it"]);
        //$dbHandler = new FakeSSODatabaseHandler;
        //$databaseHandler->testInserimentoDatabase();
        $databaseHandler = new FakeSSODatabaseHandler;

        $databaseHandler->insertDataIntoTables($data);
        
        return view("vodafone_fake_sso.db-create-view");
    }


 app/Http/Requests/SSOFormRequest.php

@@ -24,7 +24,7 @@
    public function rules()
    {
        return [
            'EmailAddress' => 'required|email',
            'EmailAddress' => 'required|email', //da cambiare con una regular expression?
            'Name' => 'required',
            'Surname' => 'required',
            'sim_1' => 'digits_between:10,10',

 app/Vola/Services/FakeSSODatabase/FakeSSODatabaseHandler.php

@@ -3,8 +3,13 @@

use Exception;
use Illuminate\Support\Facades\DB;
use PDOException;

class FakeSSODatabaseHandler {

    public function __construct() {
        echo "Loaded class 'FakeSSODatabaseHandler'";
    }
    
    /*public function insertDataIntoTable(array $data) {
        //usare insert() per inserire il valore nella tabella giusta
@@ -14,12 +19,16 @@
        
    }*/

    public function testInsert() {
    public function insertDataIntoTables(array $data) {
        print_r($data["EmailAddress"]);


        try{
            DB::insert("insert into fakesso_vodafoneusers (Name, Surname) values (?, ?)", ["CIAO", "CIAONE"]);
        }catch(Exception $e) {
            echo $e;
        }
            DB::insert("insert into fakesso_vodafoneusers (Name, Surname, EmailAddress) values (?, ?, ?)",
                        [$data["Name"], $data["Surname"], $data["EmailAddress"]]);
        }catch(PDOException $e) {
            echo $e->getMessage();
        };
    }