February 5th, 2002, 11:19 AM
C and MySql
I am working in C and I wanna connect my app in C with MySql.
Is there a app library to use with C to connect for mysql?
I had the library for mysql++ but this work more properly with c++ and I am using C?
February 5th, 2002, 11:42 AM
"Me fail English? That's unpossible!"
March 2nd, 2002, 08:06 AM
March 4th, 2002, 08:09 AM
take it from me.....mysql and c are a pain in the ***. there is an api for mysql, though, but there are a few things you might want to know:
/*all this applies to unix*/
to compile, type this:
gcc -g -o -L/*directory*/lib -I/*directory*/include -lmysqlclient -lm
where I put *directory*, put the location of your mysql folder. This should be something like /usr/local/mysql/
then....here are some code snippets you can use:
/*connect to mysql*/
connection = mysql_connect(&mysql, "localhost", "9841860u", "9841860u");
/*check for a connection error*/
if(connection == NULL)
/*print error message*/
/*select a database*/
/*here you create a string to pass as a query...you have to do it this way (I think) because you can't pass mysql a variable from C*/
strcpy(query, "SELECT column FROM table WHERE variable = ");
state = mysql_query(connection, query);
if(state != 0)
/*this will give you a result set (if you are expecting a result)...you can go through that with row=mysql_fetch_row(result)*/
/*before you can call another query that will return a result set, you must free the result set*/
/*close the mysql connection*/
there are a whole load of functions and structures used, just go through the c api section of the mysql manual.....you can get that online
hope I was of help,
March 18th, 2002, 02:50 AM
how about windows?
how to compile them with bcc?
March 19th, 2002, 06:57 AM
sorry, fate and the universe have conspired to ensure I don't speak windows.
March 19th, 2002, 10:25 AM
thx anyway :-)
any others know how to do that?