How to use MySQL and Ruby on Rails to develop a simple blog search function
Introduction:
With the popularity of blogs, users hope to quickly find interesting information blog post. In order to achieve this requirement, it is very important to develop a simple and effective blog search function. MySQL and Ruby on Rails are commonly used database and web development frameworks that provide powerful functions and easy-to-use tools to implement such search functions.
This article will introduce how to use MySQL and Ruby on Rails to develop a simple blog search function. We'll cover the following aspects: configuring the database, creating models, writing controllers and views, and implementing search functionality. At the same time, this article will provide specific code examples to show how to implement each step.
Step 1: Configure the database
First, we need to install the MySQL database and Ruby on Rails development environment. Make sure you have installed both tools correctly. Next, add the MySQL database connection information to your Rails application's configuration file (config/database.yml). This will allow you to connect to the database and run normally. Here is an example configuration:
development: adapter: mysql2 encoding: utf8 database: your_database_name username: your_username password: your_password host: localhost port: 3306
Step 2: Create the model
In this example, we assume that our blog post already has a model named Article
. Use the following command to create a resource generator:
$ rails generate scaffold Article title:string content:text
This command will generate the model, controller and view files related to the article. Next, execute the database migration command to create the relevant table structure:
$ rake db:migrate
Step Three: Write Controllers and Views
In our example, we will create the relevant table structure in app/controllers/articles_controller. Write relevant code in rb
. In the index
method, we will implement the search logic. Here is an example:
def index if params[:search] @articles = Article.where('title LIKE ?', "%#{params[:search]}%") else @articles = Article.all end end
In the view file app/views/articles/index.html.erb
, we will display the search form and search results. The following is the sample code:
<%= form_tag(articles_path, method: :get) do %> <%= text_field_tag(:search, params[:search], placeholder: "Search articles") %> <%= submit_tag("Search", name: nil) %> <% end %> <% @articles.each do |article| %> <h3><%= link_to article.title, article %></h3> <p><%= truncate(article.content, length: 200) %></p> <% end %>
Step 4: Implement the search function
Now we have completed the basic settings and displayed the search form and search results on the front end. Next, the routes.rb
file needs to be modified to accept search requests. The following is an example:
Rails.application.routes.draw do resources :articles do collection do get 'search' end end end
Then, create a new method search
in the controller to handle the search logic:
def search @articles = Article.search(params[:search]) end
Finally, in Add search method to Article
model:
def self.search(search) if search where('title LIKE ?', "%#{search}%") else all end end
Now, you can search your blog articles by submitting the search form.
Conclusion:
In this article, we learned how to develop a simple blog search function using MySQL and Ruby on Rails. We implemented this functionality step by step through the steps of configuring the database, creating the model, writing controllers and views, and implementing the search functionality. I hope this tutorial was helpful and inspired you to use these tools and techniques more deeply in real-world projects.
The above is the detailed content of How to develop a simple blog search function using MySQL and Ruby on Rails. For more information, please follow other related articles on the PHP Chinese website!