i need simple php mysql code for openid logon and session control, using no 3rd party proprietary code, to be incorporated by me into my website and eventually developed upon.
i have a site that requires session control. i will NOT control authentication of passwords via my database, it must be done directly thru OpenId and/or FB authentication (no use of third party [especially NOT google] tools, free or otherwise). if necessary can supply simple openid logon, but i imagine you will want to use some stock code of yours - tested and true.
please check [login to view URL] for a working sample of google, yahoo and fb identity authentication, written in php. this is the base code for authentication, i will need YOUR code to:
1. check db for user email (or fb id), once he/she is authenticated by google, yahoo or fb
2a. in case user exists, initiate session
2b. in case user does not exist, ask if wants to be created and insert into db
3. in case user exists (or was created), start session
4. control valid session or reauthenticate (step 1)
will accept logon from google, fb and twitter.
will need session control to be inserted into ALL pages (not by you, by me!), with simple session duration maintenance (session duration must be a simple and accessible variable). MUST have unlimited duration as an option (not for client, of course)
must be in php using mysql
i will supply db structure, but will be a simple:
"SELECT Id_Target from target_email_view WHERE Ds_Target_Email = '"
that you will need in your code.
Id_Target is a UNIQUE index in target_email_view, therefore you either get 0 or 1 result.
the database is already created and a working LAMP environment is ready to use.
please do not bid if you have not developed session control code before - the pay is not enough for you to develop the code from scratch.