#!/usr/local/bin/ruby print "Content-type: text/html\n\n" require "cgi" require "mysql" form = CGI.new f_name = form['name1'][0] f_price = form['price1'][0] f_and_or = form['and_or1'][0] f_zyoken = form['zyoken1'][0].to_i case f_zyoken when 1 zyoken = "=" when 2 zyoken = ">=" when 3 zyoken = "<=" end msql = Mysql::new('192.168.1.10','test','test2001','TEST_RUBY') res_price = msql.query("select name,price from test_table where price #{zyoken} '#{Mysql::quote f_price}'") res_name = msql.query("select name,price from test_table where name='#{Mysql::quote f_name}'") if res_price.num_rows == 0 && res_name.num_rows == 0 serched_out = "見つかりませんでした" else gokei = res_price.num_rows + res_name.num_rows serched_out = "#{gokei}件見つかりました" end name_array = [0] price_array = [0] i = 0 res_name.each do |name,price| name_array[i] = "#{name}" price_array[i] ="#{price}" i += 1 end res_price.each do |name,price| name_array[i] = "#{name}" price_array[i] ="#{price}" i += 1 end puts 'Ruby&MySQL
' puts serched_out puts '' for count in 0..i-1 puts '
' + name_array[count] puts '' + price_array[count] + "円" end puts '
'