Image Stored in the Database.

karthi shan

Hi All,

I developed one application, user selected image need to appeared in the label button, then if I click push-button that image need to store in database.

image only appeared in the label. I cant able to directly stored in the database.

Here is my code:
//image appeared in the label button
void MainWindow::on_pushButton_4_clicked()
{
QString fileName = "/home/embdestech/Desktop/drink.png";

        qDebug() <<fileName<<endl;
ui->label_2->setPixmap(fileName);

}

//image stored in the database
void MainWindow::on_pushButton_clicked()
{
QString img;
//img=ui->lineEdit->text();
//addr=ui->lineEdit_2->text();
PRINT<<"Connecting ....";
QSqlDatabase myDB= QSqlDatabase::addDatabase("QSQLITE");
myDB.setDatabaseName("/home/Desktop/tsk/karthick.db");

if(myDB.open())//opening database
  {
      PRINT <<"Database Opened...";
      QSqlQuery qry;
if(qry.exec("CREATE TABLE sen(img VARCHAR[20]);"))
      {
          PRINT <<"karthick Table Created...";
      }

  PRINT<<QString("INSERT INTO sen(img) VALUES('%1');").arg(img);
  if(qry.exec(QString("INSERT INTO sen(img) VALUES('%1');").arg(img)))
          {
              PRINT <<"values inserted...";
          }
          else
          {
              PRINT <<"user Error .." << qry.lastError().text();
              PRINT <<"Closed";
              myDB.close();
          }
  myDB.close();

}
}

Any one help me how to image stored in the database and retrieve the image.

jsulm

Why are you creating the table each time you try to store the image?
In the code you provided you commented out //img=ui->lineEdit->text(); that means you're trying to store an empty string.