how to get data out of mysql

[xiaotom]

I'm programming with c++, I store the data I need in mysql. Now want to
read data from mysql and put to parameters in my program.
I use c api to program. In c api there seems to have many api to query
the database. but can't find one to get data out of the database.
can someone tell me how ? or just tell me which api I should use .

thanks a lot!

[Jonathan]

xiaotom wrote:

I'm programming with c++, I store the data I need in mysql. Now want to
read data from mysql and put to parameters in my program.
I use c api to program. In c api there seems to have many api to query
the database. but can't find one to get data out of the database.
can someone tell me how ? or just tell me which api I should use .

thanks a lot!

First take a look at the MySQL C API function overview and description,
everything you are looking for is there:

http://dev.mysql.com/doc/refman/5.0/...-overview.html
http://dev.mysql.com/doc/refman/5.0/...functions.html

Basically these are thes teps you need to take:

- connect to the database using mysql_connect() or mysql_real_connect()
- execute your query using mysql_query() or mysql_real_query()
- process your results
- free your dataset using mysql_free_result()
- close the connection using mysql_close()

Take a look at these tutorials to give you an idea:

http://www.synnottsoftware.com/tutorials/mysqlbasic.php
http://www.cpp-home.com/tutorial.php?22_1

Good luck!

Jonathan

[xiaotom]

really appreciate your help! I'm a newbie, maybe I need more patience
to read the files your listed.
:)

[Shark]

you can also use the MySQL++ API.

You can do simple things like:

query<<"select * from table";

and then

Result res = query.store();

and then

Row row = res.fetch_row();
string name = string(row["user_name"]);
type of things.

xiaotom wrote:

really appreciate your help! I'm a newbie, maybe I need more patience
to read the files your listed.
:)