// reading a text file
#include <iostream>
#include <fstream>
#include <string>
using namespace std;
 
int main () {
  string line; //this will contain the data read from the file
  ifstream myfile ("example.txt"); //opening the file.
  if (myfile.is_open()) //if the file is open
  {
    while (! myfile.eof() ) //while the end of file is NOT reached
    {
      getline (myfile,line); //get one line from the file
      cout << line << endl; //and output it
    }
    myfile.close(); //closing the file
  }
  else cout << "Unable to open file"; //if the file is not open output <--
 
  return 0;
}

#include <stdio.h>
#include <string.h>
#include <mysql.h>
 
#define HOST "localhost"
#define USER ""
#define PASSWD ""
#define DB_NAME ""
 
void readLogFile();
void insert2DB(); 
void logSeparator(char log[1600]);
void logSeparatorDetails(char logDetails[2500]);
void date2DB(char dateLog[20]);
//int operatorPrefix();
 
static MYSQL demo_db;
char string1[150], msg[250];
char date[50],time[50],noXXX[50],hpno[50],noYYY[50];
char dateLog[20];
char dd[20], mm[20], yyyy[20], theDate[20];
 
int main()
{
    readLogFile();
}
 
void readLogFile()
{
    char line[1600];
    FILE *fp;
 
    fp=fopen("DB1-12-27-07-2006.txt", "r+");
 
    if(fp==NULL) {
        printf("file not found!\n");
        exit(0);
    }
    else {
        while(!feof(fp)) {
            bzero(line, sizeof(line));
            fgets(line,1600,fp);
            logSeparator(line);
            logSeparatorDetails(string1);
            date2DB(date);
            //operatorPrefix();
            insert2DB();
        }
    }
 
    fclose(fp);
    return;
}
 
void insert2DB()
{
    char query[16384];
    char query1[16384];
    int stat;
 
    if(!mysql_connect(&demo_db, HOST, USER, PASSWD))
      {
            printf(mysql_error(&demo_db));
            exit(1);
      }
 
      if(mysql_select_db(&demo_db, DB_NAME))
      {
            printf(mysql_error(&demo_db));
            exit(1);
      }
 
    bzero(query, sizeof(query1));
    sprintf(query, "INSERT INTO PostpaidProfile2 (MobileNumber,PackagePlan,Status) VALUES('%s','%s',1)",hpno,msg,stat);
 
    printf("%s\n",query);
 
    if(mysql_real_query(&demo_db, query, strlen(query)+255))
      {
           printf(mysql_error(&demo_db));
            bzero(query, sizeof(query));
             exit(1);
      }
 
    mysql_close(&demo_db);
 
    return;
}
 
void logSeparator(char log[2000])
{
    char *temp, msgTemp[200];
    int io;
 
    io=0;
    bzero(string1, sizeof(string1));
    bzero(msg, sizeof(msg));
 
    temp = strtok (log," ");
 
    while (temp != NULL)
        {    
            io++;
 
                switch(io)
                {
                    case 1: 
                            strcpy (string1, temp);
                                break;
                    default: 
                              strcpy (msgTemp, temp);
                              if (strlen(msg) != 0) {
                                  strcat(msg," ");
                                }
                                strcat(msg,msgTemp);
                                break;
        }
 
                temp = strtok (NULL," ");
    }
}
 
void logSeparatorDetails(char logDetails[2000])
{
    char *temp2;
    int io2;
 
    io2=0;
    bzero(hpno, sizeof(hpno));
    bzero(msg, sizeof(msg));
 
    temp2 = strtok (logDetails,",");
 
    while (temp2 != NULL)
        {    
            io2++;
 
                switch(io2)
                {
 
                    case 1: 
                            strcpy (hpno, temp2);
                                break;
                    case 2: 
                            strcpy (msg, temp2);
                                break;
 
        }
 
                temp2 = strtok (NULL,",");
    }
}
 
void date2DB(char dateLog[20])
{
    bzero(dd, sizeof(dd));    
    bzero(mm, sizeof(mm));
    bzero(yyyy, sizeof(yyyy));
    bzero(theDate, sizeof(theDate));
 
        strncpy(dd,dateLog,2);
        strncpy(mm,dateLog+2,2);
        strncpy(yyyy,dateLog+4,4);
 
        strcat(theDate,yyyy);
        strcat(theDate,"-");
        strcat(theDate,mm);
        strcat(theDate,"-");
        strcat(theDate,dd);   //convert to yyyy-mm-dd as in mysql date format   
 
    return;
}

 readLogFile("file1.txt");
readLogFile("file2.txt");