have you tried ? http://www.geocities.com/jahan.geo/mysql_c_by_example.html
Ruben Safir Secretary NYLXS wrote:
On Fri, Sep 19, 2003 at 09:18:22AM +0500, Vikram Vaswani wrote:
Hello,
I need to write a simple C client for a project. I am using the MySQL C API. Attached is the code. It occassionally segfaults with no visible pattern. Could someone help me figure out why? Or any other comments on the code to help me make it better?
You know, I used to read this mailing list religiously before it became
flooded with W32 questions and PHP users. And I've stay susbscribed but I haven't posted to it in many many months. iIn fact, I didn't notice
I wasn't any longer subscribed. So I'm writing this application in C and GTK and I was thinking, it's finally time to learn to write some MYSQL C API stuff.
I've written a lot of Oracle C programs in years past. And now I'm looking at the C API stuff and wow, it is not readly understandable. I open up
the mysql mail file with mutt, and bang, this is on the top!
I was going to ask the list if anyone has an exmaple of the basic needs for a MYSQL program which makes a connection, sends a querry. Checks the potention errors, and maps the most basic column types to C types.
The docs say to look at examples in the source directory, but those aren't yet clear to me to understand.
Ruben
/* client.c */
#include <stdio.h> #include <mysql.h>
int main() { /* declare structures and variables */ char query[255]; int i, j, count;
MYSQL mysql; MYSQL_RES *result; MYSQL_ROW row; MYSQL_FIELD *field;
/* initialize MYSQL structure */
mysql_init(&mysql);
/* connect to database */ if (!(mysql_real_connect(&mysql, NULL, "root", "", "db1", 0, NULL, 0)))
{ fprintf(stderr, "Error in connection: %s\n", mysql_error(&mysql)); }
for( ;; ) {
printf("query? ");
gets(query);
if (strcmp(query,"exit")
== 0) {
break;
}
/* execute query */ /* if error, display error message */ /* else check the type of query and handle appropriately */ if (mysql_query(&mysql, query) != 0)
{ fprintf(stderr, "Error in query: %s\n", mysql_error(&mysql)); }
else { if (result = mysql_store_result(&mysql)) { /* SELECT query */ /* retrieve result set */ int numRecords = mysql_num_rows(result); int numFields = mysql_num_fields(result);
for (i = 0; i < numRecords; i++) { row = mysql_fetch_row(result);
for (j = 0; j < numFields; j++) {
//field= mysql_fetch_field(result); fprintf(stdout, "%s", row[j]);
j != (numFields-1) ? printf(", ") : printf("\n"); } }
fprintf(stdout, "** Query successful, %d rows retrieved **\n", numRecords); } else { if (mysql_field_count(&mysql) == 0)
{ /* non-SELECT query */ fprintf(stdout, "** Query successful, %d rows affected **\n", mysql_affected_rows(&mysql)); } else {
fprintf(stderr, "Error in reading result set: %s\n", mysql_error(&mysql)); } } }
/* clean up */
mysql_free_result(result); } mysql_close(&mysql); }
-- I wouldn't recommend sex, drugs, and insanity for everyone, but it works for me.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
Aftab Jahan Subedar CEO/Software Engineer Subedar Technologies Subedar Baag Bibir Bagicha #1 North Jatrabari Dhaka 1204 Bangladesh http://www.SubedarTechnologies.com http://www.DhakaStockExchangeGame.com/ http://www.CEOBangladesh.com/ http://www.NYSEGame.com tel://+88027519050 EMail://[EMAIL PROTECTED] - Directly to my notebook
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
