Katerio - News & Magazine Multilingual CMS 1.0.6 (08 October 2022)

/*----------------------------------------------------
       PREPARE SQL QUERY USING PDO FOR CREATE NEW ADMIN
    ----------------------------------------------------*/
    $create_admin =  $db->prepare("INSERT INTO `admins` (email,name,username,email_verified,role,image,password,remember_token,created_at,updated_at) VALUES (:name,:email,:username,:verified,:role,:image,:password,:token,:created,:updated)");

    /*----------------------------------------------
        ADD NEW SUPER ADMIN WHILE INSTALLATION
    ----------------------------------------------*/
    $create_admin->execute([
        ':name' => strip_tags(trim($admin_details['admin_name'])),
        ':email' => trim($admin_details['admin_email']),
        ':username' => strip_tags(trim($admin_details['admin_username'])),
        ':verified' => 1,
        ':password' => password_hash($admin_details['admin_password'], PASSWORD_BCRYPT),
        ':role' => 1,
        ':image' => null,
        ':token' => null,
        ':created' => date('Y-m-d h:i:s'),
        ':updated' => date('Y-m-d h:i:s'),

    ]);
    $last_insert_id = $db->lastInsertId();
    /*--------------------------------------------------------
       PREAPARE SLQ QUERY FOR ASSIGN SUPER ADMIN ROLE
    --------------------------------------------------------*/
    $role_assign = $db->prepare("INSERT INTO `model_has_roles` (role_id,model_type,model_id) VALUES (:role_id,:model,:model_id)");
    /*--------------------------------------------------------
        ASSIGN SUPER ADMIN ROLE FOR CREATED ADMIN
    --------------------------------------------------------*/
    $role_assign->execute([
        ':role_id' => '1',
        ':model' => 'App\Admin',
        ':model_id' => $last_insert_id,
    ]);
    return true;