24.02.2019, 13:25
You would need to query the list of phone numbers in your database. Something like this:
"SELECT COUNT(*) FROM `accounts` WHERE `PhoneNumber` = '%i'"
Format this string and insert your newly generated phonenumber into the %i placeholder with format();
Then query the database, get and save the result of this and see what you received. If 0 - you are OK, if more - you need to generate the phone again because it already exists.
Replace `Accounts` with the table name where you keep your phone numbers, and `PhoneNumber` with how you call your phone number column in you database.
"SELECT COUNT(*) FROM `accounts` WHERE `PhoneNumber` = '%i'"
Format this string and insert your newly generated phonenumber into the %i placeholder with format();
Then query the database, get and save the result of this and see what you received. If 0 - you are OK, if more - you need to generate the phone again because it already exists.
Replace `Accounts` with the table name where you keep your phone numbers, and `PhoneNumber` with how you call your phone number column in you database.