use C++ with MySql : segmentation fault

Question

i'm trying to make a c++ work with MySql i have tested the following code from the link

https://www.raspberrypi.org/forums/viewtopic.php?t=31394&p=272288

    #include <iostream>
#include <mysql/mysql.h> // I added include /usr/include/mysql/ to ld.so.conf which is why that works

using namespace std;

MYSQL *connection, mysql;
MYSQL_RES *result;
MYSQL_ROW row;
int query_state;

#define HOST "localhost" // you must keep the quotes on all four items,  
#define USER "root" // the function "mysql_real_connect" is looking for a char datatype,
#define PASSWD "123" // without the quotes they're just an int.
#define DB "temps"

int main()
{
//initialize database connection
    mysql_init(&mysql);

// the three zeros are: Which port to connect to, which socket to connect to 
// and what client flags to use.  unless you're changing the defaults you only need to put 0 here
    connection = mysql_real_connect(&mysql,HOST,USER,PASSWD,DB,0,0,0); 
// Report error if failed to connect to database
    if (connection == NULL) {
        cout << mysql_error(&mysql) << endl;
        return 1;
    }
//Send query to database
        query_state = mysql_query(connection, "select * from temps");
// store result
        result = mysql_store_result(connection);
       while ( ( row = mysql_fetch_row(result)) != NULL ) {
// Print result, it prints row[column_number])
        cout << row[0] << "\t" << row[1] << endl;
        }
    return 0;
}

the file compiled successfully with :

g++ -o sqlOut -lmysqlclient sqlTest.cpp

but i got the error : segmentation fault when trying to run the compiled file !!!
any help will be appreciated , thanks

NB : i need to save data from my c++ file into MySql database and view it with phpMyAdmin , it will be very helpfull if you give me another link aor turtorial to foollow

i'm using raspberry pi b+

Time to do some debugging!

Lightness Races in Orbit
– Lightness Races in Orbit

2015-08-10 11:19:20 +00:00
Commented Aug 10, 2015 at 11:19 — Lightness Races in Orbit
– Lightness Races in Orbit, Commented Aug 10, 2015 at 11:19

Heavy · Accepted Answer · 2015-08-10 11:38:04Z

1

You should check if row[0] and row[1] contain values (are not NULL). Try this:

while ( ( row = mysql_fetch_row(result)) != NULL ) {
  if(!row[0] || !row[1]){
    continue;
  }
  cout << row[0] << "\t" << row[1] << endl;
}

answered Aug 10, 2015 at 11:38

Heavy

1,92014 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

The Beast · Accepted Answer · 2015-08-10 12:05:43Z

0

i have used "temps" for both database and table , i have change the table name in

select * from "tempdat"

here temps is the name of the database and tempdat is the name of the table => it's working now

hope that will help someone having the same error

edited Aug 10, 2015 at 12:05

answered Aug 10, 2015 at 11:43

The Beast

1,6873 gold badges31 silver badges46 bronze badges

10 Comments

Lightness Races in Orbit Over a year ago

The real answer is that your program needs error checking & handling.

The Beast Over a year ago

yes i agree , How to check for errors , using debugger ??

Lightness Races in Orbit Over a year ago

No, you write error handling into your code. Which book are you using?

The Beast Over a year ago

i put the link that i have used in the post : raspberrypi.org/forums/viewtopic.php?t=31394&p=272288

Lightness Races in Orbit Over a year ago

Yes, it is a very bad habit. You should learn from a book; you cannot expect to learn by asking questions like this.

|

Collectives™ on Stack Overflow

use C++ with MySql : segmentation fault

2 Answers 2

Comments

10 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

10 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related