用+C+写的+CGI+留言板程序.doc

用 C 写的 CGI 留言板程序- 支持mysql 发表时间： 2006-4-29 10:52:32作者：newzy来源： 来自: /blog/blog.asp?name=newzy这里下载源代码: /develop/download/review.rar看看 eybuild 的中文手册: /develop/doc/manual/eyBuild_manual_ch.pdf这里下载 CSP 开发环境: /develop可以让留言本支持 MYSQL, 方法是 将下面的 db_mysql.c 替换掉 原来的 db.c 即可.程序接口与原来的兼容.extern void * open_db(char * mode);extern int close_db(void * fp);extern int db_read_next(void * fp, RECORD * rcd);extern int db_insert(void * fp, RECORD * rcd);/* db_mysql.c - where to start CGI */* Copyright(C) eyBuild Group, 2005, 2006. All Rights Reserved. */* */*modification history01a, 2005-04-03, newzy writen*/*DESCRIPTIONthis module is for suport mysql.Thanks for xxt help.ALSO SEE:db.c db.h*/#include #include #include #include #include #include db.h#include /* database info */typedef struct char * dbname;char * table_name;MYSQL * mydata;MYSQL_RES * records; DB_INFO;/* open data base */void * open_db(char * mode)DB_INFO * db_fp = NULL;db_fp = (DB_INFO *)malloc(sizeof(DB_INFO);memset(db_fp, 0, sizeof(DB_INFO);if ( ! (db_fp-mydata = mysql_init(NULL) )return NULL;db_fp-dbname = example;db_fp-table_name = viewmsg;if (!mysql_real_connect(db_fp-mydata, NULL, root, xxt, db_fp-dbname, MYSQL_PORT, NULL, 0 )return NULL;return db_fp;/* close data base */int close_db(void * fp)DB_INFO * db_fp = (DB_INFO *)fp;if (NULL = fp)return ERROR;if (db_fp-records)mysql_free_result(db_fp-records);if (db_fp-mydata)mysql_close(db_fp-mydata);free (db_fp);return OK; /* read record from base */int db_read_next(void * fp, RECORD * rcd)DB_INFO * db_fp = (DB_INFO *)fp;MYSQL_ROW row;/* get records from server */if (NULL=db_fp)return ERROR;if (NULL=db_fp-records)char strsql256 = ; sprintf (strsql, select * from %s, db_fp-table_name);if (mysql_query(db_fp-mydata, strsql) ) close_db(db_fp); return ERROR; db_fp-records = mysql_store_result(db_fp-mydata); /* read one record */row = mysql_fetch_row(db_fp-records);if (NULL = row) /* end of records */return 0;strcpy(rcd-name, row1);strcpy(rcd-sex, row2);strcpy(rcd-mail, row3);strcpy(rcd-now, row4);strcpy(rcd-msg, row5);rcd-msg_len = strlen(rcd-msg);return sizeof(RECORD);/* insert record to data base */int db_insert(void * fp, RECORD * rcd)DB_INFO * db_fp = (DB_INFO *)fp;char strsqlsizeof(RECORD) = ; /* get records from server */if (NULL=db_fp | NULL=db_fp-mydata)return ERROR;sprintf(strsql, insert into %s (name,sex,email,date,content) values(%s, %s, %s, %s, %s),db_fp-table_name,rcd-