How can i store and retrive image / sound files to and from Remaote sql server

[spirit]

try this example, works fine for me.

#include <QtGui>
#include <QtSql>
#include <QApplication>
 
int main(int argc, char **argv)
{
	QApplication app(argc, argv);
 
	QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
	db.setDatabaseName("pictures");
	if (!db.open())
		return db.lastError().number();
 
	QSqlQuery query;
	qDebug() << query.exec("CREATE TABLE IF NOT EXISTS pictures (id INT PRIMARY KEY, pic BLOB)");
 
	QImage image("flower.jpg");
	qDebug() << image.size();
	QByteArray byteArray;
	QBuffer buffer(&byteArray);
	buffer.open(QIODevice::WriteOnly);
	image.save(&buffer, "jpg");
 
	query.prepare("INSERT INTO pictures (id, pic) VALUES (?, ?)");
	query.addBindValue(1);
	query.addBindValue(byteArray);
	qDebug() << query.exec();
 
	qDebug() << query.exec("SELECT pic FROM pictures WHERE id = 1");
	qDebug() << query.next();
 
	byteArray = query.value(0).toByteArray();
	QPixmap pixmap = QPixmap::fromImage(QImage::fromData(byteArray, "jpg"));
	qDebug() << pixmap.size();
 
	QLabel label;
	label.setPixmap(pixmap);
	label.show();
 
	return app.exec();
}

#include <QtGui>
#include <QtSql>
#include <QApplication>

int main(int argc, char **argv)
{
	QApplication app(argc, argv);

	QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
	db.setDatabaseName("pictures");
	if (!db.open())
		return db.lastError().number();

	QSqlQuery query;
	qDebug() << query.exec("CREATE TABLE IF NOT EXISTS pictures (id INT PRIMARY KEY, pic BLOB)");

	QImage image("flower.jpg");
	qDebug() << image.size();
	QByteArray byteArray;
	QBuffer buffer(&byteArray);
	buffer.open(QIODevice::WriteOnly);
	image.save(&buffer, "jpg");

	query.prepare("INSERT INTO pictures (id, pic) VALUES (?, ?)");
	query.addBindValue(1);
	query.addBindValue(byteArray);
	qDebug() << query.exec();

	qDebug() << query.exec("SELECT pic FROM pictures WHERE id = 1");
	qDebug() << query.next();

	byteArray = query.value(0).toByteArray();
	QPixmap pixmap = QPixmap::fromImage(QImage::fromData(byteArray, "jpg"));
	qDebug() << pixmap.size();

	QLabel label;
	label.setPixmap(pixmap);
	label.show();

	return app.exec();
}

To copy to clipboard, switch view to plain text mode 

[soxs060389]

Found my mistake, first row within my table had zer0 (NULL) in the blob field :-S .. dumb

[soxs060389]

And what was all the mess about toBase64() and fromBase64().

if I use that, I can't recreate the image from db?

Greets

[spirit]

try my example, it stores to database and recreates an image from database.
you don't need to use base64 at all. it was my mistake, I thought that you need to store an xml with an image into databse.

[soxs060389]

oh, ok... you may be forgiven.. things just happen.

So my code works too, (just drop the *Base64 stuff) and I prefer at as I disklike SQL syntax blah... ;-)

Note: no my program code is not cluttered as the example ;-) it was just rapid typing...

[thaihoangluu]

try this example, works fine for me.

#include <QtGui>
#include <QtSql>
#include <QApplication>
 
int main(int argc, char **argv)
{
	QApplication app(argc, argv);
 
	QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
	db.setDatabaseName("pictures");
	if (!db.open())
		return db.lastError().number();
 
	QSqlQuery query;
	qDebug() << query.exec("CREATE TABLE IF NOT EXISTS pictures (id INT PRIMARY KEY, pic BLOB)");
 
	QImage image("flower.jpg");
	qDebug() << image.size();
	QByteArray byteArray;
	QBuffer buffer(&byteArray);
	buffer.open(QIODevice::WriteOnly);
	image.save(&buffer, "jpg");
 
	query.prepare("INSERT INTO pictures (id, pic) VALUES (?, ?)");
	query.addBindValue(1);
	query.addBindValue(byteArray);
	qDebug() << query.exec();
 
	qDebug() << query.exec("SELECT pic FROM pictures WHERE id = 1");
	qDebug() << query.next();
 
	byteArray = query.value(0).toByteArray();
	QPixmap pixmap = QPixmap::fromImage(QImage::fromData(byteArray, "jpg"));
	qDebug() << pixmap.size();
 
	QLabel label;
	label.setPixmap(pixmap);
	label.show();
 
	return app.exec();
}

#include <QtGui>
#include <QtSql>
#include <QApplication>

int main(int argc, char **argv)
{
	QApplication app(argc, argv);

	QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
	db.setDatabaseName("pictures");
	if (!db.open())
		return db.lastError().number();

	QSqlQuery query;
	qDebug() << query.exec("CREATE TABLE IF NOT EXISTS pictures (id INT PRIMARY KEY, pic BLOB)");

	QImage image("flower.jpg");
	qDebug() << image.size();
	QByteArray byteArray;
	QBuffer buffer(&byteArray);
	buffer.open(QIODevice::WriteOnly);
	image.save(&buffer, "jpg");

	query.prepare("INSERT INTO pictures (id, pic) VALUES (?, ?)");
	query.addBindValue(1);
	query.addBindValue(byteArray);
	qDebug() << query.exec();

	qDebug() << query.exec("SELECT pic FROM pictures WHERE id = 1");
	qDebug() << query.next();

	byteArray = query.value(0).toByteArray();
	QPixmap pixmap = QPixmap::fromImage(QImage::fromData(byteArray, "jpg"));
	qDebug() << pixmap.size();

	QLabel label;
	label.setPixmap(pixmap);
	label.show();

	return app.exec();
}

To copy to clipboard, switch view to plain text mode 

oh great...thanks so much...