EugeneX MiniWeb

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

====== Установка и работа с MySQL на C++ ======

<code makefile makefile>
make: main.cpp
	g++ -Wall -o xvec main.cpp -lmariadb

clean:
	rm -rf xvec *.o
</code>

<code cpp main.cpp>
#include <iostream>
#include <vector>
#include <string>

#include <mariadb/mysql.h>

using namespace std;

vector<string> f;

void fail(MYSQL* c) {
    fprintf(stderr, "%s\n", mysql_error(c));
    mysql_close(c);
    exit(1);
}

int main() {
   
    MYSQL* conn = mysql_init(NULL);
    if (conn == NULL) {
        cerr << "mysql_init failed!" << endl;
        return 1;
    }

    if ( mysql_real_connect(conn, "localhost", "root", "datasuit86!", "homeauto", 0, NULL, 0) == NULL) {
        fprintf(stderr, "%s\n", mysql_error(conn));
        mysql_close(conn);
        return 1;
    }

    if ( mysql_query(conn, "SELECT CURRENT_TIMESTAMP as 'time', version() as 'ver' UNION SELECT now(), 6543456546546456456456")) {
        fail(conn);
    }

    MYSQL_RES* result = mysql_store_result(conn);
    if (result == NULL) {
        fail(conn);
    }

    // int num_fields = mysql_num_fields(result);
    MYSQL_ROW row;

    while ((row = mysql_fetch_row(result))) {

        cout << row[0] << ", " << row[1] << endl;

    }
    
    mysql_free_result(result);

    mysql_close(conn);

    cout << "OK!" << endl;
    return 0;
}
</code>

EugeneX MiniWeb

User Tools

Site Tools

Page Tools