Guest User

Untitled

a guest
Jul 13th, 2017
30
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.14 KB | None | 0 0
  1. }
  2. char *server = "localhost";
  3. char *user = "root";
  4. char *password = "wh289";
  5. char *database = "udoo_data";
  6.  
  7. MYSQL *conn;
  8.  
  9. conn = (MYSQL*) mysql_init(NULL);
  10.  
  11. // Prepare an insert into database
  12.  
  13. //stmt = mysql_stmt_init(mysql);
  14.  
  15. //mysql_stmt_prepare(stmt, "INSERT INTO packet_data( sze, idx, header) VALUES (psze, i, buf[i])");
  16.  
  17. /* Bind data
  18. bind[0]
  19. memset(bind, 0 sizeof(bind));
  20. */
  21. /* connect to database */
  22. if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0))
  23. {
  24. fprintf(stderr, "%s\n", mysql_error(conn));
  25. exit(1);
  26. }
  27.  
  28. // SQL database insert - find out how to insert array of floats properly
  29. // This section causes error currently.
  30. for (i = 0; i < BUF_SIZ; i++)
  31. {
  32. if (i > 16)
  33. printf("%lf\n",buf[i]);
  34. if (i < 16)
  35. {
  36. mysql_query(conn, "INSERT INTO packet_data (sze, idx, header) VALUES (psze, i, buf[i]");
  37. {
  38. fprintf(stderr, "%s\n", mysql_error(conn));
  39. exit(1);
  40. }
  41. }
  42. else
  43. {
  44. mysql_query(conn, "INSERT INTO raw_data (sze, idx, dta) VALUES (psze, i, buf");
  45. {
  46. fprintf(stderr, "%s\n", mysql_error(conn));
  47. exit(1);
  48. }
  49. }*/
  50. }
Add Comment
Please, Sign In to add comment