Advertisement
tatdat171

Fetch Array in mysql using C

Apr 21st, 2015
249
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C 1.29 KB | None | 0 0
  1. #include <stdio.h>
  2. #include <stdlib.h>
  3. #include </usr/include/mysql/mysql.h>
  4.  
  5. int main(void) {
  6.    MYSQL *conn;
  7.    MYSQL_RES *res;
  8.    MYSQL_ROW row;
  9.    unsigned long *lengths;
  10.   /* Change me */
  11.    char *server = "localhost";
  12.    char *user = "perdition";
  13.    char *password = "123456";
  14.    char *database = "perdition";
  15.    
  16.    conn = mysql_init(NULL);
  17.    
  18.    /* Connect to database */
  19.    if (!mysql_real_connect(conn, server,
  20.          user, password, database, 0, NULL, 0)) {
  21.       fprintf(stderr, "%s\n", mysql_error(conn));
  22.       exit(1);
  23.    }
  24.  
  25.    /* send SQL query */
  26.    if (mysql_query(conn, "select keyword from replace_keyword")) {
  27.       fprintf(stderr, "%s\n", mysql_error(conn));
  28.       exit(1);
  29.    }
  30.  
  31.    res = mysql_use_result(conn);
  32.    //Get length result
  33.    lengths = mysql_fetch_lengths(conn);
  34.    printf ("%s \n", lengths);
  35.    char** arrayString;
  36.    arrayString = (char**)malloc(lengths * sizeof(char*));
  37.    for (int i = 0; i < lengths; i++) {
  38.     arrayString[i] = (char**)malloc(lengths * sizeof(char*));
  39.    }
  40.  
  41.    /* output table name */
  42.    printf("MySQL Tables in mysql database:\n");
  43.    while ((row = mysql_fetch_row(res)) != NULL)
  44.       printf("%s \n", row[0]);
  45.  
  46.    /* close connection */
  47.    mysql_free_result(res);
  48.    mysql_close(conn);
  49.  
  50.   return 0;
  51. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement