i've tried and fixed bt others comment at stackoverflow, but my program still not working properly
#include <iostream>
#include <windows.h>
#include <mysql.h> //header mysql
#include <sstream>
#include <cstring>
#include <algorithm>
using namespace std;
int main()
{
int j, count = 0;
char del[] = ".,/;:";
string hadis, hadis1;
MYSQL* conn;
MYSQL_ROW row, row2;
MYSQL_RES* res, res2;
conn = mysql_init(0);
conn = mysql_real_connect(conn, "192.168.43.205", "ibrahim", "hadis", "hadis", 0, NULL, 0);
if(conn)
{
//int qstate = mysql_query(conn, "SELECT NoHdt, Isi_Arab, Isi_Indonesia, Kategori, Perawi FROM malik ORDER BY id ASC");
//int qstate = mysql_query(conn, "SELECT NoHdt, Isi_Indonesia FROM malik ORDER BY id ASC");
int qstate = mysql_query(conn, "SELECT Isi_Indonesia FROM malik");
if(!qstate)
{
res = mysql_store_result(conn);
while(row = mysql_fetch_row(res))
{
hadis = row[0];
for(unsigned int i=0;i<strlen(del);++i)
{
hadis.erase (remove(hadis.begin(), hadis.end(), del[i]), hadis.end());
}
for (j=0; hadis[j]; j++)
{
if (hadis[j] == ' ')
{
count++;
cout<< "-";
}
hadis1 = hadis[j];
cout<<hadis1;
}
cout<<"\n";
int input = mysql_query(conn, "INSERT INTO totalkata_malik(kata,total) VALUES ('"+hadis1+"',1)"); //this is error
}
}
cout<< "\n\nJumlah kata = "<<count+1<<"\n\n";
}
return 0;
}
and i've tried with this code
std::string query = "INSERT INTO totalkata_malik(kata,total) VALUES
('"+hadis1+"',1)";
if (mysql_query(conn, query.c_str()))
these code is working and the compiler run well, but the result in my database wasn't suitable the result that i desire, i could input word by word as the result of splitting the string(data from database)
Aucun commentaire:
Enregistrer un commentaire