C++ Program communicating with MySQL Database

Question

Does anyone know of a simple way for a C++ program to communicate directly with a MySQL database? I have looked at MySQL++ and found it to be very confusing. If anyone knows of a very simple way of doing this, please let me know.

Thanks

P.S. I am developing on a Windows machine. PHP and MySQL web web application setup. C++ setup to talk to the serial port. Thus why I need a way for C++ to talk to the MySQL database directly.

Answer 1

There are quite a few database API wrappers but my favourite - and the one I recommend - is the SOCI library. Much nicer syntax than using the raw C API.

The 'motivating' example from the SOCI website:

int id = ...;
string name;
int salary;

sql << "select name, salary from persons where id = " << id, into(name), into(salary);