cgic库的使用问题

[hubiaolinger]

有人能给几个使用cgic库的c程序的啊，只有一个test感觉还是不给力啊，谢谢啦

[yaopingcs]

给你贴个往数据库增加用户的程序：


#include <stdlib.h>
#include <stdio.h>
#include <sqlite3.h>
#include <string.h>

int select_result(void *data,int n_columns,char **column_values,char **column_names);
int user_exist=0;
char name[20];

int main(int argc,char *argv[])
{
sqlite3 *db=NULL;
char *errMsg=NULL;
int rc;
char temp[100];
//sprintf(name,"%s",argv[3]);
strcpy(name,argv[3]);
fprintf(stdout,"Content-type:text/html\n\n");
fprintf(stdout,"<html><title>display data</title>");

if(sqlite3_open(argv[1],&db))
{
fprintf(stderr,"Cann't open database %s<br>!",sqlite3_errmsg(db));
sqlite3_close(db);
exit(1);
}

else
{
printf("open database %s successfully!<br>",argv[1]);
}

sqlite3_exec(db,"BEGIN TRANSACTION;",NULL,NULL,NULL);

sprintf( temp,"SELECT * FROM %s",argv[2]);

rc=sqlite3_exec(db,temp,select_result,NULL,&errMsg);//check the fdata exist or not!
if(rc)
{
printf("%s",errMsg);
exit(1);
}

if(user_exist == 0) //legal username
{
printf("<br>add user now!<br>");
sprintf(temp,"INSERT INTO %s VALUES('%s','%s')",argv[2],argv[3],argv[4]);
rc=sqlite3_exec(db,temp,NULL,NULL,&errMsg);
if(rc)
{
printf("%s",errMsg);
}
}

sqlite3_exec(db,"COMMIT TRANSACTION;",NULL,NULL,NULL);


sqlite3_close(db);

fprintf(stdout,"</html>");
}




int select_result(void *data,int n_columns,char **column_values,char **column_names)
{
int i,c1=1,c2=1;


/*******************Judge the username and password*********************/
c1=strcmp(column_values[0],name);
//c2=strcmp(column_values[1],nv[1].value);
//printf("c1=%s,<br>c2=%s<br>",column_values[1],nv[1].value);
if(c1==0)
{
//legal_user=1;
user_exist=1;
printf("username exist");
//printf("<script>");
//printf("window.location='../adduser'");
//printf("</script>");
exit(1);
}

return 0;
}

[bloveslw]

其实很容易解决的。你到google一下就ok了