Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Selecting data from mysql using qt?
Forum Update on Monday, May 27th 2025

Selecting data from mysql using qt?

Scheduled Pinned Locked Moved General and Desktop
150 Posts 7 Posters 141.8k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • D Offline
    D Offline
    doforumda
    wrote on 11 Oct 2010, 18:16 last edited by
    #19

    well i tried "File/new file or project and select qt gui app" but i ddint find any sql checkbox anywhere in creating new project

    1 Reply Last reply
    0
    • D Offline
      D Offline
      Dmytro
      wrote on 11 Oct 2010, 18:32 last edited by
      #20

      no coments...
      How can I send you screenshot?

      1 Reply Last reply
      0
      • D Offline
        D Offline
        doforumda
        wrote on 11 Oct 2010, 18:34 last edited by
        #21

        you can add pictures here as screenshots or if you want my email address i ll give you that as well for screenshots

        1 Reply Last reply
        0
        • D Offline
          D Offline
          doforumda
          wrote on 11 Oct 2010, 19:14 last edited by
          #22

          anyone who can help?

          1 Reply Last reply
          0
          • D Offline
            D Offline
            Dmytro
            wrote on 11 Oct 2010, 19:30 last edited by
            #23

            !http://hin.dp.ua/files/down/qt_scr.PNG(my screenshot)!

            1 Reply Last reply
            0
            • D Offline
              D Offline
              doforumda
              wrote on 11 Oct 2010, 19:56 last edited by
              #24

              well i dont have that option. here is what i get
              when i click file/new file or project then this screenshot
              "Your text to link here...":http://www.freeimagehosting.net/uploads/702f633ae7.png
              then i keep clicking next getting the follwoing screenshots
              "Your text to link here...":http://www.freeimagehosting.net/uploads/ab872acfb8.png
              "Your text to link here...":http://www.freeimagehosting.net/uploads/45c51ab364.png
              "Your text to link here...":http://www.freeimagehosting.net/uploads/84605eae46.png
              "Your text to link here...":http://www.freeimagehosting.net/uploads/84605eae46.png

              1 Reply Last reply
              0
              • D Offline
                D Offline
                Dii
                wrote on 11 Oct 2010, 21:47 last edited by
                #25

                Well, it should make no problem to have SQL query before exec(), at least I don't have any problem with that.

                Let's get back to square one:
                You said if you uncomment the
                @bool ok = db.open();@
                then your program hangs. Can we see the value of 'ok'?
                @qDebug() << ok;@
                My guess is probably you have problems granting the rights in mysql when you've created the table... have you made
                @GRANT ALL ON testTwo.* to 'root'at'localhost' IDENTIFIED BY 'somepassword';@
                (Ouch please replace the 'at' with the 'at' sign, the forum motor uses it for code tags, I don't know how to write it... I hope it's not confusing.
                I'm not sure if you can do it with empty password, I guess yes, but I never do that.)

                1 Reply Last reply
                0
                • D Offline
                  D Offline
                  doforumda
                  wrote on 12 Oct 2010, 05:49 last edited by
                  #26

                  i now put password for root at localhost.
                  when i place qDebug() << ok then it displays this
                  @
                  false
                  QSqlQuery::exec: database not open
                  @

                  false might be the value of ok.

                  1 Reply Last reply
                  0
                  • L Offline
                    L Offline
                    lyuts
                    wrote on 12 Oct 2010, 08:16 last edited by
                    #27

                    Are you able to connect to your DB from shell?

                    I'm a rebel in the S.D.G.

                    1 Reply Last reply
                    0
                    • D Offline
                      D Offline
                      doforumda
                      wrote on 12 Oct 2010, 08:21 last edited by
                      #28

                      i dont know how to connect to my DB from shell. I install xampp which is easy for me to manage my databases.
                      how can i connect from shell?

                      1 Reply Last reply
                      0
                      • L Offline
                        L Offline
                        lyuts
                        wrote on 12 Oct 2010, 08:25 last edited by
                        #29

                        @mysql -h host -D dbname -u user@

                        I guess your can omit host parameter if you are connecting to localhost. You might need to specify "-p password" switch also (depends on mysql configuration).

                        I'm a rebel in the S.D.G.

                        1 Reply Last reply
                        0
                        • D Offline
                          D Offline
                          doforumda
                          wrote on 12 Oct 2010, 08:30 last edited by
                          #30

                          i think i did not install any mysql client. bcause it displays this output
                          @
                          root@zafar-laptop:/# mysql -h localhost -D testTwo -u root -p xxxxxx
                          The program 'mysql' can be found in the following packages:

                          • mysql-client-core-5.1
                          • mysql-client-5.0
                          • mysql-cluster-client-5.1
                            Try: apt-get install <selected package>
                            @
                          1 Reply Last reply
                          0
                          • L Offline
                            L Offline
                            lyuts
                            wrote on 12 Oct 2010, 08:31 last edited by
                            #31

                            Run
                            @dpkg --list | grep mysql@
                            and post the output for this command.

                            I'm a rebel in the S.D.G.

                            1 Reply Last reply
                            0
                            • D Offline
                              D Offline
                              doforumda
                              wrote on 12 Oct 2010, 08:35 last edited by
                              #32

                              here it is
                              @
                              root@zafar-laptop:/# dpkg --list | grep mysql
                              ii libmysqlclient-dev 5.1.41-3ubuntu12.6 MySQL database development files
                              ii libmysqlclient16 5.1.41-3ubuntu12.6 MySQL database client library
                              ii mysql-common 5.1.41-3ubuntu12.6 MySQL database common files (e.g. /etc/mysql

                              @

                              1 Reply Last reply
                              0
                              • L Offline
                                L Offline
                                lyuts
                                wrote on 12 Oct 2010, 08:37 last edited by
                                #33

                                How did you create your database? I don't see any mysql server either.

                                I'm a rebel in the S.D.G.

                                1 Reply Last reply
                                0
                                • D Offline
                                  D Offline
                                  doforumda
                                  wrote on 12 Oct 2010, 08:40 last edited by
                                  #34

                                  well i download xampp and install it. i created database using phpmyadmin.

                                  1 Reply Last reply
                                  0
                                  • D Offline
                                    D Offline
                                    doforumda
                                    wrote on 12 Oct 2010, 08:42 last edited by
                                    #35

                                    i install xampp in this folder /opt/lampp

                                    and my database is in /opt/lampp/var/mysql

                                    1 Reply Last reply
                                    0
                                    • L Offline
                                      L Offline
                                      lyuts
                                      wrote on 12 Oct 2010, 08:44 last edited by
                                      #36

                                      Ok, I see. What is the location of your XAMPP installation? try to find the mysql binary there. And use the whole path (since I assume it is not in PATH) when connecting, i.e.

                                      @/path/to/xampp/bin/mysql -D dbname -u username@

                                      UPD: Didn't notice the location of xampp. then try (I guess it would be like this) @/opt/lampp/bin/mysql@

                                      I'm a rebel in the S.D.G.

                                      1 Reply Last reply
                                      0
                                      • D Offline
                                        D Offline
                                        doforumda
                                        wrote on 12 Oct 2010, 09:00 last edited by
                                        #37

                                        now here it what it says
                                        @
                                        root@zafar-laptop:/# /opt/lampp/bin/mysql -D testTwo -h localhost -u root -p 123456
                                        Enter password:
                                        ERROR 1049 (42000): Unknown database '123456'
                                        @
                                        i am providing the right pw

                                        1 Reply Last reply
                                        0
                                        • L Offline
                                          L Offline
                                          lyuts
                                          wrote on 12 Oct 2010, 09:01 last edited by
                                          #38

                                          Try not passing -p switch. I guess you will be prompted to type in your password.
                                          or
                                          @/opt/lampp/bin/mysql -u root testTwo@

                                          I'm a rebel in the S.D.G.

                                          1 Reply Last reply
                                          0

                                          28/150

                                          12 Oct 2010, 08:21

                                          topic:navigator.unread, 122
                                          • Login

                                          • Login or register to search.
                                          28 out of 150
                                          • First post
                                            28/150
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Users
                                          • Groups
                                          • Search
                                          • Get Qt Extensions
                                          • Unsolved