Posted By: chomer () on 'CZdatabases' Title: Re: C+MySql Date: Fri Jun 22 11:25:22 2001 > > > jasne ... z perlu je to v dobry ... me ale spis zajimalo to C ... > x-max > Taky bych rad vedel.. zatim jsem se dostal k necemu takovemuto (bohuzel nikde zadny tutorial neni :-((, vsechno jsem zkousel pomoci cteni hlavickovych souboru... :-o) ------------------- insert.c ----------------------------------------------- #include <stdlib.h> #include <mysql/mysql.h> int main () { MYSQL *m; m=mysql_init(NULL); m=mysql_connect(m,"localhost","root",""); if (!m) {printf(":-("); return -10;} mysql_select_db(m,"test"); mysql_query(m,"insert into ctest values('hee','huu','hoo')"); mysql_close(m); return 0; } ------------------ list.c (tady jsem nejak nenasel, jaxe dostat k hodnotam :(-- #include <stdio.h> #include <stdlib.h> #include <mysql/mysql.h> int main () { MYSQL *m; MYSQL_RES *re; int i,n,nn; printf(".");fflush (stdout); m=mysql_init(NULL); m=mysql_connect(m,"localhost","root",""); if (!m) {printf(":-(n"); return -10;} mysql_select_db(m,"test"); i=mysql_query(m,"select * from ctest"); if (i) {printf(":-((n"); return -20;} re=mysql_store_result(m); if (!re) {printf(":-(((n"); return -30;} n= mysql_num_rows(re); if (!n) {printf(":-((((n"); return -40;} nn=mysql_num_fields(re); printf(" %ld x %d n",n,nn); mysql_close(m); return 0; } -----------------------Makefile-------------------------------------- LFLAGS=-L/usr/lib/mysql CC=gcc CFLAGS=-O6 OPT=$(CFLAGS) $(LFLAGS) LIBS=-lmysqlclient all: insert list insert: insert.c $(CC) $(OPT) $@.c -o $@ $(LIBS) list: list.c $(CC) $(OPT) $@.c -o $@ $(LIBS) --------------------------------------------------------------------- ~ Chomer (chatid: opat) Nesnasim turisticke znacky, nenavidim minova pole a miluju poust....