Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- }
- char *server = "localhost";
- char *user = "root";
- char *password = "wh289";
- char *database = "udoo_data";
- MYSQL *conn;
- conn = (MYSQL*) mysql_init(NULL);
- // Prepare an insert into database
- //stmt = mysql_stmt_init(mysql);
- //mysql_stmt_prepare(stmt, "INSERT INTO packet_data( sze, idx, header) VALUES (psze, i, buf[i])");
- /* Bind data
- bind[0]
- memset(bind, 0 sizeof(bind));
- */
- /* connect to database */
- if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0))
- {
- fprintf(stderr, "%s\n", mysql_error(conn));
- exit(1);
- }
- // SQL database insert - find out how to insert array of floats properly
- // This section causes error currently.
- for (i = 0; i < BUF_SIZ; i++)
- {
- if (i > 16)
- printf("%lf\n",buf[i]);
- if (i < 16)
- {
- mysql_query(conn, "INSERT INTO packet_data (sze, idx, header) VALUES (psze, i, buf[i]");
- {
- fprintf(stderr, "%s\n", mysql_error(conn));
- exit(1);
- }
- }
- else
- {
- mysql_query(conn, "INSERT INTO raw_data (sze, idx, dta) VALUES (psze, i, buf");
- {
- fprintf(stderr, "%s\n", mysql_error(conn));
- exit(1);
- }
- }*/
- }
Add Comment
Please, Sign In to add comment