Converting client data from thousands of records into a secure hash value?

I want to use one of the Wappler hash security features. With a unique SALT string.

So that the User login values are encrypted on Submit & the query matches a unique Authorized User in the server table by those encrypted login field values.

But I would need to import hundreds to thousands of Authorized User records which are given to me in plain text. I cannot convert such a list one record at a time, obviously. So I need to convert each “username” and “password” text value in my plain text mysql table with the same encryption method I am going to specify for encrypting the Login Username and Password online.

Can I see the Wappler query that encrypts these 2 inputs on post submission?

And then create a mysql or php script that loops through my plain text records and converts these 2 fields the same way & using the specified SALT value I’ve chosen?

So that the query quickly UPDATES thousands of text value login fields which will match the Wappler encryption generated when a user tries to log in.

Creating a whole new table with the correctly encrypted values to compare with the Login encrypted form inputs?

Community Page
Last updated: