QSqlDatabase  db_ = QSqlDatabase::addDatabase("QSQLITE");
        db_.setDatabaseName("C:\\SQLiteDatabaseBrowserPortable\\Data\\cities.db");
         db_.open();
      if(db_.isOpen())
         ui->textBrowser_2->append("Opened");
      QSqlQuery q;
      ui->textBrowser_2->append(e.train_name+"_people " + QString::number(T.passangers.size()));
      for(int i = 0; i< T.passangers.size();i++)//Add passengers
      {
          QString bot = "bot";
          QString privilages = "No";
          QString dataB = e.train_name+"_people";
          if(!q.prepare("INSERT INTO "+dataB+" (depart_city,arrival_city,firstname,lastname,bot,vagon,place,privilages,distance,ticket_price)"
                    "VALUES (:depart_city,:arrival_city,:firstname,:lastname,:bot,:vagon,:place,:privilages,:distance,:ticket_price)"))
               ui->textBrowser_2->append(dataB);

          q.bindValue(":depart_city",T.passangers[i].left_city);
            q.bindValue(":arrival_city",T.passangers[i].arrival_city);
              q.bindValue(":firstname",T.passangers[i].name);
                q.bindValue(":lastname",T.passangers[i].surname);
                  q.bindValue(":bot",bot);
                    q.bindValue(":vagon",T.passangers[i].wagon);
                    q.bindValue(":place",T.passangers[i].place);
                      q.bindValue(":privilages",privilages);
                        q.bindValue(":distance",T.passangers[i].way_distance);
                         q.bindValue(":ticket_price",T.passangers[i].ticket_cost);
                         if(!q.exec())
                             ui->textBrowser_2->append(q.lastError().text()+" "+QString::number(q.lastError().number()));
//ui->textBrowser_2->append(QString::number(i+1)+" "+T.passangers[i].left_city+" "+T.passangers[i].arrival_city+" "+T.passangers[i].name+" "
//+T.passangers[i].surname+" "+QString::number(T.passangers[i].wagon)+" "+QString::number(T.passangers[i].place)+" "+QString::number(T.passangers[i].way_distance));
/*if(!q.exec("INSERT INTO " +dataB +" (depart_city,arrival_city,firstname,lastname,bot,vagon,place,privilages,distance,ticket_price)"
          +"values('"+T.passangers[i].left_city+"','"+T.passangers[i].arrival_city+"','"+T.passangers[i].name+"','"
+T.passangers[i].surname+"','"+bot+"','"+T.passangers[i].wagon+"','"+T.passangers[i].place+"','"+privilages+"','"+T.passangers[i].way_distance+"','"+T.passangers[i].ticket_cost+"')"))
{
    ui->textBrowser_2->append(q.lastError().text()+" "+QString::number(q.lastError().number()));
}*/
      }
       i++;
       db_.close();