#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#include <mysql/mysql.h>
#include "c_in_linux.h"

int main(int argc, char *argv[], char *env[])
{

	char value1[255] = "", value2[255] = "", SQL[1024]="";
	int rc = 0;
	MYSQL *conn = NULL;
	MYSQL_RES *result = NULL;
	MYSQL_ROW row;

    char* pEnv;
    //setenv("QUERY_STRING", "&item1=thomas%20clark&item2=%21%21%21", 1);
    pEnv = getenv("QUERY_STRING");

	if (!pEnv)
    {
        printf("<form>\n");
        printf("<input type=\"text\" name=\"item1\">\n");
        printf("<input type=\"text\" name=\"item2\">\n");
        printf("<input type=\"submit\">");
        printf("</form>\n");
        printf("</body></html>\n");
        return 0;
    }
    else
    {
        strncpy(value1,(char *) getenv("QUERY_STRING"),255);
        printf("QUERY_STRING (encoded) : %s<BR>\n", value1 );
        printf("<form>\n");

        //call the decode_value function to get value of "ITEM1"
        decode_value( "item1=", (char *) &value1, 255);

        if(strlen(value1) > 0 )
            printf("<input type=\"text\" name=\"item1\" value=\"%s\">\n",value1);
        else
            printf("<input type=\"text\" name=\"item1\">\n");

        //call the decode_value function to get value of "ITEM2"
        decode_value( "item2=", (char *) &value2, 255);

        if(strlen(value2) > 0 )
            printf("<input type=\"text\" name=\"item2\" value=\"%s\">\n",value2);
        else
            printf("<input type=\"text\" name=\"item2\">\n");

        printf("<input type=\"submit\">");

        printf("</form>\n");
    }
    //printf("</body></html>\n");


	//OPEN DATABASE
	conn = mysql_init((MYSQL *) 0);
	mysql_options(conn,MYSQL_READ_DEFAULT_GROUP,"cpilc5");
	mysql_real_connect(conn, "localhost","cpil","cpilc5","CIL",0, NULL, 0);

	//INSERT IF THERE IS ANY DATA
	if(strlen(value1) > 0 || strlen(value2) > 0)
	{
		sprintf(SQL,"insert into C5 values ('%s','%s')",value1,value2);
		rc = mysql_query(conn,SQL);
	}

	//READ
	rc = mysql_query(conn,"select * from C5");
	result = mysql_use_result(conn);

        printf("<p>");
        int e = 0; //counter
	while( (row = mysql_fetch_row(result)) != NULL)
	{
            e++;
            printf("<h4 style=\"margin-bottom: 0px; padding-bottom: 0px;\">Entry #%d:</h4>", e);
            printf("<p>item1=%s<br />item2=%s<br /></p>",row[0],row[1]);
	}
        printf("</p>");

        printf("</body></html>\n");

	mysql_free_result(result);
	mysql_close(conn);


	return 0;

}