c mysql注册登录_mysql_register.c(数据库登录)

#include

#include

#include

#include

int main()

{

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

MYSQL m_sql;

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");

if(data == NULL)

printf("

接收数据出错.");

else

{

//获取用户名和密码分别保存到user[]和password[]中

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++;

}

}

//printf("

user_name = %s, user_passwd=%s",user,password);

//char sql[100] = {0};

//sprintf(sql, "insert into user_info values ('%s','%s');", user, password);

char query_sql[100] = {0};

sprintf(query_sql, "insert into user_info values ('%s','%s');", user, password);

mysql_query(&m_sql, query_sql);

mysql_close(&m_sql);

//printf("

Register Success.");

//sleep(1);

FILE *fp = fopen("./htdocs/index.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);

return 0;

}