Friendsnippets

1. connection a une base de donnée MySQL en C

   view plain - save this

   Code en C permettant l'accès a une base de donnée MySQL C code wich permit MySQL access

    1 /*********************************************************
    2 **Attention il est impératif de compiler ce code avec l'option de compilation -lmysqlclient
    3 **********************************************************/
    4 
    5 #include <stdio.h>
    6 #include <errno.h>
    7 #include <stdlib.h>
    8 #include <iostream.h>
    9 #include <fstream>
   10 #include <mysql/mysql.h>
   11 #include <sys/types.h>
   12 #include <sys/wait.h>
   13 
   14 #define MY_SERVER_HOST "localhost"
   15 #define MY_SERVER_PORT 0
   16 #define MY_ACCOUNT "root"
   17 #define MY_PASS "test"
   18 #define MY_DB_NAME "itest"
   19 #define MY_TABLE_NAME "test_tbl"
   20 #define MY_UX_SOCK NULL
   21 #define MY_CLIENT_FLAG 0
   22 
   23 void main()
   24 {
   25         MYSQL *mysql;
   26         MYSQL_RES *res;
   27         MYSQL_ROW row;
   28         MYSQL_ROW rowchamps;
   29         const char *query;
   30         string qutmp;
   31 
   32         int t,f,tt,ff;
   33 
   34         mysql=mysql_init(NULL);
   35 
   36         if (!mysql_real_connect(mysql,MY_SERVER_HOST,MY_ACCOUNT,MY_PASS,bd,MY_SERVER_PORT,MY_UX_SOCK,MY_CLIENT_FLAG)) {
   37                 printf( "Erreur de connexion : %s\n",mysql_error(mysql));
   38         }
   39         else {
   40                 qutmp = "SHOW FULL COLUMNS FROM TABLE ";
   41                 query = qutmp.c_str();
   42                 t=mysql_real_query(mysql, query, (unsigned int) strlen(query));
   43                 if((res=mysql_use_result(mysql))) {
   44                         f=mysql_num_fields(res);
   45                         while((row=mysql_fetch_row(res))) { 
   46                                 for(f=0;f<t;f++){
   47                                     cout<<row[f]<<endl;
   48                                 }
   49                          }
   50                          mysql_free_result(res);
   51                 }
   52         }
   53         mysql_close(mysql);
   54 }
   

   first posted by cybersax to c c c++ ... saved by 7 persons ... 0 comments ... 1 year, 2 months

Pages : 1