Thread: using mysql with c++

I've installed the mysql server, but I can't really find any website that tells you how to use it with c++. I know I need to use the my_global.h and mysql.h but I also need to use a dll. I found a website that said all I have to do is link libmysql.dll to dev-cpp but it said I have to use pexports and I can't find any information about that at all. Then I have to use the dlltool and I can't find any information on that either. Does anyone know what I have to do to use mysql in a c++ compiled exe? I would really appreciate it if you could tell me where I could find something to walk me through this. Thank you for your time.

Hi! I browsed through the MySql site and saw this: MySQL++ hope that helps. I saw a little of docs, and seems simple to use.

I thought mysql was for storing data generated by web programs, e.g. php/Apache/mysql. How do you use mysql in a C++ application?

Hey! I was browsing again and saw that MySQL already has a C API =D. Acctualy it is needed to build the lib I told first. Here is its doc: MySQL C API. I downloaded mysql, and this lib come togheter.

7stud, you can have a desktop application, like a bank system, or a rental agency, a store. Any application that you must store large amounts of data, like customer info, products, so on...

Ok. I want to learn how to set up a C++ app with mysql, too.

I know about the mysql api. But I don't know how to set it up with dev-cpp. I found this:

Hi.

Try with Dev-Cpp

download pexports-043 (search in google) I don't know the site.

... and execute ...

1. pexports libmysql.dll > libmysql.def
2. dlltool comes with dev-cpp
dlltool -k --input-def libmysql.def --dll-name libmysql.dll --output-lib libmysql.a
3. create a project (with a source code), in project menu->project options->parameters->linker-> add -lmysql
4. compile and link your program
5. a error ocorred

a unrecognized ... mysql_init@4

or something like this.
6. edit limysql.def and add @number in front of the function. Example:
a unrecognized ... mysql_init@4
in libmysql.def
(you find like this)
...
...
mysql_init
...
...
(so)
...
...
mysql_init@4
...
...

save the file. execute dlltool again, and try compile/link,


Bye

The only problem is I don't know how to use the pexports or the dlltool. If anyone can say exactly how to do this that would be great. Thank you for your help.

Originally Posted by 7stud

I thought mysql was for storing data generated by web programs, e.g. php/Apache/mysql. How do you use mysql in a C++ application?

mysql is just a database server that can be accesed by anything that has the ability to access it.

I got the libmysql.a created and linked into the project but now I need to know how to use MySql commands in c++. Is that what I need a wraper for? I downloaded mysql++ and tried to install it, because origionally thats what I thought I needed. But when I got to the make.mingw I couldn't figure out what to do next. So if anyone can tell me what to do after I've linked libmysql.a I'd really appreciate it. Thank you for your time.

I followed the directions and I got an error saying dlltool: installation error, cannot exec 'as' I don't really understand what that means. I tried to google it but I didn't really find anything useful. Seems other people have had problems similar to this, but every page I checked never had an answer. Do you know of anything that causes this error, what this error means? Thank you for your time.

There's no reason you can't use C++ for web applications 7stud. It's not even a stupid idea: writing code in one of the 'p's (-thon,-erl,-hp) isn't really that much faster, despite people always going on about it.

yahn, on Windows I found it easier to just use the mysql c api, rather than Mysql++ (although apparently Mysql++ is good, I couldn't get it working properly). All you need to do is #include <winsock.h> before you #include <mysql.h>. Then you have to include the libraries wsock32.lib (or ws2_32.lib if you need winsock2 support) and mysqlclient.lib (there is another mysql library, but that one is probably the one you're going to want). Make sure you they will be found by the compiler and that should be it.

There's no reason you can't use C++ for web applications 7stud. It's not even a stupid idea: writing code in one of the 'p's (-thon,-erl,-hp) isn't really that much faster, despite people always going on about it.

How?

You don't need anything, really. A CGI library isn't at all hard to write, but it's true that certain aspects of the p's are better suited. To be honest I don't see why having no compile cycle is of any significance, except that web apps in general aren't very mature, so development times need to be as short as possible. Remember that having an uncompiled web app is less secure than having a compiled one.

For now though, it's like Chaos said: actual execution speed of your app isn't usually the bottleneck. I only choose to write mine in c++ because I prefer it.
</offtopic banter>