Thread: C and MySql

    #1
  1. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2001
    Location
    Dominican Republic
    Posts
    22
    Rep Power
    0

    Unhappy 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?
    Any comments?
    TIA
  2. #2
  3. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2001
    Location
    USA
    Posts
    286
    Rep Power
    13
    Jon Sagara

    "Me fail English? That's unpossible!"
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2002
    Posts
    1
    Rep Power
    0
  6. #4
  7. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2002
    Location
    Galway, Ireland
    Posts
    4
    Rep Power
    0
    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*/
    mysql_init(&mysql);
    connection = mysql_connect(&mysql, "localhost", "9841860u", "9841860u");

    /*check for a connection error*/
    if(connection == NULL)
    {
    /*print error message*/
    printf(mysql_error(&mysql));
    }


    /*select a database*/
    mysql_select_db(&mysql, "Nag");

    /*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 = ");
    strcat(query, x);
    state = mysql_query(connection, query);
    if(state != 0)
    {
    printf(mysql_error(connection));
    }

    /*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*/
    mysql_free_result(result);

    /*close the mysql connection*/
    mysql_close(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,

    good luck,

    Des.

    :p
  8. #5
  9. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2002
    Posts
    1
    Rep Power
    0
    how about windows?
    how to compile them with bcc?
    thx
  10. #6
  11. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2002
    Location
    Galway, Ireland
    Posts
    4
    Rep Power
    0

    Unhappy


    sorry, fate and the universe have conspired to ensure I don't speak windows.
  12. #7
  13. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2002
    Posts
    1
    Rep Power
    0
    god...~
    too bad
    thx anyway :-)

    any others know how to do that?

IMN logo majestic logo threadwatch logo seochat tools logo