values are being stored as null in mysql d/b

rubyonrails-talk
1

hi!! i am building a form in ROR but all the values are being stored as null in mysql d/b.

my controller code:

class UsersController < ApplicationController

  def home   render :layout => false   end

  def index   end

  def new

  @user = User.new   @users = User.find(:all) render :layout => false   end

  def edit   end

  def show   end

  def update   end

  def destroy   end

  def create

@user = User.new(params[:user])

if @user.save   render :text =>'saved' else   render 'home' end   end

def login   render :layout => false end

end

my view code.

<%= form_for @user do |f| %>

user_name: <%= f.text_field :user_name %></br> user_fname: <%= f.text_field :user_fname %></br> user_name: <%= f.text_field :user_lname %></br> <%= f.submit %></br>

<% end %>

<% @users.each do |u| %>   <%= u %> <% end %>

could someone please help me with this issue. the values are stored in d/b but as null.

Thanks in Advance. :slight_smile:

2

How are you getting on with working through railstutorial.org (or similar)?

Colin

3

Colin Law wrote in post #1108486:

4

Do you mean that you are not a beginner and therefore do not need to work through the tutorial? If you are not a beginner I would have thought that you would know to look in development.log to find whether it is the form or the controller/model that is causing the problem and to see the query being run, and also would have read the Rails Guide on Debugging and would know about pry and other tools that can help you find the problem.

Colin

5

Can you verify the schema of your users table? The form written here implies that it has columns named “user_name”, “user_fname”, and “user_lname”. Is this correct?

–Matt Jones