Quellcode

char* sql_nodb (char* host, char* user, char* password, char* query)
{
	/* Private vars defintions */
	MYSQL *mysql=NULL;
	MYSQL_RES *result;
	MYSQL_ROW row;
	char sQuery[1000];
	unsigned int num_fields;
	int i;

  	if ((mysql=mysql_init(mysql)) == NULL) 
	{
    		perror ("Fatal");
		exit(1);
  	}

  	if (!mysql_real_connect(mysql, host, user, password, NULL, 0, NULL, 0)) 
	{
    		perror ("Fatal");
    		exit(1);
  	}
	cout << "\033[32mConnection to database established\033[m"<<endl;

  	strcpy (sQuery, query);
  	if(mysql_exec_sql(mysql,sQuery) == 0) 
	{
    		result = mysql_store_result(mysql);
    		// are there any rows??
    		if (result) 
		{
      			num_fields = mysql_num_fields(result);
      			while ((row = mysql_fetch_row(result))) 
			{
        			for(i = 0; i < num_fields; i++) 
				{
          				cout << row[i]<<endl;
        			}
     			}
      			mysql_free_result(result);
     		}
  	}
	mysql_close(mysql);
	cout << "\033[31mConnection closed\033[m"<<endl;

}