Soo gal MySQL adoo adeegsanaya C

Casharradan waxaan bulshada ugu soo bandhigayaa sida looga helo xogta MySQL ee ku jira luuqadda barnaamijka C iyo iyada oo aan la isticmaalin ku-tiirsanaan badan, oo kaliya

libmysqlclient

Waxaan rajaynayaa inay waxtar u yeelan doonto dadkii u baahnaa dukumiintiyada noocan oo kale ah isla markaana ay sii wadaan inay wax ku biiriyaan bulshada reer SL isla markaana caawiyaan kuwa aan lahayn INTERNET.

qaabeynta

Marka hore waa inaan hubinaa inaan leenahay maktabadaha qaabeynta *-dev si aad ugala soo bixi karto C / C ++ illaa MySQL.

mysql_config --libs

Waa inay u muuqataa wax sidan oo kale ah:

-Wl, -Bsymbolic-hawlaha –L / usr / lib / mysql -lmysqlclient rdynamic

Haddii aad hubiso in maktabadda aan la rakibin, waxaan ku rakibeynaa amarka soo socda:

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

Tan iyo markii aan hubinno oo aan rakibno waxa aan u baahan nahay xiriirka ka dhexeeya MySQL iyo C, waxaan u gudubnaa abuurista keydka:

Abuuritaanka DATABASE imtixaanka; ISTICMAALKA ISTICMAALKA; Abuur xogta JADWALKA (id int AUTO_INCREMENT MA AHN NIMAAD HOOS U DHEH, magaca varchar (40), da'da int); GELIYO QIIMAHA xogta (NULL, 'Alma Hernandez', 28), (NULL, 'Jose Sanchez', 39), (NULL, 'Martin loera', 25), (NULL, 'Leonardo Cortez', 26), (NULL , 'Gustavo Romero', 25);

Barnaamij iyo isku dubarid

Waxaan sii wadeynaa sameynta furaha:

Weydiinta.c

/ * maktabadaha la adeegsado * / #ku dar / * maktabadda noo oggolaaneysa inaan ka faa'iideysano isku xirnaanta iyo weydiimaha MySQL * / #ku dar / * Si loo isticmaalo daabacaadda, iwm. * / int main () {MYSQL * conn; / * doorsoomaha isku xirka MySQL * / MYSQL_RES * res; / * doorsoome ka koobnaan doona natiijada weydiinta * / MYSQL_ROW saf; / * doorsoome kaas oo ka koobnaan doona meelaha duubitaan walba lala tashaday * / char * server = "localhost"; / * cinwaanka server 127.0.0.1, localhost ama cinwaanka ip * / char * user = "root"; / * isticmaale si uu u waydiiyo keydka macluumaadka * / char * password = "root"; / * lambarka sirta ah ee isticmaaleha su'aasha ah * / char * database = "tijaabo"; / * Magaca keydka xogta weydiinta * / conn = mysql_init (NULL); ) fprintf (stderr, "% s \ n", mysql_error (conn)); / * haddii qalad jiro qeex khaladka uu ahaa * / bixitaanka (0); } / * dir SQL su'aal * / haddii (mysql_query (conn, "xulo * xogta")) {/ * qeexitaanka su'aasha iyo asalka xiriirka * / fprintf (stderr, "% s \ n", mysql_error ( conn)); bixitaanka (0); } res = mysql_use_result (conn);
	printf("ID \ tMagaca \ t \ da'da \ n"); halka ((saf = mysql_fetch_row (res))! = NULL) / * loop dhex mara isbadalka leh dhamaan diiwaanada la helay si loo isticmaalo * /
		printf("% s \ t% s \ t% s \ n", safka [0], safka [1], safka [2]); / mysql_close (conn); }

Waxaan isku soo uruurineynaa:

gcc -o Su'aal $ (mysql_config --cflags) Query.c $ (mysql_config -–libs)

Xaqiijinta

Waxaan fulin:

./ Su'aal

source: Hugo4295's Blog