WRITE YOUR OWN BLOG ENGINE Making (Web host forum) your blog
WRITE YOUR OWN BLOG ENGINE Making your blog searchable You no doubt have noticed the search form repeated throughout your blog. Thanks to MySQL, adding search capabilities to your blog is easy. All you need to do is add a search index to your posts table. To do this, open up phpMyAdmin in your browser, select the blog database, and click the posts link in the left frame. In the Indexes box (halfway down the screen), type 3 in the Create an index on n columns box and click Go (see Figure 7-20). Figure 7-20. Creating an index in PHPMyAdmin Now fill out the form as shown in Figure 7-21 and click Save. Figure 7-21. Adding a fulltext index to the posts table in phpMyAdmin 325