delete.c

来自「linux下的网站」· C语言 代码 · 共 59 行

C
59
字号
#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,"delete from student where name='%s'",cgi_param("Name"));    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("Delete Success!");		puts("</body></html>");		puts("\n");		 sqlite3_close(db);		 cgi_end();    return 0;}

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?