Login system for drawing in php

Question

I need to create a login system for a draw page. The user has to be the number that will be drawn, this information will already be fed in the BD, then the user would enter this number and email to log in and have access to the content of the page. For example when loading the page will have the code field of the draw and e-mail, then this code will already be in the BD and he would need to feed only with his e-mail and ready would be already logged in. Any idea on how to create this login that works as a register too?

Answer 1

I think that simpler than making a complete registration system with email validation, would be you allow the user to identify with your Facebook account, Google, Microsoft, Yahoo, etc..

For this you can use Oauth because this protocol allows you to access the account data and get the user’s email with your permission.

Then you create the user account on your site if the email does not already exist in your database.

The Oauth protocol is a little complicated and that’s why I wrote a Oauth client class in PHP to simplify the process of authorizing and accessing Oauth-based Apis such as Facebook, Google, etc. Here’s the first and the second part of a Portuguese tutorial on this subject.

Answer 2

from what I understand you will have to do the following, this assuming you are using mysql:

$numero = "numero do sorteio";

$email = "email digitado";

$sql = mysql_query("SELECT * FROM tabela WHERE numero = '{$numero}'") or die (mysql_error());

if(mysql_num_rows($sql)){

    $sql = mysql_query("UPDATE tabela set email = '{$email}' WHERE numero = '{$numero}'") or die (mysql_error());

}