start with the QtSQL module

[EL-jos]

Hi everyone, I'm a beginner in Qt but I'd like to use the QtSQL module but I don't understand anything about the directions given by the documentation.
Can anyone tell me what I need to do to use the QtSQL module, what do I need to install on my computer to use QtSQL?

[SGaist]

Hi,

What version of Qt ?
What OS ?
How did you install Qt ?

[EL-jos]

I use Qt version 5.10
I am on windows 10
I had downloaded Qt Creator from Qt's official website.

[Christian Ehrlicher]

So the QtSql module is already available and you can just start using it like explained here: https://doc.qt.io/qt-5/qtsql-index.html

[SGaist]

What kind of database do you plan to use ?

[EL-jos]

Hi
Sorry for the delay in my answer.

actually I want to use MYSQL

[SGaist]

Do you have MySQL installed on your machine ?

[123456789]

@SGaist comigo não resultou

[SGaist]

@123456789 said in start with the QtSQL module:

comigo não resultou

How is it related to the question at hand ?

[EL-jos]

@SGaist since I'm also a webmaster so I use phpMyAdmin for the MYSQL database.

[123456789]

@SGaist not result
yes
not result your solution

[KillerSmath]

@123456789
Get access of all sql modules using QT += sql in .pro file of your project.

You can create a database object to create a connection with your database using QsqlDatabase Class

http://doc.qt.io/qt-5/sql-connecting.html

With a created database object, you can use QSqlQuery to insert, update, remove or recover information of your database

http://doc.qt.io/qt-5/sql-sqlstatements.html

[123456789]

not result

[mrjj]

Hi
Can you try this demo project.
It runs for me and if yours still fail, something is wrong with your Qt install.
https://www.dropbox.com/s/uo43f7sbiwcjazv/mySqlite.zip?dl=0

output:

create table: true

"Young"
"Holand"
"Gordon"
"Robitaille"
"Papadopoulos"

[EL-jos]

Hi, here's my source code:

QSqlDatabase m_database = QSqlDatabase::addDatabase("QMYSQL");
m_database.setDatabaseName("127.0.0.1");
 m_database.setPort(3306);
m_database.setUserName("root");
foreach(QString pilote, m_database.drivers())
    qDebug()<< "Pilote: " << pilote;
if(m_database.open())
    qDebug() << "Connexion réussie.";

and here's the result:
QSqlDatabase: QMYSQL driver not loaded

QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7

Pilote: "QSQLITE"

Pilote: "QMYSQL"

Pilote: "QMYSQL3"

Pilote: "QODBC"

Pilote: "QODBC3"

Pilote: "QPSQL"

Pilote: "QPSQL7"

[SGaist]

I guess you are hitting the usual problem: do you have the MySQL client libraries that are accessible by your application ?

[EL-jos]

I don't know what a MySQL client library is and how to get it and what its importance?
if it is necessary to make simple I know nothing in module QtSQL
so if you can really help me use the QtSQL module, if there are things to download, you can tell me by posting the download link.

[SGaist]

The MySQL issue already triggered numerous threads on this forum, you should search for them.