4 replies to this topic

[mutago]

please experts, I want to query and print my database records on a web page, but
when I run the code it displays nothing. below is the work so far

#!C:/Ruby192/bin/ruby 


require "dbi"

require 'cgi'


cgi = CGI.new

puts cgi.header







begin

     # connect to the MySQL server

     dbh = DBI.connect("DBI:Mysql:testdb:localhost", 

	                    "root", "root77")

     sth = dbh.prepare("SELECT * FROM data")

     sth.execute()


     sth.fetch do |row|

        printf "First Name: %s, Last Name : %s\n", row[0], row[1]

        printf "Sex : %s\n", row[2]

 printf "Salary :%s \n\n", row[3]

       

     end

     sth.finish



rescue DBI::DatabaseError => e

     puts "An error occurred"

     puts "Error code:    #{e.err}"

     puts "Error message: #{e.errstr}"

ensure

     # disconnect from server

     dbh.disconnect if dbh

end

thanks

[WingedPanther]

Do you have data in the table?

[mutago]

yes, there is data in the table

[WingedPanther]

I'm not a Ruby coder, but this looks promising: Using the Ruby DBI Module

[mutago]

thanks, is working