mysql login_mysql_login.c(数据库登录)

#include

#include

#include

#include

int main()

{

printf("Content-Type:text/html;charset=utf-8\n\n");

MYSQL m_sql; //创建MYSQL对象

mysql_init(&m_sql); //初始化对象

MYSQL *sql = mysql_real_connect(&m_sql,"localhost","root","123","test",3306,NULL,0);//链接到数据库

if(sql == NULL)

{

printf("

Connect Mysql Fail.\n");

exit(1);

}

char user[20] = {0};

char password[20] = {0};

int i = 0;

char *data = getenv("QUERY_STRING"); //查询sql语句

if(data == NULL)

printf("

接收数据出错.");

else

{

while(*data != '=')

data++;

data++; //skip =

while(*data != '&')

{

user[i++] = *data;

data++;

}

data++; //skip &

while(*data != '=')

data++;

data++;

i = 0;

while(*data != '\0')

{

password[i++] = *data;

data++;

}

}

MYSQL_ROW sqlrow;

MYSQL_RES *res_ptr;

char select[100] = {0};

sprintf(select,"select user_passwd from user_info where user_name='%s'",user);

int res = mysql_query(&m_sql, select);

res_ptr = mysql_store_result(&m_sql);

if(res_ptr)

{

sqlrow = mysql_fetch_row(res_ptr);

}

else

{

printf("

database data error.");

exit(1);

}

if(strcmp(sqlrow[0], password) == 0)

{

FILE *fp = fopen("./htdocs/bigcalc.html","r");

if(NULL == fp)

{

printf("

Not Found 404

");

exit(1);

}

char buf[128];

while(!feof(fp))

{

fgets(buf, 128, fp);

printf(buf);

}

fclose(fp);

}

else

{

printf("

user name or user password error.");

}

mysql_close(&m_sql);

return 0;

}