Selecting data from mysql using qt?

tony · wrote on 11 Oct 2010, 17:22

Maybe an "#include <QVariant>" is missing at the top?

T.

MTK358 · wrote on 11 Oct 2010, 17:27

Why not just

@#include <QtCore>
#include <QtSql>@

and not worry about every single class you use?

tony · wrote on 11 Oct 2010, 17:29

That can be a solution only when you're testing something. So, in this case, I agree with you, let's avoid such worries.

But if your project grows up, it's better to include what's needed, otherwise your compilation time can increase a lot.

T.

doforumda · wrote on 11 Oct 2010, 17:29

i add #include <QVariant>

now it is saying
@
QSqlQuery::exec: database not open
@

Dmytro · wrote on 11 Oct 2010, 17:32

Try to use QSqlQuery::lastError() for find problem

doforumda · wrote on 11 Oct 2010, 17:32

what is the problem now in my code why it is not opening database?

tony · wrote on 11 Oct 2010, 17:33

Did you leave

@
//bool ok = db.open();
@

commented?

doforumda · wrote on 11 Oct 2010, 17:36

well i changed my code to this and added lastError as well

@
#include <QApplication>
#include <QSqlDatabase>
#include <QSqlError>
#include <QSqlQuery>
#include <QDebug>
#include <QString>
#include <QVariant>
//#include <QtCore>
//#include <QtSql>
//#include "../connection.h"
#include "db.h"

int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setDatabaseName("testTwo");
db.setUserName("root");
db.setPassword("");
db.setHostName("localhost");

//bool ok = db.open();

QSqlQuery query;
query.exec&#40;"SELECT firstname,lastname FROM testTable"&#41;;
while(query.next()) {
    QString firstName = query.value(0).toString();
    QString secondName = query.value(1).toString();
    qDebug() << "First Name: " << firstName << "Last Name:" << secondName;
    qDebug() << db.lastError();
}
return a.exec&#40;&#41;;

}
@

it still says QSqlQuery::exec: database not open

doforumda · wrote on 11 Oct 2010, 17:37

it is still as commented
[quote author="Antonio Di Monaco" date="1286818410"]Did you leave

@
//bool ok = db.open();
@

commented?[/quote]

Dmytro · wrote on 11 Oct 2010, 17:39

Try uncomment line 23

doforumda · wrote on 11 Oct 2010, 17:42

i uncomment line 23 and comment everything below line 23 then it just says
@
Starting /home/zafar/c++/dbExample-build-desktop/dbExample...
@

and stucks there

Dmytro · wrote on 11 Oct 2010, 17:55

OH! You use SQL code before
a.exec()
!
Are you sure?

Create standart QT GUI application and wrote sql code in mainwindow module.

doforumda · wrote on 11 Oct 2010, 18:01

i am new to qt. how can i create Qt Gui App and do you mean i should write sql code in mainwindow.h file?

doforumda · wrote on 11 Oct 2010, 18:05

right now i have three files. db.h, db,cpp and main.cpp

Dmytro · wrote on 11 Oct 2010, 18:12

Run QT Creator.
Use menu File/new file or project.
Select QT Gui application.
...
and select SQL checkbox
...
and write sql code in MainWindow.cpp
...
and see SQL Example please

doforumda · wrote on 11 Oct 2010, 18:16

well i tried "File/new file or project and select qt gui app" but i ddint find any sql checkbox anywhere in creating new project

Dmytro · wrote on 11 Oct 2010, 18:32

no coments...
How can I send you screenshot?

doforumda · wrote on 11 Oct 2010, 18:34

you can add pictures here as screenshots or if you want my email address i ll give you that as well for screenshots

doforumda · wrote on 11 Oct 2010, 19:14

anyone who can help?

Dmytro · wrote on 11 Oct 2010, 19:30

!http://hin.dp.ua/files/down/qt_scr.PNG(my screenshot)!