Fikelela kwi-MySQL usebenzisa uC

Ngalesi sifundo ndibonisa kuluntu ukuba ungafikelela njani kwisiseko sedatha ye-MySQL kulwimi lwenkqubo ye-C kwaye ngaphandle kokusebenzisa ukuxhomekeka kakhulu,

libmysqlclient

Ndiyathemba ukuba iyakuba luncedo kwabo bafuna olu hlobo lwamaxwebhu kwaye ke baqhubeke nokwenza igalelo kuluntu lwe-SL kwaye bancede abo bangenayo i-INTERNET.

Cwangcisa

Kuqala kufuneka sijonge ukuba sinazo na iilayibrari zoyilo ezifakiweyo *-dev ukuze ukwazi ukufikelela kwi-C / C ++ ukuya kwi-MySQL.

mysql_config -ibhayibhile

Kuya kuvela into enje:

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

Ukuba ujonga ukuba ilayibrari ayifakwanga, siyifaka ngalo myalelo ulandelayo:

Sudo apt-fumana ukufaka i-libmysqlclient-dev mysql_config --cflags -I / usr / include / mysql -DBIG_JOINS = 1 -fno-strict-aliasing -DUNIV_LINUX -DUNIV_LINUX

Kuba siqinisekisile kwaye sayifaka into esiyifunayo kunxibelelwano phakathi kwe-MySQL kunye no-C, siyaqhubeka nakwisiseko sedatha:

YENZA UVAVANYO LOLWAZI; Sebenzisa uvavanyo; YENZA idatha yeTafile (i-id int AUTO_INCREMENT HAYI NGOKUPHELELEYO KWIPHEPHA LOKUQALA, igama varchar (40), ubudala int); FAKA AMANQAKU Eedatha (NULL, 'Alma Hernandez', 28), (NULL, 'Jose Sanchez', 39), (NULL, 'Martin loera', 25), (NULL, 'Leonardo Cortez', 26), (NULL , 'UGustavo Romero', 25);

Inkqubo kunye nokudityaniswa

Siyaqhubeka nokwenza ikhowudi:

Umbuzo.c

/ * iilayibrari esiza kuzisebenzisa * / # kubandakanya / * Ithala leencwadi elisivumela ukuba sisebenzise unxibelelwano kunye nemibuzo nge-MySQL * / #include / * Ukuze usebenzise printf, njl. * / int ephambili () {MYSQL * ikhonkco; / * uqhagamshelo olwahlukileyo lwe-MySQL * / MYSQL_RES * res; / * Umahluko oza kuba neziphumo zombuzo * / MYSQL_ROW umqolo; / * Umahluko oza kuba namabala kwirekhodi nganye ekuboniswene ngayo * / char * server = "localhost"; / * Idilesi yeseva 127.0.0.1, localhost okanye ip idilesi * / char * umsebenzisi = "ingcambu"; / * Umsebenzisi ukuba abuze isiseko sedatha * / char * password = "ingcambu"; / * Iphasiwedi yomsebenzisi ekuthethwa ngawo * / char * database = "test"; / * Igama ledatha ukubuza * / conn = mysql_init (NULL); / * Ukuqalisa ukucima uqhagamshelo * / / * qhagamshela kwindawo yogcino lwedatha * / ukuba (! fprintf (stderr, "% s \ n", mysql_error (ikhonkco)); / * ukuba kukho impazamo echaza ukuba yeyiphi impazamo eyi * / exit (0); } / * thumela umbuzo we-SQL * / ukuba (mysql_query (ikhonkco, "khetha * kwidatha")) {/ * Inkcazo yombuzo kunye nemvelaphi yonxibelelwano * / fprintf (stderr, "% s \ n", mysql_error ( ikhonkco)); ukuphuma (0); } Res = i-mysql_use_result (ikhonkco);
	ukuprinta("Isazisi \ gama \ t \ yobudala \ n"); ngelixa ((umqolo = mysql_fetch_row (res))! = NULL) / * loop ngokusebenzisa res eguquguqukayo kunye nazo zonke iirekhodi ezifunyenweyo zokusetyenziswa * /
		ukuprinta("% s \ t% s \ t% s \ n", umqolo [0], umqolo [1], umqolo [2]); / * umahluko womqolo uba luluhlu lwenani lamabala etafileni * / / * umahluko okhutshiweyo uyakhutshwa kwaye uqhagamshelo luvaliwe * / mysql_free_result (res); i-mysql_close (ikhonkco); }

Sihlanganisa kunye:

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

Uqinisekiso

Siphumeza:

./Umbuzo

Umthombo: Ibhlog kaHugo4295