Re: [PHP & mssql]email verifcation with mssql
Quote:
Originally Posted by
Popa Andrei
Thanks a lot kutsumo,in a bit i will remain at the pc ant start implementing this and i will come with update.Thanks a lot for the help untill now.
Ok i manged to set up mi script to send the email.Now i am facing a big question.What do i do with the stored procedure?
Isnt it simplier to make the confirmation.php page rung the sp if everithyng is ok and the mail is confirmed?
That is up to you , you asked for an e-mail confirmation script , not a register script :D
Right now the confirmation.php will display to the user
PHP Code:
echo "Your account has been activated";
use
Code:
session_register();
and
Code:
if_session_registered();
to redirect user upon login to the desired page , or something similar .... look it up on google.
Re: [PHP & mssql]email verifcation with mssql
Quote:
Originally Posted by
Vusion
MSSQL code.
Code:
USE [Your Database name]
ALTER TABLE YOURTABLEHERE ADD AccActive int
And on the login function, add something like this:
Code:
$q = mssql_query("SELECT AccActive FROM YOURTABLE WHERE UserID = '".$_POST['iguess']."'");
if(mssql_result($q, 0, 'AccActive') != 1)
{
//throw out your message saying it isn't active.
}
if(mssql_result($q, 0, 'AccActive') != 1)
Can you please tell me what reprezents the red bolded caracter.
EDIT: a big thanks to all who helped.I succesfully made the register function after 2 hard days of work but it worth it :D
Again thanks a lot.
Re: [PHP & mssql]email verifcation with mssql [REZOLVED]
i need help // i need ur script//
we made but its having email problem its work good in website server linux
but its not work windows server 2008 with appserver
need help urget
niravmehta2009@gmail.com
Re: [PHP & mssql]email verifcation with mssql [REZOLVED]
Have you heard of Hooked on phonics?
Didn't think so.
If your thread is "REZOLVED" You might was well cloze it.