#include <stdio.h>
#include <stdlib.h>
#include "sqlite3.h"


int exe(const char* s_exe) {
    int test;
    char **result; /* where the reuslts are written to*/
    sqlite3 *db;
    char *zErrMsg;
    
    int rc;
    int nrow,ncol;
    int db_open;
    
    
    
    test = sqlite3_open("test.db", &db);
    if( test != SQLITE_OK ){
    fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
    sqlite3_close(db);
    }
    rc = sqlite3_get_table(
		db,              /* An open database */
		s_exe,       /* SQL to be executed */
		&result,       /* Result written to a char *[]  that this points to */
		&nrow,             /* Number of result rows written here */
		&ncol,          /* Number of result columns written here */
		&zErrMsg          /* Error msg written here */
		);

    char *titles[ncol];
    char *data[nrow*ncol];

    if( rc == SQLITE_OK ){
        for(int i=0; i < ncol; ++i)
             titles[i]= result[i];   /* First row heading */
        for(int i=0; i < ncol*nrow; ++i)
            data[i]=result[ncol + i];
    }
    else 
        printf ("%s \n", "Fout met uitvoer data");
    sqlite3_free_table(result);
    return rc;

}



int main(){

    exe("select * from table1");

    return 0;
    }