急求!!sqlite3_exec函数 如果未查询到想要的数据,怎么继续执行其它操作?
问题:以下是登陆界面的相关代码,大致流程是:登陆界面填入用户名和密码后写入session,然后比对session和sqlite数据库里的用户名及密码,相同则跳转到主界面index.html,不相同则跳转回登陆界面。但是以下代码只能实现登录正确时跳转,用户名及密码错误时却不能跳转回登陆界面,只能保持缓冲状态!而且在执行了if(empty)后,不管用户名和密码是否正确,均会打印“empty”这条语句!不知道在数据库没有查询到想要的数据时如何继续执行之后的不同跳转操作。请高手指点啊。。。。。
#include <stdio.h>
#include <string.h>
#include <stdlib.h>
#include <sqlite3.h>
#include <ctype.h>
#include <iconv.h>
#include "../../public/common.h"
#include "xmlshare.h"
#define dbPath "/var/www/sqlite/docclass.db"
int sql_manage(void *p, int argc, char **argv, char **argvv);
int flag = 0;
char *role = NULL;
char* szOut= NULL;
int main(int argc,char **argv)
{
int i = 0;
char *user_name = NULL;
char *user_passwd = NULL;
struct user_info user;
int length = 0;
char cookie_string[256];
cgi_decoder();
user_name = cgi_value("userid");
user_passwd = cgi_value("userpwd");
printf_value("userid",user_name);
printf_value("userpwd",user_passwd);
memset(&user,0,sizeof(struct user_info));
sprintf(user.user_name,"%s",user_name);
sprintf(user.user_passwd,"%s",user_passwd);
sqlite3 *db;
char *err = 0;
int ret = 0;
int empty = 1;
int id = 1;
char sql[1024];
ret = sqlite3_open(dbPath, &db);
if(ret != SQLITE_OK) {
fputs(sqlite3_errmsg(db), stderr);
fputs("\n", stderr);
exit(1);
}
sprintf(sql,"select user,role,pwd from Login_table where user='%s';",user_name);
ret = sqlite3_exec(db,sql, sql_manage,&empty, &err);
if(ret != SQLITE_OK) {
fputs(err, stderr);
fputs("\n", stderr);
sqlite3_close(db);
exit(1);
}
if(empty){
printf("empty\n");
}
sprintf(user.user_role,"%s",szOut);
//printf("user.user_role=%s\n",user.user_role);
if(flag == 4)
{
cgi_session(NULL);
cgi_session_add("user",user.user_name);
cgi_session_add("role",user.user_role);
cgi_session_add("login","yes");
cgi_session_set_timeout((time_t)(600));
cgi_session_free();
printf("Content-Type: %s%c%c","text/html",10,10);
printf("<script>window.location.href='../html/prog/index.htm';</script>");
}
else
{
printf("Content-Type: %s%c%c","text/html",10,10);
printf("<script>window.location.href='../html/login1.htm';</script>");
}
if(flag == 4)
{
logs(user_name,"登录",LOG_SUCC);
}
else
{
logs(user_name,"登录",LOG_FAIL);
}
return 0;
}
int sql_manage(void *p, int argc, char **argv, char **argvv)
{
char buf[1024]="";
int i=0;
int j=0;
char *name = NULL;
char *passwd = NULL;
char *tmp = NULL;
cgi_decoder();
name = cgi_value("userid");
passwd = cgi_value("userpwd");
sprintf(buf,"%s|%s|%s|\n",argv[0],argv[1],argv[2]);
printf("%s", buf);
if(!strcmp(argv[0],name))
{
if(!strcmp(argv[2],passwd))
{
flag = 4; //全局变量
role = argv[1];
strcat(role,",");
szOut = g2u(role); //全局变量
printf("flag = %d\n",flag);
}
}
return 0;
}