i have done my insertion code for the registration form but now i have to do password encryption after register which i totally have no idea on how to do it in C++ MFC dialog application. please help me if u have any source files. just encrypt the password part.

UpdateData();

MYSQL \*ssock;
ssock = (MYSQL \*)malloc(sizeof(MYSQL));
mysql\_init(ssock);

conn = mysql\_init(NULL);

if (conn == NULL) {
    printf("Error %u: %s\\n", mysql\_errno(conn), mysql\_error(conn));
    exit(1);
}

if (mysql\_real\_connect(conn, "127.0.0.1", "root", "Root", "inomatic", 0, NULL, 0) == NULL)
{
    printf("Error %u: %s\\n", mysql\_errno(conn), mysql\_error(conn));
    exit(1);
}

int tmp = atoi((LPSTR)(LPCTSTR)m\_Contact);

if(m\_Password != m\_CfmPassword)
    {
    MessageBox("Both Password do not match! Please enter again.");
    m\_EditPassword.SetFocus();
    }
if(m\_Username == "" || m\_Password=="" || m\_CfmPassword =="" || m\_Email =="" || m\_Contact =="" || m\_Company == "")
    {
    MessageBox("Please fill in all the blanks.");
    }
else if (m\_Password == m\_CfmPassword)
    {
            Insert(conn,(LPSTR)(LPCTSTR)m\_Username,(LPSTR)(LPCTSTR)m\_Password,(LPSTR)(LPCTSTR)m\_Email,tmp,(LPSTR)(LPCTSTR)m\_Company,"User");
            MessageBox("Thank You! You have successfully registed into People Counter Application.");
    }
UpdateData(FALSE);
mysql\_close(conn);
//Clear text after register ======================================================================================================================================
m\_EditUsername.SetSel(0,-1),m\_EditPassword.SetSel(0,-1),m\_EditCfmPassword.SetSel(0,-1),m\_EditEmail.SetSel(0,-1),m\_EditContact.SetSel(0,-1),m\_EditCompany.SetSel(0,-1);
m\_EditUsername.Clear();
m\_EditPassword.Clear();
m\_EditCfmPassword.Clear();
m\_EditEmail.Clear();
m\_EditContact.Clear();
m\_EditCompany.Clear();

Winter

Here is my code for my login dialog application. there is this error whereby any username and password will allow user to login. i link it with mysql database but its not checking for the user and just login with unexisting users. please help me solve this i don know where i go wrong or lack of anything else? thank you!

void CPeopleCounterDlg::OnBnClickedbtnlogin()
{
UpdateData();
bool ValidLogin = false;

if( m\_Username == "" )
{
    AfxMessageBox("You must provide a username to Login.");
    m\_EditUsername.SetFocus();

    return;
}
if( m\_Password == "" )
{
    AfxMessageBox("Please enter your password.");
    m\_EditPassword.SetFocus();
    return;
}
        //SQL查询语句
    if(mysql\_query( ssock,"SELECT \* FROM user WHERE Username == \\"m\_Username\\" AND Password == \\"m\_Password\\" "))
    {
        ValidLogin = true;
        CPplCMain  m\_pplc;
        m\_pplc.DoModal();
        this->ShowWindow(SW\_HIDE);
        this->ShowWindow(SW\_SHOW);
    }
    if(ValidLogin = false){
        MessageBox("Invalid login!");
    }
    if( !(res = mysql\_store\_result(ssock)) )
{
    MessageBox("Disconnected!", mysql\_error(ssock));
}
UpdateData(FALSE);
mysql\_close(ssock);

}