SELECT * > to $array

[smrtak]

how can i write in qt this?

PHP:

$sql = "SELECT * FROM ..."
...
while($row = mysql_assoc_array($result)){
    $result[] = $row;
}
return $row;

$sql = "SELECT * FROM ..."
...
while($row = mysql_assoc_array($result)){
    $result[] = $row;
}
return $row;

To copy to clipboard, switch view to plain text mode 

I think am best way is use Object class (or maybe structs), but i want try something easy (XP).

[lyuts]

QSqlDatabase *db = QSqlDatabase::addDatabase("QPSQL7", "mainConnect");
//set db's credentials
if (!db->open()) {
   // show some error message and stuff like that
}
 
QSqlQuery query(db);
QString qstr;
...
qstr = QString("your query goes here; ");
 
query.exec(qstr);
 
if (!query.first()) {
 // in this case no data has been selected
 // do what you think you shoul
}
 
do {
  // process your data
} while (query.next())

QSqlDatabase *db = QSqlDatabase::addDatabase("QPSQL7", "mainConnect");
//set db's credentials
if (!db->open()) {
   // show some error message and stuff like that
}

QSqlQuery query(db);
QString qstr;
...
qstr = QString("your query goes here; ");

query.exec(qstr);

if (!query.first()) {
 // in this case no data has been selected
 // do what you think you shoul
}

do {
  // process your data
} while (query.next())

To copy to clipboard, switch view to plain text mode 

http://doc.trolltech.com/4.4/qsqlquery.html

[smrtak]

sorry, wrong question...

i need this

something_as_assoc_array_inPHP DB:myDbFunction(){
      QSqlDatabase *db = QSqlDatabase::addDatabase("QPSQL7", "mainConnect");
      //set db's credentials
      if (!db->open()) {
       // show some error message and stuff like that
      QSqlQuery query(db);
      QString qstr;
      qstr = QString("your query goes here; ");
      query.exec(qstr);
 
      if (!query.first()) {
       // in this case no data has been selected
       // do what you think you shoul
      }
      do {
        something_as_assoc_array_inPHP = query..........
      } while (query.next()) 
      delete db;
 
      return something_as_assoc_array_inPHP;
}
 
 
code:
 
var = DB:myDbFunction();
qtDebug() << var[0]["id"];

something_as_assoc_array_inPHP DB:myDbFunction(){
      QSqlDatabase *db = QSqlDatabase::addDatabase("QPSQL7", "mainConnect");
      //set db's credentials
      if (!db->open()) {
       // show some error message and stuff like that
      QSqlQuery query(db);
      QString qstr;
      qstr = QString("your query goes here; ");
      query.exec(qstr);

      if (!query.first()) {
       // in this case no data has been selected
       // do what you think you shoul
      }
      do {
        something_as_assoc_array_inPHP = query..........
      } while (query.next()) 
      delete db;

      return something_as_assoc_array_inPHP;
}


code:

var = DB:myDbFunction();
qtDebug() << var[0]["id"];

To copy to clipboard, switch view to plain text mode 

[spirit]

you still need to use QSqlQuery in loop like was written above.
you can get access to data using by index

QVariant QSqlQuery::value ( int index ) const

QVariant QSqlQuery::value ( int index ) const

To copy to clipboard, switch view to plain text mode 

or by field name using

QSqlRecord QSqlQuery::record () const
QVariant QSqlRecord::value ( const QString & name ) const

QSqlRecord QSqlQuery::record () const
QVariant QSqlRecord::value ( const QString & name ) const

To copy to clipboard, switch view to plain text mode 

links:
getting value by index using QSqlQuery
getting record
geeting value by index using QSqlRecord
getting value by name using QSqlRecord

[Lesiok]

Can You explain for what ? I don't see any reason for that.

[yxmaomao]

I don't think there is an easy way to read all records into a Array directly.
Does anyone has good idea?

[spirit]

why not? you can keep list of pointers to QSqlRecord. why this is bad idea?

[spirit]

you can create you own container for returning result in this way. I've just show how to get values from query using existing methods.