Finyelela i-MySQL usebenzisa i-C

Ngalesi sifundo ngethula emphakathini ukuthi ungafinyelela kanjani i-database ye-MySQL kusuka kulimi lohlelo lwe-C futhi ngaphandle kokusebenzisa ukuncika okuningi, ngokuvele

libmysqlclient

Ngiyethemba ukuthi kuzoba wusizo kulabo ababedinga lolu hlobo lwemibhalo futhi ngaleyo ndlela baqhubeke nokufaka isandla emphakathini we-SL futhi basize labo abangenayo i-INTERNET.

Isethaphu

Okokuqala kufanele sihlole ukuthi sinemitapo yolwazi eyakhiwe *-dev ukwazi ukufinyelela kusuka ku-C / C ++ kuya ku-MySQL.

i-mysql_config - amalibhu

Kufanele kuvele into enjengale:

-Wl, -Bsymbolic-works -L / usr / lib / mysql -lmysqlclient rdynamic

Uma kwenzeka ubheka ukuthi umtapo wezincwadi awufakiwe, siwufaka ngomyalo olandelayo:

sudo apt-get ukufaka libmysqlclient-dev mysql_config --cflags -I / usr / include / mysql -DBIG_JOINS = 1 -fno-strict-aliasing -DUNIV_LINUX -DUNIV_LINUX

Njengoba sikuqinisekisile futhi sakufaka esikudingayo kusixhumanisi esiphakathi kwe-MySQL ne-C, siqhubeka nokwakhiwa kwe-database:

DALA isivivinyo sedatha; SEBENZISA isivivinyo; DALA idatha yethebula (id int AUTO_INCREMENT NOT NULL PRIMARY KEY, name varchar (40), age int); FAKA AMANANI EDatha (NULL, 'Alma Hernandez', 28), (NULL, 'Jose Sanchez', 39), (NULL, 'Martin loera', 25), (NULL, 'Leonardo Cortez', 26), (NULL , 'UGustavo Romero', 25);

Ukuhlela nokuhlanganisa

Siyaqhubeka nokwakha ikhodi:

Umbuzo.c

/ * imitapo yolwazi esizoyisebenzisa * / #include / * umtapo wezincwadi osivumela ukuthi sisebenzise ukuxhumana nemibuzo nge-MySQL * / #include / * Ukuze usebenzise i-printf, njll. * / int main () {MYSQL * conn; / * ukuxhumeka okuguqukayo kwe-MySQL * / MYSQL_RES * res; / * Okuzoqukatha umphumela wombuzo * / MYSQL_ROW umugqa; / * okuguqukayo okuzoba nezinkundla zerekhodi ngalinye elibonisiwe * / char * server = "localhost"; / * Ikheli leseva 127.0.0.1, i-localhost noma ikheli le-ip * / char * user = "root"; / * umsebenzisi ukubuza i-database * / char * password = "root"; / * iphasiwedi yomsebenzisi okukhulunywa ngaye / / char * database = "test"; / * Igama ledathabheyisi yokubuza * / conn = mysql_init (NULL); / * Ukuqalisa ukuqeda ukuxhumana * / / * xhuma ku-database * / if (! mysql_real_connect (conn, server, user, password, database, 0, NULL, 0)) {/ * chaza amapharamitha wokuxhuma asethwe ngaphambilini * / fprintf (stderr, "% s \ n", mysql_error (conn)); / * uma kunephutha chaza ukuthi yiliphi iphutha elaliyi * / exit (1); } / * thumela umbuzo we-SQL * / if (mysql_query (conn, "select * from data")) {/ * incazelo yombuzo nomsuka woxhumano * / fprintf (stderr, "% s \ n", mysql_error ( conn)); phuma (1); } i-res = mysql_use_result (i-conn);
	printf("ID \ tIgama \ t \ age \ n"); ngenkathi ((row = mysql_fetch_row (res))! = NULL) / * loop ngokusebenzisa i-res eguquguqukayo nawo wonke amarekhodi atholakele ukusetshenziswa * /
		printf("% s \ t% s \ t% s \ n", umugqa [0], umugqa [1], umugqa [2]); / * ukuguquguquka komugqa kuba ukuhlelwa kwenani lezinkambu kutafula * / / * i-res eguqukayo ikhishwa futhi ukuxhumana kuvaliwe * / mysql_free_result (res); i-mysql_close (conn); }

Sihlanganisa ne:

gcc -o Umbuzo $ (mysql_config --cflags) Umbuzo.c $ (mysql_config -–libs)

Ukuqinisekisa

Sikhipha:

./Umbuzo

Umthombo: Ibhulogi likaHugo4295