Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #include <stdio.h>
- #include <stdlib.h>
- #include <sqlite3.h>
- using namespace std;
- int callback(void *data, int argc, char **argv, char **azColName){
- string userName = "admin";
- string passWord = "passw0rd";
- string sortCode = "202020";
- if(userName == argv[1] && passWord == argv[2] && sortCode == argv[3])
- {
- cout << " MATCH TO DATABASE " << endl;
- //flag to send cookie
- cout << userName << passWord << sortCode << endl;
- }
- printf("\n");
- return 0;
- }
- int main(int argc, char* argv[]) {
- sqlite3 *db;
- char *zErrMsg = 0;
- int rc;
- char *sql;
- const char* data = "Callback function called";
- /* Open database */
- rc = sqlite3_open("/usr/lib/cgi-bin/bank.db", &db);
- if( rc ) {
- fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
- return(0);
- } else {
- fprintf(stderr, "Opened database successfully\n");
- }
- /* Create SQL statement */
- sql = "SELECT * FROM BANK WHERE username = '";
- sql.append(userName);
- sql.append("'");
- /* Execute SQL statement */
- rc = sqlite3_exec(db,sql.c_str(),callback, (void*)data, &errMsg);
- if( rc != SQLITE_OK ) {
- fprintf(stderr, "SQL error: %s\n", zErrMsg);
- sqlite3_free(zErrMsg);
- } else {
- fprintf(stdout, "Operation done successfully\n");
- }
- sqlite3_close(db);
- return 0;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement