insert_db.h

#ifndef INSERT_DB_H
#define INSERT_DB_H
#include <iostream>
#include "select_db.h"
#include "libsqlite.hpp"
using namespace std;

int insert_db(int studentID, string name, string surname, string username, string email, string password)
{/*insert the student details into database*/
  try{
    sqlite3::sqlite db("School.db");
    auto cur = db.get_statement();
    cur->set_sql( "INSERT INTO Studentdetails VALUES(?,?,?,?,?,?,?);" );
    cur->prepare();
    cur->bind( 1, studentID );
    cur->bind( 2, name );
    cur->bind( 3, surname );
    cur->bind( 4, username );
    cur->bind( 5, email );
    cur->bind( 6, password );
    cur->step();
}
    catch( sqlite::exception e )
    {
        cerr << e.what() << endl;
        return 1;
    }
  return 0;
}
#endif