OpenForum RSS: mysql � c++

mysql � c++ (Heretic)

Thu, 29 Nov 2007 14:22:42 GMT

��

#include <stdio.h>
#include <stdlib.h>
#include <iostream>
#include "mysql.h"

MYSQL mysql;
MYSQL_RES *res;
MYSQL_ROW row;

void exiterr(int exitcode)
{
fprintf(stderr, "%s\n", mysql_error(&mysql));
exit(exitcode);
}

int main()
{
uint i = 0;
if(!mysql_init(&mysql))
exiterr(1);

if (!(mysql_real_connect(&mysql,"localhost","root","secret","",0,NULL,0)))
exiterr(1);
if (mysql_select_db(&mysql,"egroupware")) exiterr(2);
if (mysql_query(&mysql,"SELECT * FROM egw_accounts"))
exiterr(3);
if (!(res = mysql_store_result(&mysql))) exiterr(4);

while ((row=mysql_fetch_row(res))) {
int z = mysql_num_fields(res);
std::cout << z << "\n";
for (i=0 ; i < 2; i++) {
std::cout << row[i] << "\n";
// std::cout << "test" << "\n";
}
}
if (!mysql_eof(res)) exiterr(5);
mysql_free_result(res);
mysql_close(&mysql);
}

int z = mysql_num_fields(res);
std::cout << z << "\n";
� �� ^^^^^^^^^^^^^^^^^^ �� 12 ��

mysql � c++ (Heretic)

Thu, 29 Nov 2007 12:57:35 GMT

��, �� .
�� include <mysql/mysql.h>, �� ?
�� url �� http://www.mysql.ru/webboard/index.html?n1=1151&n2=2 ,�� .

mysql � c++ (Heretic)

Thu, 29 Nov 2007 12:54:23 GMT

>http://tangentsoft.net/mysql++/doc/html/userman/tutorial.html#id2843575
>http://www.codeproject.com/database/mysqlwrap.asp
>� ��

�� 2 �� , �� , mysql/mysql.h, �� .

mysql � c++ (AITech)

Thu, 29 Nov 2007 09:58:10 GMT

��
uint id = 0;
char buf[255];

mysql � c++ (AITech)

Thu, 29 Nov 2007 09:57:09 GMT

#include "mysql.h"

MYSQL mysql;

int main()
{
uint id = 0;
char buf[255];

if(!mysql_init(&mysql))
exiterr("can't init DB");

if (!mysql_real_connect(&mysql, "localhost", "myname", "mypass", "mydb", 0, NULL, 0))
exiterr("can't connect DB");

if (mysql_query(&mysql,"INSERT INTO mytable (myfield) VALUES (myvalue)"))
exiterr("query failed");

mysql_close(&mysql);
mysql_library_end();
}

mysql � c++ (Alu)

Thu, 29 Nov 2007 08:37:37 GMT

http://tangentsoft.net/mysql++/doc/html/userman/tutorial.html#id2843575
http://www.codeproject.com/database/mysqlwrap.asp
� ��