Форум программистов [Powered by Invision Power Board]

Код


$KCODE = "utf8"  
ENV['LC_ALL'] = 'en_US'  
require 'oci8'
require "mysql"
require 'iconv'
            
cnt = 2
conn = OCI8.new('zh', 'dfdfsddsfdsf', 'bp_test3')
hostname= "localhost"
username= "root"
password= ""
database= "sonet"
my= Mysql.new(hostname, username, password, database)
st = my.prepare("insert into users (login,email,crypted_password, salt, state) values (?,'[email protected]', '649fde36cc7034e', '3d1e9c7d690c1057fa', 'passive')")
sel = my.prepare("select id from users where login = ?")
ia = my.prepare("insert into accounts (user_id, name1, name2, name3, city_id) values (?,?,?,?,1)")    
ic = Iconv.new('UTF-8', 'WINDOWS-1251')

puts my.character_set_name # Выводит latin1
ch = my.prepare("SET CHARACTER SET UTF8") 
ch.execute
puts my.character_set_name # что странно - опять вводит latin1

conn.exec('select pass_id, name1, name2, name3 from passport where pass_id > 0 and pass_id  < '+ cnt.to_s) do |r| 
  st.execute('login'+r[0].to_s)
  sel.execute('login'+r[0].to_s)
  uid = sel.fetch[0]
  ia.execute(uid,ic.iconv(r[1]), ic.iconv(r[2]), ic.iconv(r[3]))    
  puts ic.iconv(r[1])
end

Код


<% form_tag :controller => :accounts, :action => :find do %>

<p>
<b>id</b><br />
  <%=text_field "conditions", "id" %>
</p>
<p>
<b>full_name (фамилия имя отчество)</b><br />
  <%=text_field "conditions", "full_name" %>
</p>

<%= submit_tag "yep"%>
<%end%>

<%if not @accounts.nil? and not get_account.nil?%>
<table>
  <tr>
    <th>id</th>
    <th>Name1</th>
    .....
  </tr>

<% for account in @accounts %>
  <tr>
    <td><%=h account.id %></td>
    <td><%=h account.name1 %></td>
....<% end %>
</table>
<%end%>

Код


  def find
   
    unless params["conditions"].nil?
      cond = "1=1"
      cond+= " and id = " +  params["conditions"]["id"].to_s if not params["conditions"]["id"].empty?

      unless params["conditions"]["full_name"].empty?
        cond+= " and upper(concat(name3, name1, name2)) like upper(" + '\'' + params["conditions"]["full_name"].to_s.delete(' ') { |i|  } + '%' + '\')'
      end
      
      if cond != "1=1" 
      then
        @accounts = Account.find(:all, :conditions => cond)
      else  
        @accounts = [Account.find(:first, :conditions => cond)]
      end
    end
       
    respond_to do |format|
      format.html # index.html.erb
      format.xml  { render :xml => @accounts }
    end
    
  end