how to pass C++ variables to Insert of c++ using Mysql ++

Question

I am struggling with the code from few days can anyone help

std::string str=uri_req1.substr(found+1);
char query[2000];
sprintf(query,"Insert into publish VALUES('%s','NO')",str);

I am getting following warnings and value is not inserted in the tables

warning: cannot pass objects of non-POD type ‘struct std::string’
through ‘...’; call will abort at runtime
warning: format ‘%s’ expects type ‘char*’, but
argument 3 has type ‘int’

other thing I tried was

string query;
query="Insert into publish values('";
query+=str;
query+="','NO')";
  mysql_query(&mysql,query);

but this also never worked kindly help

It told you it didn't like string but does like char*. Why not just call query.c_str()? — John Dibling
– John Dibling, Commented Sep 21, 2010 at 5:24

Jerry Coffin · Accepted Answer · 2010-09-21 04:30:11Z

4

I'd probably use a stringstream to assemble the string:

std::ostringstream query;

query << "Insert into publish values('" << str << "', 'NO')";
mysql_query(&mysql, query.str().c_str());

answered Sep 21, 2010 at 4:30

Jerry Coffin

494k83 gold badges657 silver badges1.2k bronze badges

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

Comments

The Beast · Accepted Answer · 2015-08-18 15:08:59Z

0

This will surely work ;)

string query;
query="Insert into publish values('";
query+=str; 
query+="','NO')"; 
mysql_query(&mysql,query.c_str());

answered Aug 18, 2015 at 15:08

The Beast

1,6873 gold badges31 silver badges46 bronze badges

Collectives™ on Stack Overflow

how to pass C++ variables to Insert of c++ using Mysql ++

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related