📄 update.c
字号:
#include <stdio.h>#include <stdlib.h>#include <sqlite3.h>#include "cgi.h"int main(void){if(!cgi_session_var_exists("username")) { puts("<html>" "<head>" "<meta http-equiv='Content-Type' content='text/html;charset=utf-8'>" "</head>" "<body>"); puts("Please login!"); puts("</body></html>"); puts("\n"); return 0;}char s[1024]; cgi_init(); cgi_init_headers(); cgi_process_form(); 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,"update student set Name='%s',Gender='%s',ScoreA=%d,ScoreB=%d,ScoreC=%d where Name='%s'",cgi_param("Name"),cgi_param("Gender"),atoi(cgi_param("ScoreA")),atoi(cgi_param("ScoreB")),atoi(cgi_param("ScoreC")),cgi_param("NameToUpdate")); ret = sqlite3_exec(db, s, NULL, &empty, &err); if(ret != SQLITE_OK) { fputs(err, stderr); fputs("\n", stderr); sqlite3_close(db); exit(1); } if(empty) { fputs("table student is empty\n", stderr); exit(1); } puts("<html><head><meta http-equiv='Content-Type' content='text/html;charset=utf-8'></head><body>"); puts("Update Success!"); puts("</body></html>"); sqlite3_close(db); cgi_end(); return 0;}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -