📄 logins.c
字号:
#include <stdio.h>#include <stdlib.h>#include <sqlite3.h>#include "cgi.h"int rscallback(void *p, int argc, char **argv, char **argvv){ puts("<html><head><meta http-equiv='Content-Type' content='text/html;charset=utf-8'></head><body><p>"); printf("%s ", argv[0]); puts("Login Success!</p>"); puts("</body></html>"); cgi_session_register_var("username", argv[0]); return 0;} int main(void){cgi_init();cgi_session_start();cgi_process_form();cgi_init_headers();if (cgi_param("action")) { if(cgi_session_var_exists("username")){ puts("<html><head><meta http-equiv='Content-Type' content='text/html;charset=utf-8'></head><body><p>"); puts("Logined!</p>"); puts("</body></html>"); return 0; } char s[1024]; sqlite3 *db; char *err = 0; int ret = 0; int empty = 1; ret = sqlite3_open("./test.db", &db); if(ret != SQLITE_OK) { fputs(sqlite3_errmsg(db), stderr); fputs("\n", stderr); exit(1); } sprintf(s,"select name from login where name='%s' and passwd ='%s'",cgi_param("usrname"),cgi_param("pwd"), rscallback, &empty, &err); ret = sqlite3_exec(db, s, rscallback, &empty, &err); if(ret != SQLITE_OK) { fputs(err, stderr); fputs("\n", stderr); sqlite3_close(db); exit(1); } if(empty) { fputs("table employee is empty\n", stderr); exit(1); } sqlite3_close(db);} cgi_include("login.htm");cgi_end();return 0;}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -