hy guz l run a school website and l want to create a login system from the database, any ideas much appreciated
Pre-aApproving is feature request at this point, so manual actions is only option here:
https://support.wix.com/en/article/site-members-request-pre-approving-new-members
As for manual way: to add a user to the members area, you need to create a new member account for them using the Members Area app in the Wix editor. This will require the user to provide a username and password, and will give them access to any content or pages that you have set up for members only.
You can also use the contact list and the members area together to create a more integrated user experience on your site. For example, you could use the contact list to collect user information and then use that information to pre-populate the registration form for the members area. Or you could use the contact list to send targeted email campaigns to specific emails, to speed up the procedure of registration.