#include <sqlite3.h>
string  userName;
string passWord;
string sortCode;

string userTest;



static int callback(void *data, int argc, char **argv, char **azColName)
{
 int i;
 cout << " : " << (const char*)data;
 cout << " " << endl;


 if (userName == argv[1]  && passWord == argv[2] && sortCode == argv[3]){
 cout << " MATCH TO DATABASE " << endl;
	//flag to send cookie
     cout << userName << passWord << sortCode << endl;
}
 cout << " " << endl;
 return 0;
}





sqlite3 *db; //pointer
char *errMsg = 0;
int rc;
string sql;
const char* data = "Callback called  : ";

//Opening the database
rc = sqlite3_open("/usr/lib/cgi-bin/bank.db", &db);





if (rc)
{
 cout << "CANNAE OPEN DATABASE" << endl;
 return(0);
}else {
 cout << "OPENED THE DATABASE" << endl;
}

sql = "SELECT * FROM BANK WHERE username = '";
sql.append(userTest);
sql.append("'");

cout << sql << endl;


rc = sqlite3_exec(db,sql.c_str(),callback, (void*)data, &errMsg);
if (rc != SQLITE_OK)
    {
	cout << "SQL HAS ERROR " << errMsg << endl;
	sqlite3_free(errMsg);
    } else {
	cout << "OPERATION COMPLETE" << endl;
    }