Thanks for tinysoft now my code is working well.
void Dialog::RetrieveFromDatabase()
{
QString imagePath
= QFileDialog::getSaveFileName(this,
"Save image to",
QDir::currentPath(),
"JPEG Image (*.jpg)");
query.prepare("SELECT image FROM `test`.`images` WHERE `id_no`=:id;");
query.bindValue(":id",ui->lineID->text());
if (!query.exec())
{
QMessageBox::critical(this,
"Query error",query.
lastError().
text());
}
else
{
//Set model
model.setQuery(query);
index = model.index(0,0);
bytes = index.data().toByteArray();
//Save image
imageWrite.loadFromData(bytes);
imageWrite.save(imagePath,"JPG");
}
}
void Dialog::RetrieveFromDatabase()
{
QString imagePath = QFileDialog::getSaveFileName(this,"Save image to",QDir::currentPath(),"JPEG Image (*.jpg)");
QModelIndex index;
QSqlQueryModel model;
QByteArray bytes;
QSqlQuery query;
query.prepare("SELECT image FROM `test`.`images` WHERE `id_no`=:id;");
query.bindValue(":id",ui->lineID->text());
if (!query.exec())
{
QMessageBox::critical(this,"Query error",query.lastError().text());
}
else
{
//Set model
model.setQuery(query);
index = model.index(0,0);
bytes = index.data().toByteArray();
//Save image
QImage imageWrite;
imageWrite.loadFromData(bytes);
imageWrite.save(imagePath,"JPG");
}
}
To copy to clipboard, switch view to plain text mode
Bookmarks