Search login user record in mysql

Question

I have a followers exchange system, where the user logs in to the panel and use his list so I created a texarea so he can put his list which is in the format email@provider:password and then save the data in the table of the database

and after if loaded 100% and inserted the records in the database I will call a page to check if the login was validated or not on Instagram and if it is valid change the value of the tested column ( N = Not checked , B = Login valido R = Login bad )

php that will check if the login is good or bad it receives the email value and password of the database and goes tested until finalizes all registration that the user register in texarea .

my doubt and how can I do this without affecting other users , each user will only be able to check the list that is theirs that will check who is by the user column .

Thank you...

Answer 1

Do you want to do a check if the list is good, bad or not checked? I don’t understand much what you meant, but come on.

Make a fetch_array to get the string from the "tested field":

$q = mysql_query("SELECT testados FROM tabela");
$array = mysql_fetch_array($q);

Now just make an IF system to see if it’s worth what you want, that’s what I got...