#include <cstdlib>
#include <iostream>
#include <stdio.h>
#include <stdlib.h>
#include <windows.h>
#include <winsock.h>
//#include <my_global.h>
//#include <my_sys.h>
#include <mysql/mysql.h>
#include <string>

using namespace std;





//typedef unsigned int uint;

void getrow();

int main()
{

    string asd("dupa");
MYSQL *conn;
MYSQL_RES *res, *result;
MYSQL_ROW row;
 int num_fields;
  int i;



char *server = "127.0.0.1";
char *user = "root";
char *password = "";
char *database = "projekt"; // nazwa bazy
conn = mysql_init(NULL);
/* Connect to database */
if (!mysql_real_connect(conn, server,
user, password, database, 0, NULL, 0)) {
fprintf(stderr, "%sn", mysql_error(conn));
exit(1);
}
/* send SQL query */
if (mysql_query(conn, "show tables")) {
fprintf(stderr, "%sn", mysql_error(conn));
exit(1);
}
res = mysql_use_result(conn);
/* output table name */
printf("MySQL Tables in mysql database:\n");
while ((row = mysql_fetch_row(res)) != NULL)
printf("%s \n", row[0]);



mysql_query(conn, "SELECT * FROM m_ksm_arch");
  result = mysql_store_result(conn); // wynik zapytania
  num_fields = mysql_num_fields(result); // pobierz ilosc pol
 row = mysql_fetch_row(result);
 cout << *row << endl;

 // wypisanie jednej linii
for ( int j = 0; j < 500; j++) {
    row = mysql_fetch_row(result);
      for(i = 0; i < num_fields; i++)
      {
          printf("%s ", row[i] ? row[i] : "NULL");
      }
      printf("\n ");

}



/* close connection */
mysql_free_result(res);
mysql_close(conn);
system("PAUSE");
return 0;
}