#include <fcgi_stdio.h>
#include <stdlib.h>
#include <stdio.h>
#include <string.h>
#include <mysql.h>

int main(int argc, char *argv[])
{
	MYSQL mysql;
	MYSQL_RES *res;
	MYSQL_ROW row;
	char stmt_str[] = "select id, lb, description from pages where id = 3";

	mysql_init(&mysql);
	mysql_options(&mysql, MYSQL_READ_DEFAULT_GROUP, "SUPA_CGI");
	
		
	if (!mysql_real_connect(&mysql, "127.0.0.1", "root", "", "test", 0, NULL, 0))
	{
		fprintf(stdout, "Failed to connect to database: Error: %s\n", mysql_error(&mysql));
		return EXIT_FAILURE;
	}
		
	while(FCGI_Accept() >= 0)
	{
		mysql_real_query(&mysql, stmt_str, strlen(stmt_str));
		res = mysql_use_result(&mysql);
		if(row = mysql_fetch_row(res))
		{
			puts("Content-Type: text/plain; charset=us-ascii\n\n");
			printf("id: %s\nlb: %s\ndescription: %s\n", row[0], row[1], row[2]);
		}
		else
		{
			puts("Content-Type: text/plain; charset=us-ascii\n\n");
			puts("no data found");
		}
		
		mysql_free_result(res);
	}
	
	mysql_close(&mysql);
	return EXIT_SUCCESS;
}